日期:2014-05-18 浏览次数:20750 次
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); } } } }
推荐阅读更多>
- c#项目中的小疑点
- 采取哪种算法,能够更精确的判断出文件的差异
- 关于Array.IndexOF()步骤
- window form怎麼設置快捷鍵啊解决方案
- WinForm SqlDataAdapter 和 DataGridView 的有关问题
- C#中queue的有关问题
- C# Socket,该如何处理
- 请问关于 datagrid 和 dataset 的两个有关问题~
- config有关问题
- 请教局域网服务器支持GHOST备份和恢复吗
- .ascx文件怎么读取MasterPage中控件?(ContentPlaceHolder)this.Parent.FindControl("ContentPlaceHolder1")
- C#中、自定义属性解决了什么有关问题
- 新手问个 水晶报表的白痴有关问题
- 正则匹配两处红色区域的有关问题
- winform中删除对话框点确认和取消都会删除,如何才能解决呢
- 内存不足,是什么原因?该怎么解决
- 一个关于查询的有关问题
- 如何读取目录下的所有文件名
- 初始化Form1出现了有关问题,请帮忙看看这是咋回事。(无限循环初始化)
- 用c#编的软件生成了setup.exe但是装配后运行不了