In previous tutorials we learned how the Object Data Source control allowed for inserting, updating, and deleting of data.
The Sql Data Source control supports the same operations, but the approach is different, and this tutorial shows how to configure the Sql Data Source to insert, update, and delete data.
Open() Dim cmd As New Sql Command("Select * from stores", con) Dim da As New Sql Data Adapter(cmd) Dim ds As New Data Set() da.
Page Private con As New Sql Connection("Data Source=.; Initial Catalog=pubs; User ID=sa; Password=*****") Protected Sub Page_Load(By Val sender As Object, By Val e As System. Load If Not Is Post Back Then load Stores() End If End Sub Protected Sub load Stores() con.
Sql Client; public partial class _Default : System.
If we could have accessed the Bind method ,that implicitly performs two-way binding, in the code-behind then we could have just override the Row Databound event and assigned the value to the gridview's checkbox control using the Bind method.
But unfortunately the Bind is not available in ASP. We could still achieve this in two simple and easy steps. Wrap the Eval(fieldname) HTML code in a function eg: Checkvalue that checks the datafield value, performs transformations to True OR False values and assigns to Chekced property. Override the Row Updating event of gridview and update only the Checked property's value since the SQLData Source that is bound to gridview will take care of remaining fields to update.
Please let me know if this has helped anyone solve the problem!!
By performing above coding we would avoid the error - Specified cast is invalid.