C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...






Forums » .NET » .NET »

urgent


Posted Date: 05 Sep 2008      Posted By: maheswari      Member Level: Bronze     Points: 1   Responses: 2



hi friends,
i am writing store procedure for emailid exists or not, i am caaling the sp in data access layer and busines logic layer, but how to call in presentation layer and what condition write here so plz send me........





Responses

Author: vipul    05 Sep 2008Member Level: DiamondRating: 2 out of 52 out of 5     Points: 2

Hi,
first of all the pest your data access layer and busines logic layer, from where you take this email id with there class name.


vipul,
http://dongavipul.blogspot.com

Please Rate This Answer If They Helpful

Thanks & Regards
Patel Vipul



Author: Anil Kumar Pandey    05 Sep 2008Member Level: DiamondRating: 2 out of 52 out of 5     Points: 2

simply..


u need to call the Sp with the help of the SqlCommand....
SqlConnection con = new SqlConnection(strConStr);
SqlCommand cmd = new SqlCommand();
con.Open();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader drd = cmd.ExecuteReader();


Regards
Anil

Thanks & Regards
Anil Kumar Pandey



Post Reply

 This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.


Next : Resize jpeg image using javascript
Previous : Source code to convert foxpro to MS Access database
Return to Discussion Forum
Post New Message
Category: .NET

Related Messages



dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use