日期:2014-05-18 浏览次数:20844 次
CREATE PROCEDURE getallczyinfo ( @sale_id char(10) , @sale_name char(10), @sale_jg char(10) ) AS declare @condition varchar(400) set @condition='' if(rtrim(@sale_id)!='') begin set @condition=@condition+' and sale_id='''+@sale_id+'''' end if(rtrim(@sale_name)!='') begin set @condition=@condition+' and sale_name='''+@sale_name+'''' end if(rtrim(@sale_jg)!='') begin set @condition=@condition+' and sale_jg='''+@sale_jg+'''' end declare @select1 varchar(2000) set @select1='select salepeople.sale_id as 销售员编号,salepeople.sale_name as 销售员姓名,salepeople.sale_sex as 销售员性别, salepeople.sale_age as 销售员年龄, salepeople.sale_jg as 销售员籍贯,salepeople.sale_xl as 销售员学历, salepeople.sale_call as 销售员电话,salepeople.sale_zhz as 销售员住址, salepeople.sale_xst as 销售员柜台 from salepeople where sale_id!=''-1''' exec(@select1+@condition) GO
namespace openjjsys { public partial class salepeoplemanage : Form { public salepeoplemanage() { InitializeComponent(); } private SqlConnection mycn; private SqlCommand mycmd; private SqlDataAdapter myda; private DataSet myds; private void salepeoplemanage_Load(object sender, EventArgs e) { mycn = new SqlConnection(); mycn = new SqlConnection("server=localhost;uid=sa;pwd=;database=openjjsys;"); myds = new DataSet(); mycmd = new SqlCommand(); mycmd.Connection = mycn; mycmd.CommandType = CommandType.StoredProcedure; mycmd.CommandText = "getallczyinfo"; mycmd.Parameters.Add(new System.Data.SqlClient.SqlParameter ("@sale_id",System.Data.SqlDbType.Char,10,"sale_id")); mycmd.Parameters.Add(new System.Data.SqlClient.SqlParameter ("@sale_name", System.Data.SqlDbType.Char, 10, "sale_name")); mycmd.Parameters.Add(new System.Data.SqlClient.SqlParameter ("@sale_jg", System.Data.SqlDbType.Char, 10, "sale_jg")); myda = new SqlDataAdapter(); myda = new SqlDataAdapter("getallczyinfo", mycn); myda.SelectCommand = mycmd; mycmd.Parameters["@sale_id"].Value = "%"; mycmd.Parameters["@sale_name"].Value = "%"; mycmd.Parameters["@sale_jg"].Value = "%"; myda.Fill(myds, "salepeople"); dataGridView1.DataSource = myds; dataGridView1.DataMember = "salepeople"; } private void button1_Click(object sender, EventArgs e) { try { myda.SelectCommand.Parameters["@sale_id"].Value = textBox1.Text; myda.SelectCommand.Parameters["@sale_name"].Value = textBox2.Text; myda.SelectCommand.Parameters["@sale_jg"].Value = comboBox1.SelectedItem; myds.Tables["salepeople"].Clear(); myda.Fill(myds, "salepeople"); } catch (SqlException ee) { MessageBox.Show(ee.Message); } } } }
![]()
推荐阅读更多>
- 使用IExtenderProvider接口的有关问题
- 求:涉及到多线程的UML Sequence的画法。该如何解决
- 前台页面直接条用后台程序失误
- 正则表达式 过滤html 保留flash解决办法
- 这点经验能混几斤棒子面吃?该怎么解决
- 能用linq 连接 oralce 么,该怎么解决
- 解决有关问题马下给分
- 工作难找解决方法
- 怎么获得datagridview单元格中心的坐标
- 小弟我第一次用c#编程序 想请问一个有关问题
- ref有关问题,请讲解
- C# winform中调用 *exe文件中的窗体,该怎么解决
- SQL中将带有分隔符号的字段分割分别插入新表中解决办法
- C#winform怎么关闭指定窗体,感激不尽呀
- 为什么有些线程只执行一次就不执行了?该怎么处理
- 怎样能让异常在母版页中暴露出来?
- 类似XP桌面上的按钮样式如何实现
- LINQ,根据条件修改。如何做!(急)
- C# 里边[]的意义
- 求:算法,该怎么解决