error

Maneesh A N

13y1.4kVisual Basic .NET

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi13y ago
hi,

I am not getting you. can you please provide more information?
0
Maneesh A N13y ago
please give rowheader mouse click code of syntax...and how to fill eachtextboxes
0
Jignesh Trivedi13y ago
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.
0
Maneesh A N13y ago
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 < ds.Tables[0].Rows.Count; 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;
}
}
}
}
}
0
Jignesh Trivedi13y ago
hi,

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