totals don't display in gridview and the last cell displays empty

Question

to get values in datagridview and also display totals in gridview last cells but the problem is to select the last cell in datagridview then totals are not display in gridview and the last cell displays empty

naga jyothi · Answer

thank u Satyapriya Nayak

Satyapriya Nayak · Answer

Hi Naga For Windows apps using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Sum_in_datagridview_cell { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings[dsn]; OleDbCommand com; OleDbDataAdapter oledbda; DataSet ds; string str; public Form1() { InitializeComponent(); } private void Form1_Load(object sender EventArgs e) { bindgrid(); } private void bindgrid() { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = select * from product; com = new OleDbCommand(str con); oledbda = new OleDbDataAdapter(com); ds = new DataSet(); oledbda.Fill(ds product); dataGridView1.DataMember = product; dataGridView1.DataSource = ds; con.Close(); } private void dataGridView1_DataSourceChanged(object sender EventArgs e) { int sum = 0; for (int i = 0; i { if (dataGridView1[1 i].Value != DBNull.Value) sum += (int)dataGridView1[1 i].Value; } dataGridView1[1 dataGridView1.Rows.Count - 1].Value = sum; } } } Thanks If this post helps you mark it as answer

Satyapriya Nayak · Answer

Hi Naga For Web apps Untitled Page AllowPaging=true PageSize=10 AutoGenerateColumns=False CellPadding=4 GridLines=None ShowFooter=True> Total Bill:Rs. using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Sub_total_gridview { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; string str; SqlCommand com; SqlDataAdapter sqlda; DataSet ds; void bind() { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = select * from test; com =new SqlCommand(str con); sqlda = new SqlDataAdapter(str con); ds =new DataSet(); sqlda.Fill(ds test); GridView1.DataSource = ds; GridView1.DataMember = test; GridView1.DataBind(); con.Close(); } public string totalbills() { SqlConnection con = new SqlConnection(strConnString); str = SELECT SUM(bill) from test; com = new SqlCommand(str con); con.Open(); decimal Totalbill = Convert.ToDecimal(com.ExecuteScalar()); con.Close(); con.Dispose(); com.Dispose(); return string.Format(Totalbill.ToString()); } protected void Page_Load(object sender EventArgs e) { bind(); } } } Thanks