Here I modified code that is working with information that you provided e.g. removed try-catch and reference to your fileds:
//
private System.Windows.Forms.Button InsertButton;
this.InsertButton.Click += new System.EventHandler(this.InsertButton_Click);
//
// Handler to insert in SQL table 3 values edited in the 3 TextBox controls
// m_ConnectionString stored somewhere in your app or retrieved from the exe.config
private void InsertButton_Click(object sender, System.EventArgs e)
{
int vSQLReturn = Insert(m_ConnectionString, textBox1.Text.ToString().Trim(),textBox2.Text.ToString().Trim(),textBox3.Text.ToString().Trim());
if (vSQLReturn == 1)
{
//insert successfully
}
else
{
// insert error
}
}
// cOnnect to a SQL database and insert in a table 3 values passed as parameters
private int Insert(string sConnectionString, string sForeName, string sSureName, string sTelephone )
{
int vReturn=0;
SqlConnection SQLConnection = new SqConnection(sConnectionString);
SqlDataAdapter vSqlDataAdapter=new SqlDataAdapter();
SQLConnection.Open();
vSqlDataAdapter.SelectCommand = new SqlCommand("sp_Insert",SQLConnection);
vSqlDataAdapter.SelectCommand.CommandType =CommandType.StoredProcedure;
SqlParameter vSqlParameter= vSqlDataAdapter.SelectCommand.Parameters.Add("@ReturnValue", SqlDbType.Int);
vSqlParameter.Direction = ParameterDirection.ReturnValue;
vSqlParameter= vSqlDataAdapter.SelectCommand.Parameters.Add("@forname", sForeName );
vSqlParameter= vSqlDataAdapter.SelectCommand.Parameters.Add("@surename", sSureName);
vSqlParameter= vSqlDataAdapter.SelectCommand.Parameters.Add("@telephone", sTelephone);
DataSet vDataSet = new DataSet();
vSqlDataAdapter.Fill(vDataSet);
vReturn= (Int32) vSqlDataAdapter.SelectCommand.Parameters["@ReturnValue"].Value;
return(vReturn);
}
Stored Procedure which will insert the value passed as parameters
CREATE PROCEDURE dbo.sp_Insert
(
@forename varchar(50),
@surename varchar(50),
@telephone varchar(50)
)
AS
SET NOCOUNT ON
Set @TableName='_tWork'
Set @Cmd='INSERT INTO ' + @TableName +....
EXEC(@Cmd)
RETURN(1)
GO
//
You also can use ExecuteNonQuery() to execute the stored procedure but in my example I assumed many return values from the stored procedure such as records and these will be stored in the vDataSet object.
-obislavu-