Product page entry not showing on the gridview

I am developing sales invoice application using visual studio c# and my database is SQL server. My problem, I have developed the product page where you can save, update and delete products but when I input a product name it does not show on the gridview instead it shows the word product name: please help. Here are my codes and there is no visible error.

Here is my code

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace Sales_Invioce

{

public partial class Products : Form

{

SqlConnection con = new SqlConnection(Properties.Settings.Default.Sales_InvoiceCon);

SqlCommand cmd;

SqlDataAdapter da;

DataTable dt;

public Products()

{

InitializeComponent();

}

private void Products_Load(object sender, EventArgs e)

{

fillGrid();

}

private void btnSave_Click(object sender, EventArgs e)

{

if (txtProName.Text == "")

{

MessageBox.Show("Please Enter Product Name");

}

else

{

try

{

con.Open();

cmd = new SqlCommand("INSERT INTO tbl_Products (ProName)VALUES('" +txtProName.Text + "')", con);

cmd.ExecuteNonQuery();

con.Close();

MessageBox.Show("Product Info Saved...");

fillGrid();

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

public void fillGrid()

{

con.Open();

da = new SqlDataAdapter("Select * from tbl_Products order by ProName asc", con);

con.Close();

SqlCommandBuilder cd = new SqlCommandBuilder(da);

dt = new DataTable();

da.Fill(dt);

dataGridView1.DataSource = dt;

}

private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)

{

}

App.config file:

connectionString="Data Source=chidiebere;Initial Catalog=Sales_Invoice;Integrated Security=True" />

my Dashboard

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar6y ago
Hey,

Please check this link,
https://www.aspdotnet-suresh.com/2015/08/bind-specific-columns-of-datatable-to-datagridview-in-csharp-windows-application-in-vbnet.html
Chidiebere Mgbemena6y ago
Here is my code

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Sales_Invioce
{

public partial class Products : Form
{
SqlConnection con = new SqlConnection(Properties.Settings.Default.Sales_InvoiceCon);
SqlCommand cmd;
SqlDataAdapter da;
DataTable dt;
public Products()
{
InitializeComponent();
}
private void Products_Load(object sender, EventArgs e)
{
fillGrid();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtProName.Text == "")
{
MessageBox.Show("Please Enter Product Name");
}
else
{
try
{
con.Open();
cmd = new SqlCommand("INSERT INTO tbl_Products (ProName)VALUES('" +txtProName.Text + "')", con);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Product Info Saved...");
fillGrid();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public void fillGrid()
{
con.Open();
da = new SqlDataAdapter("Select * from tbl_Products order by ProName asc", con);
con.Close();
SqlCommandBuilder cd = new SqlCommandBuilder(da);
dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
}

private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{

}
}
}

App.config file:

connectionString="Data Source=chidiebere;Initial Catalog=Sales_Invoice;Integrated Security=True" />

my Dashboard
Vinay Singh6y ago
Hi Please check the GridView Template what u have bind. U must have bind the string insteed to DB column name