RIG000
جمعه 07 مرداد 1390, 18:15 عصر
دوست عزیز ما هر چی تا حالا من سوال کردم 90 در صدشو پاک کرده . الان کد من اینه
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.IO;
namespace Govahi_Eshteqal_be_Tahsil
{
public partial class frmDaneshjoInsert : Form
{
public frmDaneshjoInsert()
{
InitializeComponent();
}
public static string databaseAddress = String.Format(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\Govahi.mdf;integrated security=true;User Instance=True");
private void button1_Click(object sender, EventArgs e)
{
//try
//{
SqlConnection con = new SqlConnection(databaseAddress);
byte[] imageData = ReadFile(label10.Text);
string insertandupdate = string.Format("INSERT INTO daneshjo name,id,year,month,reshte,Grayesh,maghtetahsili,Or iginalPath,ImageData VALUES " +
"(@name,@id,@year,@month,@reshte,@Grayesh,@maghteta hsili,@nahvepaziresh,@OriginalPath,@ImageData)");
SqlCommand cm = new SqlCommand();
cm.Parameters.AddWithValue("@name", boxname.Text.ToString());
cm.Parameters.AddWithValue("@id", boxiddaneshjo.Text);
cm.Parameters.AddWithValue("@year", boxinyear.Text);
cm.Parameters.AddWithValue("@month", cbomah.Text);
cm.Parameters.AddWithValue("@reshte", cboreshte.Text);
cm.Parameters.AddWithValue("@Grayesh", cbogaryesh.Text);
cm.Parameters.AddWithValue("@maghtetahsili", cbomaghtaetahsili.Text);
cm.Parameters.AddWithValue("@nahvepaziresh", cbonahvepaziresh.Text);
cm.Parameters.Add(new SqlParameter("@OriginalPath", (object)label10.Text));
cm.Parameters.Add(new SqlParameter("@ImageData", (object)imageData));
cm.Connection = con;
cm.CommandText = insertandupdate;
con.Open();
cm.ExecuteNonQuery();
MessageBox.Show("ok");
con.Close();
//}
//catch (Exception ex)
//{ MessageBox.Show(ex.Message); }
}
private void bpic_Click(object sender, EventArgs e)
{
OpenFileDialog fd = new OpenFileDialog();
if (fd.ShowDialog() == DialogResult.OK)
{
picbox1.ImageLocation = fd.FileName;
label10.Text = fd.FileName;
}
}
byte[] ReadFile(string sPath)
{
byte[] data = null;
FileInfo fInfo = new FileInfo(sPath);
long numBytes = fInfo.Length;
FileStream fStream = new FileStream(sPath, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fStream);
data = br.ReadBytes((int)numBytes);
return data;
}
موضو ع اینه که incorrect syntax name میگیره نمیدونم مشکل از چیه!!!!!!!!!!!!!!
دوست عزیز/ مدیر جان/ عزیزم /اگه دوست داشتی پاکش نکن !!!
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.IO;
namespace Govahi_Eshteqal_be_Tahsil
{
public partial class frmDaneshjoInsert : Form
{
public frmDaneshjoInsert()
{
InitializeComponent();
}
public static string databaseAddress = String.Format(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\Govahi.mdf;integrated security=true;User Instance=True");
private void button1_Click(object sender, EventArgs e)
{
//try
//{
SqlConnection con = new SqlConnection(databaseAddress);
byte[] imageData = ReadFile(label10.Text);
string insertandupdate = string.Format("INSERT INTO daneshjo name,id,year,month,reshte,Grayesh,maghtetahsili,Or iginalPath,ImageData VALUES " +
"(@name,@id,@year,@month,@reshte,@Grayesh,@maghteta hsili,@nahvepaziresh,@OriginalPath,@ImageData)");
SqlCommand cm = new SqlCommand();
cm.Parameters.AddWithValue("@name", boxname.Text.ToString());
cm.Parameters.AddWithValue("@id", boxiddaneshjo.Text);
cm.Parameters.AddWithValue("@year", boxinyear.Text);
cm.Parameters.AddWithValue("@month", cbomah.Text);
cm.Parameters.AddWithValue("@reshte", cboreshte.Text);
cm.Parameters.AddWithValue("@Grayesh", cbogaryesh.Text);
cm.Parameters.AddWithValue("@maghtetahsili", cbomaghtaetahsili.Text);
cm.Parameters.AddWithValue("@nahvepaziresh", cbonahvepaziresh.Text);
cm.Parameters.Add(new SqlParameter("@OriginalPath", (object)label10.Text));
cm.Parameters.Add(new SqlParameter("@ImageData", (object)imageData));
cm.Connection = con;
cm.CommandText = insertandupdate;
con.Open();
cm.ExecuteNonQuery();
MessageBox.Show("ok");
con.Close();
//}
//catch (Exception ex)
//{ MessageBox.Show(ex.Message); }
}
private void bpic_Click(object sender, EventArgs e)
{
OpenFileDialog fd = new OpenFileDialog();
if (fd.ShowDialog() == DialogResult.OK)
{
picbox1.ImageLocation = fd.FileName;
label10.Text = fd.FileName;
}
}
byte[] ReadFile(string sPath)
{
byte[] data = null;
FileInfo fInfo = new FileInfo(sPath);
long numBytes = fInfo.Length;
FileStream fStream = new FileStream(sPath, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fStream);
data = br.ReadBytes((int)numBytes);
return data;
}
موضو ع اینه که incorrect syntax name میگیره نمیدونم مشکل از چیه!!!!!!!!!!!!!!
دوست عزیز/ مدیر جان/ عزیزم /اگه دوست داشتی پاکش نکن !!!