-----------------------------------------------------------
New Message on cochindotnet
-----------------------------------------------------------
From: Jignesh Desai
Message 2 in Discussion
Hi Roshit,
Sorry busy in training so coul';t write more in detail......but
businesslayer:
public void insertrecords(string name,string surname)
{
datalayer.RunSP(StoredProcedureName , SendHimArrayofRequiredParameters);
}
datalayer:
public void RunSP(string SPN, params object[] SPParameters )
{
}
Hope u get an fair Idea how to go about doing....
Regards,
Jignesh Desai
http://www.dotnetjini.com
>From: "Roshit Rajan" <[EMAIL PROTECTED]>
>Reply-To: "Roshit Rajan" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: :query
>Date: 29 Sep 2004 15:47:36 -0000
>
>hi jignesh,
>Thank u so much for the instant reply on datagrid javascripting.
>it was quite interesting.
>pl do help with the foll:
>
>i am trying to use stored procedures in 3-tier layers .for ex if i want
>to INSERT textbox records from registration form into the database, this is what i
>did with sql statements.
>
>just an ex with names:
>
>presentation layer:
>
>string name=txtname.text;
>string surname=txtsurname.text;
>businesslayer.insertrecords(name,surname);
>
>businesslayer:
>public void insertrecords(string name,string surname)
>{
>datalayer.runquery("insert into table(name,surname)values('"+name+"','"+surname+"');
>}
>
>datalayer:
>public void runquery(strsql)
>{
>SqlConnection con =new SqlConnection("server=......");
>SqlCommand cmd=new SqlCommand(strsql,con);
>con.open();
>cmd.executenonquery();
>con.close();
>}
>
>how can i use stored procedures to pass parameters within layers????
>
>pl do help
>thank u
>roshitrajan
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/cochindotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
