kamoo_677
یک شنبه 26 آذر 1391, 11:11 صبح
با سلام خدمت دوستان.
در حال انجام پروژه دانشجویی هستم و نیاز به کمک سریع دارم.
کلاس customer :
namespace Modiriat_foroush
{
class customer
{
connect co = new connect();
public string tel1;
public string tel2;
public string name;
public string lastname;
public string address;
public string job;
public string Ncode;
public int add()
{
co.connect111();
string s = "insert into Customer (Firstname,Lastname,Address,Telephone,Telephone2,J obtype,Nationalcode)values(N'{0}',N'{1}',N'{2}','{ 3}','{4}',N'{5}',N'{6}')";
s = string.Format(s, this.name, this.lastname, this.address,this.tel1,this.tel2,this.job,this.Nco de);
int result = co.command(s);
co.disconnect();
return result;
}
}
}
کلاس connect
namespace Modiriat_foroush
{
class connect
{
private SqlConnection con;
private SqlCommand com;
private SqlDataAdapter da;
public connect()
{
con = new SqlConnection();
com = new SqlCommand();
da = new SqlDataAdapter();
com.Connection = con;
da.SelectCommand = com;
}
public void connect111()
{
string s = "Data Source=.\\sqlexpress; AttachdbfileName=|DataDirectory|Modiriatforoush.md f;User instance = true; integrated security=true";
con.ConnectionString = s;
con.Open();
}
public void disconnect()
{
con.Close();
}
public int command(string s)
{
com.CommandText = s;
int result = com.ExecuteNonQuery();
return result;
}
}
و در آخر کد مربوط به ذخیره در جدول Customer
private void btnsave_Click(object sender, EventArgs e)
{
customer cu = new customer();
cu.name = txtname.Text;
cu.lastname = txtFamily.Text;
cu.address = txtaddress.Text;
cu.tel1 = txttel.Text;
cu.tel2 = txttel2.Text;
cu.job = txtjobtype.Text;
cu.Ncode = txtNationalcode.Text;
if (cu.add() > 0)
{
MessageBox.Show("OK");
}
}
لطفا کمک کنید
در حال انجام پروژه دانشجویی هستم و نیاز به کمک سریع دارم.
کلاس customer :
namespace Modiriat_foroush
{
class customer
{
connect co = new connect();
public string tel1;
public string tel2;
public string name;
public string lastname;
public string address;
public string job;
public string Ncode;
public int add()
{
co.connect111();
string s = "insert into Customer (Firstname,Lastname,Address,Telephone,Telephone2,J obtype,Nationalcode)values(N'{0}',N'{1}',N'{2}','{ 3}','{4}',N'{5}',N'{6}')";
s = string.Format(s, this.name, this.lastname, this.address,this.tel1,this.tel2,this.job,this.Nco de);
int result = co.command(s);
co.disconnect();
return result;
}
}
}
کلاس connect
namespace Modiriat_foroush
{
class connect
{
private SqlConnection con;
private SqlCommand com;
private SqlDataAdapter da;
public connect()
{
con = new SqlConnection();
com = new SqlCommand();
da = new SqlDataAdapter();
com.Connection = con;
da.SelectCommand = com;
}
public void connect111()
{
string s = "Data Source=.\\sqlexpress; AttachdbfileName=|DataDirectory|Modiriatforoush.md f;User instance = true; integrated security=true";
con.ConnectionString = s;
con.Open();
}
public void disconnect()
{
con.Close();
}
public int command(string s)
{
com.CommandText = s;
int result = com.ExecuteNonQuery();
return result;
}
}
و در آخر کد مربوط به ذخیره در جدول Customer
private void btnsave_Click(object sender, EventArgs e)
{
customer cu = new customer();
cu.name = txtname.Text;
cu.lastname = txtFamily.Text;
cu.address = txtaddress.Text;
cu.tel1 = txttel.Text;
cu.tel2 = txttel2.Text;
cu.job = txtjobtype.Text;
cu.Ncode = txtNationalcode.Text;
if (cu.add() > 0)
{
MessageBox.Show("OK");
}
}
لطفا کمک کنید