Actually we do that way wherein we assume the size co datatype base on how they create. But the problem is we have some datatype with different size. Example sometimes the default value of nVarChar = 50, but there was a case like in "comment" we make it more than to that value. Regarding GetSchemaTable, im not familiar to used that. Can u give me some example of using that in datagrid wherein we can update, insert, and delete direct to the grid..

If you have some tips of making parameters in datagrid except using commandbuilder, (we have a complex datatable) please send it to me. It will help me a lot. Thank you. Good day