如何在Windows窗体应用程序中筛选Gridview？ [英] How to Filter Gridview in Windows Form Application?

问题描述

如何在Windows窗体应用程序中过滤网格视图？



我有一个包含一个参数的存储过程。

如何在运行时给出输入参数....？

存储过程

How to Filter Grid view in Windows Form Application?

I have stored procedure which contain one parameter.
how can i give input parameter at run time.... ?
Stored procedure

ALTER PROCEDURE [dbo].[TruckInfo] 
	@TruckNumber nvarchar(50)
AS
BEGIN
	SET NOCOUNT ON;
SELECT     dbo.TruckNumber.CommingDate, dbo.TotalProfit.TotalBachat, dbo.Drivers.DriverName1, dbo.Drivers.DriverName2, dbo.Drivers.Month, dbo.TruckNumber.TruckNumber, 
                      dbo.TruckNumber.GoingDate
FROM         dbo.TruckNumber INNER JOIN
                      dbo.TotalProfit ON dbo.TruckNumber.TruckNumber = dbo.TotalProfit.TruckNumber INNER JOIN
                      dbo.Drivers ON dbo.TruckNumber.TruckNumber = dbo.Drivers.TruckNumber
WHERE     (dbo.TruckNumber.TruckNumber = N'JU9786')
END

代码

CODE

private void CMBTotal_SelectedIndexChanged(object sender, EventArgs e)
        {
string ConStr = "Data Source=HP\\SM;Initial Catalog=SalraySystem;Integrated Security=True";

            SqlConnection con = new SqlConnection(ConStr);
            con.Open();

            SqlCommand cmd = new SqlCommand("TruckInfo", con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = CMBSearch.Text;// CMBSearch  take value from dropdown list


            SqlDataAdapter da = new SqlDataAdapter(cmd);

            DataSet ds = new DataSet();

            da.Fill(ds, "TruckInfo");

            dataGridView1.DataSource = ds.Tables["TruckInfo"]; 
        }

如何解决这个问题？

how to solve this problem ?

推荐答案

参考：how-to-pass-value-to-a-stored-procedure -using-c-sharp [ ^ ]

这篇关于如何在Windows窗体应用程序中筛选Gridview？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！