C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !




urgent


Posted Date: 05 Sep 2008      Total Responses: 2

Posted By: maheswari       Member Level: Bronze     Points: 1


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


Author: ANIL PANDEY    05 Sep 2008Member Level: DiamondRating:     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


Post Reply
You must Sign In to post a response.
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   BizTalk Adaptors    Web Design

conference calls

Contact Us    Privacy Policy    Terms Of Use