unable to save Total_one_four, Total_five_six, Net_claim, Claim_dDate values using asp c#
namespace TourPro
{
public partial class one : System.Web.UI.Page
{
string strConnString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
string str;
SqlCommand com;
protected void Page_Load(object sender, EventArgs e)
{
{
SqlConnection con = new SqlConnection(strConnString);
con.Open();
str = "select * from two";
com = new SqlCommand(str, con);
SqlDataReader reader = com.ExecuteReader();
reader.Read();
TextBox1.Text = reader["Amt"].ToString();
}
{
SqlConnection con = new SqlConnection(strConnString);
con.Open();
str = "select * from two";
com = new SqlCommand(str, con);
SqlDataReader reader = com.ExecuteReader();
reader.Read();
TextBox2.Text = reader["Amt"].ToString();
}
{
SqlConnection con = new SqlConnection(strConnString);
con.Open();
str = "select * from Sec_four";
com = new SqlCommand(str, con);
SqlDataReader reader = com.ExecuteReader();
reader.Read();
TextBox3.Text = reader["amount_hotel"].ToString();
}
{
SqlConnection con = new SqlConnection(strConnString);
con.Open();
str = "select * from Sec_four";
com = new SqlCommand(str, con);
SqlDataReader reader = com.ExecuteReader();
reader.Read();
TextBox6.Text = reader["amount_hotel"].ToString();
}
{
SqlConnection con = new SqlConnection(strConnString);
con.Open();
str = "select * from Sec_four";
com = new SqlCommand(str, con);
SqlDataReader reader = com.ExecuteReader();
reader.Read();
TextBox4.Text = reader["amount_hotel"].ToString();
}
{
SqlConnection con = new SqlConnection(strConnString);
con.Open();
str = "select * from Sec_four";
com = new SqlCommand(str, con);
SqlDataReader reader = com.ExecuteReader();
reader.Read();
TextBox7.Text = reader["amount_daily_allowance"].ToString();
}
}
protected void Button3_Click(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO one VALUES(@Journey_fares,@Conve_carges,@Accomm_charges,@Dally_allowance,@Total_one_four,@Corporate_centre,@From_project,@Total_five_six,@Net_claim,@Claim_dDate)", con))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Journey_fares", TextBox1.Text.Trim());
cmd.Parameters.AddWithValue("@Conve_carges", TextBox2.Text.Trim());
cmd.Parameters.AddWithValue("@Accomm_charges", TextBox3.Text.Trim());
cmd.Parameters.AddWithValue("@Dally_allowance", TextBox4.Text.Trim());
cmd.Parameters.AddWithValue("@Total_one_four", TextBox5.Text.Trim());
cmd.Parameters.AddWithValue("@Corporate_centre", TextBox6.Text.Trim());
cmd.Parameters.AddWithValue("@From_project", TextBox7.Text.Trim());
cmd.Parameters.AddWithValue("@Total_five_six", TextBox8.Text.Trim());
cmd.Parameters.AddWithValue("@Net_claim", TextBox9.Text.Trim());
cmd.Parameters.AddWithValue("@Claim_dDate", TextBox10.Text.Trim());
con.Open();
cmd.ExecuteNonQuery();
con.Close();
TextBox1.Text = string.Empty;
TextBox2.Text = string.Empty;
TextBox3.Text = string.Empty;
TextBox4.Text = string.Empty;
TextBox5.Text = string.Empty;
TextBox6.Text = string.Empty;
TextBox7.Text = string.Empty;
TextBox8.Text = string.Empty;
TextBox9.Text = string.Empty;
}
}
}