private void button3_Click(object sender, EventArgs e) { string p = path.ToString(); string name = this.textBox1.Text.ToString(); string description = this.richTextBox1.Text.ToString(); //MessageBox.Show(p); DateTime da = DateTime.Now; string date = da.ToString("dd/MM/YYYY"); string connString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Gardezi\Documents\Visual Studio 2012\Projects\homeWork2\homeWork2\Database1.mdf;Integrated Security=True"; SqlConnection con = new SqlConnection(connString); string query = "insert into diaryDB(Title , Description , Date , pic) values (@name , @description ,@date , @p)"; SqlCommand comm = new SqlCommand(query, con); comm.Parameters.Add(new SqlParameter("name" , name)); comm.Parameters.Add(new SqlParameter("description", description)); comm.Parameters.Add(new SqlParameter("date", date)); comm.Parameters.Add(new SqlParameter("p",p )); con.Open(); comm.ExecuteNonQuery(); con.Close(); }
ToString
Text
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)