h-rafiee
دوشنبه 25 مهر 1390, 10:56 صبح
یکی بگه اینی که نوشتم درسته یا نه؟
FileSource = txtthesis_path.Text;
FileDestination = Application.StartupPath + @"\PDF\" + txtobj.Text + ".pdf";
System.IO.File.Copy(FileSource, FileDestination, true);
SqlConnection cn = new SqlConnection(connection);
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.Text;
cn.Open();
cmd.CommandText = "insert into thesis_table" +
"(stuFname,stuLname,session_id,obj_thesis,perofesso r,year,thesis_path)" +
"values(@stuFname,@stuLname,@session_id,@obj_thesis ,@perofessor,@year,@thesis_path)";
cmd.Parameters.AddWithValue("@stuFname", txtFname.Text);
cmd.Parameters.AddWithValue("@stuLname",txtLname.Text);
cmd.Parameters.AddWithValue("@session_id",txtsession_id.Text);
cmd.Parameters.AddWithValue("@obj_thesis", txtobj.Text);
cmd.Parameters.AddWithValue("@perofessor",txtperofessor.Text);
cmd.Parameters.AddWithValue("@year",txtyear.Text);
cmd.Parameters.AddWithValue("@thesis_path", FileDestination);
cmd.ExecuteNonQuery();
cn.Close();
FileSource = txtthesis_path.Text;
FileDestination = Application.StartupPath + @"\PDF\" + txtobj.Text + ".pdf";
System.IO.File.Copy(FileSource, FileDestination, true);
SqlConnection cn = new SqlConnection(connection);
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.Text;
cn.Open();
cmd.CommandText = "insert into thesis_table" +
"(stuFname,stuLname,session_id,obj_thesis,perofesso r,year,thesis_path)" +
"values(@stuFname,@stuLname,@session_id,@obj_thesis ,@perofessor,@year,@thesis_path)";
cmd.Parameters.AddWithValue("@stuFname", txtFname.Text);
cmd.Parameters.AddWithValue("@stuLname",txtLname.Text);
cmd.Parameters.AddWithValue("@session_id",txtsession_id.Text);
cmd.Parameters.AddWithValue("@obj_thesis", txtobj.Text);
cmd.Parameters.AddWithValue("@perofessor",txtperofessor.Text);
cmd.Parameters.AddWithValue("@year",txtyear.Text);
cmd.Parameters.AddWithValue("@thesis_path", FileDestination);
cmd.ExecuteNonQuery();
cn.Close();