Browse by Tags

Related Posts

  • Gridview selecting command?

    I have a gridview on my page that is populated with a tableadaptor using a SQL query. The table is set for SELECT. my question is when a user clicks select on a record I would like to pull detail info of that record up on the page inside a <div> above the gridview I have setup already. I have an...
    Posted to Data Presentation Controls (Forum) by shawn.bordeaux on 05-15-2009, 12:00 AM
    Filed under: SQL, vb.net, asp.net, datasource
  • Display records in gridview - have a search button on page to display search results in grid view?

    Basically I want to have an asp textbox where a user can submit a string to search for data that exists in a gridview. They will search by either first_name or last_name something like; @search = request.form("search_string") SELECT * FROM customer_entry WHERE first_name Like %@search% OR last_name...
    Posted to Data Presentation Controls (Forum) by shawn.bordeaux on 05-15-2009, 12:00 AM
    Filed under: SQL, vb.net, asp.net, datasource
  • Creating a C# Web Service

    I have an interesting problem at work. I need the ability to get an amount of data, maybe 15MB or less, on a recurring basis for external datasources. Such as from a system in another state. These data files, CSV, XML, or whatever are too large to be transfered via email, plus I would have to manually...
    Posted to XML Web Services (Forum) by BrianFan on 04-09-2009, 12:00 AM
    Filed under: object, Object Oriented, Objects, remotely, Remove users, SQL, SQL Server 2005, SQLDataReader, System.IO, System.IO OutputStream, system.io.file, system.net, text, textstream, Web Application, <C#>, .net C# jobs, appSettings, Asp.Net bulk Uploading, big file size, C# 2.0, c# 2008 LINQ, c# 3.0, c# 3.5, c# memory .net, Class implementation, collections, create c# application, csv, Datasource, file, file system, file.io, filestream, Link SQL, memory usage, web services, Web Services ASP.net 2.0, WebParts, xml serialization deserialization, xml Word parse CSV SQL Server, xls table multiple, XML and asp.net, XML file, applicationSettings
  • Not updating with parameters

    Hi, I have an sql data source control on my page which has an update query like the following: UPDATE users SET email = @email, nickname = @nickname WHERE OpenIdUrl = @openidurl The parameters are defined below this ( <asp:Parameter Name="email" /> etc) The parameters value is set in...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by briggins5 on 12-25-2008, 12:00 AM
    Filed under: SQL, UPDATE, datasource
  • Selecting a URL from an SQL database.

    I have set up openId authentication on my site and would like to implement something where the page checks to see if the openId user has eneterd andy personla informaation into the sites database. I am trying to accomplish this by looking for recrods in the database where the 'openIdUrl' column...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by briggins5 on 11-19-2008, 12:00 AM
    Filed under: openid, SQL, authenticationntication, datasource
  • Re: Between sql2005 db, tableAdapters, BLL and Codehinds, How do display data related error messages?

    This is the code for the method in question: 1 [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, false )] 2 public MarketingContacts.OwnershipDataTable GetOwnershipByContactIdAndStaffDivId( int ContactId, int StaffDivId) 3 { 4 return GetOwnershipByContactIdAndStaffDivId...
    Posted to Data Access and ObjectDataSource Control (Forum) by akuyali on 04-18-2008, 12:00 AM
    Filed under: ObjectDataSource DataSet Multitable, sql, SQL ASP OBJECTDATASOURCE, strongly typed datatable, ADO.NET data access, BLL, BLL DAL Tier Separation, C#, DataAdapter, DataAdapter Update, DataSource, DataTable, Insert, insert datatable
  • I am attempting to post to another page and pass a form text box to a sql data source as a query variable.

    Hello. I used to use dreamweaver and vbscript to post a form to another page and then use Request.Form to get the variable from the form and put it in a query. I have been trying to do the same in ASP.net. I have managed to get it to work with postback. However when I change the property of the submit...
    Posted to Web Forms (Forum) by peterfleminguk on 09-23-2007, 12:00 AM
    Filed under: sql, TextBox, datasource
  • 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
  • Quantasoft

    Hi I am trying to set up an sql express (2005) database on quantasoft (qsh.eu). They assure me that they support this type of database and say to use user instances. There is also a connection string generator on their website. I have tried numerous times to get the connection to work, but every time...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by briggins5 on 06-16-2007, 12:00 AM
    Filed under: qsh, qsh.eu, quantasoft, sql, database, express, datasource, mdf
  • Unable to run complex SQL in DataList Data Source Config?

    Hi guys, I've written a SQL query that allows me to do paging (10 records per page view or as required), which I want to control using query strings. I've tested this in the SQL Server Management Studio and it seems to be working great. Just when I go into my DataList control's data source config and...
    Posted to Data Presentation Controls (Forum) by ziggy_911 on 03-05-2007, 12:00 AM
    Filed under: Pagination for Datalist, paging, paging custom control, sql, SQL Datasets, SQL Datasource TransactSQL JOIN SELECT, sqldatasource, T-SQL, ADO.NET, Datalist, datalist paging database, datasource, SELECT
Page 1 of 2 (12 items) 1 2 Next >