如何通过ajax获取ID和值 [英] How do I get the ID and value through ajax
问题描述
$(function(){
$ .ajax({
url:'@ Url.Action(GetAllTableNames, home)',
数据:{},
类型:'post',
contentType:application / json; charset = utf-8,
dataType:json,
成功:函数(数据){
var ddl = $('#ddlTableNames ');
var options = [];
for(var i = 0,len = data.length; i'+ data [i] +'');
ddl.append(options.join(''));
},
错误:function(a,b,c){
console.log(a,b,c);
}
});
});
函数populateColumns(ddl){
var table = ddl.value;
$ .ajax({
url:'@ Url.Act ion(GetAllColumnNames,home)',
数据:JSON.stringify({'tbl':table}),
类型:'post',
contentType:application / json; charset = utf-8,
dataType:json,
成功:函数(数据){
var ddl = $(' #ddColumnNames');
ddl.empty();
var options = [];
for(var i = 0,len = data.length; i'+ data [i] +'');
ddl.append(options.join(''));
},
错误:函数(a,b,c){
console.log(a,b,c);
}
});
}
函数getdata(){
var table = $('# ddlTableNames')。val();
var columns = $('#ddlColumnNames')。val()。join(',');
debugger;
$ .ajax({
url:'@ Url.Action(GetTableData,home )',
数据:JSON.stringify({'tableName': table,'columnNames':columns}),
type:'post',
contentType:application / json; charset = utf-8,
dataType:json,
成功:函数(数据){
调试器;
var json = JSON.parse(data);
generateTable(json)
},
错误:函数(a,b,c){
console.log(a,b,c);
}
} );
}
函数generateTable(json){< br $>
var $ table = $('#tblDynamic');
$ table.find('thead')。empty()
$ table.find('tbody')。empty()
if(json&& json.length> 0){
var header = json [0];
var columns = [];
for(var col in header){
columns.push( ''+ col +'');
}
$ table.find('thead')。append(''+ columns.join('')+'');
var rows = [];
for (var i = 0;我'+ row [col] +'');
}
rows.push(''+ tds.join()+'');
}
$ table.find('tbody')。append(rows.join(''));
}
}
// tbl我得到文本值但想得到ID
公共类HomeController:控制器
{
string constr =CONNECTION STRING;
public ActionResult Index()
{
返回查看();
}
public ActionResult GetAllTableNames()
{
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand(select CountryName,CountryId from Countries,con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
var data = dt.AsEnumerable()。选择( k => k [CountryName]。ToString());
返回Json(数据);
} $ / $
public ActionResult GetAllColumnNames(string tbl)
{
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand(SELECT c.CountryId,c.CountryName,s.CityId,s.CityName FROM(Countries c INNER JOIN Cities s ON c.CountryId = s.StateId)where c .CountryName = @tbl,con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
cmd.Parameters.AddWithValue(@ tbl,tbl);
DataTable dt = new DataTable();
da.Fill(dt);
var data = dt.AsEnumerable()。选择(k => k [CityName]。ToString());
返回Json(数据);
}
public ActionResult GetTableData(string tableName, string columnNames)
{
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand(select+ columnNames +来自+ tableName,con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da .Fill(dt);
string data = JsonConvert.SerializeObject(dt);
返回Json(数据);
}
}
什么我试过了:
i获取城市名称,但试图获得城市ID
< blockquote> .ajax({
url:'@ Url.Action(GetAllTableNames,home)',
data:{},
类型:'post',
contentType:application / json; charset = utf-8,
dataType:json,
成功:函数(数据){
var ddl =
('#ddlTableNames');
var options = [];
for(var i = 0,len = data.length;我'+ data [i] +'');
ddl.append(options.join(''));
},
错误:函数(a,b,c){
console.log(a,b,c);
}
}) ;
});
函数populateColumns(ddl){
var table = ddl.value;
.ajax({
url:'@ Url.Action(GetAllColumnNames,home) ',
数据:JSON.stringify({'tbl':table}),
类型:'post',
contentType: application / json; charset = utf-8,
dataType:json,
成功:函数(数据){
var ddl =
$(function () {
$.ajax({
url: '@Url.Action("GetAllTableNames", "home")',
data: {},
type: 'post',
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (data) {
var ddl = $('#ddlTableNames');
var options = [];
for (var i = 0, len = data.length; i ' + data[i] + '');
ddl.append(options.join(''));
},
error: function (a, b, c) {
console.log(a, b, c);
}
});
});
function populateColumns(ddl){
var table = ddl.value;
$.ajax({
url: '@Url.Action("GetAllColumnNames", "home")',
data: JSON.stringify({'tbl':table}),
type: 'post',
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (data) {
var ddl = $('#ddlColumnNames');
ddl.empty();
var options = [];
for (var i = 0, len = data.length; i ' + data[i] + '');
ddl.append(options.join(''));
},
error: function (a, b, c) {
console.log(a, b, c);
}
});
}
function getdata() {
var table = $('#ddlTableNames').val();
var columns = $('#ddlColumnNames').val().join(',');
debugger;
$.ajax({
url: '@Url.Action("GetTableData", "home")',
data: JSON.stringify({ 'tableName': table, 'columnNames':columns }),
type: 'post',
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (data) {
debugger;
var json = JSON.parse(data);
generateTable(json)
},
error: function (a, b, c) {
console.log(a, b, c);
}
});
}
function generateTable(json) {
var $table = $('#tblDynamic');
$table.find('thead').empty()
$table.find('tbody').empty()
if (json && json.length > 0) {
var header = json[0];
var columns = [];
for (var col in header) {
columns.push('' + col + '');
}
$table.find('thead').append('' + columns.join('') + '');
var rows = [];
for (var i = 0; i ' + row[col] + '');
}
rows.push('' + tds.join() + '');
}
$table.find('tbody').append(rows.join(''));
}
}
// tbl i get the text value but want to get the ID
public class HomeController : Controller
{
string constr = "CONNECTION STRING";
public ActionResult Index()
{
return View();
}
public ActionResult GetAllTableNames()
{
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand("select CountryName,CountryId from Countries", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
var data = dt.AsEnumerable().Select(k => k["CountryName"].ToString());
return Json(data);
}
public ActionResult GetAllColumnNames(string tbl)
{
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand("SELECT c.CountryId, c.CountryName, s.CityId,s.CityName FROM (Countries c INNER JOIN Cities s ON c.CountryId = s.StateId) where c.CountryName= @tbl ", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
cmd.Parameters.AddWithValue("@tbl", tbl);
DataTable dt = new DataTable();
da.Fill(dt);
var data = dt.AsEnumerable().Select(k => k["CityName"].ToString());
return Json(data);
}
public ActionResult GetTableData(string tableName, string columnNames)
{
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand("select " + columnNames + " from " + tableName, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
string data = JsonConvert.SerializeObject(dt);
return Json(data);
}
}
What I have tried:
i am getting the city name but try to get city id
.ajax({
url: '@Url.Action("GetAllTableNames", "home")',
data: {},
type: 'post',
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (data) {
var ddl =
('#ddlTableNames');
var options = [];
for (var i = 0, len = data.length; i ' + data[i] + '');
ddl.append(options.join(''));
},
error: function (a, b, c) {
console.log(a, b, c);
}
});
});
function populateColumns(ddl){
var table = ddl.value;
.ajax({
url: '@Url.Action("GetAllColumnNames", "home")',
data: JSON.stringify({'tbl':table}),
type: 'post',
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (data) {
var ddl =
这篇关于如何通过ajax获取ID和值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!