User1216627406 posted
Greetings experts,
I am using GridView CRUD operations to insert, update, delete and display records.
Initially, there will be no records on the database. So, when a user loads the form, there will be blank cells for user to enter records.
So far, for some reason, the blank cells are not being visible. Users cannot enter records unless there are cells to enter data into.
Does any one have any ideas what I could be doing wrong?
Many thanks in advance. Here is the code I am using so far.
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>XPHIAS Client Management System</title>
<style type="text/css">
table.gridview td {
border: 1px solid #000;
}
.gridheader {
background-image: url("images/bgBack.png");
background-repeat: repeat-x;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
<div>
<asp:GridView ID="gvSpeaker" runat="server"
AutoGenerateColumns="False"
DataKeyNames="SpeakerID"
onrowcancelingedit="gvSpeaker_RowCancelingEdit"
onrowediting="gvSpeaker_RowEditing"
onrowdeleting="gvSpeaker_RowDeleting"
onrowupdating="gvSpeaker_RowUpdating"
GridLines="None"
AllowPaging="true"
CssClass="gridview gridheader"
AlternatingRowStyle-CssClass="alt"
Width="100%" CellPadding="3" PageSize="5" BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellSpacing="2">
<Columns>
<asp:TemplateField HeaderText="S.No." ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<%#Container.DataItemIndex+1%>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Speaker Name">
<ItemTemplate>
<%# Eval("SpeakerName")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtspeakername" runat="server" Text='<%#Eval("SpeakerName") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtcSpeakerName1" runat="server" Width="150px"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Ministry Name">
<ItemTemplate>
<%#Eval("MinistryName")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtministryname" runat="server" Text='<%#Eval("MinistryName") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtMinistryName1" runat="server" Width="150px"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Client Name">
<ItemTemplate>
<%# Eval("ClientName") %>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtclientname" runat="server" Text='<%#Eval("ClientName") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtcClientName1" Width="100px" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Email">
<ItemTemplate>
<%#Eval("Email")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtemail" runat="server" Text='<%#Eval("Email") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtcEmail1" Width="150px" runat="server"></asp:TextBox>
</FooterTemplate> </asp:TemplateField>
<asp:TemplateField HeaderText="Date Added">
<ItemTemplate>
<%#Eval("dateAdded")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtdateadded" runat="server" Text='<%#Eval("dateAdded") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtcDateAdded1" Width="150px" CssClass="clientDate" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Website URL">
<ItemTemplate>
<%#Eval("WebsiteURL")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtwebsiteurl" runat="server" Text='<%#Eval("WebsiteURL") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtcWebsiteURL1" Width="150px" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:CommandField ShowEditButton="true" ButtonType ="Image" EditImageUrl="Image/edit.png" UpdateImageUrl="Image/accept.png"
CancelImageUrl="Image/cancel.png" HeaderText="Edit" />
<asp:CommandField ShowDeleteButton="true" ButtonType="Image" DeleteImageUrl="Image/delete.png" HeaderText="Delete" />
</Columns>
<RowStyle BackColor="#BDBDBD" ForeColor="#3C3C3C" />
<FooterStyle BackColor="#E0E0E0" ForeColor="#3C3C3C" />
<PagerStyle BackColor="#2C3539" ForeColor="#FFFAF8" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#BDBDBD" Font-Bold="True" ForeColor="White" />
<HeaderStyle Font-Bold="True" ForeColor="#FFFAF8" />
<AlternatingRowStyle BackColor="#E0E0E0" />
</asp:GridView><br />
</div>
</form>
</body>
</html>
//C#
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Home : Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
GetSpeakerDetail();
}
}
private SqlConnection GetConnection()
{
string connStr = ConfigurationManager.ConnectionStrings["XString"].ConnectionString;
SqlConnection con = new SqlConnection(connStr);
con.Open();
return con;
}
public void GetSpeakerDetail()
{
SqlConnection con = GetConnection();
SqlCommand cmd = new SqlCommand("_sp_GetSpeakerDetail", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
if (ds.Tables[0].Rows.Count > 0)
{
gvSpeaker.DataSource = ds;
gvSpeaker.DataBind();
}
else
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); // if record not found then returning a blank table structure
gvSpeaker.DataSource = ds;
gvSpeaker.DataBind();
int columncount = gvSpeaker.Rows[0].Cells.Count;
gvSpeaker.Rows[0].Cells.Clear();
gvSpeaker.Rows[0].Cells.Add(new TableCell());
gvSpeaker.Rows[0].Cells[0].ColumnSpan = columncount;
gvSpeaker.Rows[0].Cells[0].Text = "No Records Found";
}
}
protected void gvSpeaker_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int id = Convert.ToInt32(gvSpeaker.DataKeys[e.RowIndex].Value.ToString());
SqlConnection con = GetConnection();
SqlCommand cmd = new SqlCommand("_sp_DeleteSpeaker", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", id);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.ExecuteNonQuery();
GetSpeakerDetail();
}
protected void gvSpeaker_RowEditing(object sender, GridViewEditEventArgs e)
{
gvSpeaker.EditIndex = e.NewEditIndex;
GetSpeakerDetail();
}
protected void gvSpeaker_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
gvSpeaker.EditIndex = -1;
GetSpeakerDetail();
}
protected void gvSpeaker_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int id = Convert.ToInt32(gvSpeaker.DataKeys[e.RowIndex].Value.ToString());
string speaker_name = ((TextBox)gvSpeaker.Rows[e.RowIndex].FindControl("txtempname")).Text;
string ministry_name = ((TextBox)gvSpeaker.Rows[e.RowIndex].FindControl("txtempcode")).Text;
string client_name = ((TextBox)gvSpeaker.Rows[e.RowIndex].FindControl("txtempcode")).Text;
string email = ((TextBox)gvSpeaker.Rows[e.RowIndex].FindControl("txtempcode")).Text;
string date_added = ((TextBox)gvSpeaker.Rows[e.RowIndex].FindControl("txtempcode")).Text;
string website_url = ((TextBox)gvSpeaker.Rows[e.RowIndex].FindControl("txtempcode")).Text;
SqlConnection con = GetConnection();
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("_sp_UpdateSpeaker", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id ", id);
cmd.Parameters.AddWithValue("@Speaker_Name ", speaker_name);
cmd.Parameters.AddWithValue("@Ministry_Name ", ministry_name);
cmd.Parameters.AddWithValue("@Client_Name ", client_name);
cmd.Parameters.AddWithValue("@Email ", email);
cmd.Parameters.AddWithValue("@date_Added ", date_added);
cmd.Parameters.AddWithValue("@Website_URL ", website_url);
cmd.ExecuteNonQuery();
con.Close();
gvSpeaker.EditIndex = -1;// no row in edit mode
GetSpeakerDetail();
}
}
Blank Insert Cells not showing
