|
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" CellPadding="4" DataKeyNames="Productid" ShowFooter ="True"
ForeColor="#333333" GridLines="None" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" AutoGenerateColumns="False" OnRowUpdated="GridView1_RowUpdated" OnRowUpdating="GridView1_RowUpdating" OnRowEditing="GridView1_RowEditing" OnSelectedIndexChanging="GridView1_SelectedIndexChanging">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#EFF3FB" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#2461BF" />
<AlternatingRowStyle BackColor="White" />
<Columns >
<asp:TemplateField HeaderText ="Productid" InsertVisible ="False" SortExpression ="Productid" >
<ItemTemplate >
<asp:Label ID="lblProductid" runat ="server" Text='<%# Eval("Productid") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText ="ProductCode" SortExpression ="ProductCode" InsertVisible ="False" >
<EditItemTemplate >
<asp:TextBox ID ="txtProductCode" runat ="server" Text ='<%#Bind("ProductCode") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblProductCode" runat ="server" Text='<%#Eval("ProductCode") %>'></asp:Label>
</ItemTemplate>
<FooterTemplate >
<asp:TextBox ID="txtfooterProductCode" runat="server" > </asp:TextBox>
<asp:RequiredFieldValidator ID="rfvProductCode" runat="server" ControlToValidate="txtfooterProductCode" ErrorMessage="*"></asp:RequiredFieldValidator>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText ="ProductName" InsertVisible ="False" SortExpression ="ProductName">
<EditItemTemplate >
<asp:TextBox ID="txtProductName" runat ="server" Text='<%#Bind("ProductName") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate >
<asp:Label ID ="lblProductName" runat ="server" Text='<%#Eval("ProductName") %>'></asp:Label>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtfooterProductName" runat="server" > </asp:TextBox>
<asp:RequiredFieldValidator ID="rfvProductName" runat="server" ControlToValidate="txtfooterProductName" ErrorMessage="*"></asp:RequiredFieldValidator>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText ="ProductDescription" InsertVisible ="False" SortExpression ="ProductDescription">
<EditItemTemplate >
<asp:TextBox ID="txtProductDescription" runat ="server" Text ='<%#Bind("ProductDescription") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate >
<asp:Label ID ="lblProductDescription" runat ="server" Text ='<%# Eval("ProductDescription") %>'></asp:Label>
</ItemTemplate>
<FooterTemplate >
<asp:TextBox ID="txtProductDescription" runat ="server" ></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvProductDescription" runat="server" ControlToValidate="txtProductDescription" ErrorMessage="*"></asp:RequiredFieldValidator>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="EditRecord">
<EditItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="True" CommandName="Update"
Text="Update"></asp:LinkButton>
<asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel"></asp:LinkButton>
</EditItemTemplate>
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Edit"
Text="Edit"></asp:LinkButton>
</ItemTemplate>
<FooterTemplate>
<asp:LinkButton ID="lnkInsert" runat="server" Text ="Insert" OnClick="lnkInsert_Click"></asp:LinkButton>
</FooterTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:Label ID="lblMessage" runat="server" Text ="Insert Record Successfully" Visible ="false" > </asp:Label>
</div>
</form>
code behind
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class HOMEME_AddRowGrid : System.Web.UI.Page
{
SqlCommand cmd = new SqlCommand();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Binddata();
}
}
public void Binddata()
{
string sqlQuery = "SELECT * from Product";
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
SqlDataAdapter sda = new SqlDataAdapter(sqlQuery, conn);
DataTable dtData = new DataTable();
sda.Fill(dtData);
GridView1.DataSource = dtData.DefaultView;
GridView1.DataBind();
}
protected void lnkInsert_Click(object sender, EventArgs e)
{
TextBox txtfooterProductCode = GridView1.FindControl("txtfooterProductCode") as TextBox;
TextBox txtfooterProductName = GridView1.FindControl("txtfooterProductName") as TextBox;
TextBox txtProductDescription = GridView1.FindControl("txtProductDescription") as TextBox;
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
conn.Open();
cmd = new SqlCommand("InsertProduct", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ProductCode", SqlDbType.VarChar).Value = ((TextBox)GridView1.FooterRow.FindControl("txtfooterProductCode")).Text;
cmd.Parameters.Add("@ProductName", SqlDbType.VarChar).Value = ((TextBox)GridView1.FooterRow.FindControl("txtfooterProductName")).Text;
cmd.Parameters.Add("@ProductDescription", SqlDbType.VarChar).Value = ((TextBox)GridView1.FooterRow.FindControl("txtProductDescription")).Text;
cmd.ExecuteNonQuery();
conn.Close();
Binddata();
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void GridView1_RowUpdated(object sender, GridViewUpdatedEventArgs e)
{
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//int Productid = ((Label)GridView1.Rows[e.RowIndex].FindControl("lblProductid").Text);
// TextBox txtProductCode = GridView1.FindControl("txtProductCode") as TextBox;
// TextBox txtProductName = GridView1.FindControl("txtProductName") as TextBox;
// TextBox txtProductDescription = GridView1.FindControl("txtProductDescription") as TextBox;
// SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
// conn.Open();
// cmd = new SqlCommand("UpdateProduct", conn);
// cmd.CommandType = CommandType.StoredProcedure;
// //cmd.Parameters.AddWithValue("Productid", SqlDbType.VarChar).Value
// cmd.Parameters.AddWithValue("Productid", GridView1.DataKeys["Productid"]);
// cmd.Parameters.Add("@ProductCode", SqlDbType.VarChar).Value = ((TextBox)GridView1.FooterRow.FindControl("txtProductCode")).Text;
// cmd.Parameters.Add("@ProductName", SqlDbType.VarChar).Value = ((TextBox)GridView1.FooterRow.FindControl("txtProductName")).Text;
// cmd.Parameters.Add("@ProductDescription", SqlDbType.VarChar).Value = ((TextBox)GridView1.FooterRow.FindControl("txtProductDescription")).Text;
// cmd.ExecuteNonQuery();
// conn.Close();
// Binddata();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
}
protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
}
}
help-- how we update delete in gridview using storeporocedure
CREATE PROCEDURE [UpdateProduct]
@ProductCode VARCHAR(50),
@productName VARCHAR(50),
@ProductDescription VARCHAR(500),
@Productid numeric
AS
update Product set ProductCode=@ProductCode,productName =@productName,ProductDescription =@ProductDescription where Productid=@Productid
GO
pls sent code to my id
|
|
|
|
|
what do you expect from other forum members?
What is your exact problem. After 6 highways of code I don't see your problem
|
|
|
|
|
update , delete not working,i am using store procedure pls help me
|
|
|
|
|
What I see in your SqlParameter usage is that you expect that the rowdata is found in the footerrow. That may be for new data but for data loaded from a DB you need the objects used in the row.
For the correct usage of UPDATE and DELETE, search Google or use the ask the SQL forum of CodeProject
|
|
|
|
|
Hello friends,
I am adding some checkboxes dynamically by following method:
Dim chk As New CheckBox
chk.ID = "Random String"
chk.Text = "Random String"
chk.AutoPostBack = True
AddHandler chk.CheckedChanged, AddressOf chkSelected_CheckedChanged
Page.Form.Controls.Add(chk)
I have also added event handler of checkbox as:
Protected Sub chkSelected_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs)
Response.Write(" " & sender.Checked)
End Sub
I am also trying to access these controls by FindControl() method as ".netman" told to.
But the problem is i am not able to check or uncheck those checkboxes and also those are not showing in FindControl() method.
I even tried to create controls in Page_Init method but its still not working.
Can anybody tell me what is wrong?
Thanks and Regards,
Nagendra
|
|
|
|
|
nagendrathecoder wrote: But the problem is i am not able to check or uncheck those checkboxes and also those are not showing in FindControl() method.
Try this sample.This is working.
I take one PlaceHolder and one button control on page.
On Page_Load event,I create two checkboxes
protected void Page_Load(object sender, EventArgs e)
{
CreateCheckBox();
if (!IsPostBack)
{
}
}
Create Checkbox Method
public void CreateCheckBox()
{
CheckBox chk;
for (int i = 0; i < 2; i++)
{
chk = new CheckBox();
chk.ID = "chk_" + i.ToString();
chk.AutoPostBack = true;
PL.Controls.Add(chk);
}
}
Now I check status of checkbox on Button Click event.
protected void btn_Click(object sender, EventArgs e)
{
for (int i = 0; i < 2; i++)
{
Response.Write(((CheckBox)this.Page.FindControl("chk_" + i.ToString())).Checked);
}
}
Note: You need to create checkboxes on every event of the page so I call that method out of IsPostBack condition.
please don't forget to vote on the post that helped you.
modified on Wednesday, July 16, 2008 6:53 AM
|
|
|
|
|
Hello friends,
If u have any idea of ASP.NET caching please send to me with examples.
Regards
anu :)
anu
modified on Wednesday, July 16, 2008 5:59 AM
|
|
|
|
|
Asp.Net Caching
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
please use google to research information like this
|
|
|
|
|
|
Hi
In my update panel I display a gridview but the paging doesnt work.
When I click on a number at the bottom it doesnt do anything
Why would this be?
thanks
|
|
|
|
|
Are you binding the DataSource again once you call the PageIndexChanged event? If no, do that. If you does, post you code..
|
|
|
|
|
Yeah that worked!!
thanks
|
|
|
|
|
Hello
Each Time i add a grid View in my page,
I'm surprise when i run the app to have an error saying:
"BC30456: 'GridView1_RowCommand' is not a member of 'ASP.default_aspx'."
Any Help Will be greatly appreciated
Thanks in advance
Assaf
|
|
|
|
|
It might be you have assigned 'GridView1_RowCommand' as OnRowCommand event in the HTML Source code but no definition in the codebehind.
|
|
|
|
|
Yes, I wrote my gridview directly in the html
So what i should do
Thanks in advance
Assaf
|
|
|
|
|
Thank you
The idea is get it
Assaf
|
|
|
|
|
From the html code of ur asp.net application delete
OnRowCommand="GridView1_RowCommand" where grideview is defined
|
|
|
|
|
Hi i am having multiple datatables inmy dataset...,
I want to write each datatble datas in different different excel files...,
How to do that,..
Any one have idea
plz forward to me...,
Thanks & Regards,
NeW OnE,
please don't forget to vote on the post
|
|
|
|
|
Did you tried anything.
Because its not that much difficult to convert a data table to excel.
Search 'google' you will get lots of samples.Try it out and if you are stuck somewhere, come back.
Somebody is rating down your questions, do you know why?
EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.
|
|
|
|
|
No i didnt get last 2 days i am tryiing for that......,
My problem is each datatble have to write in different different excel files...,
If u have any links to create multiple excel file in runtime ans save the datatable datas in that plz forward to me................,
Thanks & Regards,
NeW OnE,
please don't forget to vote on the post
|
|
|
|
|
1[^]
EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.
|
|
|
|
|
Ya but they bind all the datatables in same excel file different different sheets...,
but i want bind each datatable in different different excel sheets
Thanks & Regards,
NeW OnE,
please don't forget to vote on the post
|
|
|
|
|
You wont get the complete code for such things,Sir...
You will get an idea from that article, and you should develop the rest..
EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.
|
|
|
|
|
I hope you are only doing this as a school project or something. You have been given loads of help and yet you still don't want to actually think for yourself.
Bob
Ashfield Consultants Ltd
|
|
|
|