Comments by Member 12718897 (Top 6 by date)

after saving data using save button,if i want to add more rows in same project so i am using edit button on my form . after that i select particular project from combo box and it will load all data from databse in datagrid view ,in same grid view i want to add some more rows after the old data and it should be save in database

yes it is working fine when i start new project that time functioning very well, but when i am trying to edit project that time it is not working.

public partial class NewProject : Form
{
string cn = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
DataTable dt = new DataTable();

public NewProject()
{
InitializeComponent();
}

private void NewProject_Load(object sender, EventArgs e)
{
SqlConnection connection = new SqlConnection(cn);
//TO LOAD CLIENT LIST

SqlCommand cmd = new SqlCommand("select * from Client",connection);
connection.Open();
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
cmbclient.Items.Add(sdr["ClientName"].ToString());
}
sdr.Close();
connection.Close();
//TO LOAD SUPPLIER LIST

SqlCommand cmd1 = new SqlCommand("Select * from Supplier", connection);
connection.Open();
SqlDataReader sdr1 = cmd1.ExecuteReader();
while (sdr1.Read())
{
cmbsupplier.Items.Add(sdr1["SupplierName"].ToString());
}
sdr1.Close();
connection.Close();
//TO LOAD PRODUCTS

SqlCommand cmd2 = new SqlCommand("Select * from Product", connection);
connection.Open();
SqlDataReader sdr2 = cmd2.ExecuteReader();
while (sdr2.Read())
{
cmbproduct.Items.Add(sdr2["ProductName"].ToString());
}
sdr2.Close();
connection.Close();

//TO ADD DATA INTO GRID VIEW
dt.Columns.Add("Project ID",typeof(string));
dt.Columns.Add("Product Name",typeof(string));
dt.Columns.Add("Supplier Name", typeof(string));
dt.Columns.Add("Product Cost", typeof(float));
dt.Columns.Add("product Price", typeof(float));
dt.Columns.Add("Product Quantity", typeof(int));
dgprdesc.DataSource = dt;

}

private void label1_Click(object sender, EventArgs e)
{

}

private void btnclose_Click(object sender, EventArgs e)
{
this.Close();
}

private void btnadd_Click(object sender, EventArgs e)
{

dt.Rows.Add(txtprid.Text,cmbproduct.SelectedItem,cmbsupplier.SelectedItem,txtcost.Text,txtprice.Text,txtquantity.Text);
dgprdesc.DataSource = dt;
}

private void btnremove_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow item in this.dgprdesc.SelectedRows)
{
dgprdesc.Rows.RemoveAt(item.Index);
}

}

private void btnew_Click(object sender, EventArgs e)
{
btnew.Enabled = false;
btnsave.Enabled = true;
txtprname.Enabled = true;
pdate.Enabled = true;
cmbclient.Enabled = true;
cmbproduct.Enabled = true;
cmbsupplier.Enabled = true;
txtcost.Enabled = true;
txtprice.Enabled = true;
txtquantity.Enabled = true;
}


private void btnsave_Click(object sender, EventArgs e)
{

SqlConnection connection = new SqlConnection(cn);
foreach (DataGridViewRow row in dgprdesc.Rows)
{
using (SqlCommand cmd1 = new SqlCommand("INSERT INTO ProductSell VALUES(@ProjectID, @ProductName, @SupplierName,@ProductCost,@ProductPrice,@ProductQuantity)", connection))
{
cmd1.Parameters.AddWithValue("@ProjectID", row.Cells["Project ID"].Value);
cmd1.Parameters.AddWithValue("@ProductName", row.Cells["Product Name"].Value);
cmd1.Parameters.AddWithValue("@SupplierName", row.Cells["Supplier Name"].Value);
cmd1.Parameters.AddWit

I tried something like that
for saving new record on one button named as save
private void btnsave_Click(object sender, EventArgs e)
{
SqlConnection connection = new SqlConnection(cn);
SqlCommand cmd = new SqlCommand("insert into myname (name)values('"+txtpname.Text+"')", connection);
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
MessageBox.Show("Reocrd Added Successfully");
//SqlConnection connection = new SqlConnection(cn);
SqlCommand cmd1 = new SqlCommand("select * from myname", connection);
SqlDataAdapter sdr = new SqlDataAdapter(cmd1);
SqlCommandBuilder scb = new SqlCommandBuilder(sdr);


DataSet ds = new DataSet();
connection.Open();
sdr.Fill(ds);
connection.Close();
dgproduct.DataSource = ds.Tables[0];


}

And for edit than save using 2 button named as editsave
private void btneditsave_Click(object sender, EventArgs e)
{
SqlConnection connection = new SqlConnection(cn);
SqlCommand cmd = new SqlCommand("update myname set Name='"+txtpname.Text+"' where ID ='" + txtpid.Text + "'", connection);
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
MessageBox.Show("Reocrd Upadted Successfully");
//SqlConnection connection = new SqlConnection(cn);
SqlCommand cmd1 = new SqlCommand("select * from myname", connection);
SqlDataAdapter sdr = new SqlDataAdapter(cmd1);
SqlCommandBuilder scb = new SqlCommandBuilder(sdr);


DataSet ds = new DataSet();
connection.Open();
sdr.Fill(ds);
connection.Close();
dgproduct.DataSource = ds.Tables[0];
txtpname.Enabled = false;
}

but I want only one save button on my form which can be use as to save new record
and as well as after editing record to update.