Re: GridVew Updation - ASP.NET Discussion Boards

1.First create a template column for data grid
<asp:templatecolumn>
<itemtemplate>
<asp:linkbutton runat="server" id="lnkDelete" text="Delete" onclientclick="return confirm('Are you sure?')" commandname="Delrecd" commandargument="<%# Eval("ProductID")%>">

2.set an event in DataGrid as
OnItemCommand="mydatagrid_ItemCommand"

3.Now in the code behing file in mydatagrid_ItemCommand function
protected void mydatagrid_ItemCommand(object source, DataGridCommandEventArgs e)
{

if (e.CommandName.ToString() == "Delrecd")
{

SqlConnection con = new SqlConnection("connstring");
con.Open();
int pid = Convert.ToInt32(e.Item.Cells[0].Text);
String updtstr = "Delete from products where ProductID=" + pid;
SqlCommand cmd = new SqlCommand(updtstr, con);
cmd.ExecuteNonQuery();
con.Close();
mydatagrid.EditItemIndex = -1;
binddatagrid(); //this method bind data in datagrid
}
}

just follow this u will get what u want bye

PIYUSH

Hi Piyush,

Thanks, but at later checking, I was wondering is there a different between data grid and data view as it seems mine is data view, that whether the code used is the same.

J Liang

Hi All,

I have 2 webforms .First Form have one Textbox.I want to display the value of Textbox in webform2 using javascript and then compare both the textboxex using javascript.Pls send me the code.

Thanks.

u may use the Cross Page Posting feature if u r using ASP.Net 2.0

sreeram

Hi,

In my application,When member's session expires I want to redirect the member to home page where he can relogin there.This functinality is working fine in internet explorer but not in firefox.It is showing an error "Unable to Validate Data".

Can anybody helpme why this is not happening in firefox please

Thanx in Advance.

Bhanu

Posting the code what you used for redirection will be much helpfull

printf("Navaneeth!!")

www.w3hearts.com

How to update a gridview if we have used sqldatasource and updatecommand is storedprocedure,How We can get the edited fields of gridview as a parameters for our stored procedure used here??????

PIYUSH

Use the SqlDataSource for this or code it your self.
I asume you will not use the SqlDataSource.
Steps:
1) fetch the GridViewRowUpdate event
2) compare old and new value
3) create sql statements

See sample(you should call your Storedproc with SqlCommand class)
Protected Sub GridViewDetectorInstellingen_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles GridViewDetectorInstellingen.RowUpdating
Dim newvals As IOrderedDictionary = e.NewValues
Dim oldvals As IOrderedDictionary = e.OldValues
'note TDBP1 is column name in Grid
Dim begin As String = newvals.Item("TDBP1").ToString()
Dim einde As String = newvals.Item("TDBP2").ToString()
Dim oudbegin As String = oldvals.Item("TDBP1").ToString()
Dim oudeinde As String = oldvals.Item("TDBP2").ToString()
Dim keys As IOrderedDictionary = e.Keys
'Keys are the key columns from the main key of the source table
Dim dim1 As String = keys.Item("Dimension1")
Dim dim2 As String = keys.Item("Dimension2")
Dim kid As String = keys.Item("KID")
Dim sql As String
Dim pos As Int32
If Not IsNothing(begin) Then
If begin <> oudbegin Then
pos = begin.IndexOf(":")
If pos > -1 Then
begin = begin.Remove(begin.IndexOf(":"), 1)
End If
sql = "update Elementen0 set [Value] = " & begin & " where Dimension1 = " & dim1 & " and Dimension2 = " & dim2 & " and OID = (select ID from Objecten where KID = " & kid & " and Naam = 'TDBP1')"
globalstuff.ExecuteNonQuery(sql)
End If
End If
If Not IsNothing(einde) Then
If einde <> oudeinde Then
pos = einde.IndexOf(":")
If pos > -1 Then
einde = einde.Remove(einde.IndexOf(":"), 1)
End If
sql = "update Elementen0 set [Value] = " & einde & " where Dimension1 = " & dim1 & " and Dimension2 = " & dim2 & " and OID = (select ID from Objecten where KID = " & kid & " and Naam = 'TDBP2')"
globalstuff.ExecuteNonQuery(sql)
End If
End If
'no update through SqlDataSource permitted
e.Cancel = True
'update is done through code behind so stop editmode
Me.GridViewDetectorInstellingen.EditIndex = -1
Me.GridViewDetectorInstellingen.DataBind()
End Sub

Mdv

i am using history.go() to go back to previous page on click of the back button .The problem is if i am adding something to the database and then going back with the back button the gridview is not getting updated since it is history page . so how can this be solved . How can i refresh the page.

pls help me out .

Why are you using javascript history.go() it cause the page come from Cache ?
You are trying to do 2 opposite things

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

In GridView i have used <asp:sqldatasource> for Data access and want to update through a stored procedure i have set the attributes as
UpdateCommand="Cricketers_UpdateRow" UpdateCommandType="storedProcedure"

Now for th stored procedure i want to get the updated parameters through cells of gridview than how can I get these parameters?

PIYUSH

Hi take this URL there are many article present you can take help form one of it
Grid View Website
http://gridviewguy.com/CategoryDetails.aspx?categoryID=7[^]
MSDN help

http://msdn2.microsoft.com/en-us/library/ms972948.aspx[^]

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

Hi All,

I have 3 webforms .First Form have name Textbox and show button when i click show it displaying corresponding names in datagrid with checkboxes when I try to check one particular item then it will navigate to next page for updating the name,Here user should not give the same original(currentname).For that i need to print a message please select different name using javascript How?

It is simple update of name but name should different in two form. i.e should not use same name for updating.

Thanks.

siddisagar wrote:
with checkboxes when I try to check one particular item then it will navigate to next page for updating the name,

How you are sending the name ? Assign the name in some hidden textbox. Then get the value using javascript for checking.

printf("Navaneeth!!")

www.w3hearts.com

I have to compare two values in next page using javascript I haveto pass this value using Hidden field.Pls send me the code.

Hi,

Can anybody tell me will the session expired based on the time out value of the session if i use state server or sqlserver modes ? if not when the session will expiry in both modes ?? please let me know if anybody knows. Thanks in advance

Thanks and Regards

Venkat

Hi
Based on timeout value session is going to expire in Both Modes.

Hi, i have two user controls. Namely
1.public partial class QuoteCtrl : UserControlBase
2.public partial class ItemsSummaryCtrl : UserControlBase

Now i am writing one method which return boolean value in the first usercontrol
Now my questions is how to make a call from the second user control, to that method which is written in the first user control.

If anybody knows the answer please let me know.

Thanks and Regards
Dayakar D.N

It's not very good practice to have two different user controls reliant on each other. It's better to allow the controlling page to have access to these properties and to pass them to any control that requires them.

Hi Dayakar,

you not able to do that procedure which u following.try other way.ELSE contact to Prasad. he knows very well.

Hello,

Can you please send me the Sample code for hiddenfield control in asp.net

Vimal Joseph
Software Engineer
Quest Informatics Pvt Ltd

Be Specific and let me know it in detail abt which part to be hiiden in your control.

Regards,

Satips.

In ASP.NET 2.0 there is one new tool called hiddenfield and i want to know the usage of that control

Vimal Joseph
Software Engineer
Quest Informatics

Hi
HiddenField Contorl is similar to hidden input type(<input type="hidden" id="hidden1">) in Html.You can use this to store values.

eg:-

Assigning value to HiddenField:-

HiddenField1.Value = "Your Value";

Retriving value from HiddenField:-

Response.Write(HiddenField1.Value);

Sandeep Kumar.V

Hello,

Assigning value to HiddenField:-

HiddenField1.Value = "Your Value";

Retriving value from HiddenField:-

Response.Write(HiddenField1.Value);

* But this is not working for another pages.

Vimal Joseph
Software Engineer
Quest Informatics