|
OK, I think there is actually a control on this site which validates multiple controls, I'd suggest looking for that
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
helo alll...,
this is my data:
my table is item(productid,stock) ,order(customerid,no_order), and orderdetail (no_order,productid,quantity)
example:
order and orderdetail displayed in gridview....
order is displayed like this:
--------customerid-------no_order
detail-------A---------------1
detail-------B---------------2
when i click detail in row 2, it's display orderdetail:
no_order_________productid_________quantity
____2________________c1________________2
____2________________p1________________3
i have make all this is ok. but i want to decrease stok in item with quantity in orderdetail.
my code in procedure like:
CREATE PROCEDURE [dbo].[order_item]
(
@productid AS varchar,
@quantity AS INT
)
AS
BEGIN
BEGIN TRANSACTION
DECLARE @no_order AS INT
DECLARE @stock AS INT
INSERT INTO [Orderdetail]
(
[ProductId],
[Quantity]
)
VALUES
(
@productId,
@quantity
)
SET @no_order = SCOPE_IDENTITY()
SET @Stock = (SELECT [Stock] FROM [item] WHERE [ProductId] = @productId)
UPDATE [item]
SET
[Stock] = @Stock - @quantity
WHERE
[ProductId] = @productId
COMMIT TRANSACTION
END
return
it can't work..
how about his true code in store procedure?
ok..., thx..
-- modified at 14:41 Monday 3rd September, 2007
|
|
|
|
|
1 - use the right forum ( this is a SQL question )
2 - define 'it can't work', does it compile ? What does it return ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hello.
I have made a user information to store in session.
But when admin blocks the users, it shoud kill the users session if exsist.
I want to avoid using database.
|
|
|
|
|
You can't block the users session - the only way that you could do this would be to have some mechanism where the user queries to see if they still have access to things. You may be able to do this with the Cache if you want to avoid the database.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Then only one think is could be done.... By checking every time post back, if user is valid.
Does server being overloaded if every post back is checked by using database?
|
|
|
|
|
Hello.
How can i make certan code piece to be executed only one at the time (Preventing to be executed if 2 diffrent users attempt to accsess same section)?
|
|
|
|
|
hi guys
i am having a asp.net application which is done in .net 2003 version, the problem here , i am having a text box with a range validator control for that.. when i changed controltovaliate property of the validator , the size of all the tables in the asp.net page is getting changed ,,such that the alignment is totally collapsed .. i have no idea how the sizes of tables (height and width of tables are dynamically changed)
regards
winnie
|
|
|
|
|
That's normal behaviour for tables. The size of the cells in a table are calculated from the size of the content in the cells. If you put something in a cell that is larger than the previously calculated size, the cell will grow and the other cells will be resized to give it space.
codelinks wrote: a very serious problem
How serious could it be? Serious enough to mention in the subject? 
---
single minded; short sighted; long gone;
|
|
|
|
|
Guffa wrote: How serious could it be? Serious enough to mention in the subject?
coz i didnt find any solution for this ,, can u tell what will be the solution for the above problem..
winnie
|
|
|
|
|
codelinks wrote: coz i didnt find any solution for this
Almost everyone that post here, does so because they can't find a solution. That doesn't make everything "very serious".
codelinks wrote: can u tell what will be the solution for the above problem..
Not without knowing anything more about how you use the tables.
My first advice would of course be not to use table based layouts. They were great ten years ago, when there were no alternatives. Compared to the alternatives available today, they suck.
---
single minded; short sighted; long gone;
|
|
|
|
|
Make them fixed width. Oh yuck - I can't believe I just recommended that. Seriously though, if you don't want the sizes to be recalculated you have to make them fixed width.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
You could set the validator Display property to "none" and use a ValidationSummary so you can move the error message into it's own table. This way, it's display doesn't affect your control layout.
|
|
|
|
|
hi
i want to create a report with crystal report. my report has two table (master ,detail).
in this report each master information must be in separate page as page header and detail information must be in a table under header.
how can i create this report?
tanks
|
|
|
|
|
Hi
I am having one problem with sql query.In my application i am
taking candidate first and last name and showing them to a
column if in database both field are null then i want to show
his pet name in that column.How can i do this.Please guide me.
Ex:--If first name is john,last name is mathew and petname is abc then i
am showing fullname-john mathew if both field are null in database
then i want to show its pet name in that column
fullname--abc
Rahul
|
|
|
|
|
You can test the retrieved data against DBNull.Value and act accordingly.
Talal
-- If this is a post that has been helpful to you, please vote for it. Thank you!
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
--Rich Cook
|
|
|
|
|
hi
i think is better you remove allow null in your table and then set a default value such as '-' for when is not any thing for insert.
now you can simple manage your request.
|
|
|
|
|
You can use Coalesce to return a value only if previous values were null.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Thanks for reply but
what is Coalesce i dont know about it.Can u please tell me about that?
Thanks.
Rahul
|
|
|
|
|
You can, for example, do this:
select coalesce(Name, '-') from table
I think the syntax is correct. This would return - if Name was null for a row.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi,
How do I remove references from my BIN folder? I added a reference, now I don't want to use it, so I deleted it manually, but when I build the website then it still goes and adds it.
What I did was I had Enterprise Library January 2006 installed. I removed it, and installed May 2007. Now when I build the website, it over wrote the 2.0 dlls with the 3.1 dlls.
Regards
.NET Enthusiast
|
|
|
|
|
I think you should remove it from project first go to bin folder of your application Explorer window then delete from there it will alos get deleted from project and bin folder
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
I am uploading files (.doc,.gif,.excel,etc) and storing in the server. Now I want to open those files when i click the link buttons. But I am able to get only the path but how to open it. what changes i need to the following code?
Dim SQLString As String = "SELECT filepath FROM pictures WHERE title = '" & BulletedList1.Items(e.Index).Text & "'"
Dim dr As Data.SqlClient.SqlDataReader
Dim comm As New Data.SqlClient.SqlCommand(SQLString, dbconn)
If dbconn.State <> ConnectionState.Open Then
dbconn.Open()
End If
Dim str As String
dr = comm.ExecuteReader
While dr.Read
str = dr.Item(0)
End While
dr.Close()
TextBox1.Text = str
Chaitra N
|
|
|
|
|
You have to make a little change in your code..
Code:
=====
Remove this code
---------------
TextBox1.Text = str
Apply this code
---------------
1. Take a one image html control on the form. like.
2. In the server side , Write this code..
MyImage.Src = server.mappath("" + str);
Hope this will help you,
Regards,
Abhi
|
|
|
|
|
Thank you Abhi, but image control does not have Src property. I can open a picture file using imageurl property. But how to open other files?
Chaitra N
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
