Using Stored Procedures With ASP.NET

Well article

I got the error in this code. there is a connectionstring error ( Cannot open database "xyz" requested by the login. The login failed.Login failed for user 'sa'. )

In b\w drop downlist is there means how todo

Big Thanks !!

Nice

Nice...

very good.

Good attempt.

Fist call the stored procedure then pass the parameters.Otherwise it will throw exception ....Thankyou.

write these two line after connection string cmd = new SqlCommand("submitrecord", con); cmd.CommandType = CommandType.StoredProcedure;

I have a table 7 columns, I am using gridview control Display all record In pageload? After I am inserting a record time just I am insert 4 columns only remaing columns leav it i am not insert dada? How to restrict that using ASP.NET Gridview ?

not working check the code ...

Its very useful for all beginers

Thank you very much

i hv read ur article on stored procedures,its great. but i need .net code for "when i registered in c#-sharpcorner,within a seconds i got a mail by [email protected]. with username & password " so i want to know / code example for how can we send mail to registered users ? please i need an example for the above question and more examples on wcf

how to use stroed procedure using sqldatareader to have one input value and retrieve column in gridview like dept_no as int input and value like name,sal,job etc

Thanks Gaurav.. Do You tell me How To user More Then One Stored Procedure We Can Use in Asp.Net...

why you wrote these lines ? SqlCommand cmd = new SqlCommand(); SqlParameter sp1 = new SqlParameter(); SqlParameter sp2 = new SqlParameter(); SqlParameter sp3 = new SqlParameter(); SqlParameter sp4 = new SqlParameter();

thanks for giving this oppurtunity

Dear Gaurav, plz say how to write the coding .. i mean Commands, Connections .. Instead of SQL.. Whether it is same or Different. i'm using SQLite Database

Very Nice Description

very nice and simple work

how come sql parameters variables sp1...sp4 never used? can someone give an example of how to use them if needed? much thanks.

Greate its very usefull for freshers. Written in very simple language easy to understand all programers. Greate work. Well done dude. == Jagdeep Mankotia

thank you sir. I'm glad because understand stored procedure in very easiet lang. and easily. thanks a lot.

thanks for giving this

Modications to be done to Stored Procedure.aspx ------ using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection("server=(local); database= Sample;uid=sa;pwd=pass"); SqlCommand cmd = new SqlCommand("submitrecord", con); cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = TextBox1.Text; cmd.Parameters.Add("@Password", SqlDbType.VarChar).Value = TextBox2.Text; cmd.Parameters.Add("@ConfirmPassword", SqlDbType.VarChar).Value=TextBox3.Text; cmd.Parameters.Add("@EmailId", SqlDbType.VarChar).Value = TextBox4.Text; cmd.CommandType = CommandType.StoredProcedure; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } }

hi gaurav i ambrish i have one problem how we can fill more than two table recored in gridview using corcer give complete code in asp.net with c#.net ok Thanks

U R da Man Dude ;) Hope Always Better

thanx it is very useful for fresher

thanx it is very useful for fresher

thanx it is very useful for fresher

How to Editing Data in DetailsView

Dear Sir....... Iam Working on DetailsView. In That Details View How TOo Edit The Data by Using Commmand field /Hyperlink Field And Another Doubt Is In My Project Is Each ProjectLeadre Has Create Thier Own NewProject And Editing That Project Details If there Is Tasks On The Project. But In My Prject Is Every ProjectLeader Has Seen Another Project Leader Details.and Tasks.. But The Main Thing Is Every Project Leader Has Own Details And Tasks.Onlyyyyyyyyy.... In That Siuations Another Projects Details oor not Visible ........Please Kindly Replied ABout My Question? Sir....... Thanking You Sir.... Your's Sincerely Posubabu.K Trainee Consultant, IBLESOFT PVT LTD

sql procedure is some letters , you can execute it on sql ide like "exec proc_name , arg1,...",then , we can execute procedure in c# like this way, SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "exec proc_name , arg1,..."; but this way has a defect that is can not use output argument

Great work buddy, thanks for us

The way you described it's gr8...It's very necessary for a fresher........Thanks Manas