|
Look there are multiple ways to do that one is you loop through all the number of records to be deleted and execute the delete statement.
second one is you send alll the id as a comma separated value to the query like this:
delete from table1 where id in (1,7,43,7)
Best Regards,
Apurva Kaushal
|
|
|
|
|
How can I make a datagrid editable?? So that I can modify values + delete the selected rows in dg..??
Nandini Sharma
|
|
|
|
|
either you can use datagrid built in edit and delete functionality or you can use your own one.
BTW Here[^] you can get lot of example related to datagrid.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Put one button column in datagrid, which has command name as "delete"
Now in ItemCommand write as
Select Case e.CommandName
Case "delete"
//Do all deletion operation here
//Assign datakey value of datagrid to one variable like
Dim ID as string = DataGrid1.DataKeys(e.item.itemindex)
// SQL Query is
"delete from table_name where Column_Name = ID"
// here Column_Name is the primary key column of ur table.
End Select
prakash
|
|
|
|
|
Dim str As String
Dim cmd As New SqlCommand
' Dim s As String
' s = e.Item.ItemIndex.
str = "delete from stumaster where enrol=@penrol"
cmd = New SqlCommand(str, con)
cmd.Parameters.Add(New SqlParameter("@penrol", SqlDbType.NVarChar, 4))
'cmd.Parameters("@pid").Value = dg.SelectedItem
cmd.Parameters("@penrol").Value = e.Item.Cells[0].Text
cmd.ExecuteNonQuery()
Response.Write("deleted")
bindgrid()
I have written this code for deletion ,but not functioning. Plz check it out and make corrections.....
Nandini Sharma
|
|
|
|
|
hope this[^]helps u
"If A is success in life, then A equals x plus y plus z. Work is x; y is play; and z is keeping your mouth shut." - Albert Einstein
|
|
|
|
|
Thanx for the reply..
I hope I will get my prob. solved from the material..
One more thing i want to ask--
How can i make datagrid editable, so that I can write in it...????
|
|
|
|
|
|
Thanx for the reply..
I hope I will get my prob. solved from the material..
One more thing i want to ask--
How can i make datagrid editable, so that I can write in it...????
Nanidni Sharma
|
|
|
|
|
Dim str As String
Dim cmd As New SqlCommand
' Dim s As String
' s = e.Item.ItemIndex.
str = "delete from stumaster where enrol=@penrol"
cmd = New SqlCommand(str, con)
cmd.Parameters.Add(New SqlParameter("@penrol", SqlDbType.NVarChar, 4))
'cmd.Parameters("@pid").Value = dg.SelectedItem
cmd.Parameters("@penrol").Value = e.Item.Cells[0].Text
cmd.ExecuteNonQuery()
Response.Write("deleted")
bindgrid()
I have written this code for delete operation but its not working plz check it out and make corrections if there r????
Nandini Sharma
|
|
|
|
|
hi..
u can use dataGrids bulit in events for both of ur requirements...like for 'update' use edit command and for 'delete' use delete command..after this call the functions under corsponding events..
|
|
|
|
|
Thanks for the reply...
But What functions to call????
Can u plz send me a code as an eg..
Nandini Sharma
|
|
|
|
|
Dim str As String
Dim cmd As New SqlCommand
' Dim s As String
' s = e.Item.ItemIndex.
str = "delete from stumaster where enrol=@penrol"
cmd = New SqlCommand(str, con)
cmd.Parameters.Add(New SqlParameter("@penrol", SqlDbType.NVarChar, 4))
'cmd.Parameters("@pid").Value = dg.SelectedItem
cmd.Parameters("@penrol").Value = e.Item.Cells[0].Text
cmd.ExecuteNonQuery()
Response.Write("deleted")
bindgrid()
I have written this code for delete operation but its not working plz check it out and make corrections if there r????
Nandini Sharma
|
|
|
|
|
how can we check perticular COM Component exist in a System through asp.net web application
Plz AnyBody Give me some Idea
Thanks&Regards
Srilakshmi
|
|
|
|
|
u can use createobject method if this method fail it's mean com not exist otherwise exist.
Parwej Ahamad
|
|
|
|
|
Hi,
I am Ravindra ,currently doing a project in asp.net.
I was given a task of "registration form for new users in a matrimonal site".
In the Regform there is dropdownlist in which when we select OTHER ,
the Regform.aspx is redirected to Subcaste.aspx
there the user enters the values and presses submit button
the page is again redirected to Regform.aspx.
My problem is the values which are previously entered by the user in RegForm are getting cleared.
So, please say how to preserve the values.
thanks in advance...
-Ravindra
|
|
|
|
|
you can use sessions or querystring to store the values and again set the values to the dropdownlist.
Best Regards,
Apurva Kaushal
|
|
|
|
|
I have a "Back" link in aspx page.
If clicked on this link it go to previouspage. For this I wrote goto(-1)>back
It is working fine.
But I also Have a continue button which inserts data into db when clicked on it.
So If i go back and click on continue new record is inserte for the same member i don't want that to happen.
I want to maintain state persistence.
how can I do this.
Can Anybody help me
Thanx in Advance
Bhanu
|
|
|
|
|
Hi there
the followeing code may help
If not page.isPostBack() Then
'The code that u want to execute the first time u get in the page
Else
'The code that u want to execute if u get back to the page
End if
I'm not sure if this would help but i hope so
Best Regards
3ala2
|
|
|
|
|
How to detect media player version using asp.net? any suggestions? thanks in adv.
|
|
|
|
|
|
Sir,
There is a function named access key in the datagrid property .How can i use it .Can u please explain.
Thanks
|
|
|
|
|
An access key (also known as a hot key) allows users to press the ALT key plus another key to jump to a specific control on the page without using the mouse.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hi,
Can anyone send me the link for the E-BOOKS on ASP.NET
Siva
India
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
