Help about insert row in SQL Server 2000

dimeanel · January 18th, 2006, 01:21 PM

I have SQL procedure made in SQL Sever 2000. I can not write VB.NET code which will take same strings from windows forms and put it in new row in SQL server.

nalla · January 19th, 2006, 01:42 AM

Hi dimeanel,
your problem is bit confused.
I hope what you are trying to say is that you can't use the same query in a vb form which you are using in a sql server procedure to insert a new row to a table.that's obvious because syntaxes are different in a vb form and a sql server procedure.

please let us know if you need more information regarding this.

nalaka hewage

dimeanel · January 19th, 2006, 02:49 PM

Quote:

quote:Originally posted by nalla

Hi dimeanel,
your problem is bit confused.
I hope what you are trying to say is that you can't use the same query in a vb form which you are using in a sql server procedure to insert a new row to a table.that's obvious because syntaxes are different in a vb form and a sql server procedure.

please let us know if you need more information regarding this.

nalaka hewage

dimeanel · January 19th, 2006, 02:55 PM

Hi Nalla,

I have T-SQL procedure which input some data in SQL server database. I what to write VB.NET which will run this procedure and also to take same data strings from windows VB.NET form and write it in base. If you are confused I'll send you my code.