Maryam IT
یک شنبه 26 آذر 1391, 14:15 عصر
تو رو خدا یکی به من بگه چرا قسمت LoadALL() خطا میده.
اون قسمت open خطا میده
چیکار کنم؟
این کدا رو واسه update نوشتم
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
using System.Collections;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace Agreement
{
public partial class Form1 : Form
{
SqlConnection my_cn = new SqlConnection();
SqlDataAdapter dAdapter = new SqlDataAdapter();
SqlCommand scm = new SqlCommand();
DataSet dSet = new DataSet();
ArrayList arr = new ArrayList();
public Form1()
{
InitializeComponent();
}
public void Connect()
{
SqlConnection my_cn = new SqlConnection("server=(local);database=corporation1;Integrated Security=True");
}
private DataSet LoadAll()
{
Connect();
scm.CommandText = "select * from Agreement";
scm.Connection = my_cn;
dAdapter.SelectCommand = scm;
my_cn.Open();
dAdapter.Fill(dSet, "Agreement");
my_cn.Close();
return dSet;
}
private void Form1_Load(object sender, EventArgs e)
{
LoadAll();
dataGrid1.DataSource = dSet;
dataGrid1.DataMember = "Agreement";
}
private void Update(SqlCommand scm)
{
Connect();
scm.Connection = my_cn;
my_cn.Open();
scm.ExecuteNonQuery();
my_cn.Close();
}
private void dataGrid1_Navigate(object sender, NavigateEventArgs ne)
{
}
private void button1_Click(object sender, EventArgs e)
{
arr.Add(textBox1.Text);
arr.Add(textBox2.Text);
arr.Add(textBox3.Text);
arr.Add(textBox4.Text);
arr.Add(textBox5.Text);
arr.Add(textBox6.Text);
scm.CommandText = "Update set RegistrantID=@Reg_ID, HabitationDate=@Habit_Date, LeaveDate=@Leave_Date, ContinuationAmount=@Cont_Amount, IncreaseCostPercent=@Inc_Cost Where AgreementID=@Agree_ID";
scm.Parameters.Clear();
scm.Parameters.Add("@Reg_ID", SqlDbType.Int).Value = int.Parse(arr[0].ToString());
scm.Parameters.Add("@Habit_Date", SqlDbType.DateTime).Value = DateTime.Parse(arr[1].ToString());
scm.Parameters.Add("@Leave_Date", SqlDbType.DateTime).Value = DateTime.Parse(arr[2].ToString());
scm.Parameters.Add("@Cont_Amount", SqlDbType.Int).Value = int.Parse(arr[3].ToString());
scm.Parameters.Add("@Inc_Cost", SqlDbType.Int).Value = int.Parse(arr[4].ToString());
scm.Parameters.Add("@Agree_ID", SqlDbType.Int).Value = int.Parse(arr[5].ToString());
Update(scm);
LoadAll();
dataGrid1.DataSource = dSet;
dataGrid1.DataMember = "Agreement";
}
}
}
اون قسمت open خطا میده
چیکار کنم؟
این کدا رو واسه update نوشتم
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
using System.Collections;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace Agreement
{
public partial class Form1 : Form
{
SqlConnection my_cn = new SqlConnection();
SqlDataAdapter dAdapter = new SqlDataAdapter();
SqlCommand scm = new SqlCommand();
DataSet dSet = new DataSet();
ArrayList arr = new ArrayList();
public Form1()
{
InitializeComponent();
}
public void Connect()
{
SqlConnection my_cn = new SqlConnection("server=(local);database=corporation1;Integrated Security=True");
}
private DataSet LoadAll()
{
Connect();
scm.CommandText = "select * from Agreement";
scm.Connection = my_cn;
dAdapter.SelectCommand = scm;
my_cn.Open();
dAdapter.Fill(dSet, "Agreement");
my_cn.Close();
return dSet;
}
private void Form1_Load(object sender, EventArgs e)
{
LoadAll();
dataGrid1.DataSource = dSet;
dataGrid1.DataMember = "Agreement";
}
private void Update(SqlCommand scm)
{
Connect();
scm.Connection = my_cn;
my_cn.Open();
scm.ExecuteNonQuery();
my_cn.Close();
}
private void dataGrid1_Navigate(object sender, NavigateEventArgs ne)
{
}
private void button1_Click(object sender, EventArgs e)
{
arr.Add(textBox1.Text);
arr.Add(textBox2.Text);
arr.Add(textBox3.Text);
arr.Add(textBox4.Text);
arr.Add(textBox5.Text);
arr.Add(textBox6.Text);
scm.CommandText = "Update set RegistrantID=@Reg_ID, HabitationDate=@Habit_Date, LeaveDate=@Leave_Date, ContinuationAmount=@Cont_Amount, IncreaseCostPercent=@Inc_Cost Where AgreementID=@Agree_ID";
scm.Parameters.Clear();
scm.Parameters.Add("@Reg_ID", SqlDbType.Int).Value = int.Parse(arr[0].ToString());
scm.Parameters.Add("@Habit_Date", SqlDbType.DateTime).Value = DateTime.Parse(arr[1].ToString());
scm.Parameters.Add("@Leave_Date", SqlDbType.DateTime).Value = DateTime.Parse(arr[2].ToString());
scm.Parameters.Add("@Cont_Amount", SqlDbType.Int).Value = int.Parse(arr[3].ToString());
scm.Parameters.Add("@Inc_Cost", SqlDbType.Int).Value = int.Parse(arr[4].ToString());
scm.Parameters.Add("@Agree_ID", SqlDbType.Int).Value = int.Parse(arr[5].ToString());
Update(scm);
LoadAll();
dataGrid1.DataSource = dSet;
dataGrid1.DataMember = "Agreement";
}
}
}