BindingSource and DataSet
-
I am using a commercial grid to display my data. I don't have any problem to display the whole table to the grid. For instance, the following code displays a whole table to the grid.
grid1.SetDataBinding(table1BindingSource);Now, I only want to display the FirstName and the LastName I have the following in my form table1BindingSource and db1DataSet From db1DataSet, I can see the following by intellicense; my table names Tabl1 from intellicense I can see Table1.FirstNameColumn and Table1.LastNameColumn; My question, how can I use table1BindingSource and db1DataSet to display only the firstname and the lastname rather than the whole table? -
I am using a commercial grid to display my data. I don't have any problem to display the whole table to the grid. For instance, the following code displays a whole table to the grid.
grid1.SetDataBinding(table1BindingSource);Now, I only want to display the FirstName and the LastName I have the following in my form table1BindingSource and db1DataSet From db1DataSet, I can see the following by intellicense; my table names Tabl1 from intellicense I can see Table1.FirstNameColumn and Table1.LastNameColumn; My question, how can I use table1BindingSource and db1DataSet to display only the firstname and the lastname rather than the whole table?You could use the Query Builder. Assuming you are using C# Express Edition, this "in-built" help page from the C# help file that installs with the C# express edition will show you how. There are also related help pages you might like to read! There are other ways to achieve the desired result but for a novice, this might be the easiest way. ms-help://MS.VSExpressCC.v80/MS.NETFramework.v20.en/dv_vdt01/html/815a30ce-6fb1-4611-bf43-bedd2020c443.htm Although you are wanting to program in C#, the question is about database. Try posting database questions in the correct forum.
-
I am using a commercial grid to display my data. I don't have any problem to display the whole table to the grid. For instance, the following code displays a whole table to the grid.
grid1.SetDataBinding(table1BindingSource);Now, I only want to display the FirstName and the LastName I have the following in my form table1BindingSource and db1DataSet From db1DataSet, I can see the following by intellicense; my table names Tabl1 from intellicense I can see Table1.FirstNameColumn and Table1.LastNameColumn; My question, how can I use table1BindingSource and db1DataSet to display only the firstname and the lastname rather than the whole table?