I have created and tested a stored procedure that works in sql. This stored procedure has one parameter that it requires to run "quoteno" . I already have the database attached to the form. Can anyone help me with the code for this. The name of my stored procedure is EstimateApproval and my database name is Estimator.
Thanks. Ive looked for answers on the net but not having any luck
MJV
0
Junior Poster in Training
Recommended Answers
Jump to PostPlease search this forum, this has been answered a number of times before.
Jump to PostThere and you can check here
http://support.microsoft.com/kb/320916
Jump to PostI guess my replies are either completely wrong or not worth looking at - seems to me on that link I posted was this
//Create a connection to the SQL Server; modify the connection string for your environment //SqlConnection MyConnection = new SqlConnection("server=(local);database=pubs;Trusted_Connection=yes"); SqlConnection MyConnection = new …
Jump to PostOkay, I see you are getting nowhere, so I will give you the code to do this:
private void DoSomething() { string ConnectionString = "Data Source={0};Initial Catalog={1};Integrated Security=True"; int estno; if( int.TryParse(startestnoCB.Text,out estno) ) { SqlConnection conn = new SqlConnection( string.Format(ConnectionString,".//SqlExpress" // Your Sql Server , "EstimateDataSet" …
All 13 Replies
LizR
171
Posting Virtuoso
rapture
134
Posting Whiz in Training
MJV
0
Junior Poster in Training
MJV
0
Junior Poster in Training
rapture
134
Posting Whiz in Training
JerryShaw
46
Posting Pro in Training
MJV
0
Junior Poster in Training
MJV
0
Junior Poster in Training
JerryShaw
46
Posting Pro in Training
MJV
0
Junior Poster in Training
JerryShaw
46
Posting Pro in Training
MJV
0
Junior Poster in Training
JerryShaw
46
Posting Pro in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.