Sql Paraments C#

[Muhammad Waqas Butt]

Please tell how we can give Parameters in sqladapter. this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param2", System.Data.SqlDbType.NVarChar, 18, "Press_job_order")); sqlDataAdapter1.Fill(dataSet11); where i give paramenter @Param2 value and how.

[J4amieC]

Couple of ways. 1) Create the param first SqlParameter pressJobOrderParam = new SqlParameter("@Param2", SqlDbType.NVarChar, 18, "Press_job_order"); **pressJobOrderParam.Value = 123;** this.sqlSelectCommand1.Parameters.Add(pressJobOrderParam); 2) Add the param, as you did, then refer to it by name. this.sqlSelectCommand1.Parameters.Add(new SqlParameter("@Param2", SqlDbType.NVarChar, 18, "Press_job_order")); **this.sqlSelectCommand1.Parameters["@Param2"].Value = 123;**

[Muhammad Waqas Butt]

Thanks for Help? Do you have any idea about crystal report field hide and show. And date format in crystal i select date field from sql database i need to store date in dd/MMMM/yyyy format and also show in crystal report in this format. Any Idea? ....Thank again.

[J4amieC]

if "myDate" is of type DateTime i think to format it you use myDate.ToString("dd/MMMM/yyyy");

[Guffa]

The Add method returns a reference to the parameter, so you can set it's value. this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param2", System.Data.SqlDbType.NVarChar, 18, "Press_job_order")).Value = "42"; --- b { font-weight: normal; }

[Dead Skin Mask]

this.sqlSelectCommand1.Parameters.Add("@Param2", System.Data.SqlDbType.NVarChar, 18).Value = "Press_job_order"; or (if you're using .NET 2.0) : this.sqlSelectCommand1.Parameters.AddWithValue("@Param2", "Press_job_order");