Re: How to find out previous month - ASP.NET Discussion Boards

Re: usin asp.net c# or vb insert multiple rows into sql server 2005

N a v a n e e t h2-May-08 3:26

2-May-08 3:26

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.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: usin asp.net c# or vb insert multiple rows into sql server 2005

Sarfaraj Ahmed2-May-08 4:12

Sarfaraj Ahmed

2-May-08 4:12

Thanks Rajesh
Concept you gave me it should be work (if i get any problem then i will let you know)
Thanks

Sarfarj Ahmed

Re: usin asp.net c# or vb insert multiple rows into sql server 2005

N a v a n e e t h2-May-08 3:30

N a v a n e e t h

2-May-08 3:30

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.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: usin asp.net c# or vb insert multiple rows into sql server 2005

Sarfaraj Ahmed2-May-08 4:05

Sarfaraj Ahmed

2-May-08 4:05

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

Re: usin asp.net c# or vb insert multiple rows into sql server 2005

Sarfaraj Ahmed2-May-08 4:08

Sarfaraj Ahmed

2-May-08 4:08

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

How to find out previous month

Lijo Rajan2-May-08 1:07

Lijo Rajan

2-May-08 1:07

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

Re: How to find out previous month

Hesham Amin2-May-08 1:32

Hesham Amin

2-May-08 1:32

use AddMonths(-1) to subtract 1 month from a date. Fr example:
DateTime dt = DateTime.Now.AddMonths(-1);

Hesham A. Amin
My blog

Re: How to find out previous month

Lijo Rajan2-May-08 1:40

Lijo Rajan

2-May-08 1:40

Thank you. It was verymuch help full for me.
Regards
Lijo Rajan.

Protected eventhandlers for controls

Zoltan Balazs2-May-08 0:57

Zoltan Balazs

2-May-08 0:57

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 Wink | ;)

Work @ Network integrated solutions | Flickr | A practical use of the MVC pattern

Re: Protected eventhandlers for controls

SomeGuyThatIsMe2-May-08 2:13

SomeGuyThatIsMe

2-May-08 2:13

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.

Re: Protected eventhandlers for controls

Zoltan Balazs2-May-08 2:48

Zoltan Balazs

2-May-08 2:48

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 Smile | :)

Work @ Network integrated solutions | Flickr | A practical use of the MVC pattern

Re: Protected eventhandlers for controls

SomeGuyThatIsMe2-May-08 2:53

SomeGuyThatIsMe

2-May-08 2:53

glad i could help.

script error

rajkumar.32-May-08 0:32

rajkumar.3

2-May-08 0:32

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.

Re: script error

Vasudevan Deepak Kumar2-May-08 0:32

Vasudevan Deepak Kumar

2-May-08 0:32

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

Re: script error

rahul.net112-May-08 0:40

rahul.net11

2-May-08 0:40

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.

Re: script error

J a a n s2-May-08 1:26

J a a n s

2-May-08 1:26

Can you please confirm where you wrote this code, on page load or click of the button itself?

*jaans

postback using javascript

rahul.net112-May-08 0:26

rahul.net11

2-May-08 0:26

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 = window.confirm ('Are you sure, you want to Approve this Record?');<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 />
    //__doPostBack(Form1);<br />
    //document.getElementsByName(<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.

Re: postback using javascript

Vasudevan Deepak Kumar2-May-08 0:34

Vasudevan Deepak Kumar

2-May-08 0:34

Check out a related thread here:

http://www.velocityreviews.com/forums/t73209-how-to-trigger-a-postback-from-javascript.html[^]

Re: postback using javascript

rahul.net112-May-08 0:35

rahul.net11

2-May-08 0:35

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.

Re: postback using javascript

Vasudevan Deepak Kumar2-May-08 2:40

Vasudevan Deepak Kumar

2-May-08 2:40

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.

Re: postback using javascript

eyeseetee2-May-08 0:54

eyeseetee

2-May-08 0:54

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

Re: postback using javascript

rahul.net112-May-08 0:59

rahul.net11

2-May-08 0:59

Ok i will try

People Laugh on me Because i am Different but i Laugh on them
Because they all are same.

Comparing date's in .NET (web forms)?? [modified]

Karan_TN1-May-08 22:41

Karan_TN

1-May-08 22:41

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

Re: Comparing date's in .NET (web forms)??

Hesham Amin1-May-08 23:19

Hesham Amin

1-May-08 23:19

If you use .net 3.5 (VS 2008) you can use extension methods to easily do this:
Assuming dates is an array of DateTime objects:
DateTime maxDate = dates.Max< DateTime >();

Hesham A. Amin
My blog

Re: Comparing date's in .NET (web forms)??

Karan_TN1-May-08 23:52

Karan_TN

1-May-08 23:52

currently i m using ASP.NET, with C# (.net 2005, 2.0 framework)

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.