this Higlight Code Working For Me
try
{
data.openDBConnection();
SqlCommand cmd = new SqlCommand("Sp_RegisterVehicle", data.getDatabaseConnection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ActionType", "SaveData");
cmd.Parameters.AddWithValue("@id", SqlDbType.Int).Value = empid;
cmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = txt_firstname.Text;
}
int numres = cmd.ExecuteNonQuery();
if (numres > 0)
{
MessageBox.Show("Data Saved Successfully ", "Vehicle Register", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Data Saved Failed", "Vehicle Register", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
DialogResult = MessageBox.Show("Error" + ex.Message);
}
finally
{
data.closeDBConnection();
}
But I Will try Single Parmerters three diffrent textbox value Save In Single Table Colums For Example
this is Example of Name
1.John
Clark
Davide
I Want To Save Like this on Single Parmeter but i have 2 more txetBox
cmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = txt_firstname.Text;
cmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = txt_firstname1.Text;
cmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = txt_firstname2.Text;
Save In Single ID but colums Format
1.txt_firstname.Text = value John
txt_firstname1.Text = Clark
txt_firstname2.Text = Davide
i want to save like this image
