I'm always getting '-1' as return value from my business layer insert method. Why?
View Complete Post
I have a reports table with column report id and and report version. I created a trigger on this table to execute an application to do some processing each time a row is inserted in reports table. I need to pass the new report id execute this application from the trigger. How do I get the report id from the row that was inserted?
In my mysql I have an autoincrement id , whenever I add a new row into database I need to store this id in other table, so how to get this autoincrement Id back?
1) I have a ORDER form which is a usercontrol(webpart in sharepoint)
the first field is a autogenerated column given as ORD01,ORD02,ORD03...
for this i have a column in the list which stores these values into list after user submits data.
Now i want to show last inserted ORDER + 1 in the first field .
i.e., when user opens this ORDER page it should show the value.
2) the second case would when user submits data simultanoeusly.
Can anyone suggest a solution for this
Inserted a custom list with a calendar view on a page as webpart. Browse month function does not work, there is a postback but month is still the current month instead of the next or previous.
Is this a know issue/bug?
HI, I need some help from you guys ...Please
My requirement is
I have a database called DB
SELECT COUNT (*) FROM CUSTOMER WHERE SSN NOT LIKE'88%"
SELECT CUSTOMER_ID FROM CUSTOMER
WHERE SSN NOT LIKE '88%'
---(i will have 8990 Customer)IDs
DELETE FROM TABLE CUSTOMER
WHERE SSN NOT LIKE '88%'
and here i have to store the deleted results it in a new physical table ...but here is the issue
I have columns called Customer_ID and ORDER_ID ( THERE ARE 28 TABLES DEPENDENT ON CUSTOMER TABLE
Dependent Tables: Fullfiullement( Customer_ID,Order_ID,Phone))
dependent or referencing other tables ..so i have to DROP the Child table first with taking the Customer _ID and order_IDs from above ...
SO i need to write a Script which will delete the Child tables and then Parent tables and i have to Save each deleted tables Data ........
I will have :Customer_ID
---(i will have 8990 Customer_ID )
and i need to delete only the records of those customer_IDS
I am executing the following queery snipet from a store procedure :
INSERT INTO [dbo].[PLAYERS_HISTORY]
In the same procedure I would like the lst record inserted by unsing the Identity field
Deos "Select MAx(ID) from [dbo].[PLAYERS_HISTORY]" will always return the last inserted row ?
ID is the identity column
I use the following to test in VS2005, VS2010, Winform and WebForm and I got the strange result of a string with a CrLf inserted at 1024 intervals. Anybody has any idea?
When I use this to construct <html>, if the CRLF falls in a <td > then it;'ll break. I also tried to use string builder, same effect.
string s = "";
for (int i = 0; i < 300; i++)
s += "0123456789";
set a break point after this and display ?s at th ecommand window and cut the strin gto Wrod ir any editor that shows EOL markers and the CRLF is there???