VB.Net数据库操作

[清海扬波]

VB里面数据库操作很简单，但是在VB.Net里面感觉很麻烦，比如我一个表几十个字段，那么我插入，特别是修改的时候去拼凑SQL语句很麻烦，不知道是我方法不得当还是就是这样，如果有谁有比较简洁的操作数据库的代码给我看看，谢谢

[kulama777]

调用数据库的存储过程，只需要传递参数即可，其余操作就在存储过程里面写吧。
修改的时候一般也只是针对存储过程，除非参数要调整。

[清海扬波]

我是不想用存储过程，我还想做个Access版本呢，到时候不好转，而且好多系统我看都很少用存储过程的.

[pxjhy]

我不知道人家是怎么解决的。
当时这个问题我也很苦恼。

我现在的方法是一个字段占一行。习惯后，还是比较易读的。
如下面：

有点长哈。嘻嘻。。。。


mysql = "select dwname as 单位名称 , sum(c1) as 医疗收入 , " & _
"sum(c2) as 门诊收入 , " & _
"sum(c3) as 挂号收入 , " & _
"sum(c4) as 诊察收入 , " & _
"sum(c5) as 检查收入 , " & _
"sum(c6) as 治疗收入 , " & _
"sum(c7) as 手术收入 , " & _
"sum(c8) as 化验收入 , " & _
"sum(c9) as 其他收入 , " & _
"sum(c10) as 住院收入 , " & _
"sum(c11) as 床位收入 , " & _
"sum(c12) as 住院诊察收入 , " & _
"sum(c13) as 住院检查收入 , " & _
"sum(c14) as 住院治疗收入 , " & _
"sum(c15) as 住院手术收入 , " & _
"sum(c16) as 住院化验收入 , " & _
"sum(c17) as 护理收入 , " & _
"sum(c18) as 住院其他收入 , " & _
"sum(c19) as 医疗支出 , " & _
"sum(c20) as 工资福利支出 , " & _
"sum(c21) as 基本工资 , " & _
"sum(c22) as 津补贴 , " & _
"sum(c23) as 奖金 , " & _
"sum(c24) as 社会保险缴费 , " & _
"sum(c25) as 伙食费 , " & _
"sum(c26) as 伙食补助费 , " & _
"sum(c27) as 其他工资福利支出 , " & _
"sum(c28) as 商品和服务支出 , " & _
"sum(c29) as 办公费 , " & _
"sum(c30) as 印刷费 , " & _
"sum(c31) as 咨询费 , " & _
"sum(c32) as 手续费 , " & _
"sum(c33) as 水电费 , " & _
"sum(c34) as 电费 , " & _
"sum(c35) as 邮电费 , " & _
"sum(c36) as 取暧费 , " & _
"sum(c37) as 物业管理费 , " & _
"sum(c38) as 交通费 , " & _
"sum(c39) as 差旅费 , " & _
"sum(c40) as 出国费 , " & _
"sum(c41) as 维修费 , " & _
"sum(c42) as 租赁费 , " & _
"sum(c43) as 会议费 , " & _
"sum(c44) as 培训费 , " & _
"sum(c45) as 招待费 , " & _
"sum(c46) as 劳务费 , " & _
"sum(c47) as 委托业务费 , " & _
"sum(c48) as 专用材料费 , " & _
"sum(c49) as 卫生材料 , " & _
"sum(c50) as 其他材料 , " & _
"sum(c51) as 低值易耗品 , " & _
"sum(c52) as 工会经费 , " & _
"sum(c53) as 福利费 , " & _
"sum(c54) as 其他商品服务支出 , " & _
"sum(c55) as 对个人和家庭的补助 , " & _
"sum(c56) as 离休费 , " & _
"sum(c57) as 退休费 , " & _
"sum(c58) as 退职役费 , " & _
"sum(c59) as 抚恤金 , " & _
"sum(c60) as 生活补助 , " & _
"sum(c61) as 救济费 , " & _
"sum(c62) as 医疗费 , " & _
"sum(c63) as 助学金 , " & _
"sum(c64) as 奖励金 , " & _
"sum(c65) as 生产补贴 , " & _
"sum(c66) as 住房公积金 , " & _
"sum(c67) as 提租补贴 , " & _
"sum(c68) as 购房补贴 , " & _
"sum(c69) as 其他个人家庭补助 , " & _
"sum(c70) as 其他资本性支出 , " & _
"sum(c71) as 房屋建筑物购建 , " & _
"sum(c72) as 办公设备购置费 , " & _
"sum(c73) as 专用设备购置费 , " & _
"sum(c74) as 交通工具购置费 , " & _
"sum(c75) as 图书资料购置费 , " & _
"sum(c76) as 基础设施建设 , " & _
"sum(c77) as 大型修缮 , " & _
"sum(c78) as 信息网络建设 , " & _
"sum(c79) as 物资储备 , " & _
"sum(c80) as 资本性支出的其他 , " & _
"sum(c81) as 收支差额 " & _
"from VIEW_主数据表 where R_year * 12 + R_month >= '" & DropDownList2.SelectedValue * 12 + DropDownList3.SelectedValue & "' and R_year * 12 + R_month <= '" & Dropdownlist1.SelectedValue * 12 + Dropdownlist4.SelectedValue & "' and (" & _
" Dwname = '" & ListBox2.Items(0).Text & "' "

[songhuan]

要是觉得不方便可以用O/R maping的工具，或者可以自己做个小框架，从实体类反射出属性名（最好和列明相同）生成sql语句

[firein]

用stringbulider构建方便点