Databases
StackOverflow2013
Postsdbo
POError on searching in sql server
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POError on searching in sql server
    primarykey
    data
    text
    <p>I have the following method that i uses to search for fields in database </p> <p>this method return data and work right on my laptop local machine but didn't work and return empty data when i upload the project on server.</p> <p>Note: sqlserver on my local laptop 2008 but on server 2012</p> <p>here is the method</p> <pre><code> //this method for search protected void fillGridView(int followingID, string text) { SqlCommand myCommand = new SqlCommand("select t.*,u.firstName,u.lastName,u2.firstName as afirstName,u2.lastName as alastName ,i.icon,ii.iconPath as taskIcon, iii.iconPath as seenIcon,f.fileName,f.fileID from tasks as t inner join users as u on u.userID=t.addedBy inner join users as u2 on u2.userID=t.attachTo inner join priorityIcons as i on t.priority=i.priorityID inner join icons as ii on t.status=ii.iconName inner join icons as iii on t.isNew=iii.iconName left join files as f on t.fileID=f.fileID where t.followingID=@followingID and t.description LIKE '%" + text + "%' or t.followingID=@followingID and t.title LIKE '%" + text + "%'"); myCommand.Parameters.AddWithValue("@followingID", followingID); myCommand.Parameters.AddWithValue("@text", text); SqlConnection con = new SqlConnection(); con.ConnectionString = connection; myCommand.Connection = con; con.Open(); DataSet ds = new DataSet(); SqlDataAdapter adapter = new SqlDataAdapter(myCommand); try { adapter.Fill(ds); tasksRepeater.DataSourceID = null; tasksRepeater.DataSource = ds.Tables[0]; tasksRepeater.DataBind(); tasksCounter(); } catch (Exception ex) { DAO.exDao myEx = new DAO.exDao(); myEx.insert(ex); Response.Redirect("./error.aspx"); //success = false; //throw ex; } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USFadi Khalil
    1. USFadi Khalil
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POError on searching in sql server
      1. This table or related slice is empty.
      1. VTDownMod
    1. COhi have you checked. let us know still it doesn't work for you ?
      singulars
      1. POError on searching in sql server
      1. USChandan Kumar
    2. COstill id doesn't work
      singulars
      1. POError on searching in sql server
      1. USFadi Khalil
    3. COcheck in your db what type of datatype this id having ?
      singulars
      1. POError on searching in sql server
      1. USChandan Kumar
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload