i use as statement but it give me error on @timing

okey

i write store procedure for the time .it insert time in the database before inserting it check this time is already exit or not .if exit it not allow me to insert and rasise error butit not work it give error on starting "begin" statement i don't understand where i am doing wrong someone help me to reconver this error CREATE PROCEDURE InsertTiming(@timing nvarchar(255)) BEGIN SET NOCOUNT ON; -- Check if timing already exists DECLARE @tmp nvarchar(255); SELECT @tmp = s_time FROM timing WHERE s_time = @timing; IF @tmp IS NOT NULL BEGIN raiserror(N'Timing %s already assigned', 10, 1, @timing); END -- Insert new value INSERT INTO timing(s_test) VALUES (@timing); END

okey

i use string type in data base when i run my application it stop on this statement SqlDataReader reader = command.ExecuteReader(); and show system error message

okey

hi all, i get error in my application .plz help to recover the error i add time in the database .before adding in database it check this time is already exit or not .if exits it don't allow me to add the same time again i have two comobox one for hour and second for minute and it contain int value.i get value from comobox and concatenate both value and send to database on running application it give me system error message private void btnAdd_Click(object sender, System.EventArgs e) { //cbxHr.Text hour combo box //cbxMin.Text min combo box SaveTiming(cbxHr.Text,cbxMin.Text); } private void SaveTiming(string hr, string std_min) { bool flag = false; string connectionString = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Testing;Data Source=(local)"; string test = hr+""+ std_min; string isExist = "SELECT * FROM timing WHERE s_time=" + test + ""; string sqlInst = "Insert into timing(s_test)Values(" + test + ")"; using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(isExist, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { MessageBox.Show("Timing already has been assigned"); flag = true; } reader.Close(); if (!flag) { SqlCommand cmd = new SqlCommand(sqlInst, connection); cmd.ExecuteNonQuery(); } } }

okey

can we write the code of console application into window application form

okey

it is a good approach to use utility instead of stored procedure???

okey