String strConnString = ConfigurationManager.ConnectionStrings["con"].ConnectionString; SqlConnection con = new SqlConnection(strConnString); try { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Flag", 112); cmd.Parameters.AddWithValue("@Para1",SqlDbType.NVarChar).Value=secnm; cmd.CommandText = "spSelect"; cmd.Connection = con; // Filling Data to Gridviewsearch in View3 con.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds);
ELSE IF @Flag=112 BEGIN SELECT Team.tcode, Team.tnm, Section1.sdesc FROM Team INNER JOIN Section1 ON Team.sec_id = Section1.sec_id WHERE (Section1.sdesc = @Para1) END
cmd.Parameters.AddWithValue("@Para1",SqlDbType.NVarChar).Value=secnm;
cmd.Parameters.Add("@Para1",SqlDbType.NVarChar,-1).Value=secnm;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)