private void LoadUploadedFilesDetails()
{
try
{
using (con = dbaccess.GetConnection())
{
Datechange();
DataTable dt = new DataTable();
GridView7.Dispose();
string str = "SELECT 0 + ROW_NUMBER() OVER (ORDER BY BankFileName) AS serial_no,COUNT(BankFileName) AS ActualNoofROws,UPPER(BankFileName) AS BankFileName,SUM(NetAmount) AS TotalAmount FROM BankPaymentllotment Where Plant_Code='" + pcode.Trim() + "' AND Billfrmdate='" + d1.ToString().Trim() + "' Group By BankFileName ";
SqlCommand cmd = new SqlCommand(str, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
if (dt.Rows.Count > 0)
{
GridView7.DataSource = dt;
GridView7.DataBind();
}
else
{
GridView7.DataSource = null;
GridView7.DataBind();
}
}
}
catch (Exception ex)
{
ex.ToString();
}
}