udskrivning af db data
Hej Eksperten,Jeg er relativ ny inde for asp.net og C# universet,men er gammel asp og javascript haj.
mit problem er at jeg ikke kan få koden her under til at virke !
SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconnect"].ConnectionString);
SqlCommand command = new SqlCommand("select_user", myConnection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@id", SqlDbType.Int);
command.Parameters.Add("@name", SqlDbType.VarChar);
command.Parameters["@id"].Value = 12;
command.Parameters["@name"].Value = "tim";
command.Connection.Open();
SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
Response.Write(reader["name"].ToString());
}
reader.Close();
Dette er sp'en:
CREATE PROCEDURE select_user
@name varchar(255),
@id INT
AS
BEGIN
select * from users Where user_name = @name and user_id = @id
END
og dette er min web.config conn:
<connectionStrings>
<remove name="dbconnect"/>
<add name="dbconnect" connectionString="server=my_server;uid=user_test;pwd=test_me;database=c_test" providerName="System.Data.SqlClient"/>
</connectionStrings>
det er denne linje der er fejler :
Response.Write(reader["name"].ToString());
jeg får en "IndexOutOfRangeException was unhandled by user code"