Auto-build UpdateCommand Statement

I'm doing something very similar...mySQLString = "select * from " & ComboBox1.SelectedItem.ToString & " where invoicetype = 0"

I use a button to update mySQLString and repopulate the grid, but you should have the new selected value on ComboBox1_SelectedIndexChanged if you wanted to fire the update then.  Try selecteditem and see what that does...

Thanks. I tried that; when I click the auto-generated update button on the grid; it throws the error :  Updating is not supported by data source 'SqlDataSource1' unless UpdateCommand is specified.

Is the update command re-building for you based on the table you choose in the dropdown ?

I don't use any wizards, my grid is populated via code.  

Dim myDataSet As DataSet
myDataSet = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(My.Settings.DBString2, CommandType.Text, mySQLString)
DataGridView1.DataSource = myDataSet
DataGridView1.DataMember = myDataSet.Tables(0).ToString

Mine is not completely code driven; I have a gridview and sql data source objects defined and then I just populate the selectcommand for the data source dynamically; I can change mine to code similar to what you have above if you think that would auto generate the updatecommand="update table1 set field1=@field1"  etc for me.

When I do work with your code; it tells me applicationblocks are not a part of microsoft. I'm running VS 2005 ; do I need some specific references / ?
thanks

I use application blocks, but you don't need it.  I find it easy to work with data using it.  http://www.microsoft.com/downloads/details.aspx?familyid=F63D1F0A-9877-4A7B-88EC-0426B48DF275&displaylang=en
I think you can make it work, I update rows with that grid as well...

Thanks. I apologize : I'm new to .net.  I downloaded this and was expecting to see a reference to check when I restarted VS 2005 ;  Not sure how to implement it after running it.

Likewise I'm not seeing a datagridview ; I only have a gridview object.

Perhaps once I reference it properly I'll have use of that object, but how should  I do that.

I'm increasing points for your trouble.

Lets skip the application blocks right now...Try this...

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        update_grid()
    End Sub
    Public Sub update_grid()
        Dim SQL_String As String = "select top 10 * from " & DropDownList1.SelectedValue
        Dim connection As Data.SqlClient.SqlConnection
        connection = New Data.SqlClient.SqlConnection("server=A0116-DBS0133-S;Integrated Security=SSPI;Initial Catalog=APAY")
        connection.Open()
        Dim cmd As New Data.SqlClient.SqlCommand
        cmd.CommandTimeout = 30
        Dim ds As New Data.DataSet
        Dim dataAdatpter As Data.SqlClient.SqlDataAdapter
        cmd.Connection = connection
        cmd.CommandText = SQL_String
        cmd.CommandType = Data.CommandType.Text
        Try
            ' Create the DataAdapter & DataSet
            dataAdatpter = New Data.SqlClient.SqlDataAdapter(cmd)

            ' Fill the DataSet using default values for DataTable names, etc
            dataAdatpter.Fill(ds)

            ' Detach the SqlParameters from the command object, so they can be used again
            cmd.Parameters.Clear()
        Finally
            If (Not dataAdatpter Is Nothing) Then dataAdatpter.Dispose()
        End Try
        connection.Close()
        If Not connection Is Nothing Then connection.Dispose()
        GridView1.DataSource = ds
        GridView1.DataBind()
    End Sub

    Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged
        update_grid()
    End Sub

ok. The code works great. I created a gridview2 and adjusted the code accordingly. Pulls the table based on the drop down selection. I also added autogenerateeditbutton so you could make edits in the data grid. (see code below) ; but when I click edit I get the following error message instantly.  Are you not getting this or are we handling the edit process differently ?

Thanks again.

-----------------------------------  


<asp:GridView ID="GridView2" runat="server" AutoGenerateEditButton="True" AutoGenerateDeleteButton="True">
        </asp:GridView>

--------------------------------------------------------------------------------
Server Error in '/Control_data_maint_app' Application.


The GridView 'GridView2' fired event RowEditing which wasn't handled.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: The GridView 'GridView2' fired event RowEditing which wasn't handled.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.