Help is needed. With this I want to get the data from table and print on labels using stored procedure. itz not woorking.
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["TicketConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand();
protected void Page_Load(object sender, EventArgs e)
{
con.Open();
cmd = new SqlCommand("GetTicketData", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetTicketData";
lblType.Text = cmd.Parameters.AddWithValue("@Type", SqlDbType.NChar).ToString();
lblDepartment.Text = cmd.Parameters.AddWithValue("@Department", SqlDbType.NVarChar).ToString();
lblCategory.Text = cmd.Parameters.AddWithValue("@Category", SqlDbType.NChar).ToString();
lblSubject.Text = cmd.Parameters.AddWithValue("@Title", SqlDbType.NVarChar).ToString();
lblMessage.Text = cmd.Parameters.AddWithValue("@Detail", SqlDbType.NVarChar).ToString();
lblCreatedBy.Text = cmd.Parameters.AddWithValue("@CreatedBy", SqlDbType.NVarChar).ToString();
lblCDate.Text = cmd.Parameters.AddWithValue("@CreateDate", SqlDbType.DateTime).ToString();
lblCurrentStatus.Text = cmd.Parameters.AddWithValue("@CurrentStatus", SqlDbType.NChar).ToString();
lblCurrentSDate.Text = cmd.Parameters.AddWithValue("@CurrentStatusDate", SqlDbType.DateTime).ToString();
lblCStatusSetBy.Text = cmd.Parameters.AddWithValue("@CurrentStatusSetBy", SqlDbType.NVarChar).ToString();
lblLastUDate.Text = cmd.Parameters.AddWithValue("@LastUpdatedDate", SqlDbType.DateTime).ToString();
lblLastUBy.Text = cmd.Parameters.AddWithValue("@LastUpdatedBy", SqlDbType.NVarChar).ToString();
lblRoomNo.Text = cmd.Parameters.AddWithValue("@RoomNo", SqlDbType.NVarChar).ToString();
lblAvailability.Text = cmd.Parameters.AddWithValue("@Availabilty", SqlDbType.NVarChar).ToString();
cmd.ExecuteNonQuery();
}
}
}
procedure is as:=
ALTER PROCEDURE dbo.GetTicketData
@Type nchar(10),
@Department nvarchar(50),
@Category nchar(10),
@Title nvarchar(50),
@Detail nvarchar(MAX),
@CreatedBy nvarchar(256),
@CreateDate datetime,
@CurrentStatus nchar(10),
@CurrentStatusDate datetime,
@CurrentStatusSetBy nvarchar(50),
@LastUpdatedDate datetime,
@LastUpdatedBy nvarchar(50),
@RoomNo nvarchar(10),
@Availabilty nvarchar(50)
AS
/* SET NOCOUNT ON */
Begin
Select Type, Department, Category, Title, Detail, CreatedBy, CreateDate, CurrentStatus, CurrentStatusDate, CurrentStatusSetBy, LastUpdatedDate, LastUpdatedBy, RoomNo, Availabilty From dbo.Ticket
End
Loading

Krishna GaradPosted Nov 21, 2012, 4:25 AM
Procedure
Create Procedure GetTicketData
(
@param1 datatype--if needed
)
Begin
Select Type, Department, Category, Title, Detail, CreatedBy, CreateDate, CurrentStatus, CurrentStatusDate, CurrentStatusSetBy, LastUpdatedDate, LastUpdatedBy, RoomNo, Availabilty From dbo.Ticket
End
In your code behind
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["TicketConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand();
protected void Page_Load(object sender, EventArgs e)
{
con.Open();
cmd = new SqlCommand("GetTicketData");
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da=new SqlDataAdapter(cmd,con);
DataSet ds=new DataSet();
da.Fill(ds);
//now Read the values form dataset and bind to your labels
if(ds.Tables[0].Rows.Count>0)
{
lblType.Text=ds.Tables[0].Rows[0]["ColumnName"].ToString();
//etc lables
}
}
Krishna GaradPosted Nov 21, 2012, 7:55 AM
Place the hyperlink in your gridview and pass the tickedid as querystring to another page. like
On next page populate the the details of ticket by reading ticketid from querystring value
Sheikh parvazPosted Nov 21, 2012, 5:14 AM