|
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
|
|
|
|
|
|
Sir,
I want to know about the viewstate function in the datagrid.I mean if I have to use the viewstate in the datagird then what are the various limitations and the advantages over using the viewstate or not using the viewstate.
Please Help.
Thanks
|
|
|
|
|
If you have Set EnableViewState to true for a DataGrid which is having thousands of record. Then you will end up having viewstate size more than 10 KBytes. But if you disable viewstate, you will not be able to fire any events in DataGrid. Postback and acting on postback relies on Viewstate. So if it is readonly datagrid and if you are not going to use paging and sorting provided by datagrid, then you can disable viewstate. But if you want use above mentioned feature of DataGrid, then you can not disable ViewState in DataGrid. So to avoid excessive load on client machine because of viewstate . You can disable viewstate for each item in DataGrid. Disabling can be done in two ways, one way is disabling each itemtemplate columns viewstate to false.
Best Regards,
Apurva Kaushal
|
|
|
|
|
I'm using ASP.NET 1.1 and would like to call store procedure with date type parameter
The problem is that datetime on the web server is not equal to datetime on Oracle server.
What I really want to do is to give par2 value of Oracle sysdate function and dont know how to do it.
Dim lc_date As Date = Now().ToShortDateString
Dim par2 As New OracleClient.OracleParameter("p_date", OracleClient.OracleType.DateTime)
par2.Direction = ParameterDirection.Input
par2.Value = lc_date.ToString
sqlcom.Parameters.Add(par2)
Same problem appears when you updateting table record on Oracle with values from dataset. How to tell dataset to update some field on the sourse (oracle) with oracle built-in function let's say SYSDATE
Jerry
|
|
|
|
|
i have a button which should open a new page in server side. and after clicking it, there will be two browser page. what is its server side code.
my server side language is c#.net.
thanks rastgar
|
|
|
|
|
Either you don't want what you asked for, or you have some very unusal reason for wanting it.
If you open a new page in server side, it will be opened on the server, and it won't be available to the user.
If you don't want to open it in server side at all, but on the client side, you have to do that from the browser. You can use Javascript to do that:
window.open('PageToOpen.aspx', '_blank');
---
b { font-weight: normal; }
|
|
|
|
|
there are alot of axample for what i want to do.
mmmmmmmmmmmmmmmmmmmmmm
for example: in yahoo mail. have ever seen whenever you want to delete a mail, yahoo opens a new page for you to confirm deletion? doesn't it process in server side? of course yes. because your request is sent to server.
how can i implement it?
i know that javascript code but you suppose that i want to write some code in buttonclick event depending on my database, and for each condition i sould open a new page in new window not the old window. how can i do that?
thanks
rastgar
|
|
|
|
|
Yes boss.
On buttonclick of that button
write as
Response.Write("Call javascript function here")
Thats it.
Best of Luck
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
