Comments by Member 8609405 (Top 15 by date)

thanks

I had already checked the value ther is no problem in textbox but it doesn't return the value

its my gridview id

Hi, griff i am using stored procedure. how to convert a datatable into string is it possible

there is no problem in gridview in back end i use br/tag .when it comes to front end i.e in grid view when br/ it executes in next line

select age,replace(left(type,len(type)-1),',','<br/>') as scheduletype,
replace(left(name,len(name)-1),',','<br/>') as name,
replace(left(dose,len(dose)-1),',','<br/>') as dose from

(SELECT p1.age,

( SELECT scheduletype + ','-- replace(left(scheduletype,len(scheduletype)-1),',','<br/>')

FROM k_Master_Scheduletype p2

WHERE p2.age = p1.age

ORDER BY scheduletype

FOR XML PATH('') ) AS type,
( SELECT name + ','

FROM k_Master_Scheduletype p2

WHERE p2.age = p1.age

ORDER BY name

FOR XML PATH('') ) AS name,
( SELECT dose + ','

FROM k_Master_Scheduletype p2

WHERE p2.age = p1.age

ORDER BY dose

FOR XML PATH('') ) AS dose

FROM k_Master_Scheduletype p1

GROUP BY age) a

END
GO

i used br/ html tag in back end now i want to break br/ tag in gridview

i get the records from database and i use br/ html tag in back end .now the break br/ results execute in next line

i had already try this .

protected void gvPlantRecord_RowCommand(object sender, GridViewCommandEventArgs e)
{
//e.CommandName.ToUpper() = "EditPlantRecord";

btncancel.Visible = true;
btnUpdate.Visible = true;
GridViewRow row = (GridViewRow)((LinkButton)e.CommandSource).NamingContainer;
int index = row.RowIndex;
objfeedplantentryPL.sno = Convert.ToInt16 (gvFeedPlantRecord.DataKeys[index].Value.ToString());

DataTable dtfillplantrecorddet = new DataTable();
dtfillplantrecorddet = objfeedplantentryBAL.GetplantrecordDdetail(objfeedplantentryPL);


txtDate.Text = dtfillplantrecorddet.Rows[0]["date"].ToString();
ddlPlanttype.SelectedValue = dtfillplantrecorddet.Rows[0]["planttype"].ToString();
ddlbirdtype.SelectedValue = dtfillplantrecorddet.Rows[0]["birdtype"].ToString();
feedtype();
if (ddlFeedtype.SelectedItem.Text == "Others")
{

txtOtherfeed.Text = dtfillplantrecorddet.Rows[0]["feedtype"].ToString();
}
else
{
ddlFeedtype.SelectedValue = dtfillplantrecorddet.Rows[0]["feedtype"].ToString();
}


// ddlFeedtype.SelectedValue = dtfillplantrecorddet.Rows[0]["feedtype"].ToString();
ddlbatchno.SelectedValue = dtfillplantrecorddet.Rows[0]["batchno"].ToString();
txtQuantity.Text = dtfillplantrecorddet.Rows[0]["quantity"].ToString();
txtVehicleno.Text = dtfillplantrecorddet.Rows[0]["vehicleno"].ToString();
txtDcno.Text = dtfillplantrecorddet.Rows[0]["dcno"].ToString();
txtDcno.Enabled = false;
btnSave.Visible = false;

}






protected void btnSave_Click(object sender, EventArgs e)
{
int? insertFeedPlantEntryRecords;

if (ddlFeedtype.SelectedItem.Text == "Others")
{

objfeedplantentryPL.feedtype = txtOtherfeed.Text.Trim().ToString();
}else
{
objfeedplantentryPL.feedtype = ddlFeedtype.SelectedValue;
}

IFormatProvider provider = new System.Globalization.CultureInfo("en-CA", true);
String datetime = txtDate.Text.Trim();
DateTime dt = DateTime.Parse(datetime, provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault);


objfeedplantentryPL.supplydate = dt;
objfeedplantentryPL.planttype = ddlPlanttype.SelectedValue;
objfeedplantentryPL.birdtype = ddlbirdtype.SelectedValue;
objfeedplantentryPL.feedtype = ddlFeedtype.SelectedValue;
objfeedplantentryPL.batchno = ddlbatchno.SelectedValue;
objfeedplantentryPL.vehicleno = txtVehicleno.Text.Trim().ToString();
objfeedplantentryPL.dcno = txtDcno.Text.Trim().ToString();
objfeedplantentryPL.quantity = Convert.ToDouble(txtQuantity.Text.Trim().ToString());
objfeedplantentryPL.username = Session["username"].ToString();
insertFeedPlantEntryRecords = objfeedplantentryBAL.FeedPlantEntryInsert(objfeedplantentryPL);
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "UpdateDetails", "alert('Added Successfully');", true);
clear();
BindPlantRecord();
}

public void clear()
{
pnlOther.Visible = false;
txtDate.Text = "";
BindBirdType();
BindPlanttype();
txtQuantity.Text = "";
ddlFeedtype.Items.Clear();
ddlFeedtype.Items.Add(new ListItem("--Select--", "0"));
ddlFeedtype.SelectedIndex = ddlFeedtype.Items.Count - 1;
txtOtherfeed.Text = "";
txtDcno.Text = "";
Bindbatchno();
txtVehicleno.Text = "";
txtDate.Text = DateTime.Now.ToUniversalTime().AddMinutes(DateTime.Now.Subtract(DateTime.Now.ToUniversalTime()).TotalMinutes).ToString("dd/MM/y