|
Mark Nischalke wrote: you can't make such a blanket statement that not using it is bad practice
Good point Mark.
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
insted of using [SELECT MAX(l_id) FROM listings] use IDENT_CURRENT(listings)
IDENT_CURRENT
Returns the last identity value generated for a specified table
Navi
|
|
|
|
|
dim comm as new sqlcommand("AddListing",connection)
comm.commandtype=commandtype.storedprocedure
'For input parameters
coom.parameters.add("@name","abc")
comm.parameters.add("@nextid",sqldbtype.int).direction=parameterdirection.output
comm.executenonquery
comm.parameters("@nextid").value
Thanks & Regards
Kumar Prabhakar
abc
|
|
|
|
|
after your insert, add the following:
Select SCOPE_IDENTITY() as NewestRecordsID
|
|
|
|
|
Suppose i have an Insert trigger on a table (in MSDE) and lots of records are inserted in quick succession
How will the triggers be fired, is it guaranteed that the triggers will be fired in the same order the records were inserted?
Thanks Last modified: Monday, August 28, 2006 7:04:15 AM --
|
|
|
|
|
The trigger will always be fired in order. However, if the trigger contains switching code that performs data dependent tasks then they may not be completed in order.
If the insert is a single record insert, even in a batch, then the trigger will be fired for each insert. If the insert has multiple inserts in one go such as inserting based on a subquery, then the trigger will only be fired once and you will need to loop through the special inserted table in the trigger.
Ian
|
|
|
|
|
Thanks
One more question, Does the next trigger fires only when the previous one has returned?
|
|
|
|
|
I retrieve a Image column using SqlDataAdapter.Fill.
I then try to create a binary(photo) file From the DataRow's Image column but fail... (the photo file is to be showed in PictureBox)
Thanks for replying...
Pedestrian, Penang.
|
|
|
|
|
pedestrian797 wrote: I then try to create a binary(photo) file From the DataRow's Image column but fail
And how are you trying to do that?
pedestrian797 wrote: the photo file is to be showed in PictureBox
As I recall, you don't need to write the data to a file to put it in a PictureBox
|
|
|
|
|
The PictureBox have ImageLocation property which accept the File path. It also have Image property with is System.Drawing.Image type. However my retrieved column is in DataRow.Column("Picture") format...
Pedestrian, Penang.
|
|
|
|
|
pedestrian797 wrote: However my retrieved column is in DataRow.Column("Picture") format...
That is not a format. That is a method for retrieving column data. The format will be a byte array.
pedestrian797 wrote: It also have Image property with is System.Drawing.Image type
Then create an image from the byte array. You can do this with a Bitmap (which is derived from image ). Then assign the image to the PictureBox .
|
|
|
|
|
Thanks for the replies...
Pedestrian, Penang.
|
|
|
|
|
how can i transfer database from sql server 2000 to MS Access in using C#.
|
|
|
|
|
Open two connections, one to the SQL Server and one to Access.
Create a SqlCommand to SELECT the data you want and extract it with a SqlDataReader . While you can read the rows from the SqlDataReader send OleDbCommand s to Access to INSERT the data. Remember to Close all connections when done.
|
|
|
|
|
|
is this feasible for transfering all tables in database???
|
|
|
|
|
Yes. Just repeat the process for each table.
|
|
|
|
|
I have a field called occdate which I need to query. This code works fine and retreives the record
SELECT OccID<br />
FROM dbo.People_Occ<br />
WHERE (OccDate >= 01 / 08 / 2006)
However when i add a second parameter i get no results returned
SELECT OccID<br />
FROM dbo.People_Occ<br />
WHERE (OccDate >= 01 / 08 / 2006) AND (OccDate < 01 / 08 / 2007)
Can anyone tell me why?
|
|
|
|
|
The where clause will be something along the lines of:
WHERE OccDate BETWEEN StartDate AND EndDate
But it is impossible to give you the exact syntax without knowing what database you are using.
|
|
|
|
|
Keith Malwitz wrote: The where clause will be something along the lines of
Not necessarily. It is perfectly valid to say a is greater than x and a is less than y as the OP did. In fact, it gives more clarity because the BETWEEN clause doesn't intrinsically tell you if it is inclusive or exclusive of the values used. In the OP's case he's using a mix. The start date is inclusive and the end date is exclusive, so the BETWEEN clause is just not going to work for him.
-- modified at 18:57 Sunday 27th August, 2006
|
|
|
|
|
Without knowing which database you are using this is difficult to answer. I always put the date in ISO format (i.e. yyyy-mm-dd) to ensure that the parser doesn't swap the month and date around depending on the locale. Also, I typically use parameters:
SELECT OccID
FROM dbo.People_Occ
WHERE (OccDate >= @minDate) AND (OccDate < @maxDate)
|
|
|
|
|
Try this:
SELECT OccID
FROM dbo.People_Occ
WHERE (OccDate >= '01/08/2006') AND (OccDate < '01/08/2007')
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
|
Hi all,first sorry if my english in bad
I'm working on a small project for university and I'm using C#.net with sql server 2005(I'm pretty new with both of them ) .creating database and adding data was ok, BUT I've got stuck in "finding and editing" section I'm using MSDN help and walkthroughs.
I used tabaleAdapter for adding rows and for locating and editing I tried to use FindBy method and as I mentioned its not working, heres the problem:
I used [this]tutorial (I'm having the first situation!) and tried to do like whats said in there! so heres my code:
0:
1:csmDataSet.T_MemberRow membersRow1 = csmDataSet1.T_Member.FindByID(1212);
2:membersRow1.F_Name = ("john");
the first error occured in the first line saying : " csmDataSet1 does not exist " I solved this problem with adding another line before the other two (line 0):
csmDataSet csmDataSet1 = new csmDataSet();
I'm not sure if it was a right descision to use this code.
second problem(the MAIN problem!) occured in line 2 after adding this line
it says:
Title:NullRefrenceException was Unhandled
->Object reference not set to an instance of an object.
I should mention that a record with ID=1212 exist in the table but in autos window the value for membersRow1 is Null, I tried some other methods like beginEdit(),IsNull and.. the all have the Error And Ive searched the net and some forums but I couldnt find a solution although I think it should be A basic problemm!!
the membersRow1 object is already created I have no idea whats the reason for this error!
I'm in a short of timee and it's driving me nutss , I'd really appreciate it if anyone could help me with this problem, Thankyou for Your Patience thanks in advance for ur replies.
|
|
|
|
|
Is it possible to do a distributed transaction across two processes where one process calls the other using .NET remoting? (I'm using .NET 2.0)
Specifically, I have a system that manages work orders, and sometimes the work order requires an adjustment to stock. The stock system uses a .NET service that runs on a server. I'd like to start the completion process of the work order in a distributed transaction, call the stock management service, enlisting it in the transaction, and then finally complete or rollback the transaction in the original work order process. I have access to the stock management source code, so modifying or adding a new method isn't a problem.
If anyone has done this or knows if it would work, where to find an example or if there are any "tricks" that must be done, I'd appreciate any feedback or thoughts on this. I've never done any practical work with distributed transactions, just read the theory from books and simple examples.
Thanks for the help,
Trevor B
|
|
|
|