新手入门多多指教。各位高手帮忙解答!
怎么将窗体中的datagridview与sql连接?
连接之后怎么将sql中的表中内容显示在datagridview 中
谢谢各位!
怎么将窗体中的datagridview与sql连接?
连接之后怎么将sql中的表中内容显示在datagridview 中
谢谢各位!
解决方案 »
- null在C#有何种解释
- 十万火急 点击Repeater 其中的一个按钮动态添加一行可以进行输入的
- 装了VS2005后是否还需要装SQL SERVER 2000
- 我有一张表 里面的一些数据想通过vs的一个函数进行转换 后将变换的数据存在另一张表中 应该如何做
- 大家遇到这个错误吗?
- 两种方式创建数据库出错,请高手解答
- 关于偏移值的问题
- .net 2.0的一个问题。错误Illegal cross-thread operation
- C# datagridview刷新之后为什么列改变了
- 请问一个关于GDI+的问题
- opengl 立方体贴图顺序问题,后贴的图覆盖先贴的图,怎么解决啊?
- ComboBox经过转换后赋值问题
SqlConnection con = new SqlConnection(str);
con.Open();
string sql = "select * from tushu";
SqlCommand com = new SqlCommand(sql, con);
SqlDataAdapter adapter = new SqlDataAdapter(com );
DataSet dataset = new DataSet();
adapter.Fill(dataset, "tushu");
dataGridView1.DataSource = dataset.Tables["tushu"];
dataGridView1.AutoGenerateColumns = true; //创建列
con.Close();
using System.Data.SqlClient;
{
SqlConnection conn=new SqlConnection(connectionString)
SqlDataAdapter adapter=new SqlDataAdapter("SQL语句",conn);
SqlCommandBuilder build=new SqlCommandBuilder(adapter );
DataTable table=new DataTable ();
adapter.Fill(table );
DataGridView .DataSource=table;
}
这样试试
或者string connString = "server=.;database=数据库名;uid=sa;pwd=ok;";
要将数据库的值添加到datagridview中
用dataset或者dinbingSource来绑定数据
,或者直接定义个list<T>把数据保存到集合中
datagridview.dataSource = list<T>;
或者dataset.dataSource = 数据
datagridview.dataSource = dataset;
dinbingSource同理
1. 创建sqlconnection类的连接对象
SqlConnection mySqlConnection =
new Sqlconnection("server=localhost;database=Northwind;uid=sa;pwd=sa");
//server指定运行sql的计算机名,localhost是常用名表示程序所在的计算机2.建立sqlcommand对象
SqlCommand mySqlCommand = mySqlConnection.CreateCommand();3.设置SqlCommand对象的CommandText属性
mySqlCommand.CommandText =
"Select CustomerID,CompanyName,ContactName,Address" +
"FROM Customer" +
"Where CustomerID = 'ALFKI' ";4.打开sqlconnection对象
mySqlConnection.Open();5.运行Select语句
SqlDataReader mySqlDataReader = mySqlCommad.ExecuteReader();
//调用ExecuteReader()方法运行Select,返回一个SqlDataReader对象6.读行
mySqlDataReader.Read();7.显示SqlDataReader对象中的列值
Console.WriteLine("mySqlDataReader[\"CustomerId\"]="+
mySqlDataReader["CustomerID"]");
//以下依次是Commpanyname等项...8.关闭Sqlconnection的连接
mySqlConnection.Close();
sqldataadapter da= new sqldataadapter();
datagridview.dataSource = ds.tables["你要显示的表"];
不知道对不
SqlConnection con = new SqlConnection("连接字符串");
SqlDataAdapter da = new SqlDataAdapter("select * from 表名", con);
DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.dataSource = ds.Tables[0];
public AddressInfo GetAccountInfo(string userName, string appName) {
string sqlSelect = "SELECT Account.Email, Account.FirstName, Account.LastName, Account.Address1, Account.Address2, Account.City, Account.State, Account.Zip, Account.Country, Account.Phone FROM Account INNER JOIN Profiles ON Account.UniqueID = Profiles.UniqueID WHERE Profiles.Username = @Username AND Profiles.ApplicationName = @ApplicationName;";
SqlParameter[] parms = {
new SqlParameter("@Username", SqlDbType.VarChar, 256),
new SqlParameter("@ApplicationName", SqlDbType.VarChar, 256)};
parms[0].Value = userName;
parms[1].Value = appName; AddressInfo addressInfo = null; SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringProfile, CommandType.Text, sqlSelect, parms);
while (dr.Read()) {
string address2 = string.Empty;
if (!dr.IsDBNull(4))
address2 = dr.GetString(4);
addressInfo = new AddressInfo(dr.GetString(1), dr.GetString(2), dr.GetString(3), address2, dr.GetString(5), dr.GetString(6), dr.GetString(7), dr.GetString(8), dr.GetString(9), dr.GetString(0));
}
dr.Close(); return addressInfo;
}
SqlDataAdapter da = new SqlDataAdapter("select * from 表名", con);
DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.dataSource = ds.Tables[0];
这样就行啦
SqlConnection con = new SqlConnection("server=localhost;database=Northwind;uid=sa;pwd=sa");
SqlDataAdapter da = new SqlDataAdapter("select * from 表名", con);
DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.dataSource = ds.Tables[0];----------
三易通软件(服装进销存,服装进销存软件,服装进销存管理软件,服装进销存管理系统,服装店管理软件,服装店管理系统,服装销售管理软件,服装销售管理系统,服装零售管理软件,服装零售管理系统,服装店软件,服装店收银软件):http://www.3etsoft.cn
SqlConnection sqlConn;
SqlDataAdapter sqlDa;
DataSet sqlDs;
sqlConn = new SqlConnection("Data Source=.;Initial Catalog=jwinfo;Integrated Security=True;");
sqlDa = new SqlDataAdapter("SELECT * FROM 学生信息", sqlConn); sqlDs = new DataSet();
sqlDa.Fill(sqlDs, "学生信息");
sqlDs.Tables["学生信息"].Constraints.Clear();
SqlCommandBuilder sqlCmdBuilder = new SqlCommandBuilder(sqlDa);
dataGridView1.DataSource = sqlDs.Tables["学生信息"];
然后参考一下:
SqlConnection,SqlCommand,SqlDataReader 和SqlParameter的用法总结
http://topic.csdn.net/u/20100517/22/1c12fab4-ab19-4d04-8f62-ea859e44c84a.html
SqlDataAdapter da = new SqlDataAdapter("select * from 表名", con);
DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.dataSource = ds.Tables[0];在详细不过了
使用SqlCommand以及SqlDataAdapter从数据库中取得数据,将返回的数据放入DataSet.
将DataSet绑定到GridView上.
可以查看MSDN上的说明和例子.
{
SqlConnection con = new SqlConnection(_ConString);
double sumMoney = 0; try
{
//连接数据库中
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
con.Open();
//查询数据库中
foreach (string mode in ClassModeList.ConsumeMode)
{
cmd.CommandText = "SELECT SUM(Money) FROM U" + _LogedUserName + "Income where (Money<0) AND Mode ='"+mode+"' and (Time1>='" + from.Date + "' AND Time1<'" + to.AddDays(1).Date + "')";
SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read())
{
if (!String.IsNullOrEmpty(dr[0].ToString()))
{
sumMoney = sumMoney + Convert.ToDouble(dr[0]);
}
}
dr.Close();
}
sumMoney = double.Parse(sumMoney.ToString("#0.00")); return sumMoney;
}
catch (Exception)
{
return -1000000000;
}
finally
{
//关闭连接
con.Close();
}
}
【如果我的答复对你有所帮助,请到下列地址http://download.csdn.net/source/2247484 下载原创家庭记账软件,并给出宝贵意见!】
将datagridview的数据源指定为一个表格,然后把需要显示的内容查询出来拷贝到这个表格里,就会在datagridview里显示出来要显示的内容了。
【如果我的答复对你有所帮助,请到下列地址http://download.csdn.net/source/2247484 下载原创家庭记账软件,并给出宝贵意见!】
连接本站内的mdf数据库文件
conn.ConnectionString=
”Data Source=.\\SQLExpress;Integrated Security=true; AttachDbFilename=|DataDirectory|\\Database.mdf;User Instance=true;”;
连接本站内的ACCESS数据库文件
string StrConn = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=news.mdb";
string StrCm = "select * from tpnews"; OleDbConnection cn = new OleDbConnection(StrConn);
OleDbCommand cmd = new OleDbCommand(StrCm, cn); cn.Open(); OleDbDataAdapter oda = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
oda.Fill(ds, "tpnews"); this.GridView1.DataSource = ds.Tables[0].DefaultView;
this.DataBind();ASP.NET连接带密码Access的方法
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\bin\Debug\DB.mdb;Persist Security Info=True;Jet OLEDB:Database Password=10
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;namespace RoomType.DAL.SQLServer
{
internal class DBHelper
{
private static readonly string connString=
ConfigurationManager.ConnectionStrings["HotelManageConnectionString"].ConnectionString;
public static DataSet ExecuteDataSet(string sql)
{
SqlDataAdapter sda = new SqlDataAdapter(sql,connString);
DataSet ds = new DataSet();
sda.Fill(ds, "HotelManage");
return ds;
}
public static SqlDataReader ExecuteDataReader(string sql, CommandType type, params SqlParameter[] ps)
{
SqlConnection connection = new SqlConnection(connString);
SqlCommand command = new SqlCommand(sql,connection);
command.CommandType = type;
if (ps != null)
command.Parameters.AddRange(ps);
connection.Open();
return command.ExecuteReader(CommandBehavior.CloseConnection);
}
public static int ExecuteNonQuery(string sql, CommandType type, params SqlParameter[] ps)
{
SqlConnection connection = new SqlConnection(connString);
SqlCommand command = new SqlCommand(sql, connection);
command.CommandType = type;
if (ps != null)
command.Parameters.AddRange(ps);
connection.Open();
int i = command.ExecuteNonQuery();
connection.Close();
return i;
}
public static object ExecuteScalar(string sql, CommandType type, params SqlParameter[] ps)
{
SqlConnection connection = new SqlConnection(connString);
SqlCommand command = new SqlCommand(sql, connection);
command.CommandType = type;
if (ps != null)
command.Parameters.AddRange(ps);
connection.Open();
object obj = command.ExecuteScalar();
connection.Close();
return obj;
}
}
}
SqlDataAdapter da = new SqlDataAdapter(sql语句, con);
DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.dataSource = ds.Tables[0];
SqlDataAdapter da = new SqlDataAdapter("select * from 表名", con);
DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.dataSource = ds.Tables[0];
private DataSet dataset = new DataSet();// 声明并初始化DataSet
private SqlDataAdapter dataAdapter; // 声明DataAdapter
string sql ="select Sno 学号,Sname 姓名,Gender 性别,Sage 年龄,Sgrade 年级 from student";
//string sql = "select * from [student]";
// 初始化 DataAdapter
dataAdapter =new SqlDataAdapter(sql, DBHelper.connection);
// 填充 DataSet
dataAdapter.Fill(dataset ,"student");
// 绑定DataGridView的数据源
dataGridView1 .DataSource =dataset .Tables ["student"];
这是我写的一个小程序中用到的
1.//先使用连接字符串
SqlConnection con = new SqlConnection("连接字符串");
2.//构造SQl语句
string sql="sql语句";
3.//使用Sql适配器
SqlDataAdapter dataAdapter =new SqlDataAdapter(sql, con);
4.//填充数据集
DataSet ds =new DataSet;
dataAdapter dataAdapter.Fill(ds,"student");//student 为DataSet中的表名5.//绑定数据集
dataGridView1 .DataSource =ds.Tables ["student"];打完收工,这样应该可以了