Connecting method

最新推荐文章于 2023-12-16 23:23:05 发布

转载最新推荐文章于 2023-12-16 23:23:05 发布 · 68 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/greencolor/archive/2010/04/30/1724599.html

本文介绍了使用SQL语句和存储过程进行数据库操作的方法，包括连接数据库、执行SQL查询及调用存储过程的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

// sb sql

string setting = System.Configuration.ConfigurationManager.AppSettings["ConnectString"].ToString();
SqlConnection myconn = new SqlConnection(setting);
myconn.Open();

SqlCommand cmd = new SqlCommand(sb.ToString(), myconn);

cmd.ExecuteReader();

----------------------------------------

采用存储过程

SqlCommand com = new SqlCommand("PR_Indepot", DBHelper.Connectionstrings);
                com.CommandType = CommandType.StoredProcedure;
                SqlParameter[] pa ={
                    new SqlParameter("@id",SqlDbType.Int),
                new SqlParameter("@goodsName",SqlDbType.VarChar,50),
                new SqlParameter("@type",SqlDbType.VarChar,50),
                new SqlParameter("@model",SqlDbType.VarChar,50),
                new SqlParameter("@spec",SqlDbType.VarChar,50),
                new SqlParameter("@card",SqlDbType.VarChar,50),
                new SqlParameter("@price",SqlDbType.Money),
                new SqlParameter("@unit",SqlDbType.VarChar,50),
                new SqlParameter("@amount",SqlDbType.Int),
                new SqlParameter("@pay",SqlDbType.Money),
                new SqlParameter("@bid",SqlDbType.Int),
                new SqlParameter("@address",SqlDbType.VarChar,50),
                new SqlParameter("@linkMan",SqlDbType.VarChar,50),
                new SqlParameter("@phone",SqlDbType.VarChar,50)
            };
                pa[0].Value = ind.Id;
                pa[1].Value = ind.GoodsName;
                pa[2].Value = ind.GoodsType;
                pa[3].Value = ind.Model;
                pa[4].Value = ind.Spec;
                pa[5].Value = ind.Card;
                pa[6].Value = ind.UnitPrice;
                pa[7].Value = ind.Unit;
                pa[8].Value = ind.Amount;
                pa[9].Value = ind.Pay;
                pa[10].Value = ind.Bid.Id;
                pa[11].Value = ind.Address;
                pa[12].Value = ind.LinkMan;
                pa[13].Value = ind.Phone;
                foreach (SqlParameter p in pa)
                {
                    com.Parameters.Add(p);
                }

转载于:https://www.cnblogs.com/greencolor/archive/2010/04/30/1724599.html