Well, here's what I was talking about for your parameter:

cmdInsert.Parameters.Add("@" & sColumnName, ds.Tables(tableName).Columns(iCtr))

I hope that's the right syntax, I'm better at C#. <g>

As far as the CommandBuilder goes, here's some sample C# code using it:

SqlDataAdapter da = new SqlDataAdapter("select * from MyTable", this.TestConnection);
SqlCommandBuilder sb = new SqlCommandBuilder(da);
da.Fill(MyDataSet);

// whatever your code here is to change your data

da.Update(MyDataSet);

Does this help?

~~Bonnie

>For iCtr = 0 To ds.Tables(tableName).Columns.Count - 1
>	sColumnName = ds.Tables(tableName).Columns(iCtr).ColumnName
>	
>         Select Case ds.Tables(tableName).Columns(iCtr).DataType.Name
>	
>         Case "Int32"
>	   oleType = OleDbType.BigInt
>	   iColumnSize = 4 '****>>>> I want to value from the dataset<<<<<****
>         Case "String"
>	   oleType = OleDbType.VarChar
>	   iColumnSize = 50
>	End Select
>
>	param = cmdInsert.Parameters.Add("@" & sColumnName, oleType, iColumnSize, _
>              sColumnName)
>Next

>
>*/Notice that I only assume the value of "size" or iColumnsize = 4
>
> Can u give some sugestion of Update, delete, and insert data in Datagrid except using a CommandBuilder.