Click here to Skip to main content
15,843,322 members
Home / Discussions / Database
   

Database

 
GeneralRe: Obtaining value of identity field when inserting into SQL Pin
Tobias Schoenig29-Nov-07 0:31
Tobias Schoenig29-Nov-07 0:31 
GeneralRe: Obtaining value of identity field when inserting into SQL Pin
Colin Angus Mackay29-Nov-07 0:40
Colin Angus Mackay29-Nov-07 0:40 
GeneralRe: Obtaining value of identity field when inserting into SQL Pin
Dewald29-Nov-07 1:16
Dewald29-Nov-07 1:16 
QuestionRank(sql) Pin
r a j u u28-Nov-07 23:44
r a j u u28-Nov-07 23:44 
AnswerRe: Rank(sql) Pin
pmarfleet29-Nov-07 1:07
pmarfleet29-Nov-07 1:07 
Question[Message Deleted] Pin
gubba28-Nov-07 23:42
gubba28-Nov-07 23:42 
AnswerRe: Regarding retreiving values from table Pin
pmarfleet29-Nov-07 1:01
pmarfleet29-Nov-07 1:01 
Questioninsert new row in sql server Pin
break_day28-Nov-07 21:20
break_day28-Nov-07 21:20 
Hi,
i insert new row in sql server with this syntax

Dim insert_transaction As SqlCommand
insert_transaction = New SqlCommand("insert into Transaction (Transaction_Id,Account_Id,Type,Amount,Date,Time) values ('30','" & account & "','Account Transfer','" & money.Text & "','" & Today & "','" & time & "')", myConnection)
insert_transaction.ExecuteNonQuery()

the error appear in ExecuteNonQuery()
the question is
how i insert new row in vb.net connect with sql server ?

AnswerRe: insert new row in sql server Pin
yaad fridman28-Nov-07 21:51
yaad fridman28-Nov-07 21:51 
GeneralRe: insert new row in sql server Pin
break_day28-Nov-07 22:13
break_day28-Nov-07 22:13 
GeneralRe: insert new row in sql server Pin
yaad fridman28-Nov-07 22:40
yaad fridman28-Nov-07 22:40 
GeneralRe: insert new row in sql server Pin
break_day29-Nov-07 0:01
break_day29-Nov-07 0:01 
GeneralRe: insert new row in sql server Pin
yaad fridman1-Dec-07 20:58
yaad fridman1-Dec-07 20:58 
AnswerRe: insert new row in sql server Pin
ChandraRam28-Nov-07 22:19
ChandraRam28-Nov-07 22:19 
QuestionExport Table to Xml Using Sql Pin
Nagaraju_Focus28-Nov-07 21:09
Nagaraju_Focus28-Nov-07 21:09 
AnswerRe: Export Table to Xml Using Sql Pin
Maharishi Bhatia28-Nov-07 21:56
Maharishi Bhatia28-Nov-07 21:56 
GeneralRe: Export Table to Xml Using Sql Pin
Nagaraju_Focus28-Nov-07 23:23
Nagaraju_Focus28-Nov-07 23:23 
GeneralRe: Export Table to Xml Using Sql Pin
Tobias Schoenig29-Nov-07 2:58
Tobias Schoenig29-Nov-07 2:58 
AnswerRe: Export Table to Xml Using Sql Pin
Maharishi Bhatia1-Dec-07 17:35
Maharishi Bhatia1-Dec-07 17:35 
Questionremote database accessing Pin
dayya28-Nov-07 19:18
dayya28-Nov-07 19:18 
AnswerRe: remote database accessing Pin
pmarfleet28-Nov-07 20:45
pmarfleet28-Nov-07 20:45 
AnswerRe: remote database accessing Pin
Paul Conrad29-Nov-07 14:00
professionalPaul Conrad29-Nov-07 14:00 
QuestionGet size of a table row Pin
Soumya Mathew28-Nov-07 19:10
Soumya Mathew28-Nov-07 19:10 
AnswerRe: Get size of a table row Pin
ChandraRam28-Nov-07 22:27
ChandraRam28-Nov-07 22:27 
AnswerRe: Get size of a table row Pin
Frank Kerrigan30-Nov-07 1:18
Frank Kerrigan30-Nov-07 1:18 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.