Dawood Abbas

Dawood Abbas

  • 1.6k
  • 245
  • 64k

how to bind empty grid forever

Feb 26 2015 6:48 AM
<asp:GridView ID="gridCustomer" runat="server" AutoGenerateColumns="False"
BackColor="White" BorderColor="White" BorderStyle="Ridge" BorderWidth="2px"
CellPadding="3" CellSpacing="1" GridLines="None"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField HeaderText="#" />
<asp:BoundField DataField="UserId" HeaderText="Account Number" />
<asp:TemplateField HeaderText="Name">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Name") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:HyperLink ID="hyperName" runat="server">[hyperName]</asp:HyperLink>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="UserName" HeaderText="User Name" />
<asp:BoundField DataField="Status" HeaderText="Status" />
<asp:BoundField DataField="PackagePeriod" HeaderText="Package Period" />
<asp:BoundField DataField="PackageName" HeaderText="Package Name" />
<asp:BoundField DataField="ActivationDate" HeaderText="Activation Date" />
<asp:BoundField DataField="OldExpiryDate" HeaderText="Account Expiry" />
<asp:BoundField DataField="Balance" HeaderText="Balance" />
<asp:BoundField DataField="PyingAmount" HeaderText="Last Paid Amount" />
<asp:BoundField DataField="LastPaidDate" HeaderText="Last Paid Date" />
<asp:BoundField DataField="LastUpdateTime" HeaderText="Last Acc Updated Time" />
<asp:BoundField DataField="AreaName" HeaderText="Area" />
<asp:BoundField DataField="MobNo" HeaderText="Mobile #" />
<asp:BoundField DataField="EmpName" HeaderText="Attended User" />
<asp:BoundField DataField="Address" HeaderText="Address" />
<asp:BoundField DataField="CreatedDate" HeaderText="Created Date" />
</Columns>
<FooterStyle BackColor="#C6C3C6" ForeColor="Black" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#E7E7FF" />
<PagerStyle BackColor="#C6C3C6" ForeColor="Black" HorizontalAlign="Right" />
<RowStyle BackColor="#DEDFDE" ForeColor="Black" />
<SelectedRowStyle BackColor="#9471DE" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#F1F1F1" />
<SortedAscendingHeaderStyle BackColor="#594B9C" />
<SortedDescendingCellStyle BackColor="#CAC9C9" />
<SortedDescendingHeaderStyle BackColor="#33276A" />
</asp:GridView>
 
protected void Page_Load(object sender, EventArgs e)
{
gridBind();
}
 
 
public void gridBind()
{
try
{
//open the db connection if it is closed...
if (connection.State == ConnectionState.Closed)
connection.Open();
string ColumnName = ddlColumn.SelectedValue;
string Value = txtColValue.Text;
command = new SqlCommand();
command.CommandText = "sp_Get_CustInfoInRecPay";
command.CommandType = CommandType.StoredProcedure;
command.Connection = connection;
command.Parameters.AddWithValue("@ColumnName", ColumnName);
command.Parameters.AddWithValue("@Value", Value);
SqlDataAdapter da = new SqlDataAdapter(command);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count == 0)
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
gridCustInfo.DataSource = ds;
gridCustInfo.DataBind();
int columncount = gridCustInfo.Rows[0].Cells.Count;
gridCustInfo.Rows[0].Cells.Clear();
gridCustInfo.Rows[0].Cells.Add(new TableCell());
gridCustInfo.Rows[0].Cells[0].ColumnSpan = columncount;
gridCustInfo.Rows[0].Cells[0].Text = "No Records Found";
}
else
{
gridCustInfo.DataSource = ds.Tables[0];
gridCustInfo.DataBind();
}
connection.Close();
if (connection.State == ConnectionState.Closed)
connection.Open();
string uid = ds.Tables[0].Rows[0]["UserId"].ToString();
command = new SqlCommand();
command.CommandText = "sp_Get_CustAccountfoInRecPay";
command.CommandType = CommandType.StoredProcedure;
command.Connection = connection;
command.Parameters.AddWithValue("@Value", uid);
SqlDataAdapter daAcc = new SqlDataAdapter(command);
DataSet dsAcc = new DataSet();
daAcc.Fill(dsAcc);
if (dsAcc.Tables[0].Rows.Count == 0)
{
dsAcc.Tables[0].Rows.Add(dsAcc.Tables[0].NewRow());
gridAccInfo.DataSource = dsAcc;
gridAccInfo.DataBind();
int columncount = gridAccInfo.Rows[0].Cells.Count;
gridAccInfo.Rows[0].Cells.Clear();
gridAccInfo.Rows[0].Cells.Add(new TableCell());
gridAccInfo.Rows[0].Cells[0].ColumnSpan = columncount;
gridAccInfo.Rows[0].Cells[0].Text = "No Records Found";
}
else
{
gridAccInfo.DataSource = dsAcc.Tables[0];
gridAccInfo.DataBind();
}
connection.Close();
if (connection.State == ConnectionState.Closed)
connection.Open();
command = new SqlCommand();
command.CommandText = "sp_Get_ControlValues";
command.CommandType = CommandType.StoredProcedure;
command.Connection = connection;
command.Parameters.AddWithValue("@uid", uid);
SqlDataAdapter daPack = new SqlDataAdapter(command);
DataSet dsPack = new DataSet();
daPack.Fill(dsPack);
ddlPackPeriod.SelectedIndex = ddlPackPeriod.Items.IndexOf(ddlPackPeriod.Items.FindByText(dsPack.Tables[0].Rows[0]["PackagePeriod"].ToString()));
//open the db connection if it is closed...
if (connection.State == ConnectionState.Closed)
connection.Open();
string packagePeriod = ddlPackPeriod.SelectedValue;
command = new SqlCommand();
command.CommandText = "sp_Get_PackName";
command.CommandType = CommandType.StoredProcedure;
command.Connection = connection;
command.Parameters.AddWithValue("@packagePeriod", packagePeriod);
ddlPackName.DataSource = command.ExecuteReader();
ddlPackName.DataValueField = "PackageId";
ddlPackName.DataTextField = "PackageName";
ddlPackName.DataBind();
ddlPackName.SelectedIndex = ddlPackPeriod.Items.IndexOf(ddlPackName.Items.FindByText(dsPack.Tables[0].Rows[0]["PackageName"].ToString()));
 
 
}
catch (Exception ex)
{
lblMessage.Text = "Please Enter Exact A/c No OR User Name for Data";
lblMessage.Visible = true;
}
finally //Close db Connection if it is open....
{
if (connection.State == ConnectionState.Open)
connection.Close();
}
}
 
 
 
I want to show empty grid when no action and whn I pass value from textbox and click on button then will bind data,(so its working)
and I have another button below my form page i.e, 'submit' when I click on this form fields inserting to my database but gridview not showing .and aftre passing the value from textbox and click on 'search' button thn gridview not showing..
so how to show grid forever? 

Answers (2)