How do i remove this blank space from gridview in asp.net?
please see this
IMAGE
I want to remove this blank white space NOT hide this(as I know we can hide this border very easily)
even after hiding the border the white unused space is there
i want to remove that
please see this
IMAGE
my gridview code is :-
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" DataKeyNames="OrderID" OnRowDataBound="FindGridAndBound" GridLines="Horizontal">
<AlternatingRowStyle BackColor="#F7F7F7" />
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:GridView ID="GridViewNested" runat="server" AutoGenerateColumns="true" EnableViewState="false"
Width="100%" BackColor="Aquamarine" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
code behind :- [i have taken this code from this
Tutorial VIDEO]
using NoshCart.DataLayer;
using System;
using System.Data;
using System.Data.SqlClient;
using System.Web.UI.WebControls;
namespace NoshCart.Account
{
public partial class WebForm2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GetData();
}
}
private void GetData()
{
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = DataAccess.AddParameter("@custid", Convert.ToInt64(Session["Id"]), SqlDbType.BigInt, 20);
DataTable table = DataAccess.ExecuteDTByProcedure("SP_GetOrderIDNumbers", parameters);
if (table.Rows.Count > 0)
{
GridView1.Visible = true;
GridView1.DataSource = table;
GridView1.DataBind();
}
else
{
LabelDataNotFound.Visible = true;
LabelDataNotFound.Text = "No Orders Found";
}
}
protected void FindGridAndBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType != DataControlRowType.DataRow) return;
GridView nestedGridView = (GridView)e.Row.FindControl("GridViewNested");
int ordid = int.Parse(GridView1.DataKeys[e.Row.RowIndex].Value.ToString());
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = DataAccess.AddParameter("@custid", Convert.ToInt64(Session["Id"]), SqlDbType.BigInt, 20);
parameters[1] = DataAccess.AddParameter("@orderid", Convert.ToInt64(ordid), SqlDbType.BigInt, 20);
DataTable table = DataAccess.ExecuteDTByProcedure("SP_GetAllOrderDetails", parameters);
nestedGridView.DataSource = table;
nestedGridView.DataBind();
}
}
}
AddParameter method :-
public static SqlParameter AddParameter(string parameterName, object value, SqlDbType DbType, int size)
{
SqlParameter param = new SqlParameter();
param.ParameterName = parameterName;
param.Value = value.ToString();
param.SqlDbType = DbType;
param.Size = size;
param.Direction = ParameterDirection.Input;
return param;
}
ExecuteDTByProcedure method :-
public static DataTable ExecuteDTByProcedure(string ProcedureName,SqlParameter[] Params)
{
SqlConnection conn = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = ProcedureName;
cmd.Parameters.AddRange(Params);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter adopter = new SqlDataAdapter(cmd);
DataTable dTable = new DataTable();
try
{
adopter.Fill(dTable);
}
catch (Exception ex)
{
string str = ex.Message;
}
finally
{
adopter.Dispose();
cmd.Parameters.Clear();
cmd.Dispose();
conn.Dispose();
}
return dTable;
}
please help
thanks :)
What I have tried:
i have tried many thing but NONE of these are working at all
e.Row.Cells[0].Visible = false;
gridView1.Columns[0].Visible = false;
RowHeadersVisible = "false"
ColumnHeadersVisible = "false"