Yes, the data is bound to a Gridview when I enter INV #.
Event I'm using is DetailsView1_It emUpdating. No additional Update statement!...
Barno77
Last Activity: Oct 17 '08, 02:07 PM
Joined: Oct 24 '07
Location:
-
Update-Insert DetailsView, result is duplicating lines
Everytime I edit a record, and hit update I get duplicating lines in my Details View. Here's my If statement:
...Code:If (Len(e.OldValues("AutoNumber")) > 0) Then sql = "UPDATE SHIP_LOG SET FileNumber='" & e.NewValues("FileNumber") & "',BOL='" & e.NewValues("BOL") & "',Container='" & e.NewValues("Container") & "',DESTN='"Last edited by Curtis Rutland; Sep 23 '08, 03:27 PM. Reason: Added Code Tags - Please surround your code with [CODE] and [/CODE] -
Button_Click Question
I would like to show a Panel or window when I click a button and then make it not visible when I click the same button again.
Help is greatly appreciated! -
Need to Fix Page Refresh using UpdatePanel in AJAX
Hi Everyone,
I have a Gridview in a UpdatePanel and everytime I click Edit button to edit a row of data in Gridview, the page refreshes. Would like to not Refresh page everytime!
Any suggestions?
Thanks in Advance!Last edited by DrBunchman; Jul 9 '08, 08:07 AM. Reason: Moved to .NET Forum - ASP Forum for Classic ASP only -
I just have a regular asp page with a button and a textbox. When I hit the button I want my record is being inserted into the table, but then I want to retrieve the Identity Id and show it in the textbox....Leave a comment:
-
Thanks, how can I actually show the value of the Identity Id in a textbox?...Leave a comment:
-
SCOPE_IDENTITY issue
I want to return the value of Identity Key which in this case is an AutoNumber field in my table and place the value of that field of the newly added record into a textbox. Here's what I got so far, my insert works, but no return as of yet:
Protected Sub Button2_Click(B yVal sender As Object, ByVal e As System.EventArg s) Handles Button2.Click
Dim sql As New SqlCommand
'Dim myconn As Data.SqlClient. SqlConnection... -
here's the sql query:
...Code:SELECT SO2_SOEntryDetailLine.SalesOrderNumber, SO1_SOEntryHeader.Division, SO1_SOEntryHeader.CustomerNumber, SO1_SOEntryHeader.BillToName, CA_OPS_PICKSEQS.LastPickSeq AS [Pick Ticket], SO2_SOEntryDetailLine.ItemNumber, SO2_SOEntryDetailLine.WhseCode, SO2_SOEntryDetailLine.LineIndex, SO1_SOEntryHeader.OrderStatus, CA_APICK_QTYS.QtyOrdered,
Leave a comment:
-
"Subquery returned more than 1 value. This is not permitted..." error
Basically I have an app with 3 buttons that populate a Gridview and all but 1 button work and the one that doesn't work brings back this error.
any ideas?Last edited by jhardman; Apr 11 '08, 07:51 PM. Reason: moved to .Net forum. ASP forum is for "classic" ASP -
Editing and Update Gridview
I have a simple app that has sqlDataSource pulling data from a table in a gridview. Now I want to be able to edit and update data in the gridview, without the automatic generate update in the sqlDataSource, by creating a function that will do that.
Any help would be greatly appreciated!
Thanks! -
Yes, I understand thank you!...Leave a comment:
-
Function to see if Table exists in sql server
Trying to build a function to see if table exists and if it doesn't then create that table!
Help would be greatly appreciated! -
I figured how to do this, but now how can figure out the date of the last Execution of a DTS Package?...Leave a comment:
-
DTS Package Transfer Help
What's the best way to transfer a DTS Package from one SQL Server to the another? -
I'm basically checking to see if a trigger exists and if it doesn't then I'm gonna get an email and I want to create that trigger. Any ideas? Check my code below:
Declare @Body as varchar(125)
Declare @NumRecs as numeric(9)
select
@NumRecs = COUNT(name)
from
dbo.sysobjects
where
OBJECTPROPERTY( id, N'IsTrigger') = 1 and name = 'TR_JUNK2'
select @NumRecs
Set...Leave a comment:
-
Create Trigger within T-SQL statement
How can I Create a Trigger that will be nested within T-SQL or another trigger? Thanks for any help! -
Thank you! This helped me!Leave a comment:
-
Query using schema to determine if Trigger exists
Hi,
I would like to know if there's a query that can tell me whether or not a trigger exists!
Thanks! -
Thanks for the quick reply and let you konw it goes! Appreciate it!...Leave a comment:
No activity results to display
Leave a comment: