Congratulations - C# Corner Q4, 2022 MVPs Announced
Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
Mursaleen Hassan
2.1k
22
3.6k
Spacing Text could not be match in SQL Server
May 3 2018 11:57 AM
View
@{
ViewBag.Title =
"Home Page"
;
}
<script src=
"~/Scripts/jquery-1.10.2.min.js"
></script>
<link rel=
"stylesheet"
href=
"http://code.jquery.com/ui/1.11.0/themes/smoothness/jquery-ui.css"
>
<script src=
"http://code.jquery.com/ui/1.11.0/jquery-ui.js"
></script>
<script type=
"text/javascript"
src=
"http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"
></script>
<script>
$(document).ready(
function
() {
$(
"#txt_city"
).change(
function
() {
var
id = $(
this
).val();
$(
"#txta_address"
).empty();
$.get(
"a_add"
, { city: id },
function
myfunction(data) {
var
v =
"<option>---Select----</option>"
;
$.each(data,
function
(i, v1) {
v +=
"<option value="
+ v1.Value +
">"
+ v1.Text +
"</option>"
;
});
$(
"#txta_address"
).html(v);
});
});
$(
"#btn"
).on(
'click'
,
function
() {
var
id = $(
"#txta_address"
).val();
$(
"#txtb_address"
).empty();
$.get(
"b_add"
, { add: id },
function
myfunction(data) {
var
v =
"<option>---Select----</option>"
;
$.each(data,
function
(i, v1) {
v +=
"<option value="
+ v1.Value +
">"
+ v1.Text +
"</option>"
;
});
$(
"#txtb_address"
).html(v);
});
});
});
</script>
<div
class
=
"row"
>
<div>
@Html.DropDownList(
"txt_city"
,
null
,
"----Selected Country-----"
);
</div>
<div>
<select id=
"txta_address"
></select>
<input id=
"btn"
type=
"button"
value=
"button"
/>
</div>
<div>
<select id=
"txtb_address"
></select>
</div>
</div>
Home Controller
using
System;
using
System.Collections.Generic;
using
System.Data;
using
System.Linq;
using
System.Web;
using
System.Web.Mvc;
namespace
dropdownlist.Controllers
{
public
class
HomeController : Controller
{
data_access_layer.db dblayer =
new
data_access_layer.db();
public
ActionResult Index()
{
city_bind();
return
View();
}
public
void
city_bind()
{
DataSet ds = dblayer.Get_Country();
List<SelectListItem> countrylist =
new
List<SelectListItem>();
foreach
(DataRow dr
in
ds.Tables[0].Rows)
{
countrylist.Add(
new
SelectListItem { Text = dr[
"city"
].ToString(), Value = dr[
"city"
].ToString() });
}
ViewBag.txt_city = countrylist;
}
public
JsonResult a_add(
string
city)
{
DataSet ds = dblayer.Get_A_Add(city);
List<SelectListItem> statelist =
new
List<SelectListItem>();
foreach
(DataRow dr
in
ds.Tables[0].Rows)
{
statelist.Add(
new
SelectListItem { Text = dr[
"address2"
].ToString(), Value = dr[
"address2"
].ToString() });
}
return
Json(statelist, JsonRequestBehavior.AllowGet);
}
public
JsonResult b_add(
string
add)
{
DataSet ds = dblayer.Get_B_Add(add);
List<SelectListItem> citylist =
new
List<SelectListItem>();
foreach
(DataRow dr
in
ds.Tables[0].Rows)
{
citylist.Add(
new
SelectListItem { Text = dr[
"add1"
].ToString(), Value = dr[
"add1"
].ToString() });
}
return
Json(citylist, JsonRequestBehavior.AllowGet);
}
public
ActionResult About()
{
ViewBag.Message =
"Your application description page."
;
return
View();
}
public
ActionResult Contact()
{
ViewBag.Message =
"Your contact page."
;
return
View();
}
}
}
DB Layer
using
System;
using
System.Collections.Generic;
using
System.Configuration;
using
System.Data;
using
System.Data.SqlClient;
using
System.Linq;
using
System.Web;
namespace
dropdownlist.data_access_layer
{
public
class
db
{
SqlConnection con =
new
SqlConnection(ConfigurationManager.ConnectionStrings[
"DBCS"
].ConnectionString);
//Get Country
public
DataSet Get_Country()
{
SqlCommand com =
new
SqlCommand(
"select distinct(city) as city from vehicle"
, con);
SqlDataAdapter da =
new
SqlDataAdapter(com);
DataSet ds =
new
DataSet();
da.Fill(ds);
return
ds;
}
//Get Address
public
DataSet Get_A_Add(
string
city)
{
SqlCommand com =
new
SqlCommand(
"select distinct(a_address) as address2 from vehicle where city='"
+city+
"'"
, con);
SqlDataAdapter da =
new
SqlDataAdapter(com);
DataSet ds =
new
DataSet();
da.Fill(ds);
return
ds;
}
//Get Address
public
DataSet Get_B_Add(
string
add)
{
SqlCommand com =
new
SqlCommand(
"select distinct(b_address) as add1 from vehicle where a_address='"
+add+
"'"
, con);
SqlDataAdapter da =
new
SqlDataAdapter(com);
DataSet ds =
new
DataSet();
da.Fill(ds);
return
ds;
}
}
}
SQl Server Database
I am tired Please help.
thanks
Reply
Answers (
4
)
Web page content has to refreshed automatically
OTP Verify With Asp.Net MVC