用C/S模式
请问如何使用sqlhelper.cs,如何调用sqlhelper啊,跪求大侠给详细剖解一下
实现数据库商品表[Product]的添删改查,具体代码如下
如何使用sqlhelper.cs实现下面的四大功能?????请大侠帮小弟实现代码
-----------------------------------------------------------------------------------
这个是商品管理的主窗体frmProduct
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using Isms.Sys;
namespace Isms.baseinfo
{
public partial class frmProduct : Form
{
public static int updateId;
public frmProduct()
{
InitializeComponent();
}
private void frmProduct_Load(object sender, EventArgs e)
{
// TODO: 这行代码将数据加载到表“ismsDataSet1.product”中。您可以根据需要移动或移除它。
this.productTableAdapter.Fill(this.ismsDataSet1.product);
}
private void dataGridView1_DoubleClick(object sender, EventArgs e)//双击事件
{
updateId = (int)this.dataGridViewProduct.CurrentRow.Cells[0].Value;
frmProductUpdate fpu = new frmProductUpdate();
fpu.ShowDialog();
}
private void toolStripButtonUpdate_Click(object sender, EventArgs e)//修改按钮
{
updateId = (int)this.dataGridViewProduct.CurrentRow.Cells[0].Value;
frmProductUpdate fpu = new frmProductUpdate();
fpu.ShowDialog();
}
private void toolStripButtonAdd_Click(object sender, EventArgs e)//添加按钮
{
frmProductUpdate fpu = new frmProductUpdate();
fpu.ShowDialog();
}
private void toolStripButtonDel_Click(object sender, EventArgs e)//删除按钮
{
}
private void dataGridViewProduct_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
}
}
此窗体有四个四个button按钮,一个datagridview
---------------------------------------------------------------------------------------------------------------
下面是添加/修改窗体frmProductUpdate
namespace Isms.baseinfo
{
public partial class frmProductUpdate : Form
{
public frmProductUpdate()
{
InitializeComponent();
}
private void frmProductUpdate_Load(object sender, EventArgs e)
{
}
private void btn_update_Click(object sender, EventArgs e)//修改按钮
{
}
private void btn_insert_Click(object sender, EventArgs e)//添加按钮
{
}
此窗体有6个textbox,分别是txt_name,txt_unit,txt_ab,txt_cu,txt_code,txt_ic,
-----------------------------------------------------------------------------
app.config 如下:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add name="Isms.Properties.Settings.ismsConnectionString" connectionString="Data Source=.;Initial Catalog=isms;Persist Security Info=True;User ID=sa;password=123;"
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
-------------------------------------------------------------------------------------------------------------------------
config.cs 如下:
using System;
using System.Collections.Generic;
using System.Text;
using System.Configuration;
using System.Data.SqlClient;
using System.Collections;
namespace Isms.Sys
{
class Config
{
public static int id;
public static string name;
public static ArrayList roleId;
public static ArrayList roleName;
public static ArrayList roleMenu;
public static DateTime lastLogon;
public static int RefreshTime;
public static string connection = ConfigurationManager.ConnectionStrings["Isms.Properties.Settings.ismsConnectionString"].ConnectionString;
}
}
------------------------------------------------------------------------------------------------------------------------
数据库是sqlserver2008,表[Product]的字段
id 主键;name[nvarchar50];ab[nvarchar50];unit[nvarchar50];code[int];cu[decimal(18,0)];ic[decimal(18,0)];is_active[int(默认值1)]
-------------------------
上述描述的很详细,就多谢高手援助了
本人菜鸟,多谢高手指点
sqlhelper.cs 如何使用????
最新推荐文章于 2022-05-17 19:07:06 发布