public partial class Form8registration : Form
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
public Form8registration()
{
InitializeComponent();
}
private void linkLabel1_login_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
Form1 fm1 = new Form1();
fm1.Show();
this.Hide();
}
private void Form8registration_Load(object sender, EventArgs e)
{
conn.Open();
}
private void button2_reset_Click(object sender, EventArgs e)
{
Reset();
}
private void Reset()
{
textBox1_add.Text = "";
textBox3_phoneno.Text = "";
textBox4_emailid.Text = "";
textBox5_desgination.Text = "";
textBox6_name.Text = "";
textBox7_empid.Text = "";
comboBox1_shifttime.SelectedText = "";
textBox1_skpid.Text = "";
}
private void button3_cancel_Click(object sender, EventArgs e)
{
Close();
}
private void button1_submit_Click(object sender, EventArgs e)
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmdd = new SqlCommand("registrtn", conn);
cmdd.CommandType = CommandType.StoredProcedure;
cmdd.Connection = conn;
cmdd.Parameters.Add("@empid",SqlDbType.VarChar, 50).Value = textBox7_empid.Text;
cmdd.Parameters.Add("@empname", SqlDbType.VarChar, 50).Value = textBox6_name.Text;
cmdd.Parameters.Add("@desgination", SqlDbType.VarChar, 50).Value = textBox5_desgination.Text;
cmdd.Parameters.Add("@emailid", SqlDbType.VarChar, 50).Value = textBox4_emailid.Text;
cmdd.Parameters.Add("@phone", SqlDbType.VarChar, 50).Value = textBox3_phoneno.Text;
cmdd.Parameters.Add("@skype", SqlDbType.VarChar, 50).Value = textBox1_skpid.Text;
cmdd.Parameters.Add("@address", SqlDbType.VarChar, 50).Value = textBox1_add.Text;
cmdd.Parameters.Add("@shifttime", SqlDbType.VarChar, 50).Value = comboBox1_shifttime.SelectedText;
cmdd.Parameters.Add("@panel", SqlDbType.VarChar, 50).Value = radioButton1_employe.Checked.ToString();
cmdd.ExecuteNonQuery();
cmdd.Dispose();
conn.Close();
Reset();
}
}
}
Satyapriya NayakPosted Sep 26, 2012, 11:40 PM
cmdd.Parameters.AddWithValue("@empid", textBox7_empid.Text);
Prakhar GargPosted Sep 26, 2012, 11:08 PM
cmdd.Parameters.AddWithValue ("@empid",SqlDbType.VarChar, 50)= textBox7_empid.Text;
and so on...........
I hope After Doing This,Your Data Will BE saved In your Databse.