Using DataFormatString for DateTime and Float in GridView using C# and VB.Net in ASP.Net

You need to use ItemStyle-HorizontalAlign and DataFormatString attribute/Property to format the data in Bound field.

Refer the below code for your reference and implement it according to your code logic.

HTML

<asp:GridView ID="gvGrid" runat="server" AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField DataField="EmployeeName" HeaderStyle-HorizontalAlign="Center" HeaderText="Employee Name"
            ItemStyle-HorizontalAlign="Left" HeaderStyle-Width="150px" ItemStyle-Width="150px" />
        <asp:BoundField DataField="EmployeeCode" HeaderStyle-HorizontalAlign="Center" HeaderText="Employee Code"
            ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="120px" ItemStyle-Width="120px"  />
        <asp:BoundField DataField="BirthDate" HeaderStyle-HorizontalAlign="Center" HeaderText="Birth Date"
            ItemStyle-HorizontalAlign="Left" DataFormatString="{0:dd/MM/yyyy}" HeaderStyle-Width="120px" ItemStyle-Width="120px"  />
        <asp:BoundField DataField="Salary" HeaderStyle-HorizontalAlign="Center" HeaderText="Salary"
            DataFormatString="{0:n}" ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="100px" ItemStyle-Width="100px"  />
    </Columns>
</asp:GridView>

C#

DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[4] { new DataColumn("EmployeeName",typeof(string))
                                    , new DataColumn("EmployeeCode",typeof(int))
                                    , new DataColumn("BirthDate",typeof(DateTime))
                                    , new DataColumn("Salary",typeof(decimal))});
dt.Rows.Add("Vaibhav", 1, "1988-01-15", 15000.50);
dt.Rows.Add("Vishal", 2, "1985-04-01", 16000.00);
dt.Rows.Add("Sachin", 3, "1986-03-18", 14000.00);
dt.Rows.Add("Yogesh", 4, "1987-09-19", 17000.00);

gvGrid.DataSource = dt;
gvGrid.DataBind();

VB.Net

Dim dt As New DataTable()
dt.Columns.AddRange(New DataColumn(3) {New DataColumn("EmployeeName", GetType(String)), New DataColumn("EmployeeCode", GetType(Integer)), New DataColumn("BirthDate", GetType(DateTime)), New DataColumn("Salary", GetType(Decimal))})
dt.Rows.Add("Vaibhav", 1, "1988-01-15", 15000.5)
dt.Rows.Add("Vishal", 2, "1985-04-01", 16000.0)
dt.Rows.Add("Sachin", 3, "1986-03-18", 14000.0)
dt.Rows.Add("Yogesh", 4, "1987-09-19", 17000.0)

gvGrid.DataSource = dt
gvGrid.DataBind()

Output

Refer the below sample.

SQL

DECLARE @prsch AS TABLE(Entry_date DATETIME,code INT,name VARCHAR(20),net NUMERIC(18,5),IFSC VARCHAR(20),ACNO BIGINT)
INSERT INTO @prsch VALUES('03/03/2017',123,'Test 1',1500.5555,'SBIN0007084','11457290690')
select convert(varchar, Entry_date,103) as Entry_Date,code as SchoolCode ,name as SchoolName ,convert(Float,net) as Net,IFSC,ACNO from @prsch

Output

HTML

<asp:GridView ID="gvGrid" runat="server" AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField DataField="SchoolName" HeaderStyle-HorizontalAlign="Center" HeaderText="School Name"
            ItemStyle-HorizontalAlign="Left" ItemStyle-Width="100" />
        <asp:BoundField DataField="SchoolCode" HeaderStyle-HorizontalAlign="Center" HeaderText="School Code"
            ItemStyle-HorizontalAlign="Right" ItemStyle-Width="100" />
        <asp:BoundField DataField="Entry_date" HeaderStyle-HorizontalAlign="Center" HeaderText="Entry Date"
            ItemStyle-HorizontalAlign="Left" DataFormatString="{0:dd/MM/yyyy}" ItemStyle-Width="100" />
        <asp:BoundField DataField="Net" HeaderStyle-HorizontalAlign="Center" HeaderText="Net"
            DataFormatString="{0:n}" ItemStyle-HorizontalAlign="Right" ItemStyle-Width="100" />
        <asp:BoundField DataField="ACNO" HeaderStyle-HorizontalAlign="Center" HeaderText="ACNO"
            ItemStyle-HorizontalAlign="Right" ItemStyle-Width="150" />
        <asp:BoundField DataField="IFSC" HeaderStyle-HorizontalAlign="Center" HeaderText="IFSC"
            ItemStyle-HorizontalAlign="Left" ItemStyle-Width="150" />
    </Columns>
</asp:GridView>

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        string query = @"DECLARE @prsch AS TABLE(Entry_date DATETIME,code INT,name VARCHAR(20),net NUMERIC(18,5),IFSC VARCHAR(20),ACNO BIGINT)
                        INSERT INTO @prsch VALUES('03/03/2017',123,'Test 1',1500.5555,'SBIN0007084','11457290690')
                        select  convert(varchar, Entry_date,103) as Entry_Date,
                                code as SchoolCode ,name as SchoolName,convert(Float,net) as Net,IFSC,ACNO from @prsch ";
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString);
        SqlCommand cmd = new SqlCommand(query,con);
        con.Open();
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        con.Close();
        gvGrid.DataSource = dt;
        gvGrid.DataBind();
    }
}

Output