我想从多个SqlDatabase表中选择多个列来将DropDownLists与唯一数据值字段绑定 .
这是我的C#代码,使用SqlQuery从Table1中选择多个列:
// Create a dropdownlist inside the dynamically created panel and insert in the 1st row 1st cell of dynamic html table
var DDL = new WebForms.DropDownList();
DDL.ID = "MainDDL";
SqlDataSource da = new SqlDataSource();
da.ConnectionString = connection;
string item = "--Select--";
da.SelectCommand = "SELECT DATA_TYPE + '_' + convert(varchar(10), ROW_NUMBER() OVER(ORDER BY DATA_TYPE))as DATA_TYPE, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE (TABLE_NAME = 'MyTable1' AND COLUMN_NAME IN ('Column1','Column2','Column3','Column4','Column5'))";
DDL.DataSource = da;
DDL.DataTextField = "COLUMN_NAME";
DDL.DataValueField = "DATA_TYPE";
DDL.DataBind();
Solution Required: 要从多个Sql表中选择多个列:
如何从Mytable2中选择column1也在以下Sql查询SELECT DATA_TYPE'_'转换(varchar(10),ROW_NUMBER()OVER(ORDER BY DATA_TYPE))为DATA_TYPE,COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE(TABLE_NAME ='MyTable1' AND COLUMN_NAME IN('Column1','Column2','Column3','Column4','Column5'))
1 回答
Q: "How to include Mytable2 and its column1 in the following Sql Query"
A: