none
to insert new values in sql db..by selecting different tables from combo box

    Question

  • well i hv made this program to insert new values in sql db..by choosing between different tables from combo box...but i need to change the sql query by which i can use insert command indivisually for each table in combo box...the area where i need help is in bold ...
    namespace combo
    {
    public partial class Form1 : Form
    {
    List lstNewRows = new List();

    public Form1()
    {
    InitializeComponent();
    }
    private void PopulateComboBox()
    {
    try
    {

    List _items = new List();

    _items.Add("select * from lol");
    _items.Add("select * from datejoin");
    comboBox1.DataSource = _items;

    }
    catch (Exception ex)
    {
    MessageBox.Show(ex.Message);
    }
    }

    private void Form1_Load(object sender, EventArgs e)
    {
    PopulateComboBox();
    }

    private void PopulateGridView(string connString, string sqlQuery)
    {

    String strconnetcion = connString;

    SqlConnection con = new SqlConnection(strconnetcion);



    try
    {

    con.Open();

    SqlCommand sqlCmd = new SqlCommand();

    sqlCmd.Connection = con;
    sqlCmd.CommandType = CommandType.Text;
    sqlCmd.CommandText = sqlQuery;

    SqlDataAdapter sqlDataAdap = new SqlDataAdapter(sqlCmd);

    DataTable dtRecord = new DataTable();
    sqlDataAdap.Fill(dtRecord);

    dataGridView1.DataSource = dtRecord;
    dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
    con.Close();
    }
    catch (Exception ex)
    {
    MessageBox.Show(ex.Message);
    }
    }


    private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
    {
    if (comboBox1.SelectedValue != null)
    {
    PopulateGridView(textBox1.Text, comboBox1.SelectedValue.ToString());
    }
    }

    private void InsertInfo()
    {

    string connectionString = null;
    SqlConnection connection;
    SqlDataAdapter adapter = new SqlDataAdapter();
    string value1 = "";
    string value2 = "";
    connectionString = @"Data Source=HP\SQLEXPRESS;database=MK;Integrated Security=true";
    connection = new SqlConnection(connectionString);
    foreach (int rowIndex in lstNewRows)
    {
    if (dataGridView1.Rows[rowIndex].Cells[0].Value != null && dataGridView1.Rows[rowIndex].Cells[1].Value != null)
    {

    value1 = dataGridView1.Rows[rowIndex].Cells[0].Value.ToString();
    value2 = dataGridView1.Rows[rowIndex].Cells[1].Value.ToString();
    string sql = "insert into lol (name,marks) values('" + value1 + "','" + value2 + "')";
    try
    {
    connection.Open();
    adapter.InsertCommand = new SqlCommand(sql, connection);
    adapter.InsertCommand.ExecuteNonQuery();
    MessageBox.Show("Row inserted !! ");
    }
    catch (Exception ex)
    {
    MessageBox.Show(ex.ToString());
    }

    }
    }
    }
    private void button1_Click(object sender, EventArgs e)
    {


    InsertInfo();

    }

    private void dataGridView1_DefaultValuesNeeded(object sender, DataGridViewRowEventArgs e)
    {
    lstNewRows.Add(e.Row.Index);
    }
    }
    }
    Thursday, March 07, 2013 7:31 AM

Answers