Insert (Save) data in database table in ASP.Net using C#

hi indradeo,

 Please refer below modified code.

Code

private string strConnectionString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
private SqlCommand _sqlCommand;
private SqlDataAdapter _sqlDataAdapter;
DataSet _dtSet;
string connStr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
SqlCommand com;
string str;
public void connection()
{
    if (!IsPostBack)
    {
        BindEmployeeData();
    }
}

protected void Page_Load(object sender, EventArgs e)
{
    Label1.Visible = false;
}

private static void ShowAlertMessage(string error)
{
    System.Web.UI.Page page = System.Web.HttpContext.Current.Handler as System.Web.UI.Page;
    if (page != null)
    {
        error = error.Replace("'", "\'");
        System.Web.UI.ScriptManager.RegisterStartupScript(page, page.GetType(), "err_msg", "alert('" + error + "');", true);
    }
}

public void CreateConnection()
{
    SqlConnection _sqlConnection = new SqlConnection(strConnectionString);
    _sqlCommand = new SqlCommand();
    _sqlCommand.Connection = _sqlConnection;
}

public void OpenConnection()
{
    _sqlCommand.Connection.Open();
}

public void CloseConnection()
{
    _sqlCommand.Connection.Close();
}

public void DisposeConnection()
{
    _sqlCommand.Connection.Dispose();
}

public void BindEmployeeData()
{
    try
    {
        CreateConnection();
        OpenConnection();
        _sqlCommand.CommandText = "TS1";
        _sqlCommand.CommandType = CommandType.StoredProcedure;
        _sqlCommand.Parameters.AddWithValue("@Event", "Select");
        _sqlDataAdapter = new SqlDataAdapter(_sqlCommand);
        _dtSet = new DataSet();
        _sqlDataAdapter.Fill(_dtSet);
    }
    catch (Exception ex)
    {
        Response.Redirect("The Error is " + ex);
    }
    finally
    {
        CloseConnection();
        DisposeConnection();
    }
}

protected void Btnsave_Click(object sender, EventArgs e)
{
    try
    {
        CreateConnection();
        OpenConnection();

        _sqlCommand.CommandText = "TS1";
        _sqlCommand.CommandType = CommandType.StoredProcedure;
        _sqlCommand.Parameters.AddWithValue("@Dept ", TextBox2.Text.ToString());
        _sqlCommand.Parameters.AddWithValue("@wrk_nm ", TextBox3.Text.ToString());
        _sqlCommand.Parameters.AddWithValue("@fts_no", TextBox4.Text.ToString());
        _sqlCommand.Parameters.AddWithValue("@prced_by_dept_date", datepicker.Text.ToString());
        _sqlCommand.Parameters.AddWithValue("@estmt_cst ", TextBox5.Text.ToString());
        _sqlCommand.Parameters.AddWithValue("@prpsl_sts ", TextBox13.Text.ToString());
        _sqlCommand.Parameters.AddWithValue("@prsnt_lctn ", TextBox7.Text.ToString());
        _sqlCommand.Parameters.AddWithValue("@in_prss_sinc ", TextBox13.Text.ToString());
        _sqlCommand.Parameters.AddWithValue("@updated_on ", TextBox13.Text.ToString());
        _sqlCommand.Parameters.AddWithValue("@Event", "Add");
        _sqlCommand.ExecuteNonQuery();
    }
    catch (Exception ex)
    {
        Response.Write("<script language='javascript'>window.alert('Record has been already exits. !!!!!!!!!!!');window.location='Index.aspx';</script>");
    }
    finally
    {
        CloseConnection();
        DisposeConnection();
    }
}

protected void Button1_Click(object sender, EventArgs e)
{
    datepicker.Text = "";
    TextBox2.Text = "";
    TextBox3.Text = "";
    TextBox4.Text = "";
    TextBox5.Text = "";
    TextBox6.Text = "";
    TextBox7.Text = "";
    TextBox13.Text = "";
}

protected void Back_Click(object sender, EventArgs e)
{
    Response.Redirect("~/Index.aspx");
}

indradeo says:

 @Dept varchar , 

    @wrk_nm      varchar,

    @fts_no                nchar ,

    @prced_by_dept_date         nchar,

    @estmt_cst             nchar,

    @prpsl_sts             varchar,

    @prsnt_lctn            nchar,

    @in_prss_sinc          varchar,

    @updated_on            date  ,

    @Event varchar(10) 

Define the length for nchar and varchar as per your table column length.

Then check the catch block. If any error share it.