1 table form any other table value set in String query ?

Question

SQL Query

use Maintenance

INSERT INTO tbl_asigncharges (CHARGES, VALUEofCHARGES) select TYPEOFCHARGES,VALUEofCHARGES from tbl_charges

this table apply in to this query
C# Code

try
{
foreach (var item in checkedListBox1.CheckedItems)
{
if (!checkedListBox2.Items.Contains(item.ToString()))
{
checkedListBox2.Items.Add(item);
string i = (item.ToString());
if (MessageBox.Show("Assgned", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK)
{
sqlcon.Open();
string query = "INSERT INTO tbl_asigncharges (SN,CHARGES,VALUEofCHARGES) VALUES ('" + Convert.ToInt32(regno.Text) + "','" + item.ToString() + "','" + Convert.ToInt32(i) + "')";
SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon);
sda.SelectCommand.ExecuteNonQuery();
sqlcon.Close();
}
}
}
}
catch(Exception ex)
{
MessageBox.Show("Error" + ex);
}

code try in C# windows Form application

Rajanikant Hawaldar · Answer

If both table have SN column and if it primery key then you have skip SN insertion. string query = "INSERT INTO tbl_asigncharges (SN,CHARGES,VALUEofCHARGES) Select (TYPEOFCHARGES,VALUEofCHARGES) From tbl_charges where WriterRegNoColumnNameHere='" + Convert.ToInt32(regno.Text) + "', TYPEOFCHARGES = '" + item.ToString() + "', VALUEofCHARGES = '" + Convert.ToInt32(i) + "'" ;

Guest User · Answer

Jignesh Kumar, Rajanikant Hawaldar thank you both of you

Rajanikant Hawaldar · Answer

explain your issue in detail

Guest User · Answer

foreach (var item in checkedListBox1.CheckedItems) { if (!checkedListBox2.Items.Contains(item.ToString())) { checkedListBox2.Items.Add(item); string i = (item.ToString()); if (MessageBox.Show("Assgned", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK) { sqlcon.Open(); string query = "INSERT INTO tbl_asigncharges (SN,CHARGES,VALUEofCHARGES) Select (TYPEOFCHARGES,VALUEofCHARGES) From tbl_charges ('" + Convert.ToInt32(regno.Text) + "','" + item.ToString() + "','" + Convert.ToInt32(i) + "')"; SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon); sda.SelectCommand.ExecuteNonQuery(); sqlcon.Close(); } } }

Guest User · Answer

Pickup value there form TypeOFcharges and valueofcharges 2 table layout first table value set here private void btnassign_Click(object sender, EventArgs e) { foreach (var item in checkedListBox1.CheckedItems) { if (!checkedListBox2.Items.Contains(item.ToString())) { checkedListBox2.Items.Add(item); string i = (item.ToString()); if (MessageBox.Show("Assgned", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK) { sqlcon.Open(); string query = "INSERT INTO tbl_asigncharges (SN,CHARGES,VALUEofCHARGES) Select (TYPEOFCHARGES,VALUEofCHARGES) From tbl_charges where ='" + Convert.ToInt32(regno.Text) + "', TYPEOFCHARGES = '" + item.ToString() + "', VALUEofCHARGES = '" + Convert.ToInt32(i) + "'"; SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon); sda.SelectCommand.ExecuteNonQuery(); sqlcon.Close(); } } } }

Jignesh Kumar · Answer

Hi, Here issue is, You are trying to insert 3 column in you insert query and select query have only two column. when you use like this you should have same number of column with same datatype for column. SN Column make identity Column which insert as auto increment. string query = "INSERT INTO tbl_asigncharges (CHARGES,VALUEofCHARGES) Select (TYPEOFCHARGES,VALUEofCHARGES) From tbl_charges ('" + Convert.ToInt32(regno.Text) + "','" + item.ToString() + "','" + Convert.ToInt32(i) + "')";

Guest User · Answer

1 or 2 table say value pickup than save value what is query use string query = "INSERT INTO tbl_asigncharges (SN,CHARGES,VALUEofCHARGES) Select (TYPEOFCHARGES,VALUEofCHARGES) From tbl_charges ('" + Convert.ToInt32(regno.Text) + "','" + item.ToString() + "','" + Convert.ToInt32(i) + "')"

Rajanikant Hawaldar · Answer

ok, what is the problem your facing

Guest User · Answer

I have 2 table 1st tbl_charges 2nd tbl_assigncharges 1st table pickup 2 value form tbl_charges ("TYPEOFCHARGES","VALUEofCHARGES") than i select this 2 colums value than assign in tbl_assigncharges ("CHARGES","VALUEofCHARGES") save the value Edit this Query string query = "INSERT INTO tbl_asigncharges (SN,CHARGES,VALUEofCHARGES) Select (TYPEOFCHARGES,VALUEofCHARGES) From tbl_charges ('" + Convert.ToInt32(regno.Text) + "','" + item.ToString() + "','" + Convert.ToInt32(i) + "')";