.net货品信息管理系统.docx

.Net 货品信息管理 ( 课程设计 )
}
protected void UpdateRecord_Click( object sender, EventArgs e)
{
( "" );
}
protected void DelRecord_Click( object sender, EventArgs e)
{
( "" );
}
protected void Search_Click( object sender, EventArgs e)
{
string ConnSql = "Data Source=.;Initial Catalog= 货品信息管理 ;Integrated Security=True" ;
// 声明 Conn为一个 SQL Server 连接对象
SqlConnection Conn = new SqlConnection (ConnSql);
(); // 打开连接
SqlDataAdapter da = new SqlDataAdapter (); // 创建 DataAdapter 对象
string SelectSql = "" ;
switch ()
{
case 0:
SelectSql = "select * from tb_Goods where 货品代码 like '%" +
+ "%'" ;
break ;
case 1:
SelectSql = "select * from tb_Goods where 生产商 like '%" + +
"%'" ;
break ;
}
= new SqlCommand(SelectSql, Conn);
DataSet ds = new DataSet ();