|
hello gurus
i m using a datagrid
i want to update and delete the database records with the datagrid.
i can update successfully.
code for update is:--------
Private Sub Dtgrd_Products_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles Dtgrd_Products.UpdateCommand
Dim txtId As TextBox = e.Item.Cells(2).Controls(0)
Dim str = txtId.Text
Dim txtName As TextBox = e.Item.Cells(3).Controls(0)
Dim txttype As TextBox = e.Item.Cells(4).Controls(0)
Dim txtdia As TextBox = e.Item.Cells(5).Controls(0)
Dim txtlength As TextBox = e.Item.Cells(6).Controls(0)
Dim txtLamType As TextBox = e.Item.Cells(7).Controls(0)
Dim txtVarType As TextBox = e.Item.Cells(8).Controls(0)
Dim txtcol1 As TextBox = e.Item.Cells(9).Controls(0)
Dim txtcol2 As TextBox = e.Item.Cells(10).Controls(0)
Dim txtcol3 As TextBox = e.Item.Cells(11).Controls(0)
Dim txtcol4 As TextBox = e.Item.Cells(12).Controls(0)
Dim txtcol5 As TextBox = e.Item.Cells(13).Controls(0)
Dim txtcol6 As TextBox = e.Item.Cells(14).Controls(0)
conn = New SqlConnection(constr)
cmd = New SqlCommand("spr_UpdateProductDetails", conn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add(New SqlParameter("@Id", txtId.Text))
cmd.Parameters.Add(New SqlParameter("@type", txttype.Text))
cmd.Parameters.Add(New SqlParameter("@dia", txtdia.Text))
cmd.Parameters.Add(New SqlParameter("@length", txtlength.Text))
cmd.Parameters.Add(New SqlParameter("@laminate_type", txtLamType.Text))
cmd.Parameters.Add(New SqlParameter("@varnish_type", txtVarType.Text))
cmd.Parameters.Add(New SqlParameter("@col1", txtcol1.Text))
cmd.Parameters.Add(New SqlParameter("@col2", txtcol2.Text))
cmd.Parameters.Add(New SqlParameter("@col3", txtcol3.Text))
cmd.Parameters.Add(New SqlParameter("@col4", txtcol4.Text))
cmd.Parameters.Add(New SqlParameter("@col5", txtcol5.Text))
cmd.Parameters.Add(New SqlParameter("@col6", txtcol6.Text))
conn.Open()
cmd.ExecuteNonQuery()
Dtgrd_Products.EditItemIndex = -1
conn.Close()
bindgrid()
End Sub
and for delete code is:--------
Private Sub Dtgrd_Products_DeleteCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles Dtgrd_Products.DeleteCommand
Dim txtId As TextBox = e.Item.Cells(2).Controls(0)
Dim str As String = txtId.Text
conn = New SqlConnection(constr)
cmd = New SqlCommand("spr_DeleteProductDetails", conn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add(New SqlParameter("@Id", txtId.Text))
conn.Open()
cmd.ExecuteNonQuery()
Dtgrd_Products.EditItemIndex = -1
conn.Close()
bindgrid()
End Sub
when i m trying to delete i get the error
"Specified arguement was outside the bound of the valid values."
wht to do.
Ajay
|
|
|
|
|
MissionSuccess wrote: Dtgrd_Products.EditItemIndex = -1
I'd say that -1 is outside the bounds of valid values
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
So What should i do?
this is for edit
Private Sub Dtgrd_Products_EditCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles Dtgrd_Products.EditCommand
Me.Dtgrd_Products.EditItemIndex = e.Item.ItemIndex
bindgrid()
End Sub
and this is for cancel
Private Sub Dtgrd_Products_CancelCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles Dtgrd_Products.CancelCommand
Me.Dtgrd_Products.EditItemIndex = -1
bindgrid()
End Sub
|
|
|
|
|
Am I on candid camera ?
Take that line out and see if it works. If so, find another way to clear the index.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
now i had commented out that line
Dtgrd_Products.EditItemIndex = -1
still gettin the same error
|
|
|
|
|
Step through your code and see which part throws the exception. If you use a Try/Catch block, the stack trace should show you where the error is. Unfortunately, you have so many parameterised variables in your code that we cannot help you here. Only debugging can save you now.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hi all !
As per my client request we need to create a webaplication that which automatically get connected to the webserver duering the OS loading(like a windows service).Am not createing any downloadable files to support that (like if we want to use yahoomessanger first we have to download the corresponding EXE from the webserver...then only by makeing use of the options(connect to the server duering OS loading) we will connecte to the server duering OS loading).First of all plz let me know the fact ,is it possible to create icon for the webapplication on the desktop,plz let me know wither this scenario is valid one or not.....if it is guide me in a proper way![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
Hmm...I'm not 100% sure what you mean. Is it that you want the clients browser to load and point to the web application when the OS starts? To do that, you'd have to create a shortcut to the URL and add it to the users startup (just put it in the startup folder on the start menu on Windows). Is that what you meant?
|
|
|
|
|
In calendar webcontrol,I want to inactive some of the dates in a particular month of the calendar and also i want to assign a single color to a particular date in a particular month of the calendar.
Neelima
|
|
|
|
|
hi K.R.Neelima,
this code may help u,
private void Calendar1_DayRender(object sender, System.Web.UI.WebControls.DayRenderEventArgs e)
{
if(e.Day.Date.Day<=29 && e.Day.Date.Month==01)
{
e.Cell.Enabled=false;
}
if(e.Day.Date.Day==29 && e.Day.Date.Month==01)
{
e.Cell.ForeColor=Color.SkyBlue;
}
}
|
|
|
|
|
Hi,
I'm currently creating an online share point-like portal for a school, and I need to be able to upload files i.e. Word, Excel etc (which is no problem), but then be able to edit and save them online, instead of downloading and reuploading.
Is this possible and if so how? I don't mind having to pay for a plug in if necessary.
Thanks,
Aaron
|
|
|
|
|
Well, you could always search for the DSOFramer control and see if that fits your needs.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hi dear.
How can i design online application form using asp.net and microsoft access as a database tool
Please advise me
regards
adil
m.adil.farooq
mcs & acca
adil-farooq@maktoob.com
|
|
|
|
|
|
Hi All,
I am using the ajax extension in my project asp.net 2.0.
following error occur.
Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 12031
even i had add the handler
<httphandlers>
<remove verb="*" path="*.asmx">
<add verb="*" path="*.asmx" validate="false" type="Microsoft.Web.Script.Services.ScriptHandlerFactory, Microsoft.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
<add verb="GET" path="ScriptResource.axd" type="Microsoft.Web.Handlers.ScriptResourceHandler" validate="false">
any budy help me.
thanks in advance
|
|
|
|
|
Try disabling AsyncPostBack on the ScriptManager so you get a normal postback and then you should get a more meaningfull error page.
|
|
|
|
|
Hi friends,
How can i give paypal intergeration facility to my website? Can you give any reference or url?
Thanks and regards,
Jegastar D.
|
|
|
|
|
https://developer.paypal.com/
|
|
|
|
|
hello
my question is that i'm getting a page HTML by my code.what i want....to make the thumbnail image of this HTML display like we do by "PRINTSCREEN" button.
can i do this?
thanx
Dotnet
|
|
|
|
|
Hi all
I have a datagrid, which holds item name, item price, and its image(all from SQL Server database), what I need is when the user clicks on the image, I need the (id) for the item to be carried to the new page where I want to show more details about the item (expiry date, ...)
thanks alot...
|
|
|
|
|
|
Hi Dear...
you didn't attach me the grid code block...
thanks alot and have a nice day
|
|
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
