mehran63
شنبه 08 آبان 1389, 13:35 عصر
من با کد زیر داده ها را از textBox میخوام وارد جدول کنم خطا میگیره هیچی ازش نمیدونم
لطفا بگید که چطور رکورد ها را از طریق TextBox با کلیک روی یک command وارد کنم
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace ConnectioinToSql2008
{
public partial class formConnectioinToSql2008 : Form
{
SqlConnection conn = new SqlConnection();
SqlCommand cmd = new SqlCommand();
//SqlDataReader rd;
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
public formConnectioinToSql2008()
{
InitializeComponent();
}
private void formConnectioinToSql2008_Load(object sender, EventArgs e)
{
string str = @"server=Mehran;" + "database=for_work;" + "Integrated Security=True";
conn.ConnectionString = str;
//conn.Open();
cmd.Connection = conn;
cmd.CommandText = @"select * from tinfo";
da.SelectCommand = cmd;
//rd = com.ExecuteReader();
//ds.Clear();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
//rd.Close();
//conn.Close();
} // end method formConnectioinToSql2008_Load
private void addButton_Click(object sender, EventArgs e)
{
//cmd.CommandText = "insert into tinfo(code,fn,ln,jens) valuse ('"
//+ fNTextBox.Text + "','" + lNTextBox.Text + "',";
cmd.CommandText = "insert into tinfo(code,fn,ln,jens) values (?)";
cmd.parameter.AddWithValue("@fn",fNTextBox.Text );
cmd.parameter.AddWithValue("@ln",lNTextBox.Text );
cmd.parameter.AddWithValue("@code",codeTextBox.Text );
cmd.parameter.AddWithValue("@jens",jensTextBox.Text );
cmd.ExecuteNonQuery();
}
}
}
لطفا بگید که چطور رکورد ها را از طریق TextBox با کلیک روی یک command وارد کنم
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace ConnectioinToSql2008
{
public partial class formConnectioinToSql2008 : Form
{
SqlConnection conn = new SqlConnection();
SqlCommand cmd = new SqlCommand();
//SqlDataReader rd;
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
public formConnectioinToSql2008()
{
InitializeComponent();
}
private void formConnectioinToSql2008_Load(object sender, EventArgs e)
{
string str = @"server=Mehran;" + "database=for_work;" + "Integrated Security=True";
conn.ConnectionString = str;
//conn.Open();
cmd.Connection = conn;
cmd.CommandText = @"select * from tinfo";
da.SelectCommand = cmd;
//rd = com.ExecuteReader();
//ds.Clear();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
//rd.Close();
//conn.Close();
} // end method formConnectioinToSql2008_Load
private void addButton_Click(object sender, EventArgs e)
{
//cmd.CommandText = "insert into tinfo(code,fn,ln,jens) valuse ('"
//+ fNTextBox.Text + "','" + lNTextBox.Text + "',";
cmd.CommandText = "insert into tinfo(code,fn,ln,jens) values (?)";
cmd.parameter.AddWithValue("@fn",fNTextBox.Text );
cmd.parameter.AddWithValue("@ln",lNTextBox.Text );
cmd.parameter.AddWithValue("@code",codeTextBox.Text );
cmd.parameter.AddWithValue("@jens",jensTextBox.Text );
cmd.ExecuteNonQuery();
}
}
}