multiview database connection

Question

protected void Button1_Click(object sender, EventArgs e)
{
    string insrt = "insert into book_mas_det(book_date,book_from,book_to,travel_date,return_date,adult_pax,child_pax,travel_class,contact_name,pnr_no,tot_amt,adv_amount,travler_rmks,agent_rmks) values (@a,@b,@c,@d,@e,@f,@g,@h,@i,@j,@k,@l,@m,@n)";
    string insrt2 = "insert into book_mas_det(book_date,book_from,book_to,travel_date,adult_pax,child_pax,travel_class,contact_name,pnr_no,tot_amt,adv_amount,travler_rmks,agent_rmks) values (@a,@b,@c,@d,@f,@g,@h,@i,@j,@k,@l,@m,@n)";
    MySqlCommand cmd = new MySqlCommand(insrt, conn);
    MySqlCommand cmd2 = new MySqlCommand(insrt2, conn);
    if (MultiView1.ActiveViewIndex == 1)
    {

        cmd.Parameters.AddWithValue("@a", txtbookingdate.Text);
        cmd.Parameters.AddWithValue("@b", ddlfrom.SelectedValue);
        cmd.Parameters.AddWithValue("@c", ddlto.SelectedValue);
        cmd.Parameters.AddWithValue("@d", txtdeprtr.Text);
        cmd.Parameters.AddWithValue("@e", txtreturn.Text);
        cmd.Parameters.AddWithValue("@f", txtadult.Text);
        cmd.Parameters.AddWithValue("@g", txtchild.Text);
        cmd.Parameters.AddWithValue("@h", ddlclass.SelectedValue);
        cmd.Parameters.AddWithValue("@i", txtcontpername.Text);
        cmd.Parameters.AddWithValue("@j", txtcontmobile.Text);
        cmd.Parameters.AddWithValue("@k", txtamnttocharge.Text);
        cmd.Parameters.AddWithValue("@l", txtadvamnt.Text);
        cmd.Parameters.AddWithValue("@m", txtcmnttrav.Text);
        cmd.Parameters.AddWithValue("@n", txtcmntagnt.Text);

    }
    else if (MultiView1.ActiveViewIndex == 0)
    {
        cmd2.Parameters.AddWithValue("@a", txtbookingdate.Text);
        cmd2.Parameters.AddWithValue("@b", ComboBox1.SelectedItem.Text);
        cmd2.Parameters.AddWithValue("@c", ComboBox2.SelectedItem.Text);
        cmd2.Parameters.AddWithValue("@d", TextBox1.Text);

        cmd2.Parameters.AddWithValue("@f", DropDownList1.Text);
        cmd2.Parameters.AddWithValue("@g", DropDownList2.Text);
        cmd2.Parameters.AddWithValue("@h", DropDownList3.SelectedItem.Text);
        cmd2.Parameters.AddWithValue("@i", txtcontpername.Text);
        cmd2.Parameters.AddWithValue("@j", txtcontmobile.Text);
        cmd2.Parameters.AddWithValue("@k", txtamnttocharge.Text);
        cmd2.Parameters.AddWithValue("@l", txtadvamnt.Text);
        cmd2.Parameters.AddWithValue("@m", txtcmnttrav.Text);
        cmd2.Parameters.AddWithValue("@n", txtcmntagnt.Text);
    }
    conn.Open();
    cmd.ExecuteNonQuery();
    cmd2.ExecuteNonQuery();
    conn.Close();
    string display = "Booking Details is added successfully";
    ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + display + "');", true);
}

this is my .cs code for the database connectivity of multiview.Actually i have 3 views oneway,roundtrip and multicity, for the first two views i am going with these codes for the database connectivity.But i am not able to get. error is giving.."Fatal error encountered during command execution"...how to resolve this...??..

score 0 · Answer 1 · answered Nov 13 '13 at 06:36

0

You are using the:
cmd.Parameters.AddWithValue("@i", txtcontpername.Text);

Try it like this: cmd.Parameters.Add("@i", txtcontpername.Text);

answered Nov 13 '13 at 06:36

ggiinnoo

9
2

There is another way to try it: cmd.Parameters.Add("@" + st, OleDbType.VarChar).Value = txtcontpername.Text; The only part im not sure of is what database you are using (OleDbType is what i use) – ggiinnoo Nov 13 '13 at 08:52

multiview database connection

1 Answers1