Hi Friends I am trying to bind drop down from database. I am getting data from database by calling wep api using HTTP service. Below is my code
1. To get data from database
public string ds2json()
{
sqlCommand.CommandText = "Select Id,Monthname From tbl_month";
sqlCommand.CommandType = CommandType.Text;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
SqlDataAdapter adapter = new SqlDataAdapter();
DataSet ds = new DataSet();
adapter.SelectCommand = sqlCommand;
MainConnection.Open();
adapter.Fill(ds);
return JsonConvert.SerializeObject(ds, Formatting.Indented);
}
{
sqlCommand.CommandText = "Select Id,Monthname From tbl_month";
sqlCommand.CommandType = CommandType.Text;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
SqlDataAdapter adapter = new SqlDataAdapter();
DataSet ds = new DataSet();
adapter.SelectCommand = sqlCommand;
MainConnection.Open();
adapter.Fill(ds);
return JsonConvert.SerializeObject(ds, Formatting.Indented);
}
2. Web Api
$http.get('/api/Common/Get/')
.then(function (responce) {
$scope.Months = responce.data;
})
.then(function (responce) {
$scope.Months = responce.data;
})
When I called web api I got below json data
{
"Table": [
{
"Id": 1,
"Monthname": "Apr"
},
{
"Id": 2,
"Monthname": "May"
},
{
"Id": 3,
"Monthname": "Jun"
},
{
"Id": 4,
"Monthname": "Jul"
},
{
"Id": 5,
"Monthname": "Aug"
},
{
"Id": 6,
"Monthname": "Sep"
},
{
"Id": 7,
"Monthname": "Oct"
},
{
"Id": 8,
"Monthname": "Nov"
},
{
"Id": 9,
"Monthname": "Dec"
},
{
"Id": 10,
"Monthname": "Jan"
},
{
"Id": 11,
"Monthname": "Feb"
},
{
"Id": 12,
"Monthname": "Mar"
}
]
}
I need to bind this Id as value and Month name as text for drop down in angular js.
May be my problem with multiple objects in this data
"Table": [{} ],"Table1": [{} ]
Bryian TanPosted Sep 25, 2017, 2:13 AM