问题描述
I have a windows forms application where i have to load different fee structures tables for different courses in one datagridview using the textbox but i do not know how to use the mulitple datasources for datagridview I have 20 fee structure which differ from each of them by the values in it I have a Textbox where i would retrieve the name of the table to be retrieved but how should i proceed further ?
I used the have made a DataSet named fSDataSet where all the datatables are stored Now i want to load the tables when i get the values from the form
private void fSDataSetBindingSource_CurrentChanged(object sender,EventArgs e)
{
BindingSource bindingsource = new BindingSource();
string getfeest =FYBIOTECH;
string s = @Data Source = SRINATH-PC\SQLEXPRESS; Initial Catalog = FS; Integrated Security = True; Pooling = False;
SqlConnection OK =新SqlConnection(s);
SqlDataAdapter getfeestructure = new SqlDataAdapter();
SqlCommandBuilder commandBuilder = new SqlComman dBuilder(getfeestructure);
SqlCommand cmd = new SqlCommand(@select * from+ getfeest,OK);
getfeestructure.SelectCommand = cmd;
DataTable dt = new DataTable(@ fsDataSet。+ getfeest);
dt.Locale = System.Globalization.CultureInfo.InvariantCulture;
getfeestructure.Fill(dt);
bindingsource.DataSource = dt;
dataGridView1.AutoResizeColumns(
DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
}
private void button1_Click(object sender,EventArgs e)
{
fSDataSetBindingSource_CurrentChanged(sender,e);
}
现在错误是它没有显示其中的行而且我无法理解实际的错误
推荐答案
这篇关于无法使用数据集加载datagridview中的多个数据源?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!