error

Question

private void btnSearch_Click(object sender, EventArgs e)

{

groupBox3.BringToFront();

string sqlcondition="ORDER BY iEmpID";

fnEmpView(sqlcondition);

}

Incorrect syntax near the keyword 'ORDER'....pls correct as soon as possible

Jignesh Trivedi · Answer

hi, I am not getting you. can you please provide more information?

Maneesh A N · Answer

please give rowheader mouse click code of syntax...and how to fill eachtextboxes

Jignesh Trivedi · Answer

hi, Store procedure is same as http://www.c-sharpcorner.com/Forums/Thread/240289/error-sql-2005in-dynamic-query.aspx if yes than try with store procedure.. alter procedure prcEmpView ( @Wherecondition nvarchar(4000) ) as begin declare @sqlquery nvarchar(4000) set @sqlquery= 'select vEmpName, vAddress, vPhone, vEmail from tblEmployee '+@Wherecondition exec(@sqlquery) end hope this will help you.

Maneesh A N · Answer

private void fnEmpView(string searchvalue) { DataSet ds = new DataSet(); ds.Tables.Clear(); SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = new SqlCommand("prcEmpView", ClsConnect.consql); sda.SelectCommand.CommandType = CommandType.StoredProcedure; //sda.SelectCommand.Parameters.AddWithValue("@iEmpID",G_iEmpID); sda.SelectCommand.Parameters.AddWithValue("@Wherecondition", searchvalue); string s = ClsConnect.consql.State.ToString(); if (s == "open") { ClsConnect.consql.Close(); } ClsConnect.consql.Open(); sda.Fill(ds); ClsConnect.consql.Close(); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i { dgvEmp.DataSource = ds.Tables[0]; dgvEmp.Columns[0].Width = 100; dgvEmp.Columns[1].Width = 100; dgvEmp.Columns[2].Width = 100; dgvEmp.Columns[3].Width = 100; } } } } }

Jignesh Trivedi · Answer

hi, can you please share fnEmpView function code so that we can verify...?