一种插入记录的方式,撇开效率,看看对不对
以前写过一个库,可以用很简单的方式往数据库里插记录,但是现在看看,总觉得有问题。所以写了本文
是通过这么一种方式来往表中插入记录的
DataAccess.GetTable 和 UpdateDataTable 是这么实现的。
大家看看,有感想吗?
是通过这么一种方式来往表中插入记录的
1
DataTable dt = DataAccess.GetTable("tableName");
2
DataRow dr = dt.NewRow();
3
dr["col1"] = 1;
4
dr["col2"] = "test str";
5
dt.Rows.Add(dr);
6
DataAccess.UpdateDateTable(dt);
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/None.gif)
3
![](/Images/OutliningIndicators/None.gif)
4
![](/Images/OutliningIndicators/None.gif)
5
![](/Images/OutliningIndicators/None.gif)
6
![](/Images/OutliningIndicators/None.gif)
DataAccess.GetTable 和 UpdateDataTable 是这么实现的。
1
public static DataTable GetTable(string tablename)
2
{
3
SqlConnection conn = GetConn(); //取得数据库链接
4
SqlCommand cmd = new SqlCommand("select top 1 * from " + tablename, conn);
5
DataTable dt = new DataTable();
6
conn.Open();
7
SqlDataAdapter da = new SqlDataAdapter();
8
da.SelectCommand = cmd;
9
da.FillSchema(dt, SchemaType.Mapped);
10
dt.TableName = tablename;
11
conn.Close();
12
return dt;
13
}
14![](/Images/OutliningIndicators/None.gif)
15
public static int UpdateDataTable(DataTable dt)
16
{
17
SqlConnection conn = GetConn();
18
SqlCommand cmd = new SqlCommand("select top 1 * from " + dt.TableName, conn);
19
SqlCommandBuilder scb = new SqlCommandBuilder(da);
20
return da.Update(dt);
21
}
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
3
![](/Images/OutliningIndicators/InBlock.gif)
4
![](/Images/OutliningIndicators/InBlock.gif)
5
![](/Images/OutliningIndicators/InBlock.gif)
6
![](/Images/OutliningIndicators/InBlock.gif)
7
![](/Images/OutliningIndicators/InBlock.gif)
8
![](/Images/OutliningIndicators/InBlock.gif)
9
![](/Images/OutliningIndicators/InBlock.gif)
10
![](/Images/OutliningIndicators/InBlock.gif)
11
![](/Images/OutliningIndicators/InBlock.gif)
12
![](/Images/OutliningIndicators/InBlock.gif)
13
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
14
![](/Images/OutliningIndicators/None.gif)
15
![](/Images/OutliningIndicators/None.gif)
16
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
17
![](/Images/OutliningIndicators/InBlock.gif)
18
![](/Images/OutliningIndicators/InBlock.gif)
19
![](/Images/OutliningIndicators/InBlock.gif)
20
![](/Images/OutliningIndicators/InBlock.gif)
21
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
大家看看,有感想吗?
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步