Welcome to Discuss Everything Forums...

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.


 

Reply to Thread

Post a reply to the thread: Error in insert into sql from asp.net?

Your Message

Click here to log in

What comes after M0nday

 
 

You may choose an icon for your message from this list

Additional Options

  • Will turn www.example.com into [URL]http://www.example.com[/URL].

Rate Thread

You may rate this thread from 1-star (Terrible) to 5-stars (Excellent) if you wish to do so.

Topic Review (Newest First)

  • 09-03-2010, 03:34 AM
    xtreamiest

    Error in insert into sql from asp.net?

    Dim cn As SqlConnection
    Dim cmd As SqlCommand
    cn = New SqlConnection
    cn.ConnectionString = ConfigurationManager.ConnectionStrings("fees_syste mConnectionString").ToString
    cn.Open()
    cmd = New SqlCommand
    cmd.Connection = cn
    cmd.CommandType = CommandType.Text
    cmd.CommandText = "insert into fees_submit ("date","grno,fees_of_month","admission_fees","mon thly_fees","arears","others","Total_fees","Rupees_ inwords") values('"& date.text &"',"& grno.text &",dropdownlist1.text,"& afees.text &","& mfees.text &","& arrears.text &","& others.text &","& totsl.text &",'"& inwords.text &"') "
    cmd.ExecuteNonQuery()

Posting Permissions

  • You may post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts
  •