关于textbox和sql的问题 读到一个string 里面不就可以了 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 TextBox1.Text=sqlDataReader["文本"].ToString(); 示例如下: String strCn = "server = sun;uid=sa;pwd=;database = NorthWind"; String strSQL = "SELECT Title FROM Employees"; SqlConnection cn = null; SqlCommand com = null; SqlDataReader rd = null; try { cn = new SqlConnection(strCn); cn.Open(); com = new SqlCommand(strSQL,cn); rd = com.ExecuteReader(); if( rd.Read()) { String str = rd["Title"].ToString(); textBox1.Text = str; } } catch(Exception ee) { //错误处理 } finally { if(rd != null) rd.Close(); if(com != null) com.Dispose(); if(cn != null) cn.Close(); } using System;using System.Drawing;using System.Collections;using System.ComponentModel;using System.Windows.Forms;using System.Data;using System.Data.SqlClient;namespace WindowsApplication6{ /// <summary> /// Form1 的摘要说明。 /// </summary> public class Form1 : System.Windows.Forms.Form { private System.Windows.Forms.TextBox textBox1; private System.Windows.Forms.TextBox textBox2; private System.Windows.Forms.TextBox textBox3; private System.Windows.Forms.Button button1; private System.Windows.Forms.Button button2; private System.Windows.Forms.Button button3; private System.Windows.Forms.Button button4; private System.Windows.Forms.Button button5; private System.Windows.Forms.Button button6; private System.Windows.Forms.Button button7; private System.Windows.Forms.Button button8; private SqlConnection conn; private SqlDataAdapter ad; private DataSet ds; private DataTable dt; private int i; private SqlCommandBuilder cmdB; /// <summary> /// 应用程序的主入口点。 /// </summary> [STAThread] static void Main() { Application.Run(new Form1()); } private void Form1_Load(object sender, System.EventArgs e) { conn=new SqlConnection("server=b02;uid=xcj;pwd=xcj;database=pubs"); ad=new SqlDataAdapter("select * from student",conn); cmdB=new SqlCommandBuilder(ad); conn.Open(); ds=new DataSet(); try { ad.Fill(ds,"student"); dt=ds.Tables["student"]; moverecord(); } catch(Exception exp) { MessageBox.Show(exp.Message ); } } private void moverecord()//绑定数据到TEXTBOX { textBox1.Text=dt.Rows[i][0].ToString(); textBox2.Text=dt.Rows[i][1].ToString(); textBox3.Text=dt.Rows[i][2].ToString(); } //移动到第一条记录 private void button1_Click(object sender, System.EventArgs e) { i=0; moverecord(); } //移动到最后一条记录 private void button4_Click(object sender, System.EventArgs e) { i=dt.Rows.Count-1; moverecord(); } //向前移动记录 private void button2_Click(object sender, System.EventArgs e) { i--; if(i<0) { i=0; } moverecord(); } //向后移动记录 private void button3_Click(object sender, System.EventArgs e) { i++; if(i>dt.Rows.Count-1) { i=dt.Rows.Count-1; } moverecord(); } //添加记录,清空文本框 private void button5_Click(object sender, System.EventArgs e) { textBox1.Text=""; textBox2.Text=""; textBox3.Text=""; textBox1.Focus(); } //保存添加的记录 private void button6_Click(object sender, System.EventArgs e) { try { DataRow dr=dt.NewRow(); dr[0]=this.textBox1.Text; dr[1]=this.textBox2.Text; dr[2]=this.textBox3.Text; dt.Rows.Add(dr); ad.Update(ds,"student"); ds.AcceptChanges(); } catch(Exception exp) { MessageBox.Show(exp.Message); } } //删除记录 private void button7_Click(object sender, System.EventArgs e) { dt.Rows[i].Delete(); ad.Update(ds,"student"); ds.AcceptChanges(); } //更新记录 private void button8_Click(object sender, System.EventArgs e) { dt.Rows[i][0]=textBox1.Text; dt.Rows[i][1]=textBox2.Text; dt.Rows[i][2]=textBox3.Text; ad.Update(ds,"student"); ds.AcceptChanges(); } }} using System;using System.Drawing;using System.Collections;using System.ComponentModel;using System.Windows.Forms;using System.Data;using System.Data.SqlClient;namespace WindowsApplication6{ /// <summary> /// Form1 的摘要说明。 /// </summary> public class Form1 : System.Windows.Forms.Form { private System.Windows.Forms.TextBox textBox1; private System.Windows.Forms.TextBox textBox2; private System.Windows.Forms.TextBox textBox3; private System.Windows.Forms.Button button1; private System.Windows.Forms.Button button2; private System.Windows.Forms.Button button3; private System.Windows.Forms.Button button4; private System.Windows.Forms.Button button5; private System.Windows.Forms.Button button6; private System.Windows.Forms.Button button7; private System.Windows.Forms.Button button8; private SqlConnection conn; private SqlDataAdapter ad; private DataSet ds; private DataTable dt; private int i; private SqlCommandBuilder cmdB; /// <summary> /// 应用程序的主入口点。 /// </summary> [STAThread] static void Main() { Application.Run(new Form1()); } private void Form1_Load(object sender, System.EventArgs e) { conn=new SqlConnection("server=b02;uid=xcj;pwd=xcj;database=pubs"); ad=new SqlDataAdapter("select * from student",conn); cmdB=new SqlCommandBuilder(ad); conn.Open(); ds=new DataSet(); try { ad.Fill(ds,"student"); dt=ds.Tables["student"]; moverecord(); } catch(Exception exp) { MessageBox.Show(exp.Message ); } } private void moverecord()//绑定数据到TEXTBOX { textBox1.Text=dt.Rows[i][0].ToString(); textBox2.Text=dt.Rows[i][1].ToString(); textBox3.Text=dt.Rows[i][2].ToString(); } //移动到第一条记录 private void button1_Click(object sender, System.EventArgs e) { i=0; moverecord(); } //移动到最后一条记录 private void button4_Click(object sender, System.EventArgs e) { i=dt.Rows.Count-1; moverecord(); } //向前移动记录 private void button2_Click(object sender, System.EventArgs e) { i--; if(i<0) { i=0; } moverecord(); } //向后移动记录 private void button3_Click(object sender, System.EventArgs e) { i++; if(i>dt.Rows.Count-1) { i=dt.Rows.Count-1; } moverecord(); } //添加记录,清空文本框 private void button5_Click(object sender, System.EventArgs e) { textBox1.Text=""; textBox2.Text=""; textBox3.Text=""; textBox1.Focus(); } //保存添加的记录 private void button6_Click(object sender, System.EventArgs e) { try { DataRow dr=dt.NewRow(); dr[0]=this.textBox1.Text; dr[1]=this.textBox2.Text; dr[2]=this.textBox3.Text; dt.Rows.Add(dr); ad.Update(ds,"student"); ds.AcceptChanges(); } catch(Exception exp) { MessageBox.Show(exp.Message); } } //删除记录 private void button7_Click(object sender, System.EventArgs e) { dt.Rows[i].Delete(); ad.Update(ds,"student"); ds.AcceptChanges(); } //更新记录 private void button8_Click(object sender, System.EventArgs e) { dt.Rows[i][0]=textBox1.Text; dt.Rows[i][1]=textBox2.Text; dt.Rows[i][2]=textBox3.Text; ad.Update(ds,"student"); ds.AcceptChanges(); } }} [Help]RasDial拨号上网可以在Win7下使用么? C#获取网络上一个url内容然后输出 如何使用时间控件(Calendar1) 文本框中不能输入符号 DataList编辑项中的控件选取 请教.net程序中往映射盘上写文件的问题 请推荐机器配置 帮助啊?? 加载string类型数据,读取指定值 。net用什么打包安装,帮帮忙了 请问各位高手,怎样用VC#下载FTP的文件 本人想转行了,准备再去自考一个本科文凭,什么专业实用呀!
String strSQL = "SELECT Title FROM Employees"; SqlConnection cn = null;
SqlCommand com = null;
SqlDataReader rd = null;
try
{
cn = new SqlConnection(strCn);
cn.Open();
com = new SqlCommand(strSQL,cn); rd = com.ExecuteReader(); if( rd.Read())
{
String str = rd["Title"].ToString();
textBox1.Text = str;
}
}
catch(Exception ee)
{
//错误处理
}
finally
{
if(rd != null)
rd.Close(); if(com != null)
com.Dispose(); if(cn != null)
cn.Close();
}
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;namespace WindowsApplication6
{
/// <summary>
/// Form1 的摘要说明。
/// </summary>
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.TextBox textBox2;
private System.Windows.Forms.TextBox textBox3;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.Button button2;
private System.Windows.Forms.Button button3;
private System.Windows.Forms.Button button4;
private System.Windows.Forms.Button button5;
private System.Windows.Forms.Button button6;
private System.Windows.Forms.Button button7;
private System.Windows.Forms.Button button8;
private SqlConnection conn;
private SqlDataAdapter ad;
private DataSet ds;
private DataTable dt;
private int i;
private SqlCommandBuilder cmdB;
/// <summary>
/// 应用程序的主入口点。
/// </summary>
[STAThread]
static void Main()
{
Application.Run(new Form1());
} private void Form1_Load(object sender, System.EventArgs e)
{
conn=new SqlConnection("server=b02;uid=xcj;pwd=xcj;database=pubs");
ad=new SqlDataAdapter("select * from student",conn);
cmdB=new SqlCommandBuilder(ad);
conn.Open();
ds=new DataSet(); try
{
ad.Fill(ds,"student");
dt=ds.Tables["student"];
moverecord();
}
catch(Exception exp)
{
MessageBox.Show(exp.Message );
}
}
private void moverecord()//绑定数据到TEXTBOX
{
textBox1.Text=dt.Rows[i][0].ToString();
textBox2.Text=dt.Rows[i][1].ToString();
textBox3.Text=dt.Rows[i][2].ToString();
}
//移动到第一条记录
private void button1_Click(object sender, System.EventArgs e)
{
i=0;
moverecord();
}
//移动到最后一条记录
private void button4_Click(object sender, System.EventArgs e)
{
i=dt.Rows.Count-1;
moverecord();
}
//向前移动记录
private void button2_Click(object sender, System.EventArgs e)
{
i--;
if(i<0)
{
i=0;
}
moverecord();
}
//向后移动记录
private void button3_Click(object sender, System.EventArgs e)
{
i++;
if(i>dt.Rows.Count-1)
{
i=dt.Rows.Count-1;
}
moverecord();
}
//添加记录,清空文本框
private void button5_Click(object sender, System.EventArgs e)
{
textBox1.Text="";
textBox2.Text="";
textBox3.Text="";
textBox1.Focus();
}
//保存添加的记录
private void button6_Click(object sender, System.EventArgs e)
{
try
{
DataRow dr=dt.NewRow();
dr[0]=this.textBox1.Text;
dr[1]=this.textBox2.Text;
dr[2]=this.textBox3.Text;
dt.Rows.Add(dr);
ad.Update(ds,"student");
ds.AcceptChanges();
}
catch(Exception exp)
{
MessageBox.Show(exp.Message);
}
}
//删除记录
private void button7_Click(object sender, System.EventArgs e)
{ dt.Rows[i].Delete();
ad.Update(ds,"student");
ds.AcceptChanges();
}
//更新记录
private void button8_Click(object sender, System.EventArgs e)
{
dt.Rows[i][0]=textBox1.Text;
dt.Rows[i][1]=textBox2.Text;
dt.Rows[i][2]=textBox3.Text;
ad.Update(ds,"student");
ds.AcceptChanges();
}
}
}
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;namespace WindowsApplication6
{
/// <summary>
/// Form1 的摘要说明。
/// </summary>
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.TextBox textBox2;
private System.Windows.Forms.TextBox textBox3;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.Button button2;
private System.Windows.Forms.Button button3;
private System.Windows.Forms.Button button4;
private System.Windows.Forms.Button button5;
private System.Windows.Forms.Button button6;
private System.Windows.Forms.Button button7;
private System.Windows.Forms.Button button8;
private SqlConnection conn;
private SqlDataAdapter ad;
private DataSet ds;
private DataTable dt;
private int i;
private SqlCommandBuilder cmdB;
/// <summary>
/// 应用程序的主入口点。
/// </summary>
[STAThread]
static void Main()
{
Application.Run(new Form1());
} private void Form1_Load(object sender, System.EventArgs e)
{
conn=new SqlConnection("server=b02;uid=xcj;pwd=xcj;database=pubs");
ad=new SqlDataAdapter("select * from student",conn);
cmdB=new SqlCommandBuilder(ad);
conn.Open();
ds=new DataSet(); try
{
ad.Fill(ds,"student");
dt=ds.Tables["student"];
moverecord();
}
catch(Exception exp)
{
MessageBox.Show(exp.Message );
}
}
private void moverecord()//绑定数据到TEXTBOX
{
textBox1.Text=dt.Rows[i][0].ToString();
textBox2.Text=dt.Rows[i][1].ToString();
textBox3.Text=dt.Rows[i][2].ToString();
}
//移动到第一条记录
private void button1_Click(object sender, System.EventArgs e)
{
i=0;
moverecord();
}
//移动到最后一条记录
private void button4_Click(object sender, System.EventArgs e)
{
i=dt.Rows.Count-1;
moverecord();
}
//向前移动记录
private void button2_Click(object sender, System.EventArgs e)
{
i--;
if(i<0)
{
i=0;
}
moverecord();
}
//向后移动记录
private void button3_Click(object sender, System.EventArgs e)
{
i++;
if(i>dt.Rows.Count-1)
{
i=dt.Rows.Count-1;
}
moverecord();
}
//添加记录,清空文本框
private void button5_Click(object sender, System.EventArgs e)
{
textBox1.Text="";
textBox2.Text="";
textBox3.Text="";
textBox1.Focus();
}
//保存添加的记录
private void button6_Click(object sender, System.EventArgs e)
{
try
{
DataRow dr=dt.NewRow();
dr[0]=this.textBox1.Text;
dr[1]=this.textBox2.Text;
dr[2]=this.textBox3.Text;
dt.Rows.Add(dr);
ad.Update(ds,"student");
ds.AcceptChanges();
}
catch(Exception exp)
{
MessageBox.Show(exp.Message);
}
}
//删除记录
private void button7_Click(object sender, System.EventArgs e)
{ dt.Rows[i].Delete();
ad.Update(ds,"student");
ds.AcceptChanges();
}
//更新记录
private void button8_Click(object sender, System.EventArgs e)
{
dt.Rows[i][0]=textBox1.Text;
dt.Rows[i][1]=textBox2.Text;
dt.Rows[i][2]=textBox3.Text;
ad.Update(ds,"student");
ds.AcceptChanges();
}
}
}