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
  • Unable to build LINQ to SQL entity in Visual Studio 2008 sp1

    When I drag a table from the server explorer onto the OR designer I get the error message "The selected object(s) use an unsupported data provider" I upgraded my visual studio 2008 version to the SP1 version and my database provider is sql server 2008 (my hosting service) but i'm still...
    Posted to Visual Studio 2008 (Forum) by mkatakiti on 12-16-2008, 12:00 AM
    Filed under: Server 2008, Service Pack 1 Fatal Error during installation, sql, Viisual Studio 2008, .net framework 3.5, asP.NET 3.5 linq, ASP.NET 3.5, DataContext, Frameowrk 3.5, linq liqdatasource, Linq to Objects, linq to sql, Linq Update Database, linq, SP1
  • Use LINQ to join two tables in two different database?

    HI, I wonder if I can use LINQ to join two tables in two different database: I created two Database Data Contexts: DBDataContext1 and DBDataContext2, In DBDataContext1, there is Table1 with following fields: UserID, UserName, PhoneID In DBDataContext2, there is Table2 with following fields: HistoryID...
    Posted to Data Access and ObjectDataSource Control (Forum) by nuber19 on 10-29-2008, 12:00 AM
    Filed under: SQL, C#, data binding problem, LINQ
  • Dynamic LINQ Objects

    I have spent quite some time Googling and looking around for anything relatively related to my subject, and have found very little. My scenario is this: I want to use LINQ in a web application, BUT I need the ability to dynamically create a Data Context, I believe it's called? The .dbml file that...
    Posted to Data Access and ObjectDataSource Control (Forum) by JMoore5268 on 09-17-2008, 12:00 AM
    Filed under: Query, sql, Visual Studio 2008, "Linq to Sql" LinqDataSource, .NET 3.5 SP1, asp.NET 3.5, asp.net 3.5 Linq, C#, data Acces, Data Access, Database, dynamic LINQ, LINQ in Action, Linq query, LINQ SQL Dynamic predicate builder, Linq to SQL, LinqDataSource, database connection, Linq, linq ado, LINQ databasecontext dbml, LINQ databasecontext dbml System, 3.5, Data Access connections, Data Access Application block, linq databasecontext
  • System.OutOfMemoryException when inserting large amount of data

    Hi everybody! I can't resolve one problem. Please help me! I have a table in SQL server 2005/2008 with column of data type XML. I'm trying to upload a large XML file to my web app and then insert it to this table. When I'm trying to do this, I receiving an exception System.OutOfMemoryException...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by flashion on 08-05-2008, 12:00 AM
    Filed under: OutOfMemoryException, SQL, xml, Linq
  • Linq to Sql rounds decimal e.g. 12.3 to 12.00?

    Hi I save e.g. 12.3 but in the table it is saved as 12.00 ? The column datatype is decimal(18,2) and I'm also able to save 12.3 directly into table over sql manager. I'm using the autogenerated LINQtoSQL dataset for table access Thank you very much
    Posted to Data Access and ObjectDataSource Control (Forum) by zipfeli on 07-18-2008, 12:00 AM
    Filed under: sql, Linq
  • LINQ to SQL object in Session between requests problems

    I am working on a project using LINQ to SQL and I am having a problem Inserting an object which I persist between requests in a multi stage data entry process. I create the object at the start of the process, and store it in session. So something like Order o = new Order(); Session.Add("order"...
    Posted to Data Access and ObjectDataSource Control (Forum) by tatsky on 07-07-2008, 12:00 AM
    Filed under: sql, Linq to SQL, Linq, Session
  • LINQ to SQL - Help needed in writing a query

    I am new to LINQ and I have managed to write some basic queries. But now I have somewhat complex requirement and I spend lot of time on it but couldnt solve myself.. Please help I have 5 tables - The tablke names and fields are given below 1. Category [CID(pk), Name] 2. QuestionCategory [CID(fk), QID...
    Posted to Data Access and ObjectDataSource Control (Forum) by anzer on 06-10-2008, 12:00 AM
    Filed under: sql, Linq
  • Re: Advantages of LINQ?

    It seems to m that the main advantage of Linq over writing a stored procedure in management studio is the hard typing of tables and parameters and auto completion of column names. The amount of code to connect to the database is significantly reduced - to one or two lines making code much more readable...
    Posted to ASP.NET 3.5 Extensions Preview (Forum) by ex glider pilot on 05-12-2008, 12:00 AM
    Filed under: SQL, column order, LINQ
Page 1 of 2 (16 items) 1 2 Next >