|
DataTable dt = (DataTable ) Session["DataTable"];
foreach(DataRow dr in dt.Rows )
{
// You can use to get record from datarow like dr["ColumnName"]
ItemId= dr["itemID"];
Quantity = dr["Quantity"]
Price = dr["Price"]
// call you function or write code for insert Record into database
}
I think this will help you.
Regards
rajesh
|
|
|
|
|
Rajesh_K_Sharma wrote: Session["DataTable"];
Check for NULL or existence of session value before casting it to escape from any exceptions.
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
Rajesh_K_Sharma wrote: foreach(DataRow dr in dt.Rows )
{
// You can use to get record from datarow like dr["ColumnName"]
ItemId= dr["itemID"];
Quantity = dr["Quantity"]
Price = dr["Price"]
// call you function or write code for insert Record into database
}
This won't insert items in one shot.
|
|
|
|
|
Thanks Rajesh
Concept you gave me it should be work (if i get any problem then i will let you know)
Thanks
Sarfarj Ahmed
|
|
|
|
|
Sarfaraj Ahmed wrote: I am trying to develop a online order project. When customer add item then it item information will save into session data table.
This is not a good design. You can keep the user's items in database. When user places order, remove from this table. It would be more efficient than session.
Sarfaraj Ahmed wrote: all 5 items into orderDetails table using one insert statement
Lop through datatable records, form insert query, don't execute it inside the loop. When loop ends, execute the query. So you will get all the records inserted.
|
|
|
|
|
Thanks for your reply
My database design is like this
tblOrder (orderID (PK), customerID(FK), dateStamp, totalPrice)
tblOrderDetails (orderID(FK), itemID(FK), Quantity, Price)
as you said I can create another table like tblTempOrder (orderID(FK), itemID(FK), Quantity, Price)
when customer will click btnConfirmOrder then it will add all data into tblOrderDetails
from tblTempOrder then remove all data from tblTempOrder
my question is what will happen if that customer cancel that order but he forgot to click btnCancel?
waiting for your answer
Thanks in advace
Sarfarj Ahmed
|
|
|
|
|
also could you please tell me how i can add all data from tblTempOrder to OrderDetails , writing only one single insert statement
Tanks in advance
Sarfarj Ahmed
|
|
|
|
|
Hai all
Can u tell me how to find out previous and next month.I have one text box and two buttons on my page named Next And Previous.When form gets loaded the current month will be displayed in text box. When i click on Next button the next month date should be displayed in text box.When i click on Previous the previous month date should be displayed in text box. Can any one help me.
Thanks in advance.
Regards
Lijo
|
|
|
|
|
use AddMonths(-1) to subtract 1 month from a date. Fr example:
DateTime dt = DateTime.Now.AddMonths(-1);
|
|
|
|
|
Thank you. It was verymuch help full for me.
Regards
Lijo Rajan.
|
|
|
|
|
I fail to see why the eventhandlers of a control in an asp page must be protected. If I'm trying to declare the methods private I get an 'inaccesible due to its protection level'. This means that the Web.UI.Page base class is responsible for calling the eventhandler? I never done ASP so please bear with me 
|
|
|
|
|
I know that Protected methods or functions whatever you'd like to call them, can only be executed by the containing class and/or any class that inherits the containing class, and (might be wrong about this part)since your aspx page does inherit from the codebehind class the event handlers and any function used on the page must be either protected or public, i would recomend protected, but if their private the inherited class cant access them, so you get that exception. Hope i helped.
|
|
|
|
|
Thanks, so the Inherits attribute in the aspx file defines the code behind file from where the web form inherits. Actually the code behind file stand in front of the aspx file in the inheritance tree. It's clear now 
|
|
|
|
|
|
Btn_CloseWindow.OnClientClick = "window.close();";
this line is not executing when pressing button first time ? it working from second click please help me in this.
Regards
Rajkumar.
|
|
|
|
|
What is the error?
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
use
Btn_CloseWindowAttribute.add("Onclick", "javascript:window.close();")
hope this help.
People Laugh on me Because i am Different but i Laugh on them
Because they all are same.
|
|
|
|
|
Can you please confirm where you wrote this code, on page load or click of the button itself?
*jaans
|
|
|
|
|
Hello all
In my application, i m generating checkbox dynamically. User can check multiple the checkbox. If user check more than three checkbox then i am showing a confirm box. Everyhting is running fine but the problem is that when user click on "Ok" ( on confirm box) at that time i am submitting the page by using following javascript code
function confApprove1()<br />
{<br />
resp =confirm ("You have checked more than 3 answers. You will be charged $250.00 for each additional answer. Do you wish to proceed?");<br />
<br />
document.Form1['JSApprResp1'].value = resp;<br />
var theform;<br />
if (resp=true){<br />
theform = document.forms["Form1"];<br />
theform.submit();<br />
}<br />
}
the page get reloaded then i am trying to find out how many check box user has checked and adding their information to database.
When i am trying to find out checked check box even though the check box is checked it shows .checked=false
and dose not go to inner loop?
how can i solve the problem.Am i doing something wrong. I have also tried to store all check box id in session and when i check value in session after user click on yes then is shown "Nothing" in session.
Thanks
People Laugh on me Because i am Different but i Laugh on them
Because they all are same.
|
|
|
|
|
|
hi
i have already checked that but this thread is not so useful for me.
any other suggestion.
Thanks
People Laugh on me Because i am Different but i Laugh on them
Because they all are same.
|
|
|
|
|
You can have a postback and with a unique hidden field value that you submit, you can try to distribute the control flow from page_load to where the control goes first on submit.
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
It can be quite tricky involving javascript functions with code beinhd.
Javascript runs at client end so if you post back to the same page using c# you may encoutner problems eith whatever you told the jaavscript to do.
Check out some articles on storing variables and sending them
|
|
|
|
|
Ok i will try
People Laugh on me Because i am Different but i Laugh on them
Because they all are same.
|
|
|
|
|
currently i m using net 2005, 2.0 framework.
how to compare more than two date's in .net (web forms)? (both C#.NET,VB.NET)?
for example i have 4 date's
10/23/1987
7/11/2000
2/2/2008
2/1/2008
So, the resultant should be "2/2/2008" (among all the above date's this "2/2/2008" is largest)
how to achieve it? - KARAN
modified on Friday, May 2, 2008 5:52 AM
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
