How to show GridLine in GridView in ASP.Net

Hi nedash,

I have created a sample which full fill your requirement you need to modify the code according to your need.

HTML

<div>
    <asp:GridView ID="gvCustomers" GridLines="Both" runat="server" />
</div>

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        this.BindGrid();
    }
}

private void BindGrid()
{
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT CustomerId, Name, Country FROM Customers"))
        {
            using (SqlDataAdapter sda = new SqlDataAdapter())
            {
                cmd.Connection = con;
                sda.SelectCommand = cmd;
                using (DataTable dt = new DataTable())
                {
                    sda.Fill(dt);
                    gvCustomers.DataSource = dt;
                    gvCustomers.DataBind();
                }
            }
        }
    }
}

VB.Net

Protected Sub Page_Load(sender As Object, e As EventArgs)
	If Not Me.IsPostBack Then
		Me.BindGrid()
	End If
End Sub

Private Sub BindGrid()
	Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
	Using con As New SqlConnection(constr)
		Using cmd As New SqlCommand("SELECT CustomerId, Name, Country FROM Customers")
			Using sda As New SqlDataAdapter()
				cmd.Connection = con
				sda.SelectCommand = cmd
				Using dt As New DataTable()
					sda.Fill(dt)
					gvCustomers.DataSource = dt
					gvCustomers.DataBind()
				End Using
			End Using
		End Using
	End Using
End Sub

ScreenShot