Product page entry not showing on the gridview

Question

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.

Jignesh Kumar · Answer

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 Mgbemena · Answer

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 Singh · Answer

Hi Please check the GridView Template what u have bind. U must have bind the string insteed to DB column name