
radiobutton1 = textbox1
radiobutton2 = textbox2
radiobutton3 = textbox3
if I Will select radiobutton1 = textbox1 value save than delete radiobutton2 = textbox2,radiobutton3 = textbox3 value delete
if I Will select radiobutton2 = textbox2 value save than delete radiobutton1 = textbox1,radiobutton3 = textbox3 value delete
if I Will select radiobutton3 = textbox3 value save than delete radiobutton1 = textbox1,radiobutton2 = textbox2 value delete
cmd = new SqlCommand(@"IF (SELECT COUNT(LATEFEE) FROM [DBO].[tbl_gen]) >0
BEGIN
UPDATE tbl_gen SET LATEFEE = @latefee, A1= @a1 ,A2=@a2
END
ELSE
BEGIN
INSERT INTO tbl_gen(LATEFEE,A1,A2) VALUES (@latefee,@a1,@a2)
END", sqlcon);
sqlcon.Open();
cmd.Parameters.AddWithValue("@latefee", textBox1.Text);
cmd.Parameters.AddWithValue("@a1", textBox2.Text);
cmd.Parameters.AddWithValue("@a2", textBox3.Text);
cmd.ExecuteNonQuery();
sqlcon.Close();
MessageBox.Show("Record Inserted Successfully");