Browse by Tags

Related Posts

  • How to populate a table from a CSV File

    Using SQL Server 2005 Standard, Visual Studio 2008 Profession, ASP.NET 3.5, C#, ASP.NET AJAX. System Configuration: Web Server is a Virtual Server, Database Resides on a different server, also a Virtual Server (VMWare). I need users to be able to upload a file from their LOCAL machine. This file will...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bfancett on 12-30-2008, 12:00 AM
    Filed under: ObjectleDbDataReader, odbc, oldedb, sql, SQL 2005, SQL Data Adapter, SQL Datasets, sql server 2005, sql server 2005 stored procedure, SQL Server Stored Procedures, sql serverver reports, SQL TransactSQL Randomize Function, SqlDataAdapter, sqldatasource, SqlParameter, sqlreader, SQL-Server, stored procedure, stored Procedures, stringbuilder, Strongly Typed Datasets, strored procedures, table, table adapter, tables, Thanks, Thanks in Advace, Thanx, to a sql server database and how to retrive them, UPDATE, updating, Urgent Help needed, .NET 3.5, 2 column text field, add data, adding data, ADO.NET, ADO.NET 2.0, advanced, as.net 3.5, asp, 'ASP', asp .net 2.0, asp .net code, ASP .net.NET, ASP .net.NET Grid View, asp sql query customize datalist, ASP>NET, ASP.NET, asp.net c# sqlserver 2005 dataadapter querystring date comparison, asp.net 2.0 c#, asp.net 2.0 with c#, ASP.Net 3.5, c#, 'C#', C# 2005, c# code, c#.net, data, data access, data access layer, data entry, Data list, data mapping layer, data presentation, data repeater control, Data Set, data source, data tables, Dataa access, Excel to Sql-Server C# ASP.Net 2.0, fields, file upload, fileupload, insert, insert command, insert database sql, Insert new records, insert parameter value, insertion, InsertMode, LINQ Dynamic Data, LINQ SQL-to-LINQ DataGrid DetailsView, linq textbox query, LinqDataSource Linq, linq, ASP.NET3.5, ASP .net.net2, asp .net.net2.0, asp .net2.0, vs2008, SP, ASP .net ... c#, ASP .net ... c# ., asp .net ... c# ... SQL javascrpt, ASP .net ... c# 3.5, upload file, ASPNET SQL Server, excel C#, Sql Server, sqll, VS 2008, adding table data, ado.net designer dataset datatable datatableadapter designview gridview webforms bug, asp.net 2.0, C#. NET 2005, C#3.0, Data table, document, insert select, insert values, ASP .net ... c# ... javascript
  • Upload Excel File to SQL Server 2005 and Retrieve as link

    I want users to be able to upload an Excel file using the ASP.NET File Upload Control, have the file saved into a database table (which I have not created yet), and later on, based on an ID assigned to the file, retrieve it as a hyper link that when they click on it will open the file for them. I have...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bfancett on 12-19-2008, 12:00 AM
    Filed under: slq 2005, Slq Server, SQL, SQL 2005 SQL, Sql 2005 .NET, SQL 2005 ASP.NET, SQL Database design, SQL Server 2005, SQLL Serverr DTS, SQLServer, sqlserver 2005, SQLServer 2005SP2, sqLserver2005, sqlserverver, System.Array, varbinary, Visual Studio 2008, Visual Studio 2008 SP1, Web Project, "T-SQL", .NET 2.0, 2005, 2008, ADO.NET, asp.net 3.5, binary data, BLOB, c#, C# SQL, complex, convert, Data, data Acces, data access, data source, data storage, Database, DTS, DTS package, File Upload, files, LINQ Statement, LINQ toSQL, .NET SQL Server 2005, SQL 2005, SQL datatable, SQLServere2005, "SQL Server", .net 3.5, Linq, Store File to database, Stored procedures, ASP.NET C# sql, CSV, cvs, Data Type
  • url save plz help urgentttttttt....req...

    here iam trying to insert url into database the javascript function is generating this url " www.newpage.com?action="+save+"&name="+fname+"&uVal="+&read=yes&write=no&undo=yes+"&name2"+lname my code in www.newpage.com is if(current.request...
    Posted to Web Forms (Forum) by hivenkat on 10-23-2008, 12:00 AM
    Filed under: urlrewrite, .net 2.0, .NET Framework 2.0, data, Data Binding, Ado.Net, database, Query String
  • How to add columns in datatable already containing records

    Hi , I want to change schema of a DataTable which already contains some records. Basically I want to add one column Named "RowNo", Data type int and will contain value as Row Number in DataTable. Further I will do RowFilter on the basis of "RowNo" Column. Please provide appropriate...
    Posted to Data Access and ObjectDataSource Control (Forum) by jeetendra18 on 03-25-2008, 12:00 AM
    Filed under: 2.0, ADO, ADO.NET data access, ADO.NET LOCKING BLOCKING data access, ADO.NET Tutorial, asp 2.0, ASP 2.0 custom paging, asp .NET 2.0, ASP.NET, Asp.Net 2.0, Columns, Data, Data Access Layer, data set, data table, DataList, DataRow, DataTable, datatable full join, dataTable join, datatable tableadapter, DataTable To String Array, asp.net2.0, ASP .NET 2, ADO.NET data access, Filter, STOREd Procedures COMMAND ADO.NET ASP.NET, ADO.NET, DataColumn
  • Need help with SQL Statement (combined SELECT and WHERE at same time)

    I am building a file repository page. For data source I use SQLDataSource and Repeater to display the categories. I am trying to achieve the result of displaying the following data: List of all "Main Categories" and all "Sub Categories" under each main category name. Also, "Total...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by alex3003 on 10-29-2007, 12:00 AM
    Filed under: object data source, objectdatasource, ObjectDataSource "rows returned", SqlCommand CommandBuilder, sqldataSource, Access DataSource in code-behind, ADO, ADO.NET, ADO.NET data access, ADO.NET data access, Data, data access, dataset, DataView SqlDataSource, asp .NET 2 datatable tableadapter, SQL Server ADO.NET Transactions
  • VB.NET with ASP.NET Connection and Datareader

    I am using VB.NET for ASP.NET I get an error alot of time that another datareader of command is already associated with current connection which must be closed first. The example code logic is this its just conceptual Top level declaration. Dim cnn as new system....sqlconnection(connectionstring) Sub...
    Posted to Data Access and ObjectDataSource Control (Forum) by abid1pak on 07-12-2007, 12:00 AM
    Filed under: ADO.NET, data, DataReader, asp 2.0, Multiple datareaders, Connection Strings
  • Decode query does not take parameter!

    I am trying to use a Decode Query to define a DataTable method which looks like this: SELECT CDTS, '', '', '', LOC, NULL, DECODE(DTYPE, 'L', CONCAT(CONCAT(CONCAT('***** LOI MATCH:', LOI_DATA.NUM_1), ' ADDRESS: '), LOI_DATA.LOC), 'D', CONCAT('CLETS...
    Posted to Data Access and ObjectDataSource Control (Forum) by Chabo on 05-22-2007, 12:00 AM
    Filed under: outputparameter, Paramter, Performance : Stored Procedure with many params, Table Adapter, TableAdapter, TableAdapters, ADO.NET, ASP.NET, Asp.Net 2.0, DAL, Data, data Acces, Data Access, Data Access connections, data connections, data set, DataAdapter, Database, databind, DataGrid GridView Paging, DataSet, DataSource, Select, SQL Server ADO.NET Transactions
  • Saving listbox data - best approach?

    We have an ASP.NET 2.0 site that uses SQL Server 2000/2005. I am working on a page that updates our user table. But it will also update multiple related tables. For example, the user could be a member of several different companies and/or organizations and may have 1 to many roles out of a list of available...
    Posted to Data Access and ObjectDataSource Control (Forum) by nickpup on 04-19-2007, 12:00 AM
    Filed under: object data source, ObjectDataSource DataSet Multitable, passing object, sql, SQL Performance, Stored Procedures, VB.Net, ADO.NET, ASP.NET, Business Object, Data, Data Access, data set, DataAdapter, Database, databind, DataSet, DataTable, DataView SqlDataSource, design, SQL Server ADO.NET Transactions
  • Deciding how may datasets...

    Hi, I'm developing a mid-size web application. My database contains 83 tables and I'm certainly sure it's not advisable to create only one dataset containing all the tables. What could the criteria for grouping tables and create the necessary datasets? Number of tables in each dataset? One dataset for...
    Posted to Data Access and ObjectDataSource Control (Forum) by luxur2007 on 04-08-2007, 12:00 AM
    Filed under: ADO.NET, Business Object, DAL, Data, data Acces
  • How to retrieve data as XML from SQL database

    Hi, I have a website which is designed to search for employee information. I have the search system working which does exactly what I want to, but as an added feature I want there to be a button which, when someone clicks on it, it takes whatever the previous search was and generates a set of data in...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by tomosap on 02-28-2007, 12:00 AM
    Filed under: object data source, objectdatasource, parameter datatype, Stored Procedures, Table Adapter, TableAdapter, TableAdapters, VB.Net, ADO.NET, Columns, combining data sources, DAL, Data, Data Access, DataAdapter, Database, DataGrid GridView Paging, DataSet, DataTable, DataView SqlDataSource, DropDownList, XML, Gridview
Page 1 of 3 (21 items) 1 2 3 Next >