T
T3mplar
Guest
VS 2010/SQL 2005/VB
Normally I bind tableadapters to my datagridviews in the form designer and the underlying SQL table or view or SP is a simple select statement. But I have an SQL SP thats a bit more involved using both a full-text containstable clause and a couple of temp tables so the the procedure ends with two "drop table" commands.
When I choose the datasource for the gridview in the form designer using this SP, VS adds the dataset and the bindingsource to the bottom of the design screen, but does not add a tableadapter. Theres a querytableadapter in the list of components, but when I drag it onto the designer, it doesnt behave like a typical tableadapter. It doesnt have a ClearBeforeFill property and in the code behind, it has no tableadapter.fill function.
Oh, and due to the SP ending with the drop table commands, the datagridview did not create any columns. I created the columns manually and assigned the datapropertyname for each column to match the field names in the SP.
I can run this without errors, but the datagridview is not updated:
ValvesTA.GetValveCountItemsList(matls, szs, Keywords)
If someone could point me in the right direction, I would truly appreciate it.
Ross
Continue reading...
Normally I bind tableadapters to my datagridviews in the form designer and the underlying SQL table or view or SP is a simple select statement. But I have an SQL SP thats a bit more involved using both a full-text containstable clause and a couple of temp tables so the the procedure ends with two "drop table" commands.
When I choose the datasource for the gridview in the form designer using this SP, VS adds the dataset and the bindingsource to the bottom of the design screen, but does not add a tableadapter. Theres a querytableadapter in the list of components, but when I drag it onto the designer, it doesnt behave like a typical tableadapter. It doesnt have a ClearBeforeFill property and in the code behind, it has no tableadapter.fill function.
Oh, and due to the SP ending with the drop table commands, the datagridview did not create any columns. I created the columns manually and assigned the datapropertyname for each column to match the field names in the SP.
I can run this without errors, but the datagridview is not updated:
ValvesTA.GetValveCountItemsList(matls, szs, Keywords)
If someone could point me in the right direction, I would truly appreciate it.
Ross
Continue reading...