djadler2001
New Member
I know we can use this way to insert a record (see below):<BR><BR>**************************************************<BR>Dim MyCommand As SqlCommand<BR><BR>Dim InsertCmd As String = "insert into Authors (au_id)"<BR><BR>MyCommand = New SqlCommand(InsertCmd, MyConnection)<BR><BR>MyCommand.Parameters.Add(New SqlParameter("@Id", SqlDbType.NVarChar, 11))<BR><BR>MyCommand.Parameters("@Id").Value = http://aspmessageboard.com/archive/index.php/au_id.Value<BR><BR>************************************************** ***<BR><BR>Is there any other way to insert a row of record where the database and table with fields are already available?<BR><BR>Thanks for helping.you can use this command that will work over your last two lines<BR><BR>mycommand.parameters.add("@id",au_id.value).direction = parameterdirection.input<BR><BR>