Deleting in datagrid

Question

0.00/5 (No votes)

See more:

hi guys, again ive got a problem. as you see ive created a datagrid with a delete button my code in delete botton is as follows

VB

Dim strSQL As String
Dim DBConn As New SqlClient.SqlConnection("Data Source=ML0003135586;Integrated Security=SSPI;" & "Initial Catalog=TestSQL")
Dim DBCmd As SqlClient.SqlCommand
strSQL = "DELETE FROM tblCourses_13514 WHERE Course_Code = '" & data1.DataKeys.Item(e.RowIndex).Value & "'"
DBConn.Open()
DBCmd = New SqlClient.SqlCommand(strSQL, DBConn)
DBCmd.ExecuteNonQuery()
data1.EditIndex = -1
data1.DataBind()
    DBConn.Close()

(actually it run) my problem is it holds on loading and my project pops out and highlighted these

strSQL = &quot;DELETE FROM tblCourses_13514 WHERE Course_Code = '" & data1.DataKeys.Item(e.RowIndex).value &"'"

Help me plss im new here. thanks and more power

Posted 3-May-11 16:19pm

janwel

Updated 3-May-11 16:35pm

walterhevedeich

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Accepted Answer · 2011-05-03T17:27:00

Solution 1

Not sure what you mean by "project pops out and highlighted these". Did you get an error?
Try debugging your source code to see if you can figure out the exact issue. Check if the value of the data1 item that your are checking is null.

Posted 3-May-11 17:27pm

Abhinav S

Comments

janwel 4-May-11 0:23am

ill try