本文主要介绍下net中ado.net的基本使用方法,属于初级中的初级,最近在整理net的文档.准备将这些分门别类整理出来,希望能给一些准备学或开始学net的朋友有所帮助
//建立与数据库的联系
//string s_connstring = @"server=.;uid=sa;pwd=sa;database=Northwind";
//SqlConnection conn_object = new SqlConnection(s_connstring);
//conn_object.Open();
//string s_sqlparm1 = "select count(*) from Customers";
//SqlCommand cmd_parm1 = new SqlCommand(s_sqlparm1, conn_object);
//object obj_parm1 = cmd_parm1.ExecuteScalar(); //执行sql语句,返回单一值,如:count,sum,avg等
//if (obj_parm1 != null)
//{
// int i_rowparm1 = (int)obj_parm1;
//}
//-----------------------------------------------------------------------------------------------------
//string s_sqlparm2 = "select * from Customers";
//SqlCommand cmd_parm2 = new SqlCommand(s_sqlparm2, conn_object);
//SqlDataReader reader_parm2 = cmd_parm2.ExecuteReader();
//while (reader_parm2.Read())
//{
// System.Console.WriteLine("{0},{1}", reader_parm2[1], reader_parm2[2]);
//}
//-----------------------------------------------------------------------------------------------------
//string s_sqlparm4 = "select CustomerID,CompanyName from Customers";
//SqlCommand cmd_parm4 = new SqlCommand(s_sqlparm4, conn_object);
//SqlDataAdapter adapter_data4 = new SqlDataAdapter(cmd_parm4);
//DataSet dset_parm4 = new DataSet();
//adapter_data4.Fill(dset_parm4, "Customers");
//DataTable table_parm4 = dset_parm4.Tables[0];
////列显示
//foreach (DataColumn column_item in table_parm4.Columns)
//{
// System.Console.WriteLine("{0,-10}\t", column_item.ColumnName);
//}
////行显示
//foreach (DataRow row_item in table_parm4.Rows)
//{
// System.Console.WriteLine("{0}-{1}", row_item[0].ToString(), row_item[1].ToString());
//}
//-----------------------------------------------------------------------------------------------------
//--创建存储过程
//create procedure pr_my_GetCompanyName
//@CustomerID varchar(5)
//as
//begin
// select CompanyName from Customers where CustomerID = @CustomerID
//end
//;
//--测试存储过程
//exec pr_my_GetCompanyName 'ANTON'
//;
//--删除存储过程
//drop procedure pr_my_GetCompanyName
//;
////调用存储过程,返回单行单列数据
//object obj_parm5 = new object();
//string s_sqlparm5 = "pr_my_GetCompanyName";
//SqlCommand cmd_parm5 = new SqlCommand(s_sqlparm5, conn_object);
//cmd_parm5.CommandType = CommandType.StoredProcedure;
////加载in参数
//SqlParameter parm_customerid = new SqlParameter();
//parm_customerid.ParameterName = "@CustomerID";
//parm_customerid.SqlDbType = SqlDbType.NChar;
//parm_customerid.Size = 10;
//parm_customerid.Direction = ParameterDirection.Input;
//parm_customerid.Value = "ANTON";
//cmd_parm5.Parameters.Add(parm_customerid);
////执行存储过程
//obj_parm5 = cmd_parm5.ExecuteScalar();
//if (obj_parm5 != null)
// System.Console.WriteLine(obj_parm5.ToString());
//-----------------------------------------------------------------------------------------------------
//--创建存储过程
//create procedure pr_my_GetTableCustomer
// @CustomerID varchar(5)
// --@CompanyName varchar(20) output
//as
//begin
// select * from Customers where CustomerID = @CustomerID
//end
//;
//--测试存储过程
//exec pr_my_GetTableCustomer 'ANTON'
//;
//--删除存储过程
//drop procedure pr_my_GetTableCustomer
//;
////调用存储过程,返回数据集table
//string s_sqlparm6 = "pr_my_GetTableCustomer";
//SqlCommand cmd_parm6 = new SqlCommand(s_sqlparm6, conn_object);
//cmd_parm6.CommandType = CommandType.StoredProcedure;
//SqlParameter parm_customerid = new SqlParameter();
//parm_customerid.ParameterName = "@CustomerID";
//parm_customerid.SqlDbType = SqlDbType.NChar;
//parm_customerid.Size = 15;
//parm_customerid.Direction = ParameterDirection.Input;
//parm_customerid.Value = "ANTON";
//cmd_parm6.Parameters.Add(parm_customerid);
//SqlDataReader reader_customer = cmd_parm6.ExecuteReader();
//while (reader_customer.Read())
//{
// System.Console.WriteLine("{0}-{1}", reader_customer[0], reader_customer[1]);
//}
//-----------------------------------------------------------------------------------------------------
//这里说明一下,我的环境里,直接写Console关键字显示的是命名空间,不知为何
//可以这样写,加上System类库即可
//conn_object.Close();
//System.Console.ReadLine();