How to call and use stored procedure in codebehind page?

Hi All,

This is happenning for me the first time because I am converting LINQ concept to stored procedure.

At last I got it.Thanks for your timely help.

Just I changed @RoomID to @Id and it worked out.

Thanks,

Poornima

Hi Poornima ,

You are doing good,but i think you are not able to get data in object ,

just use Var obj=...... to get value and use foreach loop.

Hi,

My need is not to use grid view or repeater or list.

I need to retrieve the messages using stored procedure and assign tolblRoomId.Text,lblRoomName.Text.

Thanks,

Poornima

Hi All,

Thanks for your reply.

Now I changed the code like this.

public void GetRoomById(int rId)
{
string cs = ConfigurationManager.ConnectionStrings["LinqChatConnectionString"].ConnectionString;
DataSet dt = new DataSet();
try
{
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("GetRoomById", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
cmd.Parameters.AddWithValue("@RoomID",rId);

SqlDataReader rdr = cmd.ExecuteReader();//->Throwing exception here
if (rdr.HasRows)
{
while (rdr.Read())
{
lblRoomId.Text = rdr["RoomID"].ToString();
lblRoomName.Text = rdr["Name"].ToString();
}
}

con.Close();

}

}
catch(Exception ex)
{ }

}

I still get error ""Procedure or function 'GetRoomById' expects parameter '@Id', which was not supplied." I am unable to guess even after supplier Id value at @rId.while debugging it is showing the value 1. But it is throwing exception.

Help me to overcome this.

Just to fetch the data from the db, please do not use SqlDataAdaptor, DataTable, etc. These are all pretty expensive objects. You are better of using SqlDataReader and loop through the result set.

you can't assign datatable to object because datable have multiple row and columns so you can convert datable to a list...

HI.

You can't assign dataset dt to directly room and for that you need to loop the dt and assign the value to room.

foreach (DataRow dr in ds.Tables[0].Rows) 

{ 

//your code here for room

// in room you need to assign each dr

}

thanks.