Register Register Member Login Member Login Member Login Forgot Password ??
PHP , ASP , ASP.NET, VB.NET, C#, Java , jQuery , Android , iOS , Windows Phone
 

Registered : 109,038

HOME > .NET Framework > Forum > ติดอีกและพี่ช่วยดูให้หน่อย พอจา insert ก้อติดตรง comAdd1.ExecuteNonQuery() นี้อ่ามานขึ้นแทบเขียวๆอ่า


 

[.NET] ติดอีกและพี่ช่วยดูให้หน่อย พอจา insert ก้อติดตรง comAdd1.ExecuteNonQuery() นี้อ่ามานขึ้นแทบเขียวๆอ่า

 
Topic : 035235



โพสกระทู้ ( 937 )
บทความ ( 2 )



สถานะออฟไลน์
Facebook


พอจา insert ก้อติดตรง

comAdd1.ExecuteNonQuery()

นี้อ่ามานขึ้นแทบเขียวๆอ่า

code insertทั้งหมดตรงนี้นะ

Code (ASP)
view source
print?
001.Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
002.      Dim strConn As String = WebConfigurationManager.ConnectionStrings("Genius").ConnectionString
003.      Dim Conn As New SqlConnection(strConn)
004. 
005.      '-------------------------------------------------------Personal Data------------------------------------------------------------------
006.      Dim ID As String
007. 
008.      'ID = "Tc_"+ date("U")
009.      ID = "Tc_123456789"
010.      Dim User = Session("Username")
011.      Dim Pass = Session("Pass")
012.      Dim Email = Session("Email")
013.      Dim first = Session("first")
014.      Dim firstname = Session("firstname")
015.      Dim last = Session("lastname")
016.      Dim status = "0"
017.      Dim heigth = Session("heigth")
018.      Dim weigth = Session("weigth")
019.      Dim gender = Session("gender")
020.      Dim marry = Session("marry")
021.      Dim child = Session("child")
022.      Dim Nation = Session("Nationality")
023.      Dim Origin = Session("Origin")
024.      Dim religion = Session("Religion")
025.      Dim birth = Session("Date")
026.      Dim Smoke = Session("Smoke")
027.      Dim drink = Session("drink")
028.      Dim street1 = Session("street_current")
029.      Dim district1 = Session("district_current")
030.      Dim Country1 = Session("country_current")
031.      Dim Zip1 = Session("zip_current")
032.      Dim tele1 = Session("tele_current")
033.      Dim contact1 = Session("contact_current")
034.      Dim street2 = Session("street_origin")
035.      Dim district2 = Session("district_origin")
036.      Dim Country2 = Session("country_origin")
037.      Dim Zip2 = Session("zip_origin")
038.      Dim tele2 = Session("tele_origin")
039.      Dim contact2 = Session("contact_origin")
040.      Dim hight = Session("hight")
041.      Dim hight_ins = Session("hight_ins")
042.      Dim hight_major = Session("hight_major")
043.      Dim hight_branch = Session("hight_branch")
044.      Dim hight_date = Session("hight_date")
045.      Dim hight_GPA = Session("hight_GPA")
046.      Dim sec = Session("sec")
047.      Dim sec_ins = Session("sec_ins")
048.      Dim sec_major = Session("sec_major")
049.      Dim sec_branch = Session("sec_branch")
050.      Dim sec_GPA = Session("sec_GPA")
051.      ' Dim encode = MD5(Pass)
052. 
053.      Dim sqlAdd1 As String
054.      Dim comAdd1 As New SqlCommand
055. 
056.      sqlAdd1 = "INSERT INTO Teacher(ID_Tc,Username,Password,First_Tc,Name_Tc,Sur_Tc,Status,Heigth,Weigth,Gender,email_Tc,marry,Num_child,nationality,origin,religion,Date_birth,Smoke,Drink,Street_Cur,District_Cur,Country_Cur,Zip_Cur,Tel1_Tc,Street_ori,District_ori,Country_ori,Zip_ori,Tel2_Tc,Hight_Level,Hight_Ins,Hight_Major,Hight_Branch,Hight_Since,Hight_GPA,Sec_Level,Sec_Ins,Sec_Major,Sec_Branch,Sec_GPA)"
057.      sqlAdd1 = " VALUES('" & ID.ToString & "',"
058.      sqlAdd1 = "'" & User.ToString & "',"
059.      sqlAdd1 = "'" & Pass.ToString & "',"
060.      sqlAdd1 = "'" & first.ToString & "',"
061.      sqlAdd1 = "'" & firstname.ToString & "',"
062.      sqlAdd1 = "'" & last.ToString & "',"
063.      sqlAdd1 = "'" & status.ToString & "',"
064.      sqlAdd1 = "'" & heigth.ToString & "',"
065.      sqlAdd1 = "'" & weigth.ToString & "',"
066.      sqlAdd1 = "'" & gender.ToString & "',"
067.      sqlAdd1 = "'" & Email.ToString & "',"
068.      sqlAdd1 = "'" & marry.ToString & "',"
069.      sqlAdd1 = "'" & child.ToString & "',"
070.      sqlAdd1 = "'" & Nation.ToString & "',"
071.      sqlAdd1 = "'" & Origin.ToString & "',"
072.      sqlAdd1 = "'" & religion.ToString & "',"
073.      sqlAdd1 = "'" & birth.ToString & "',"
074.      sqlAdd1 = "'" & Smoke.ToString & "',"
075.      sqlAdd1 = "'" & drink.ToString & "',"
076.      sqlAdd1 = "'" & street1.ToString & "',"
077.      sqlAdd1 = "'" & district1.ToString & "',"
078.      sqlAdd1 = "'" & Country1.ToString & "',"
079.      sqlAdd1 = "'" & Zip1.ToString & "',"
080.      sqlAdd1 = "'" & tele1.ToString & "',"
081.      sqlAdd1 = "'" & street1.ToString & "',"
082.      sqlAdd1 = "'" & district2.ToString & "',"
083.      sqlAdd1 = "'" & Country2.ToString & "',"
084.      sqlAdd1 = "'" & Zip2.ToString & "',"
085.      sqlAdd1 = "'" & tele2.ToString & "',"
086.      sqlAdd1 = "'" & hight.ToString & "',"
087.      sqlAdd1 = "'" & hight_ins.ToString & "',"
088.      sqlAdd1 = "'" & hight_major.ToString & "',"
089.      sqlAdd1 = "'" & hight_branch.ToString & "',"
090.      sqlAdd1 = "'" & hight_date.ToString & "',"
091.      sqlAdd1 = "'" & hight_GPA.ToString & "',"
092.      sqlAdd1 = "'" & sec.ToString & "',"
093.      sqlAdd1 = "'" & sec_ins.ToString & "',"
094.      sqlAdd1 = "'" & sec_major.ToString & "',"
095.      sqlAdd1 = "'" & sec_branch.ToString & "',"
096.      sqlAdd1 = "'" & sec_GPA.ToString & "')"
097. 
098.      comAdd1 = New SqlCommand(sqlAdd1, Conn)
099. 
100.      Conn.Open()
101. 
102.      comAdd1.ExecuteNonQuery()
103. 
104.      Conn.Close()
105. 
106.      '-----------------------------------------------------------------------------------------------------------------
107.      '------------------------------------------Edu and Ex-------------------------------------------------------
108. 
109. 
110.      Dim from1 = Session("from1")
111.      Dim to1 = Session("to1")
112.      Dim company1 = Session("company1")
113.      Dim com_add1 = Session("com_add1")
114.      Dim position1 = Session("position1")
115.      Dim salary1 = Session("salary1")
116.      Dim job1 = Session("job1")
117. 
118.      Dim sqlAdd2 As String
119.      Dim comAdd2 As New SqlCommand
120.                           
121.      sqlAdd2 = "insert into Experience_Tc(ID_Tc,Ex_From,Ex_To,Company,Company_Add,Position,Salary,Job_Des,No_Ex)"
122.      sqlAdd2 = " values ('" & ID.ToString & "',"
123.      sqlAdd2 = "'" & from1.ToString & "',"
124.      sqlAdd2 = "'" & to1.ToString & "',"
125.      sqlAdd2 = "'" & company1.ToString & "',"
126.      sqlAdd2 = "'" & com_add1.ToString & "',"
127.      sqlAdd2 = "'" & position1.ToString & "',"
128.      sqlAdd2 = "'" & salary1.ToString & "',"
129.      sqlAdd2 = "'" & job1.ToString & "',"
130.      sqlAdd2 = "'1')"
131. 
132.      comAdd2 = New SqlCommand(sqlAdd2, Conn)
133. 
134.      Conn.Open()
135. 
136.      comAdd2.ExecuteNonQuery()
137. 
138.      Conn.Close()




Tag : - - - -
Move To Hilight (Stock) 
Send To Friend.Bookmark.
Date : 2009-12-03 10:29:50 By : LuckyStar View : 1158 Reply : 9
 

 

No. 1



โพสกระทู้ ( 74,059 )
บทความ ( 838 )

สมาชิกที่ใส่เสื้อไทยครีเอท

สถานะออฟไลน์
Twitter Facebook

Conn.Open() น่าจะอยู่ก่อน comAdd2 = New SqlCommand(sqlAdd2, Conn) น่ะครับ
Date : 2009-12-03 10:41:00 By : webmaster
 

 

No. 2



โพสกระทู้ ( 937 )
บทความ ( 2 )



สถานะออฟไลน์
Facebook

พี่อ่าพอย้ายแล้วมานก้อมาติดตรงตัวหนาตรงนี้อีกอ่า

Conn.Open()
comAdd1 = New SqlCommand(sqlAdd1, Conn)

comAdd1.ExecuteNonQuery()

Conn.Close()
Date : 2009-12-03 10:48:36 By : LuckyStar
 

 

No. 3



โพสกระทู้ ( 3,144 )
บทความ ( 1 )

สมาชิกที่ใส่เสื้อไทยครีเอท

สถานะออฟไลน์


error ตรง Execute

แสดงว่า syntex ผ่านหมดไปติดที่ sql command

ลองตรวจที่ sql command ก่อนเด้อ ว่าใช้ได้หรือเปล่า

หรืออาจเป็นที่ session บางตัวมันเป็น null เลยทำให้

sql command มันเอ๋อ

ลองใช้ if ดักดู
Date : 2009-12-03 13:28:42 By : tungman
 

 

No. 4

Guest


แง้พี่ลองใช้ifดักแล้วแบบนี้
Code (ASP)
view source
print?
001.Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
002.        Dim strConn As String = WebConfigurationManager.ConnectionStrings("Genius").ConnectionString
003.        Dim Conn As New SqlConnection(strConn)
004. 
005.        '-------------------------------------------------------Personal Data------------------------------------------------------------------
006.        Dim ID As String
007. 
008.        'ID = "Tc_"+ date("U")
009.        ID = "Tc_1234567890"
010.        Dim User = Session("Username")
011.        Dim Pass = Session("Pass")
012.        Dim Email = Session("Email")
013.        Dim first = Session("first")
014.        Dim firstname = Session("firstname")
015.        Dim last = Session("lastname")
016.        Dim status = "0"
017.        Dim heigth = Session("heigth")
018.        Dim weigth = Session("weigth")
019.        Dim gender = Session("gender")
020.        Dim marry = Session("marry")
021.        Dim child = Session("child")
022.        Dim Nation = Session("Nationality")
023.        Dim Origin = Session("Origin")
024.        Dim religion = Session("Religion")
025.        Dim birth = Session("Date")
026.        Dim Smoke = Session("Smoke")
027.        Dim drink = Session("drink")
028.        Dim street1 = Session("street_current")
029.        Dim district1 = Session("district_current")
030.        Dim Country1 = Session("country_current")
031.        Dim Zip1 = Session("zip_current")
032.        Dim tele1 = Session("tele_current")
033.        Dim contact1 = Session("contact_current")
034.        Dim street2 = Session("street_origin")
035.        Dim district2 = Session("district_origin")
036.        Dim Country2 = Session("country_origin")
037.        Dim Zip2 = Session("zip_origin")
038.        Dim tele2 = Session("tele_origin")
039.        Dim contact2 = Session("contact_origin")
040.        Dim hight = Session("hight")
041.        Dim hight_ins = Session("hight_ins")
042.        Dim hight_major = Session("hight_major")
043.        Dim hight_branch = Session("hight_branch")
044.        Dim hight_date = Session("hight_date")
045.        Dim hight_GPA = Session("hight_GPA")
046.        Dim sec = Session("sec")
047.        Dim sec_ins = Session("sec_ins")
048.        Dim sec_major = Session("sec_major")
049.        Dim sec_branch = Session("sec_branch")
050.        Dim sec_GPA = Session("sec_GPA")
051.        ' Dim encode = MD5(Pass)
052. 
053.        Dim sqlAdd1 As String
054.        Dim comAdd1 As New SqlCommand
055.        If ID.ToString = "" Or User.ToString = "" Or Pass.ToString = "" Or first.ToString = "" Or firstname.ToString = "" Or last.ToString = "" Or status.ToString = "" Or heigth.ToString = "" Or weigth.ToString = "" Or gender.ToString = "" Or Email.ToString = "" Or marry.ToString = "" Or child.ToString = "" Or Nation.ToString = "" Or Origin.ToString = "" Or religion.ToString = "" Or birth.ToString = "" Or Smoke.ToString = "" Or drink.ToString = "" Or street1.ToString = "" Or district1.ToString = "" Or Country1.ToString = "" Or Zip1.ToString = "" Or tele1.ToString = "" Or street1.ToString = "" Or district2.ToString = "" Or Country2.ToString = "" Or Zip2.ToString = "" Or tele2.ToString = "" Or hight.ToString = "" Or hight_ins.ToString = "" Or hight_major.ToString = "" Or hight_branch.ToString = "" Or hight_date.ToString = "" Or hight_GPA.ToString = "" Or sec.ToString = "" Or sec_ins.ToString = "" Or sec_branch.ToString = "" Or sec_GPA.ToString = "" Then
056. 
057. 
058.            MsgBox("null", MsgBoxStyle.OkOnly)
059.        Else
060. 
061.            sqlAdd1 = "INSERT INTO Teacher(ID_Tc,Username,Password,First_Tc,Name_Tc,Sur_Tc,Status,Heigth,Weigth,Gender,email_Tc,marry,Num_child,nationality,origin,religion,Date_birth,Smoke,Drink,Street_Cur,District_Cur,Country_Cur,Zip_Cur,Tel1_Tc,Street_ori,District_ori,Country_ori,Zip_ori,Tel2_Tc,Hight_Level,Hight_Ins,Hight_Major,Hight_Branch,Hight_Since,Hight_GPA,Sec_Level,Sec_Ins,Sec_Major,Sec_Branch,Sec_GPA)"
062.            sqlAdd1 = " VALUES('" & ID.ToString & "',"
063.            sqlAdd1 = "'" & User.ToString & "',"
064.            sqlAdd1 = "'" & Pass.ToString & "',"
065.            sqlAdd1 = "'" & first.ToString & "',"
066.            sqlAdd1 = "'" & firstname.ToString & "',"
067.            sqlAdd1 = "'" & last.ToString & "',"
068.            sqlAdd1 = "'" & status.ToString & "',"
069.            sqlAdd1 = "'" & heigth.ToString & "',"
070.            sqlAdd1 = "'" & weigth.ToString & "',"
071.            sqlAdd1 = "'" & gender.ToString & "',"
072.            sqlAdd1 = "'" & Email.ToString & "',"
073.            sqlAdd1 = "'" & marry.ToString & "',"
074.            sqlAdd1 = "'" & child.ToString & "',"
075.            sqlAdd1 = "'" & Nation.ToString & "',"
076.            sqlAdd1 = "'" & Origin.ToString & "',"
077.            sqlAdd1 = "'" & religion.ToString & "',"
078.            sqlAdd1 = "'" & birth.ToString & "',"
079.            sqlAdd1 = "'" & Smoke.ToString & "',"
080.            sqlAdd1 = "'" & drink.ToString & "',"
081.            sqlAdd1 = "'" & street1.ToString & "',"
082.            sqlAdd1 = "'" & district1.ToString & "',"
083.            sqlAdd1 = "'" & Country1.ToString & "',"
084.            sqlAdd1 = "'" & Zip1.ToString & "',"
085.            sqlAdd1 = "'" & tele1.ToString & "',"
086.            sqlAdd1 = "'" & street1.ToString & "',"
087.            sqlAdd1 = "'" & district2.ToString & "',"
088.            sqlAdd1 = "'" & Country2.ToString & "',"
089.            sqlAdd1 = "'" & Zip2.ToString & "',"
090.            sqlAdd1 = "'" & tele2.ToString & "',"
091.            sqlAdd1 = "'" & hight.ToString & "',"
092.            sqlAdd1 = "'" & hight_ins.ToString & "',"
093.            sqlAdd1 = "'" & hight_major.ToString & "',"
094.            sqlAdd1 = "'" & hight_branch.ToString & "',"
095.            sqlAdd1 = "'" & hight_date.ToString & "',"
096.            sqlAdd1 = "'" & hight_GPA.ToString & "',"
097.            sqlAdd1 = "'" & sec.ToString & "',"
098.            sqlAdd1 = "'" & sec_ins.ToString & "',"
099.            sqlAdd1 = "'" & sec_major.ToString & "',"
100.            sqlAdd1 = "'" & sec_branch.ToString & "',"
101.            sqlAdd1 = "'" & sec_GPA.ToString & "')"
102.            Conn.Open()
103.            comAdd1 = New SqlCommand(sqlAdd1, Conn)
104. 
105. 
106. 
107.            comAdd1.ExecuteNonQuery()
108. 
109.            Conn.Close()
110. 
111.            '-----------------------------------------------------------------------------------------------------------------
112.            '------------------------------------------Edu and Ex-------------------------------------------------------
113. 
114. 
115.            Dim from1 = Session("from1")
116.            Dim to1 = Session("to1")
117.            Dim company1 = Session("company1")
118.            Dim com_add1 = Session("com_add1")
119.            Dim position1 = Session("position1")
120.            Dim salary1 = Session("salary1")
121.            Dim job1 = Session("job1")
122. 
123.            Dim sqlAdd2 As String
124.            Dim comAdd2 As New SqlCommand
125. 
126.            sqlAdd2 = "insert into Experience_Tc(ID_Tc,Ex_From,Ex_To,Company,Company_Add,Position,Salary,Job_Des,No_Ex)"
127.            sqlAdd2 = " values ('" & ID.ToString & "',"
128.            sqlAdd2 = "'" & from1.ToString & "',"
129.            sqlAdd2 = "'" & to1.ToString & "',"
130.            sqlAdd2 = "'" & company1.ToString & "',"
131.            sqlAdd2 = "'" & com_add1.ToString & "',"
132.            sqlAdd2 = "'" & position1.ToString & "',"
133.            sqlAdd2 = "'" & salary1.ToString & "',"
134.            sqlAdd2 = "'" & job1.ToString & "',"
135.            sqlAdd2 = "'1')"
136.            Conn.Open()
137.            comAdd2 = New SqlCommand(sqlAdd2, Conn)
138. 
139. 
140. 
141.            comAdd2.ExecuteNonQuery()
142. 
143.            Conn.Close()
144. 
145. 
146.        End If


แต่มันยังerrorที่เดิมอ่า
comAdd1.ExecuteNonQuery()
Date : 2009-12-03 14:58:20 By : LuckyStar
 

 

No. 5



โพสกระทู้ ( 3,144 )
บทความ ( 1 )

สมาชิกที่ใส่เสื้อไทยครีเอท

สถานะออฟไลน์


error อันนี้แหละมั้ง

Code (VB.NET)
view source
print?
01.sqlAdd1 = "INSERT INTO Teacher(ID_Tc,Username,Password,First_Tc,Name_Tc,Sur_Tc,Status,Heigth,Weigth,Gender,email_Tc,marry,Num_child,nationality,origin,religion,Date_birth,Smoke,Drink,Street_Cur,District_Cur,Country_Cur,Zip_Cur,Tel1_Tc,Street_ori,District_ori,Country_ori,Zip_ori,Tel2_Tc,Hight_Level,Hight_Ins,Hight_Major,Hight_Branch,Hight_Since,Hight_GPA,Sec_Level,Sec_Ins,Sec_Major,Sec_Branch,Sec_GPA)"
02.            sqlAdd1 = " VALUES('" & ID.ToString & "',"
03.            sqlAdd1 = "'" & User.ToString & "',"
04.            sqlAdd1 = "'" & Pass.ToString & "',"
05.            sqlAdd1 = "'" & first.ToString & "',"
06.            sqlAdd1 = "'" & firstname.ToString & "',"
07.            sqlAdd1 = "'" & last.ToString & "',"
08.            sqlAdd1 = "'" & status.ToString & "',"
09.            sqlAdd1 = "'" & heigth.ToString & "',"
10.            sqlAdd1 = "'" & weigth.ToString & "',"
11.            sqlAdd1 = "'" & gender.ToString & "',"
12.            sqlAdd1 = "'" & Email.ToString & "',"
13.            sqlAdd1 = "'" & marry.ToString & "',"
14.            sqlAdd1 = "'" & child.ToString & "',"
15.            sqlAdd1 = "'" & Nation.ToString & "',"
16.            sqlAdd1 = "'" & Origin.ToString & "',"
17.            sqlAdd1 = "'" & religion.ToString & "',"
18.            sqlAdd1 = "'" & birth.ToString & "',"
19.            sqlAdd1 = "'" & Smoke.ToString & "',"
20.            sqlAdd1 = "'" & drink.ToString & "',"
21.            sqlAdd1 = "'" & street1.ToString & "',"
22.            sqlAdd1 = "'" & district1.ToString & "',"
23.            sqlAdd1 = "'" & Country1.ToString & "',"
24.            sqlAdd1 = "'" & Zip1.ToString & "',"
25.            sqlAdd1 = "'" & tele1.ToString & "',"
26.            sqlAdd1 = "'" & street1.ToString & "',"
27.            sqlAdd1 = "'" & district2.ToString & "',"
28.            sqlAdd1 = "'" & Country2.ToString & "',"
29.            sqlAdd1 = "'" & Zip2.ToString & "',"
30.            sqlAdd1 = "'" & tele2.ToString & "',"
31.            sqlAdd1 = "'" & hight.ToString & "',"
32.            sqlAdd1 = "'" & hight_ins.ToString & "',"
33.            sqlAdd1 = "'" & hight_major.ToString & "',"
34.            sqlAdd1 = "'" & hight_branch.ToString & "',"
35.            sqlAdd1 = "'" & hight_date.ToString & "',"
36.            sqlAdd1 = "'" & hight_GPA.ToString & "',"
37.            sqlAdd1 = "'" & sec.ToString & "',"
38.            sqlAdd1 = "'" & sec_ins.ToString & "',"
39.            sqlAdd1 = "'" & sec_major.ToString & "',"
40.            sqlAdd1 = "'" & sec_branch.ToString & "',"
41.            sqlAdd1 = "'" & sec_GPA.ToString & "')"
42.            Conn.Open()
43.            comAdd1 = New SqlCommand(sqlAdd1, Conn)


แก้เป็น

Code (VB.NET)
view source
print?
01.sqlAdd1 = "INSERT INTO Teacher(ID_Tc,Username,Password,First_Tc,Name_Tc,Sur_Tc,Status,Heigth,Weigth,Gender,email_Tc,marry,Num_child,nationality,origin,religion,Date_birth,Smoke,Drink,Street_Cur,District_Cur,Country_Cur,Zip_Cur,Tel1_Tc,Street_ori,District_ori,Country_ori,Zip_ori,Tel2_Tc,Hight_Level,Hight_Ins,Hight_Major,Hight_Branch,Hight_Since,Hight_GPA,Sec_Level,Sec_Ins,Sec_Major,Sec_Branch,Sec_GPA)" &_
02.            " VALUES('" & ID.ToString & "'," &_
03.            "'" & User.ToString & "'," &_
04.            "'" & Pass.ToString & "'," &_
05.            "'" & first.ToString & "'," &_
06.            "'" & firstname.ToString & "'," &_
07.            "'" & last.ToString & "'," &_
08.            "'" & status.ToString & "'," &_
09.            "'" & heigth.ToString & "'," &_
10.            "'" & weigth.ToString & "'," &_
11.            "'" & gender.ToString & "'," &_
12.            "'" & Email.ToString & "'," &_
13.            "'" & marry.ToString & "'," &_
14.            "'" & child.ToString & "'," &_
15.            "'" & Nation.ToString & "'," &_
16.            "'" & Origin.ToString & "'," &_
17.            "'" & religion.ToString & "'," &_
18.            "'" & birth.ToString & "'," &_
19.            "'" & Smoke.ToString & "'," &_
20.            "'" & drink.ToString & "'," &_
21.            "'" & street1.ToString & "'," &_
22.            "'" & district1.ToString & "'," &_
23.            "'" & Country1.ToString & "'," &_
24.            "'" & Zip1.ToString & "'," &_
25.            "'" & tele1.ToString & "'," &_
26.            "'" & street1.ToString & "'," &_
27.            "'" & district2.ToString & "'," &_
28.            "'" & Country2.ToString & "'," &_
29.            "'" & Zip2.ToString & "'," &_
30.            "'" & tele2.ToString & "'," &_
31.            "'" & hight.ToString & "'," &_
32.            "'" & hight_ins.ToString & "'," &_
33.            "'" & hight_major.ToString & "'," &_
34.            "'" & hight_branch.ToString & "'," &_
35.            "'" & hight_date.ToString & "'," &_
36.            "'" & hight_GPA.ToString & "'," &_
37.            "'" & sec.ToString & "'," &_
38.            "'" & sec_ins.ToString & "'," &_
39.            "'" & sec_major.ToString & "'," &_
40.            "'" & sec_branch.ToString & "'," &_
41.            "'" & sec_GPA.ToString & "')"
42.            Conn.Open()
43.            comAdd1 = New SqlCommand(sqlAdd1, Conn)
Date : 2009-12-04 13:57:31 By : tungman
 

 

No. 6

Guest


เอาของพี่ไปใส่แล้วแต่ว่าerrorตรงตัวหนาอ่า
"'" & sec_GPA.ToString & "')"
Date : 2009-12-04 15:55:55 By : LuckyStar
 

 

No. 7



โพสกระทู้ ( 937 )
บทความ ( 2 )



สถานะออฟไลน์
Facebook

55555+
หนูอยากจะขำตายแก้มาตั้งหลายวันที่แท้ๆๆๆๆๆผิดตรงนี้นิเอง

อันเดิม
Code (ASP)
view source
print?
1.sqlAdd1 = " VALUES('" & ID.ToString & "',"
2.  
3.sqlAdd1 = "'" & User.ToString & "',"


หนูลืม&แค่นี้เอง

Code (ASP)
view source
print?
1.sqlAdd1 = " VALUES('" & ID.ToString & "',"
2.  
3.sqlAdd1 &= "'" & User.ToString & "',"


ขอบคุนพวกพี่ๆๆๆมากๆๆนะคะแก้มาสะหลายวัน
Date : 2009-12-04 16:03:56 By : LuckyStar
 

 

No. 8



โพสกระทู้ ( 179 )
บทความ ( 0 )



สถานะออฟไลน์


มันปัญหา เดี้ยวกันอ่ะเปล่าครับ ^^

https://www.thaicreate.com/dotnet/forum/035278.html
Date : 2009-12-04 16:12:33 By : ksillapapan
 

 

No. 9



โพสกระทู้ ( 410 )
บทความ ( 0 )



สถานะออฟไลน์
Facebook

โห เห็นแบบนี้เห็นใจเลย เขียนคนเดียวสินะ ไม่มีเพื่อนข้างๆ ละสิ
Date : 2009-12-04 16:20:21 By : zero1150kfc
 

   

ค้นหาข้อมูล
   
 

แสดงความคิดเห็น
Re : ติดอีกและพี่ช่วยดูให้หน่อย พอจา insert ก้อติดตรง comAdd1.ExecuteNonQuery() นี้อ่ามานขึ้นแทบเขียวๆอ่า
 
 
รายละเอียด
 
ตัวหนา ตัวเอียง ตัวขีดเส้นใต้ ตัวมีขีดกลาง| ตัวเรืองแสง ตัวมีเงา ตัวอักษรวิ่ง| จัดย่อหน้าอิสระ จัดย่อหน้าชิดซ้าย จัดย่อหน้ากึ่งกลาง จัดย่อหน้าชิดขวา| เส้นขวาง| ขนาดตัวอักษร แบบตัวอักษร
ใส่แฟลช ใส่รูป ใส่ไฮเปอร์ลิ้งค์ ใส่อีเมล์ ใส่ลิ้งค์ FTP| ใส่แถวของตาราง ใส่คอลัมน์ตาราง| ตัวยก ตัวห้อย ตัวพิมพ์ดีด| ใส่โค้ด ใส่การอ้างถึงคำพูด| ใส่ลีสต์
smiley for :lol: smiley for :ken: smiley for :D smiley for :) smiley for ;) smiley for :eek: smiley for :geek: smiley for :roll: smiley for :erm: smiley for :cool: smiley for :blank: smiley for :idea: smiley for :ehh: smiley for :aargh: smiley for :evil:
Insert PHP Code
Insert ASP Code
 Insert VB.NET Code Insert C#.NET Code Insert JavaScript Code Insert C#.NET Code
Insert Java Code
Insert Android Code
Insert Objective-C Code
Insert XML Code
Insert SQL Code
Insert Code
เพื่อความเรียบร้อยของข้อความ ควรจัดรูปแบบให้พอดีกับขนาดของหน้าจอ เพื่อง่ายต่อการอ่านและสบายตา และตรวจสอบภาษาไทยให้ถูกต้อง

อัพโหลดแทรกรูปภาพ

Notice

เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ
อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง

   
  เพื่อความปลอดภัยและการตรวจสอบ กระทู้ที่แทรกไฟล์อัพโหลดไฟล์จากที่อื่น อาจจะถูกลบทิ้ง
 
โดย
อีเมล์
บวกค่าให้ถูก
<= ตัวเลขฮินดูอารบิก เช่น 123 (หรือล็อกอินเข้าระบบสมาชิกเพื่อไม่ต้องกรอก)





ThaiCreate.Com Logo
© www.ThaiCreate.Com. 2003-2025 All Rights Reserved.
ไทยครีเอทบริการ จัดทำดูแลแก้ไข Web Application ทุกรูปแบบ (PHP, .Net Application, VB.Net, C#)
[Conditions Privacy Statement] ติดต่อโฆษณา 081-987-6107 อัตราราคา คลิกที่นี่