General information
Title:
Help with code pls....
HERES THE CODE THAT I HAD WRITTEN AND IT SEEMS TO WORK:
Sub Button1_Click(sender As Object, e As EventArgs)
Dim connectionString As String = "server='Merlin'; trusted_connection=true; database='Solotest'"
Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString)
Dim queryString As String = "INSERT INTO [Sturecs] ([appdate],[studentid],[firstname],[midname],[lastname],[address1],[city],[studzip],[paddress1],[homephone],[birthplace],[birthdate],[national],[studgen],[cvlstat],[progcod],[special],[major],[minor],[religion],[baptized],[acrno],[guardfname],[guardmname],[guardlname],[relatiOnsh],[selfemplyd],[employed],[occupation],[oficename],[oficeadd],[oficephone],[oficefax],[oficeemail],[elemschl],[highschl],[college],[masters],[edate],[hdate],[cdate],[mdate],[esono],[hsono],[csono],[msono],[cmajor],[cminor],[mmajor],[mminor]) VALUES (@date,@tempno,@fnam,@mnam,@lnam,@cadd,@city,@zip,@padd,@contno,@pob,@dob,@natl,@gen,@cvlstat,@prgcod,@espec,@emajor,@eminor,@religion,@bapt,@acr,@gfnam,@gmnam,@glnam,@grel,@emplyd,@semplyd,@gocc,@goffnam,@goffadd,@goffph,@gofffax,@goffeadd,@eschl,@hschl,@cschl,@mschl,@edgrad,@hdgrad,@cdgrad,@mdgrad,@esono,@hsono,@csono,@msono,@cmajor,@cminor,@mmajor,@mminor)"
'
Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
dbcommand.parameters.add(New SQLParameter("@date", textbox1.text))
dbcommand.parameters.add(New SQLParameter("@tempno", textbox2.text))
dbcommand.parameters.add(New SQLParameter("@fnam", textbox3.text))
dbcommand.parameters.add(New SQLParameter("@mnam", textbox4.text))
dbcommand.parameters.add(New SQLParameter("@lnam", textbox5.text))
dbcommand.parameters.add(New SQLParameter("@cadd", textbox6.text))
dbcommand.parameters.add(New SQLParameter("@city", textbox7.text))
dbcommand.parameters.add(New SQLParameter("@zip", textbox8.text))
dbcommand.parameters.add(New SQLParameter("@padd", textbox9.text))
dbcommand.parameters.add(New SQLParameter("@contno", textbox10.text))
dbcommand.parameters.add(New SQLParameter("@pob", textbox11.text))
dbcommand.parameters.add(New SQLParameter("@dob", textbox12.text))
dbcommand.parameters.add(New SQLParameter("@natl", textbox13.text))
dbcommand.parameters.add(New SQLParameter("@gen", radiobuttonlist1.SelectedItem.value))
dbcommand.parameters.add(New SQLParameter("@cvlstat", radiobuttonlist2.SelectedItem.value))
dbcommand.parameters.add(New SQLParameter("@prgcod", textbox14.text))
dbcommand.parameters.add(New SQLParameter("@espec", textbox16.text))
dbcommand.parameters.add(New SQLParameter("@emajor", textbox17.text))
dbcommand.parameters.add(New SQLParameter("@eminor", textbox18.text))
dbcommand.parameters.add(New SQLParameter("@religion", textbox20.text))
dbcommand.parameters.add(New SQLParameter("@bapt", textbox21.text))
dbcommand.parameters.add(New SQLParameter("@acr", textbox22.text))
dbcommand.parameters.add(New SQLParameter("@gfnam", textbox23.text))
dbcommand.parameters.add(New SQLParameter("@gmnam", textbox24.text))
dbcommand.parameters.add(New SQLParameter("@glnam", textbox25.text))
dbcommand.parameters.add(New SQLParameter("@grel", textbox26.text))
dbcommand.parameters.add(New SQLParameter("@emplyd", radiobuttonlist3.SelectedItem.value))
dbcommand.parameters.add(New SQLParameter("@semplyd", radiobuttonlist4.SelectedItem.value))
dbcommand.parameters.add(New SQLParameter("@gocc", textbox27.text))
dbcommand.parameters.add(New SQLParameter("@goffnam", textbox28.text))
dbcommand.parameters.add(New SQLParameter("@goffadd", textbox29.text))
dbcommand.parameters.add(New SQLParameter("@goffph", textbox30.text))
dbcommand.parameters.add(New SQLParameter("@gofffax", textbox31.text))
dbcommand.parameters.add(New SQLParameter("@goffeadd", textbox32.text))
dbcommand.parameters.add(New SQLParameter("@eschl", textbox33.text))
dbcommand.parameters.add(New SQLParameter("@hschl", textbox34.text))
dbcommand.parameters.add(New SQLParameter("@cschl", textbox35.text))
dbcommand.parameters.add(New SQLParameter("@mschl", textbox36.text))
dbcommand.parameters.add(New SQLParameter("@edgrad", textbox37.text))
dbcommand.parameters.add(New SQLParameter("@hdgrad", textbox38.text))
dbcommand.parameters.add(New SQLParameter("@cdgrad", textbox39.text))
dbcommand.parameters.add(New SQLParameter("@mdgrad", textbox40.text))
dbcommand.parameters.add(New SQLParameter("@esono", textbox41.text))
dbcommand.parameters.add(New SQLParameter("@hsono", textbox42.text))
dbcommand.parameters.add(New SQLParameter("@csono", textbox43.text))
dbcommand.parameters.add(New SQLParameter("@msono", textbox44.text))
dbcommand.parameters.add(New SQLParameter("@cmajor", textbox45.text))
dbcommand.parameters.add(New SQLParameter("@cminor", textbox46.text))
dbcommand.parameters.add(New SQLParameter("@mmajor", textbox47.text))
dbcommand.parameters.add(New SQLParameter("@mminor", textbox48.text))
Dim rowsAffected As Integer = 0
dbConnection.Open
rowsAffected = dbCommand.ExecuteNonQuery
dbConnection.Close
End Sub
HERES WHAT I PLAN TO DO NEXT....
i have a table....
table name = parmcounters
field name = studentid value = "20030001"
now what i want to do is store the incremented studentid value in the "sturecs" table and also save the same value in the parmcounters table....
many had suggested like this...
INSERT INTO TargetTbl Select max(pstudentid) FROM SourceTable
others....
OleDbConnection conn = new OleDbConnection("Provider=blahblahblah...");
OleDbCommand cmd = new OleDbCommand("SELECT pStudentId FROM ParmStudId WHERE ... blahblahblah...", conn);
conn.Open();
int LastStudId = (int) cmd.ExecuteScalar();
conn.Close();
cmd = new OleDbCommand("UPDATE .... SET StudentId = @StudentId", conn);
cmd.Parameters.Add("@StudentId",OleDbType.Integer).Value = LastStudId + 1;
cmd.ExecuteNonQuery();
conn.Close();
.............now I REALLY Dont know how to do this in SQL...can you help me?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only