|
Hi Tad,
Just realised that LogonUserIdentity is new in 2.0. We are using 1.1, so I guess we will have to find alternative way... Thanks, anyway.. 
Regards,
Chr
|
|
|
|
|
I would like to push the rows into datatable those are selected in a grid view. How to enable it. It' nice if it has checkbox in front of each row. How to achieve this?
Jey
|
|
|
|
|
You can get it Here[^]
Best Regards,
Apurva Kaushal
|
|
|
|
|
Loop out the grid and check to "Checked" check boxes if found then push whole row into the dattable.
akhilesh
|
|
|
|
|
combo box control contain 30 vaules but i want to show maximum 5 items when user click on dropdownlist and rest come while scrolling.
dcjoshi2
|
|
|
|
|
There is no combo box. I suppose that you mean a dropdown list, i.e. a select element?
How many items that is shown in the list is chosen by the browser, and nothing that is defined in html.
---
b { font-weight: normal; }
|
|
|
|
|
Use listbox rather than going to commbo box/ drop down list.
If u want to show only 5 element then set the height accordigly.
|
|
|
|
|
I have a database in SQL Server 2000 and want to modify and delete entries in it using datagrid. How?????
Nandini Sharma
|
|
|
|
|
Do you want to delete a particular row in datagrid? If so then you can use itemcommand event for that, there you can write the code to delete the record and again rebind the datagrid.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Thanx for the reply..
But Can u send me the code as an eg. plz..
Actually what to write in the itemcommand event of data grid to delete the row???
I think the code for deletion shoulsd be
"delete from table1 where ----"
What to write in where condition???
I mean suppose i want to delete the row whose id is in its 1st column then wa=hat to write??????
One more thing can i delete more than 1 row at a time????
Nandini Sharma...
|
|
|
|
|
Nandini Sharma wrote: delete from table1 where ----
delete from table1 where "PrmaryColumnName" = "PrimarycolumnName_SentByYou"
Nandini Sharma wrote: can i delete more than 1 row at a time????
yes.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Yes....But How?????????????
Nandini Sharma
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
