Browse by Tags

Related Posts

  • Simple search using 'where' and 'like'

    Hi, I am looking to create a simple search that will display records from one of the columns in my database that contain the searched term. I have generated the SQL statement as follows SELECT * FROM [gallery] WHERE ([Tags] LIKE '%' + @Tags + '%') and I know that this will create a list...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by magicjoef on 07-24-2008, 12:00 AM
    Filed under: querystring, search, Simple, where, like, SQL
  • Re: Problem with querystring parameters

    Hi Ramblor, Yes I have modified my Sql statement but still have a problem, but it is in the array I think because I have the following in my array:- Product IDs: 214,215, (tbl_subProduct.numSubProductID = 214) AND (tbl_subProduct.numSubProductID = 215) AND (tbl_subProduct.numSubProductID = ) It's...
    Posted to Web Forms (Forum) by cornishcat on 06-13-2008, 12:00 AM
    Filed under: parameters, querystring, sql, array
  • Problem with querystring parameters

    Hi, I'm having a problem getting an array (from a Label) into a querystring parameter. Please can someone tell me what I am doing wrong. Select Statement SelectCommand= "SELECT * FROM tbl_subProduct, tbl_material, tbl_product, tbl_subCategory, tbl_topCategory, tbl_topLevelProduct WHERE [tbl_subProduct...
    Posted to Web Forms (Forum) by cornishcat on 06-13-2008, 12:00 AM
    Filed under: querystringparameter, sql, select statement, querystring
  • How to copy data from one excel file to other excel file

    Hi I have two excel file (Ex1 and Ex2), both have same template (headers) and data will be populated from the dataset. Upto this step its works fine. My question : How to copy the data form 6th row to last row of "Ex2" and paste it into the "Ex1" after the last row in Ex1. Advance...
    Posted to Enterprise Services Integration (Forum) by SudhaYogesh on 09-12-2007, 12:00 AM
    Filed under: postback variables, querystring, selection, sql, sqldatabase, t code behind, update, VB.Net, ado.net, asp, ASP.NET, Asp.Net 1.1, Asp.Net 2.0, Asp.Net 2.0 and MS SQL Server 2005, asp.net 2.0 asp.net, asp.net 2.0 export to excel, Asp.Net 2.0 session, ASP.net 2.0 Tutorials, ASP.NET Sites, ASP.NET.NET 2.0, c#, C# code, database, datareader, dataset, datasource, excel, GridView field, Asp.NET2.0, grid view, reports, DotNet, Find Control
  • problem with retrieving/displaying data based on form input

    Hi, I've developed a form which accesses a database through a data layer and sends parameters based on the form input. I have written the following code which works by checking if the textbox is empty and passing a null value as a string to the search parameter in the query, of which there are five:...
    Posted to Data Presentation Controls (Forum) by tomosap on 02-22-2007, 12:00 AM
    Filed under: Null, parameter, problem, querystring, records, rows, search, sql, sqldatasource, string, table adapter, textbox, Updateparameters, VB, access database, ADO.NET, ASP.net 2.0 GridView InsertParameters ControlParameter PropertyName, data, data access layer, database, databinding, datasource, If Statement, method, SELECT, FORM, GridView, label, GridView asp.net
  • Pull content from SQL based on url query string

    I am trying to pull content into a content page (within a master page) by using url query strings. I have got the code to pull the query string in and it is working fine. I am having trouble creating my sql Select Command using a variable. My sql Select Command works fine if I hard code it - I am just...
    Posted to Data Presentation Controls (Forum) by timwilson on 02-07-2007, 12:00 AM
    Filed under: sql, sqldatasource, data, data access layer, database, dataitem, datasource, querystring, VB, asp.net 2.0
  • Sql Repeater Insert

    This page allows a visitor to register for a seminar. They come to this page by a link that passes a querystring (ex: SeminarID=3). Right now I have it setup where a textbox captures that querystring, but would like to simply delete that textbox and have the sql insert take care of it. I am also having...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by HCBMRDD on 07-18-2009, 12:00 AM
    Filed under: SQL, c#, repeater control, querystring
  • Checkboxlist > Querystring > SQL > Gridview (VB.NET)

    I have three checkboxlist controls generated from three SqlDataSource. I want to collect all of the selections made from the three checkbox lists and redirect with a querystring and have the sql select command populate the gridview. Search.aspx <script runat="server"> Protected Sub btnSubmit_Click...
    Posted to Data Presentation Controls (Forum) by HCBMRDD on 11-23-2009, 12:00 AM
    Filed under: GridView, sql, querystring, vb.net, checkboxlist
  • Query Strings

    Can someone give me a short tutorial on querystrings simple, complex, and using a data source?
    Posted to Getting Started (Forum) by nevthegr8 on 01-27-2008, 12:00 AM
    Filed under: Query string, querystring, QueryString tildes, Repeater, VB .NET, vb.net, ADO.NET, ASP 2.0.net, ASP.NET 2.0 VB.NET, asp.net export to word, database, formview, data access, SQL, asp 2.0 website
Page 1 of 1 (9 items)