fsima
چهارشنبه 06 تیر 1386, 08:17 صبح
برای اضافه کردن یه رکورد جدید کد زیر رو مینویسم اجرا میشه errorهم نمیده اما اضافه نمیشه
یعنی تو جدول مورد نظرم ابن رکورد نیست
Dim connection5string As String = "workstation id=STEVE;packet size=4096;" & "integrated security=SSPI;initial catalog=My University;persist security info=false"
Dim connection5 As New SqlClient.SqlConnection(connection5string)
Dim command5 As New SqlClient.SqlCommand
command5.CommandText = "INSERT INTO Grades(st#,crs#,year,term) VALUES=('" + Idlbl.Text + "','" + CrsId1.Text + "','" + frm3.Yeartxt.Text.ToString + "','" + frm3.Termcmb.Text.ToString + "'))"
connection5.Close()
یعنی تو جدول مورد نظرم ابن رکورد نیست
Dim connection5string As String = "workstation id=STEVE;packet size=4096;" & "integrated security=SSPI;initial catalog=My University;persist security info=false"
Dim connection5 As New SqlClient.SqlConnection(connection5string)
Dim command5 As New SqlClient.SqlCommand
command5.CommandText = "INSERT INTO Grades(st#,crs#,year,term) VALUES=('" + Idlbl.Text + "','" + CrsId1.Text + "','" + frm3.Yeartxt.Text.ToString + "','" + frm3.Termcmb.Text.ToString + "'))"
connection5.Close()