hi all here is my grid view code
<asp:GridView ID="noticeDetails" runat="server" BorderWidth="1px"
AutoGenerateColumns="False" PageSize="4" Width="10%" CellPadding="10"
AllowSorting="True" DataKeyNames="CampaignIDRange"
AutoGenerateEditButton="True" onrowediting="noticeDetails_RowEditing"
onrowcancelingedit="noticeDetails_RowCancelingEdit" onrowupdating="UpdatedRecord" >
<Columns>
<asp:TemplateField HeaderText="CampaignIDRange">
<ItemTemplate> <%# Eval("CampaignIDRange")%>
</ItemTemplate> <EditItemTemplate>
<asp:TextBox runat="server" ID="txtCampaignIDRange" Text='<%# Eval("CampaignIDRange")%>' />
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="PromoStartDate">
<ItemTemplate> <%# Eval("PromoStartDate")%>
</ItemTemplate> <EditItemTemplate>
<asp:TextBox runat="server" ID="txtPromoStartDate" Text='<%# Eval("PromoStartDate")%>' />
</EditItemTemplate> </asp:TemplateField>
<asp:TemplateField HeaderText="PromoEndDate">
<ItemTemplate> <%# Eval("PromoEndDate")%>
</ItemTemplate> <EditItemTemplate>
<asp:TextBox runat="server" ID="txtPromoEndDate" Text='<%# Eval("PromoEndDate")%>' />
</EditItemTemplate> </asp:TemplateField>
<asp:TemplateField HeaderText="ExecutionDate">
<ItemTemplate> <%# Eval("ExecutionDate")%>
</ItemTemplate> <EditItemTemplate>
<asp:TextBox runat="server" ID="txtExecutionDate" Text='<%# Eval("ExecutionDate")%>' />
</EditItemTemplate> </asp:TemplateField>
<asp:TemplateField HeaderText="ExpiryDate">
<ItemTemplate> <%# Eval("ExpiryDate")%>
</ItemTemplate> <EditItemTemplate>
<asp:TextBox runat="server" ID="txtExpiryDate" Text='<%# Eval("ExpiryDate")%>' />
</EditItemTemplate> </asp:TemplateField>
</Columns>
</asp:GridView>
in aspx.cs
protected void Page_Load(object sender, EventArgs e) {
string _connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
if (!Page.IsPostBack) {
BindData(); } }
private void BindData() {
noticeDetails.DataSource = dt;
noticeDetails.DataBind(); }
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{ noticeDetails.PageIndex = e.NewPageIndex;
BindData(); }
protected void noticeDetails_RowEditing(object sender, GridViewEditEventArgs e)
{ noticeDetails.EditIndex = e.NewEditIndex;
myform.Visible = false;
ViewState.Add("editRowIndex", e.NewEditIndex);
noticeDetails.DataBind(); }
protected void noticeDetails_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{ e.Cancel = true;
noticeDetails.EditIndex = -1; noticeDetails.DataBind();
}
protected void UpdateRecord(object sender, GridViewUpdateEventArgs e)
{
string CampaignIDRange = ((Label)noticeDetails.Rows[e.RowIndex]
.FindControl("txtCampaignIDRange")).Text;
string PromoStartDate = ((TextBox)noticeDetails.Rows[e.RowIndex]
.FindControl("txtPromoStartDate")).Text;
string PromoEndDate = ((TextBox)noticeDetails.Rows[e.RowIndex]
.FindControl("txtPromoEndDate")).Text;
string ExecutionDate = ((TextBox)noticeDetails.Rows[e.RowIndex]
.FindControl("txtExecutionDate")).Text;
string ExpiryDate = ((TextBox)noticeDetails.Rows[e.RowIndex]
.FindControl("txtExpiryDate")).Text;
OdbcConnection con = new OdbcConnection(@"Dsn=TD;uid=up;pwd=111;Type=Teradata;database=dp_tmp;");
OdbcCommand cmd = new OdbcCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "update Record set CampaignIDRange=@CampaignIDRange," +
"PromoStartDate=@PromoStartDate + PromoEndDate=@PromoEndDate,"+
ExecutionDate=@ExecutionDate,"+
ExpiryDate=@ExpiryDate,"+"";
cmd.Parameters.Add("@CampaignIDRange", OdbcDbType.Int).Value = CampaignIDRange;
cmd.Parameters.Add("@ PromoStartDate", OdbcDbType.datetime).Value = PromoStartDate;
cmd.Parameters.Add("@ PromoStartDate", OdbcDbType.datetime).Value = PromoEndDate;
cmd.Parameters.Add("@ ExecutionDate", OdbcDbType.datetime).Value = ExecutionDate;
cmd.Parameters.Add("@ExpiryDate", OdbcDbType.datetime).Value = ExpiryDate;
noticeDetails.EditIndex = -1;
noticeDetails.DataSource = dt;
noticeDetails.DataBind(); }
I have a grid view in which when i enter values and press submit button , all the values were shown on the grid . I want to edit the row and after that updated it.
I have used RowEditing function but when i click on the edit button it appears to be blank page means that row editing function not called
please help me in this regard