ADO.net
-
i m using the tutorial "href="http://www.sitepoint.com/article/introduction-ado-net/3" to access values from database through ado.net using stored procedure.but its not working.here is my code protected void Page_Load(object sender, EventArgs e) { SqlConnection con= new SqlConnection("////here is my connection string/////"); con.Open(); SqlCommand com = new SqlCommand("ShowSuppliers", con); com.CommandType = CommandType.StoredProcedure; //SqlDataReader reader = com.ExecuteReader(); SqlParameter parm = com.Parameters.Add("@txt", SqlDbType.VarChar, 50); parm.Direction = ParameterDirection.Input; parm.Value = "US"; SqlDataReader reader = com.ExecuteNonQuery(); while (reader.Read()== true) { Response.Write(reader[0].ToString() + "
"); } reader.Close(); con.Close(); } and one of problem is whenever i m saving my procedure as in tutorial, it always chages "create PROCEDURE" with "ALTER PROCEDURE"Chohan
-
i m using the tutorial "href="http://www.sitepoint.com/article/introduction-ado-net/3" to access values from database through ado.net using stored procedure.but its not working.here is my code protected void Page_Load(object sender, EventArgs e) { SqlConnection con= new SqlConnection("////here is my connection string/////"); con.Open(); SqlCommand com = new SqlCommand("ShowSuppliers", con); com.CommandType = CommandType.StoredProcedure; //SqlDataReader reader = com.ExecuteReader(); SqlParameter parm = com.Parameters.Add("@txt", SqlDbType.VarChar, 50); parm.Direction = ParameterDirection.Input; parm.Value = "US"; SqlDataReader reader = com.ExecuteNonQuery(); while (reader.Read()== true) { Response.Write(reader[0].ToString() + "
"); } reader.Close(); con.Close(); } and one of problem is whenever i m saving my procedure as in tutorial, it always chages "create PROCEDURE" with "ALTER PROCEDURE"Chohan
If you would have provided some more specific information about what you mean by "not working", it would have been easier to spot the error. The
ExecuteNonQuerymethod does not return a data reader, it only returns an integer that represents the number of records affected. If you want a data reader, you should use theExecuteReadermethod instead.chohanpk wrote:
and one of problem is whenever i m saving my procedure as in tutorial, it always chages "create PROCEDURE" with "ALTER PROCEDURE"
That is normal. The
createcommand is only used to create a procedure. Thealtercommand is used to update the procedure when editing it.--- Year happy = new Year(2007);
-
If you would have provided some more specific information about what you mean by "not working", it would have been easier to spot the error. The
ExecuteNonQuerymethod does not return a data reader, it only returns an integer that represents the number of records affected. If you want a data reader, you should use theExecuteReadermethod instead.chohanpk wrote:
and one of problem is whenever i m saving my procedure as in tutorial, it always chages "create PROCEDURE" with "ALTER PROCEDURE"
That is normal. The
createcommand is only used to create a procedure. Thealtercommand is used to update the procedure when editing it.--- Year happy = new Year(2007);
but i m following the tutorial.when i m using the executenonquery,it gives the "int " error as u said.and when i m using ExecuteReader before sqlparamerters,as in tutorial,it gives error"Procedure 'ShowSuppliers' expects parameter '@txt', which was not supplied." protected void Page_Load(object sender, EventArgs e) { SqlConnection con= new SqlConnection("Data Source=n-6e9a4f688df44;Initial Catalog=Northwind;Integrated Security=True"); con.Open(); SqlCommand com = new SqlCommand("ShowSuppliers", con); com.CommandType = CommandType.StoredProcedure; SqlDataReader reader = com.ExecuteReader(); SqlParameter parm = com.Parameters.Add("@txt", SqlDbType.VarChar, 50); parm.Direction = ParameterDirection.Input; parm.Value = "UK"; while (reader.Read()== true) { Response.Write(reader[0].ToString() + "
"); } reader.Close(); con.Close(); } .and when i used ExecuteReader after sqlparameter it shows nothing on output protected void Page_Load(object sender, EventArgs e) { SqlConnection con= new SqlConnection("Data Source=n-6e9a4f688df44;Initial Catalog=Northwind;Integrated Security=True"); con.Open(); SqlCommand com = new SqlCommand("ShowSuppliers", con); com.CommandType = CommandType.StoredProcedure; SqlDataReader reader = com.ExecuteReader(); SqlParameter parm = com.Parameters.Add("@txt", SqlDbType.VarChar, 50); parm.Direction = ParameterDirection.Input; parm.Value = "UK"; //SqlDataReader reader = com.ExecuteNonQuery(); //SqlDataReader reader = com.ExecuteReader(); while (reader.Read()== true) { Response.Write(reader[0].ToString() + "
"); } reader.Close(); con.Close(); } n for procedure i want to create a procedure then y its changed to Alter.i dont want edit any value. kindly check the tutorial.Chohan
-
but i m following the tutorial.when i m using the executenonquery,it gives the "int " error as u said.and when i m using ExecuteReader before sqlparamerters,as in tutorial,it gives error"Procedure 'ShowSuppliers' expects parameter '@txt', which was not supplied." protected void Page_Load(object sender, EventArgs e) { SqlConnection con= new SqlConnection("Data Source=n-6e9a4f688df44;Initial Catalog=Northwind;Integrated Security=True"); con.Open(); SqlCommand com = new SqlCommand("ShowSuppliers", con); com.CommandType = CommandType.StoredProcedure; SqlDataReader reader = com.ExecuteReader(); SqlParameter parm = com.Parameters.Add("@txt", SqlDbType.VarChar, 50); parm.Direction = ParameterDirection.Input; parm.Value = "UK"; while (reader.Read()== true) { Response.Write(reader[0].ToString() + "
"); } reader.Close(); con.Close(); } .and when i used ExecuteReader after sqlparameter it shows nothing on output protected void Page_Load(object sender, EventArgs e) { SqlConnection con= new SqlConnection("Data Source=n-6e9a4f688df44;Initial Catalog=Northwind;Integrated Security=True"); con.Open(); SqlCommand com = new SqlCommand("ShowSuppliers", con); com.CommandType = CommandType.StoredProcedure; SqlDataReader reader = com.ExecuteReader(); SqlParameter parm = com.Parameters.Add("@txt", SqlDbType.VarChar, 50); parm.Direction = ParameterDirection.Input; parm.Value = "UK"; //SqlDataReader reader = com.ExecuteNonQuery(); //SqlDataReader reader = com.ExecuteReader(); while (reader.Read()== true) { Response.Write(reader[0].ToString() + "
"); } reader.Close(); con.Close(); } n for procedure i want to create a procedure then y its changed to Alter.i dont want edit any value. kindly check the tutorial.Chohan
chohanpk wrote:
but i m following the tutorial.
That doesn't help the least bit when the tutorial is wrong.
chohanpk wrote:
when i m using ExecuteReader before sqlparamerters,as in tutorial,it gives error"Procedure 'ShowSuppliers' expects parameter '@txt', which was not supplied."
You have to set the parameter berfore calling the procedure. The procedure can not use a parameter that you add in the future.
chohanpk wrote:
n for procedure i want to create a procedure then y its changed to Alter.i dont want edit any value.
When you have created the procedure, it's displayed for you so that you can edit it. Even if you don't want to edit it, it's shown that way. To show it so that you could create it would be pointless, as you have already done that.
--- Year happy = new Year(2007);
-
chohanpk wrote:
but i m following the tutorial.
That doesn't help the least bit when the tutorial is wrong.
chohanpk wrote:
when i m using ExecuteReader before sqlparamerters,as in tutorial,it gives error"Procedure 'ShowSuppliers' expects parameter '@txt', which was not supplied."
You have to set the parameter berfore calling the procedure. The procedure can not use a parameter that you add in the future.
chohanpk wrote:
n for procedure i want to create a procedure then y its changed to Alter.i dont want edit any value.
When you have created the procedure, it's displayed for you so that you can edit it. Even if you don't want to edit it, it's shown that way. To show it so that you could create it would be pointless, as you have already done that.
--- Year happy = new Year(2007);
i give parameter befor but now it didnt show anything .just open a blank page. protected void Page_Load(object sender, EventArgs e) { SqlConnection con= new SqlConnection("Data Source=n-6e9a4f688df44;Initial Catalog=Northwind;Integrated Security=True"); con.Open(); SqlCommand com = new SqlCommand("ShowSuppliers", con); com.CommandType = CommandType.StoredProcedure; //SqlDataReader reader = com.ExecuteReader(); SqlParameter parm = com.Parameters.Add("@txt", SqlDbType.VarChar, 50); parm.Direction = ParameterDirection.Input; parm.Value = "UK"; SqlDataReader reader = com.ExecuteReader(); while (reader.Read() == true) { Response.Write(reader[0].ToString() + "
"); } reader.Close(); con.Close(); } will you plz tel me what will be the right code? and how can i do it using execute "ExecuteNonQuery", also code for this. thanksChohan
-
i give parameter befor but now it didnt show anything .just open a blank page. protected void Page_Load(object sender, EventArgs e) { SqlConnection con= new SqlConnection("Data Source=n-6e9a4f688df44;Initial Catalog=Northwind;Integrated Security=True"); con.Open(); SqlCommand com = new SqlCommand("ShowSuppliers", con); com.CommandType = CommandType.StoredProcedure; //SqlDataReader reader = com.ExecuteReader(); SqlParameter parm = com.Parameters.Add("@txt", SqlDbType.VarChar, 50); parm.Direction = ParameterDirection.Input; parm.Value = "UK"; SqlDataReader reader = com.ExecuteReader(); while (reader.Read() == true) { Response.Write(reader[0].ToString() + "
"); } reader.Close(); con.Close(); } will you plz tel me what will be the right code? and how can i do it using execute "ExecuteNonQuery", also code for this. thanksChohan
Do you have any suppliers in the database that matches the condition? Have you tried "view source" on the page? As you are using Response.Write, you will be writing out the data before the actual html code. That will break the html code so that it might not show, but the data will be visible in the source of the page.
--- Year happy = new Year(2007);
-
Do you have any suppliers in the database that matches the condition? Have you tried "view source" on the page? As you are using Response.Write, you will be writing out the data before the actual html code. That will break the html code so that it might not show, but the data will be visible in the source of the page.
--- Year happy = new Year(2007);
-
Exactly what was it that you didn't understand? If I have to explain everything assuming that you know absolutely nothing at all about it, it gets rather long...
--- Year happy = new Year(2007);
-
chohanpk wrote:
give me right code
:laugh::laugh::laugh: It's not that easy. Without a copy of your database, he doesn't know what's wrong. He's told you how to work it out. If you can't work it out, abandon this project, work on something simpler, or at least buy a book and work through it.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog
-
chohanpk wrote:
tel me wats wrong in my code, give me right code
I don't see anything wrong in your code. Except of course using Response.Write, but I already explained about that.
--- Year happy = new Year(2007);
-
i m using the "northwind" database. n there are matching countries there like USA . and what is "view source" kindly tel me.
Chohan