Incorrect syntax near 'Implementation'

Rajveer singh

10y1.3k.NET

my UI

"My moto click any link open pdf file in new window but i want not use query string for security purpose"

my aspx .code

GridLines="None" Width="900px" CssClass="gridview" DataKeyNames="idno"

HeaderStyle-CssClass="header" RowStyle-CssClass="rows"

onrowdatabound="GridView1_RowDataBound">

<%#Container.DataItemIndex+1 %>

cs code on row databound

{

string filepath = "WriteReadData/documents/";

if (e.Row.RowType == DataControlRowType.DataRow)

{

HyperLink hl = (HyperLink)e.Row.FindControl("bnv");

if (hl != null)

{

DataRowView drv = (DataRowView)e.Row.DataItem;

Session["id"] = drv["idno"].ToString();

//string lsDataKeyValue = GridView1.DataKeys[e.Row.RowIndex].Values[0].ToString();

SqlConnection con = new SqlConnection(str);

string query = "select filename from level3 where link_level3='" + hl.Text + "' ";

SqlCommand cmd = new SqlCommand(query,con);

con.Open();

string file_name = (string)cmd.ExecuteScalar();

con.Close();

if (file_name != null)

{

hl.NavigateUrl = filepath + file_name;

}

Error generate on page load

how to solves this please guid me

Thanks

10 Replies

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

Francis Susaimichael10y ago
Accepted answer
I have changed your code a little. Try this and let me know.

{
string filepath = "WriteReadData/documents/";
if (e.Row.RowType == DataControlRowType.DataRow)
{
HyperLink hl = (HyperLink)e.Row.FindControl("bnv");
if (hl != null)
{
DataRowView drv = (DataRowView)e.Row.DataItem;
Session["id"] = drv["idno"].ToString();
//string lsDataKeyValue = GridView1.DataKeys[e.Row.RowIndex].Values[0].ToString();
SqlConnection con = new SqlConnection(str);
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select filename from level3 where link_level3 = @level";
cmd.Parameters.AddWithValue("@level", hl.Text);
string file_name = (string)cmd.ExecuteScalar();
con.Close();
if (file_name != null)
{
hl.NavigateUrl = filepath + file_name;
}
}
}
}
Francis Susaimichael10y ago
You are welcome Rajveer! Happy to help! :)
Rajveer singh10y ago
Thank you very Much sir............................................
Rajveer singh10y ago
bind grid view and click any item that value hl.Text

debugging query

select filename from level3 where link_level3='Telephone Directory(Complete)'
Francis Susaimichael10y ago
what is the value of the "hl.Text"? Also can you post your query, that you got during debugging?
Rajveer singh10y ago
same problem

Incorrect syntax near 'Implementation'.
Francis Susaimichael10y ago
As per your screen shot, the application throw "SQLException", which denotes that the error is on your query. Just debug the application, and take the SQLQuery from the string "query" and try to execute the same query in the SQL Server directly.

Overall, the query is not formed well that may be the issue.

Hope this helps!
Raja T10y ago
Not sure, try like

cs code on row databound
{
string filepath = "WriteReadData/documents/";
if (e.Row.RowType == DataControlRowType.DataRow)
{
HyperLink hl = (HyperLink)e.Row.FindControl("bnv");
if (hl != null)
{
DataRowView drv = (DataRowView)e.Row.DataItem;
Session["id"] = drv["idno"].ToString();
//string lsDataKeyValue = GridView1.DataKeys[e.Row.RowIndex].Values[0].ToString();
SqlConnection con = new SqlConnection(str);
string query = "select filename from level3 where link_level3=' " + hl.Text + " ' ";
SqlCommand cmd = new SqlCommand(query,con);
con.Open();
//string file_name = (string)cmd.ExecuteScalar(); changed to below

string file_name = cmd.ExecuteScalar().ToString();
con.Close();
if (file_name != null)
{
hl.NavigateUrl = filepath + file_name;
}
}
}
}
Please debug your code..
Rajveer singh10y ago
same problem .................
Raja T10y ago
Hi,

cs code on row databound
{
string filepath = "WriteReadData/documents/";
if (e.Row.RowType == DataControlRowType.DataRow)
{
HyperLink hl = (HyperLink)e.Row.FindControl("bnv");
if (hl != null)
{
DataRowView drv = (DataRowView)e.Row.DataItem;
Session["id"] = drv["idno"].ToString();
//string lsDataKeyValue = GridView1.DataKeys[e.Row.RowIndex].Values[0].ToString();
SqlConnection con = new SqlConnection(str);
string query = "select filename from level3 where link_level3='" + hl.Text + "' ";
SqlCommand cmd = new SqlCommand(query,con);
con.Open();
//string file_name = (string)cmd.ExecuteScalar(); changed to below

string file_name = cmd.ExecuteScalar().ToString();
con.Close();
if (file_name != null)
{
hl.NavigateUrl = filepath + file_name;
}
}
}
}