给你一个简单例子:-:)
namespace HowTo.Samples.ADONET
{using System;
using System.Data;
using System.Data.SqlClient;public class adooverview3
{
public static void Main()
{
adooverview3 myadooverview3 = new adooverview3();
myadooverview3.Run();
} public void Run()
{
SqlDataReader myReader = null;
SqlConnection mySqlConnection = new SqlConnection("server=(local)\\NetSDK;Trusted_Connection=yes;database=northwind");
SqlCommand mySqlCommand = new SqlCommand("select * from customers", mySqlConnection); try
{
mySqlConnection.Open();
myReader = mySqlCommand.ExecuteReader(); Console.Write("客户 ID ");
Console.WriteLine("公司名称"); while (myReader.Read())
{
Console.Write(myReader["CustomerId"].ToString() + " ");
Console.WriteLine(myReader["CompanyName"].ToString());
}
}
catch(Exception e)
{
Console.WriteLine(e.ToString());
}
finally
{
if (myReader != null)
myReader.Close(); if (mySqlConnection.State == ConnectionState.Open)
mySqlConnection.Close();
}
}
}}
namespace HowTo.Samples.ADONET
{using System;
using System.Data;
using System.Data.SqlClient;public class adooverview3
{
public static void Main()
{
adooverview3 myadooverview3 = new adooverview3();
myadooverview3.Run();
} public void Run()
{
SqlDataReader myReader = null;
SqlConnection mySqlConnection = new SqlConnection("server=(local)\\NetSDK;Trusted_Connection=yes;database=northwind");
SqlCommand mySqlCommand = new SqlCommand("select * from customers", mySqlConnection); try
{
mySqlConnection.Open();
myReader = mySqlCommand.ExecuteReader(); Console.Write("客户 ID ");
Console.WriteLine("公司名称"); while (myReader.Read())
{
Console.Write(myReader["CustomerId"].ToString() + " ");
Console.WriteLine(myReader["CompanyName"].ToString());
}
}
catch(Exception e)
{
Console.WriteLine(e.ToString());
}
finally
{
if (myReader != null)
myReader.Close(); if (mySqlConnection.State == ConnectionState.Open)
mySqlConnection.Close();
}
}
}}
解决方案 »
- 如何写一个struct来存储csv文件信息?如何创建一个class scope来存储信息于列表中?
- wpf中,tabcontrol
- 字符串操作
- 隐藏主窗体/只允许一个实例运行 送分
- 用这个WebClient 编写自动表单提交的东东 这个__VIEWSTATE 怎么提交啊,大侠指教
- WebService QQ群:14869853
- string,值类型和引用类型。
- 请问谁有installshield 10.01 express版的注册码,先行谢谢了................
- 已经转换成大写的金额,但是怎么样把“万仟佰拾圆”分隔开来,分别得到5个变量?如果没有“仟”的话,就得到一个“零”,如果要判断的话
- 如何从DataReader数据集中取得为空字符串的某个字段?
- 有没有获取文件高级属性的函数或api(高分)
- 菜鸟问题:C#.net中如何进行数据库连接?
conn.open();DataSet dataSet = new DataSet();
dscommand.SelectCommand = new SqlCommand( "Select * from 同学档案", conn );
dscommand.Fill( dataSet );
foreach( DataRow dr in dataSet.Tables[0].Rows)
{
if( convert.ToInt32( dr["id"] ) == 23 //23是你的条件 )
//id 是你的表里column的名称
{
String name = dr["name"].ToString(); //name 是你的表里column的名称
....................
}}