<asp:GridView ID="GridView1" class="gridview" runat="server"
AutoGenerateColumns="false" onrowcreated="GridView1_RowCreated">
<columns>
<asp:TemplateField HeaderText="ID">
<ItemTemplate>
<asp:Label ID="Lid" runat="server" Text='<% #Eval("id") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="NAME">
<ItemTemplate>
<asp:Label ID="Lname" runat="server" Text='<% #Eval("name") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="DATE">
<ItemTemplate>
<asp:Label ID="Ldate" runat="server" Text='<% #Eval("date") %>' /></ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="DATE">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" Text="Edit" CommandName="EDIT"/></ItemTemplate>
</asp:TemplateField>
<asp:TemplateField >
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" Text="Delete" CommandName="DELETE"/></ItemTemplate>
</asp:TemplateField>
</columns>
</asp:GridView>
this is my code for insert button..
protected void Button1_Click(object sender, EventArgs e)
{
string name = TextBox2.Text;
System.Globalization.CultureInfo cultureinfo =new System.Globalization.CultureInfo("nl-NL");
DateTime date = DateTime.Parse(DateTime, cultureinfo);
cmd.CommandText=@"insert into cultureinfo(name,date)values(@name,@date)";
cmd.Parameters.AddWithValue(@name, name);
cmd.Parameters.AddWithValue(@date, date);
cmd.ExecuteNonQuery();
cmd.Connection = conn;
conn.Open();
conn.Close();
gvbind();
}