在Windows窗体aspx中绑定多个组合框 [英] Bind multiple Combobox in windows forms aspx

问题描述

一次绑定多个组合框和数据网格的问题.它只是绑定最后一个comobox/datagrid. sql_con.Open(); sql_cmd = sql_con.CreateCommand(); 字符串 CommandText = " ; DB = 新 SQLiteDataAdapter(CommandText，sql_con); DS.Reset(); DB.Fill(DS); DT = DS.Tables [ 0 ]; Grid.DataSource = DT; ex.ExportDetails(DT，Export.ExportFormat.CSV，" )； sql_con.Close(); SetConnection(); sql_con.Open(); sql_cmd = sql_con.CreateCommand(); 字符串 CommandText1 = " ; DB = 新 SQLiteDataAdapter(CommandText1，sql_con); DS.Reset(); DB.Fill(DS); DT1 = DS.Tables [ 0 ]; dlMediatype.DataSource = DT1; dlMediatype.DisplayMember = " ; dlMediatype.ValueMember = " ; dlSearchMediaType.DataSource = DT1; dlSearchMediaType.DisplayMember = " ; dlSearchMediaType.ValueMember = " ; sql_con.Close();

从上面的代码中放到Form加载下时，它将绑定"

dlMediatype

"&调试时未绑定"

dlSearchMediaType

"但未绑定"

Grid

"，但结果在数据表中显示，但未在表单上找到.哪个放置在最后一个数据表中，哪个绑定在数据/工作上，而前一个不绑定..

解决方案

在

Grid.DataSource = DT;

之后调用Grid.DataBind()方法 我希望这是您的代码中缺少的东西

Issue in binding multiple combobox and datagrid at a time. It just binds the last comobox/datagrid.

SetConnection(); 
			sql_con.Open();

			sql_cmd = sql_con.CreateCommand();
            string CommandText = "SELECT MediaArticle.id, MediaArticle.Title,MediaArticle.Author,MediaArticle.Volume,MediaArticle.Location, Category.Category, MediaType.Title as 'Media Type', MediaArticle.Comments, MediaArticle.UpdateDate as 'Add Date', Admin.Username as 'Added By' FROM MediaArticle INNER JOIN Admin ON MediaArticle.ById = Admin.id INNER JOIN MediaType ON MediaArticle.MediaType = MediaType.id INNER JOIN Category ON MediaArticle.Category = Category.id";
			DB = new SQLiteDataAdapter(CommandText,sql_con);
            DS.Reset();
			DB.Fill(DS);
			DT= DS.Tables[0];
			Grid.DataSource = DT;
            ex.ExportDetails(DT, Export.ExportFormat.CSV, "MediaArticles");
			sql_con.Close();


 SetConnection();
            sql_con.Open();
            sql_cmd = sql_con.CreateCommand();
            string CommandText1 = "SELECT * from MediaType";
            DB = new SQLiteDataAdapter(CommandText1, sql_con);
            DS.Reset();
            DB.Fill(DS);
            DT1 = DS.Tables[0];
            dlMediatype.DataSource = DT1;
            dlMediatype.DisplayMember = "Title";
            dlMediatype.ValueMember = "id";
            dlSearchMediaType.DataSource = DT1;
            dlSearchMediaType.DisplayMember = "Title";
            dlSearchMediaType.ValueMember = "id";
            sql_con.Close();

from above code when placed under Form load it binds ''

dlMediatype

'' & ''

dlSearchMediaType

'' BUT not binding ''

Grid

'' when debugged it gives its result in datatable but not found on form. Whichever is placed as last Datatable, is binding the data/working while previous not..

解决方案

Call Grid.DataBind() method after

Grid.DataSource = DT;

I hope this is the thing which is missing in your code

这篇关于在Windows窗体aspx中绑定多个组合框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！