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,028

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



 

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

 



Topic : 035235



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



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



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

comAdd1.ExecuteNonQuery()

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

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

Code (ASP)
  Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim strConn As String = WebConfigurationManager.ConnectionStrings("Genius").ConnectionString
        Dim Conn As New SqlConnection(strConn)

        '-------------------------------------------------------Personal Data------------------------------------------------------------------
        Dim ID As String

        'ID = "Tc_"+ date("U")
        ID = "Tc_123456789"
        Dim User = Session("Username")
        Dim Pass = Session("Pass")
        Dim Email = Session("Email")
        Dim first = Session("first")
        Dim firstname = Session("firstname")
        Dim last = Session("lastname")
        Dim status = "0"
        Dim heigth = Session("heigth")
        Dim weigth = Session("weigth")
        Dim gender = Session("gender")
        Dim marry = Session("marry")
        Dim child = Session("child")
        Dim Nation = Session("Nationality")
        Dim Origin = Session("Origin")
        Dim religion = Session("Religion")
        Dim birth = Session("Date")
        Dim Smoke = Session("Smoke")
        Dim drink = Session("drink")
        Dim street1 = Session("street_current")
        Dim district1 = Session("district_current")
        Dim Country1 = Session("country_current")
        Dim Zip1 = Session("zip_current")
        Dim tele1 = Session("tele_current")
        Dim contact1 = Session("contact_current")
        Dim street2 = Session("street_origin")
        Dim district2 = Session("district_origin")
        Dim Country2 = Session("country_origin")
        Dim Zip2 = Session("zip_origin")
        Dim tele2 = Session("tele_origin")
        Dim contact2 = Session("contact_origin")
        Dim hight = Session("hight")
        Dim hight_ins = Session("hight_ins")
        Dim hight_major = Session("hight_major")
        Dim hight_branch = Session("hight_branch")
        Dim hight_date = Session("hight_date")
        Dim hight_GPA = Session("hight_GPA")
        Dim sec = Session("sec")
        Dim sec_ins = Session("sec_ins")
        Dim sec_major = Session("sec_major")
        Dim sec_branch = Session("sec_branch")
        Dim sec_GPA = Session("sec_GPA")
        ' Dim encode = MD5(Pass)

        Dim sqlAdd1 As String
        Dim comAdd1 As New SqlCommand

        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)"
        sqlAdd1 = " VALUES('" & ID.ToString & "',"
        sqlAdd1 = "'" & User.ToString & "',"
        sqlAdd1 = "'" & Pass.ToString & "',"
        sqlAdd1 = "'" & first.ToString & "',"
        sqlAdd1 = "'" & firstname.ToString & "',"
        sqlAdd1 = "'" & last.ToString & "',"
        sqlAdd1 = "'" & status.ToString & "',"
        sqlAdd1 = "'" & heigth.ToString & "',"
        sqlAdd1 = "'" & weigth.ToString & "',"
        sqlAdd1 = "'" & gender.ToString & "',"
        sqlAdd1 = "'" & Email.ToString & "',"
        sqlAdd1 = "'" & marry.ToString & "',"
        sqlAdd1 = "'" & child.ToString & "',"
        sqlAdd1 = "'" & Nation.ToString & "',"
        sqlAdd1 = "'" & Origin.ToString & "',"
        sqlAdd1 = "'" & religion.ToString & "',"
        sqlAdd1 = "'" & birth.ToString & "',"
        sqlAdd1 = "'" & Smoke.ToString & "',"
        sqlAdd1 = "'" & drink.ToString & "',"
        sqlAdd1 = "'" & street1.ToString & "',"
        sqlAdd1 = "'" & district1.ToString & "',"
        sqlAdd1 = "'" & Country1.ToString & "',"
        sqlAdd1 = "'" & Zip1.ToString & "',"
        sqlAdd1 = "'" & tele1.ToString & "',"
        sqlAdd1 = "'" & street1.ToString & "',"
        sqlAdd1 = "'" & district2.ToString & "',"
        sqlAdd1 = "'" & Country2.ToString & "',"
        sqlAdd1 = "'" & Zip2.ToString & "',"
        sqlAdd1 = "'" & tele2.ToString & "',"
        sqlAdd1 = "'" & hight.ToString & "',"
        sqlAdd1 = "'" & hight_ins.ToString & "',"
        sqlAdd1 = "'" & hight_major.ToString & "',"
        sqlAdd1 = "'" & hight_branch.ToString & "',"
        sqlAdd1 = "'" & hight_date.ToString & "',"
        sqlAdd1 = "'" & hight_GPA.ToString & "',"
        sqlAdd1 = "'" & sec.ToString & "',"
        sqlAdd1 = "'" & sec_ins.ToString & "',"
        sqlAdd1 = "'" & sec_major.ToString & "',"
        sqlAdd1 = "'" & sec_branch.ToString & "',"
        sqlAdd1 = "'" & sec_GPA.ToString & "')"

        comAdd1 = New SqlCommand(sqlAdd1, Conn)

        Conn.Open()

        comAdd1.ExecuteNonQuery()

        Conn.Close()

        '-----------------------------------------------------------------------------------------------------------------
        '------------------------------------------Edu and Ex-------------------------------------------------------


        Dim from1 = Session("from1")
        Dim to1 = Session("to1")
        Dim company1 = Session("company1")
        Dim com_add1 = Session("com_add1")
        Dim position1 = Session("position1")
        Dim salary1 = Session("salary1")
        Dim job1 = Session("job1")

        Dim sqlAdd2 As String
        Dim comAdd2 As New SqlCommand
							
        sqlAdd2 = "insert into Experience_Tc(ID_Tc,Ex_From,Ex_To,Company,Company_Add,Position,Salary,Job_Des,No_Ex)"
        sqlAdd2 = " values ('" & ID.ToString & "',"
        sqlAdd2 = "'" & from1.ToString & "',"
        sqlAdd2 = "'" & to1.ToString & "',"
        sqlAdd2 = "'" & company1.ToString & "',"
        sqlAdd2 = "'" & com_add1.ToString & "',"
        sqlAdd2 = "'" & position1.ToString & "',"
        sqlAdd2 = "'" & salary1.ToString & "',"
        sqlAdd2 = "'" & job1.ToString & "',"
        sqlAdd2 = "'1')"

        comAdd2 = New SqlCommand(sqlAdd2, Conn)

        Conn.Open()

        comAdd2.ExecuteNonQuery()

        Conn.Close()




Tag : - - - -






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

 

No. 1



โพสกระทู้ ( 74,058 )
บทความ ( 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)
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim strConn As String = WebConfigurationManager.ConnectionStrings("Genius").ConnectionString
        Dim Conn As New SqlConnection(strConn)

        '-------------------------------------------------------Personal Data------------------------------------------------------------------
        Dim ID As String

        'ID = "Tc_"+ date("U")
        ID = "Tc_1234567890"
        Dim User = Session("Username")
        Dim Pass = Session("Pass")
        Dim Email = Session("Email")
        Dim first = Session("first")
        Dim firstname = Session("firstname")
        Dim last = Session("lastname")
        Dim status = "0"
        Dim heigth = Session("heigth")
        Dim weigth = Session("weigth")
        Dim gender = Session("gender")
        Dim marry = Session("marry")
        Dim child = Session("child")
        Dim Nation = Session("Nationality")
        Dim Origin = Session("Origin")
        Dim religion = Session("Religion")
        Dim birth = Session("Date")
        Dim Smoke = Session("Smoke")
        Dim drink = Session("drink")
        Dim street1 = Session("street_current")
        Dim district1 = Session("district_current")
        Dim Country1 = Session("country_current")
        Dim Zip1 = Session("zip_current")
        Dim tele1 = Session("tele_current")
        Dim contact1 = Session("contact_current")
        Dim street2 = Session("street_origin")
        Dim district2 = Session("district_origin")
        Dim Country2 = Session("country_origin")
        Dim Zip2 = Session("zip_origin")
        Dim tele2 = Session("tele_origin")
        Dim contact2 = Session("contact_origin")
        Dim hight = Session("hight")
        Dim hight_ins = Session("hight_ins")
        Dim hight_major = Session("hight_major")
        Dim hight_branch = Session("hight_branch")
        Dim hight_date = Session("hight_date")
        Dim hight_GPA = Session("hight_GPA")
        Dim sec = Session("sec")
        Dim sec_ins = Session("sec_ins")
        Dim sec_major = Session("sec_major")
        Dim sec_branch = Session("sec_branch")
        Dim sec_GPA = Session("sec_GPA")
        ' Dim encode = MD5(Pass)

        Dim sqlAdd1 As String
        Dim comAdd1 As New SqlCommand
        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


            MsgBox("null", MsgBoxStyle.OkOnly)
        Else

            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)"
            sqlAdd1 = " VALUES('" & ID.ToString & "',"
            sqlAdd1 = "'" & User.ToString & "',"
            sqlAdd1 = "'" & Pass.ToString & "',"
            sqlAdd1 = "'" & first.ToString & "',"
            sqlAdd1 = "'" & firstname.ToString & "',"
            sqlAdd1 = "'" & last.ToString & "',"
            sqlAdd1 = "'" & status.ToString & "',"
            sqlAdd1 = "'" & heigth.ToString & "',"
            sqlAdd1 = "'" & weigth.ToString & "',"
            sqlAdd1 = "'" & gender.ToString & "',"
            sqlAdd1 = "'" & Email.ToString & "',"
            sqlAdd1 = "'" & marry.ToString & "',"
            sqlAdd1 = "'" & child.ToString & "',"
            sqlAdd1 = "'" & Nation.ToString & "',"
            sqlAdd1 = "'" & Origin.ToString & "',"
            sqlAdd1 = "'" & religion.ToString & "',"
            sqlAdd1 = "'" & birth.ToString & "',"
            sqlAdd1 = "'" & Smoke.ToString & "',"
            sqlAdd1 = "'" & drink.ToString & "',"
            sqlAdd1 = "'" & street1.ToString & "',"
            sqlAdd1 = "'" & district1.ToString & "',"
            sqlAdd1 = "'" & Country1.ToString & "',"
            sqlAdd1 = "'" & Zip1.ToString & "',"
            sqlAdd1 = "'" & tele1.ToString & "',"
            sqlAdd1 = "'" & street1.ToString & "',"
            sqlAdd1 = "'" & district2.ToString & "',"
            sqlAdd1 = "'" & Country2.ToString & "',"
            sqlAdd1 = "'" & Zip2.ToString & "',"
            sqlAdd1 = "'" & tele2.ToString & "',"
            sqlAdd1 = "'" & hight.ToString & "',"
            sqlAdd1 = "'" & hight_ins.ToString & "',"
            sqlAdd1 = "'" & hight_major.ToString & "',"
            sqlAdd1 = "'" & hight_branch.ToString & "',"
            sqlAdd1 = "'" & hight_date.ToString & "',"
            sqlAdd1 = "'" & hight_GPA.ToString & "',"
            sqlAdd1 = "'" & sec.ToString & "',"
            sqlAdd1 = "'" & sec_ins.ToString & "',"
            sqlAdd1 = "'" & sec_major.ToString & "',"
            sqlAdd1 = "'" & sec_branch.ToString & "',"
            sqlAdd1 = "'" & sec_GPA.ToString & "')"
            Conn.Open()
            comAdd1 = New SqlCommand(sqlAdd1, Conn)



            comAdd1.ExecuteNonQuery()

            Conn.Close()

            '-----------------------------------------------------------------------------------------------------------------
            '------------------------------------------Edu and Ex-------------------------------------------------------


            Dim from1 = Session("from1")
            Dim to1 = Session("to1")
            Dim company1 = Session("company1")
            Dim com_add1 = Session("com_add1")
            Dim position1 = Session("position1")
            Dim salary1 = Session("salary1")
            Dim job1 = Session("job1")

            Dim sqlAdd2 As String
            Dim comAdd2 As New SqlCommand

            sqlAdd2 = "insert into Experience_Tc(ID_Tc,Ex_From,Ex_To,Company,Company_Add,Position,Salary,Job_Des,No_Ex)"
            sqlAdd2 = " values ('" & ID.ToString & "',"
            sqlAdd2 = "'" & from1.ToString & "',"
            sqlAdd2 = "'" & to1.ToString & "',"
            sqlAdd2 = "'" & company1.ToString & "',"
            sqlAdd2 = "'" & com_add1.ToString & "',"
            sqlAdd2 = "'" & position1.ToString & "',"
            sqlAdd2 = "'" & salary1.ToString & "',"
            sqlAdd2 = "'" & job1.ToString & "',"
            sqlAdd2 = "'1')"
            Conn.Open()
            comAdd2 = New SqlCommand(sqlAdd2, Conn)



            comAdd2.ExecuteNonQuery()

            Conn.Close()


        End If


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


 

No. 5



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

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

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


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

Code (VB.NET)
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)"
            sqlAdd1 = " VALUES('" & ID.ToString & "',"
            sqlAdd1 = "'" & User.ToString & "',"
            sqlAdd1 = "'" & Pass.ToString & "',"
            sqlAdd1 = "'" & first.ToString & "',"
            sqlAdd1 = "'" & firstname.ToString & "',"
            sqlAdd1 = "'" & last.ToString & "',"
            sqlAdd1 = "'" & status.ToString & "',"
            sqlAdd1 = "'" & heigth.ToString & "',"
            sqlAdd1 = "'" & weigth.ToString & "',"
            sqlAdd1 = "'" & gender.ToString & "',"
            sqlAdd1 = "'" & Email.ToString & "',"
            sqlAdd1 = "'" & marry.ToString & "',"
            sqlAdd1 = "'" & child.ToString & "',"
            sqlAdd1 = "'" & Nation.ToString & "',"
            sqlAdd1 = "'" & Origin.ToString & "',"
            sqlAdd1 = "'" & religion.ToString & "',"
            sqlAdd1 = "'" & birth.ToString & "',"
            sqlAdd1 = "'" & Smoke.ToString & "',"
            sqlAdd1 = "'" & drink.ToString & "',"
            sqlAdd1 = "'" & street1.ToString & "',"
            sqlAdd1 = "'" & district1.ToString & "',"
            sqlAdd1 = "'" & Country1.ToString & "',"
            sqlAdd1 = "'" & Zip1.ToString & "',"
            sqlAdd1 = "'" & tele1.ToString & "',"
            sqlAdd1 = "'" & street1.ToString & "',"
            sqlAdd1 = "'" & district2.ToString & "',"
            sqlAdd1 = "'" & Country2.ToString & "',"
            sqlAdd1 = "'" & Zip2.ToString & "',"
            sqlAdd1 = "'" & tele2.ToString & "',"
            sqlAdd1 = "'" & hight.ToString & "',"
            sqlAdd1 = "'" & hight_ins.ToString & "',"
            sqlAdd1 = "'" & hight_major.ToString & "',"
            sqlAdd1 = "'" & hight_branch.ToString & "',"
            sqlAdd1 = "'" & hight_date.ToString & "',"
            sqlAdd1 = "'" & hight_GPA.ToString & "',"
            sqlAdd1 = "'" & sec.ToString & "',"
            sqlAdd1 = "'" & sec_ins.ToString & "',"
            sqlAdd1 = "'" & sec_major.ToString & "',"
            sqlAdd1 = "'" & sec_branch.ToString & "',"
            sqlAdd1 = "'" & sec_GPA.ToString & "')"
            Conn.Open()
            comAdd1 = New SqlCommand(sqlAdd1, Conn)


แก้เป็น

Code (VB.NET)
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)" &_
            " VALUES('" & ID.ToString & "'," &_
            "'" & User.ToString & "'," &_
            "'" & Pass.ToString & "'," &_
            "'" & first.ToString & "'," &_
            "'" & firstname.ToString & "'," &_
            "'" & last.ToString & "'," &_
            "'" & status.ToString & "'," &_
            "'" & heigth.ToString & "'," &_
            "'" & weigth.ToString & "'," &_
            "'" & gender.ToString & "'," &_
            "'" & Email.ToString & "'," &_
            "'" & marry.ToString & "'," &_
            "'" & child.ToString & "'," &_
            "'" & Nation.ToString & "'," &_
            "'" & Origin.ToString & "'," &_
            "'" & religion.ToString & "'," &_
            "'" & birth.ToString & "'," &_
            "'" & Smoke.ToString & "'," &_
            "'" & drink.ToString & "'," &_
            "'" & street1.ToString & "'," &_
            "'" & district1.ToString & "'," &_
            "'" & Country1.ToString & "'," &_
            "'" & Zip1.ToString & "'," &_
            "'" & tele1.ToString & "'," &_
            "'" & street1.ToString & "'," &_
            "'" & district2.ToString & "'," &_
            "'" & Country2.ToString & "'," &_
            "'" & Zip2.ToString & "'," &_
            "'" & tele2.ToString & "'," &_
            "'" & hight.ToString & "'," &_
            "'" & hight_ins.ToString & "'," &_
            "'" & hight_major.ToString & "'," &_
            "'" & hight_branch.ToString & "'," &_
            "'" & hight_date.ToString & "'," &_
            "'" & hight_GPA.ToString & "'," &_
            "'" & sec.ToString & "'," &_
            "'" & sec_ins.ToString & "'," &_
            "'" & sec_major.ToString & "'," &_
            "'" & sec_branch.ToString & "'," &_
            "'" & sec_GPA.ToString & "')"
            Conn.Open()
            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)
sqlAdd1 = " VALUES('" & ID.ToString & "',"
 
sqlAdd1 = "'" & User.ToString & "',"


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

Code (ASP)
sqlAdd1 = " VALUES('" & ID.ToString & "',"
 
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 (หรือล็อกอินเข้าระบบสมาชิกเพื่อไม่ต้องกรอก)







Exchange: นำเข้าสินค้าจากจีน, Taobao, เฟอร์นิเจอร์, ของพรีเมี่ยม, ร่ม, ปากกา, power bank, แฟลชไดร์ฟ, กระบอกน้ำ

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