asp.net.data_access-other

CodeVerge.Net ^Beta
Item Entry Register Login

Novell Forums

> Asp.Net Forum > data_access.other_databases

Type

Replies

Views

Date

need help: Export large data from table to excel

I have a large table(45 columns and morn than 80k rows), how can I export it to Excel file?
I try codes from

11/28/2009 12:05:56 AM

DB2 .NET Data Provider in Visual Studio

I am new to working with IBM as/400 database.

I heard of DB2 .NET Data Provider that helps connect to this database, but not sure where to begin.

Where do I fing this DL

11/25/2009 10:34:24 PM

How Do I - MVC and DB2

I am looking for a advice and/or examples that shows the "Best Practice" for adding DB2 data source to an MVC WebApp. I know how to connect to DB2, run queries, create da

11/24/2009 5:12:50 PM

The IBMDA400 provider is not registered on the local machine

Setup: win 2003 x64
iSeries: 5.4 (32bit)
Framework: 3.5
Error location: dev machine

I have the following conn string which I use in a class toolbox:

connstr =

11/18/2009 9:07:02 PM

Add calendar entry to Lotus Notes 6.5/8.5

I am new to Lotus Notes integration. However I am tasked to create ASP.NET application that will add calendar entry to Lotus Notes 6.5. So far, I managed to add a COM reference to the pr

11/16/2009 3:20:50 AM

Please help with firebird

I searching all over the web for Firebird alternative to sort by in SELECT statement (since sort by is not supported). I was unable to find anything. Can any1 who knows firebird, help.

11/14/2009 1:22:20 AM

ASP.Net Export Excel issue

Is there file size limit while exporting excel 2007 file using Microsoft.ACE.OleDB driver from ASP.Net?

I can export file with any size (like 10 MB) when same code is used with Console ap

11/12/2009 6:47:05 PM

Client unable to establish a connection

Hi,

I am connecting asp.net application to Sybase database. Below is connection string in web.config

11/12/2009 8:49:09 AM

How to index dynamic pages with Microsoft Indexing Service?

Hello,

I have implemented Microsoft Indexing service for ASP.Net C# web site for my client.

I am facing issue with the Dynamic pages. For example I have a datagrid which shows nam

11/12/2009 3:40:55 AM

The 'Microsoft.OLEDB.4.0' provider is not registered on the local machine

protected void Page_Load(object sender, EventArgs e)

11/11/2009 9:49:04 AM

how can i generate data from DB to Excel Sheet

Hello

I'm working in project Asp.net vb Access Database

What i want is to get the data i need from DB and then generate it to excel file

11/11/2009 9:48:55 AM

Open connection to AS400 - Use OleDbConnection?

Up to now, I've been using SQLdatasource to populate page data. I'm trying to modify an example page that uses "load from database" C# script. I think I can figure the res

11/11/2009 9:48:55 AM

How to connect remote server sybase database from sql server 2005 client th rough linked server

Hi Friends,

I have tried to connect through odbc driver, But it will be getting unable to establish connection error. But while accessing in dotnet 2005 application through cod

11/11/2009 9:48:53 AM

ASPNET does not have the authority to perform the requested command

Hi,

I have created a web service with VB .NET 2005 that is connecting to a DB2 database through a third party ODBC driver of DataDirect and simply adds a row to the table.

T

11/11/2009 9:48:52 AM

Conncecting Sybase with C# .NET

Am fed up connecting sybase with c# .Net as am getting one exception or other.

My connection string in web config is this.

11/11/2009 9:48:48 AM

db2 update and insert problem using C# asp.net

Hi,

I am trying to connect with DB2/AS400 using oledb. The connection has been succeed and I can fetch data successfully. But problem with insert and update.

When I send any qu

11/11/2009 9:48:44 AM

Problem in Enter Records in Excel Sheet (No value given for one or more req uired parameters.)

Hello,

I have getting an error message when enter data and click on submit button...

Below is the code for insert record in excel sheet version 5.0....

11/11/2009 9:48:42 AM

Not Showing Data From Excel Sheet

Hello,

I need to show data from excel sheet to page in asp.net. I have make connection on click button where creating a connection and then tryinhg to shos data there the code is given be

11/11/2009 9:48:38 AM

Advantage DataBase - Connecting using ASP

I have an ASP application that connects to an advantage database. After I close all the connections, the job still shows as active and stays as active for about 2 hours before terminating. Anyone

11/11/2009 9:48:37 AM

OLEDB DB2 connection from ASP.Net

I'm having a problem creating an OLEDB connection to a DB2 database using IIS/ASP.Net (from VS 2008)

I can connect from a windows app using the exact same connection string but not from

11/11/2009 9:48:34 AM

Select query syntax for Microsoft Indexing service using asp.net C#

I am using Microsoft Indexing service with asp.net C# 2.0. I need select query to modify to meet below requirements:

11/11/2009 9:48:30 AM

Order By in Foxpro

I am using foxpro database and my query looks like:

"Select top 4 x, y, z, w from Table order by 1"

I am using the query like this:

string sql = "Select top 4 mfc

11/11/2009 9:48:29 AM

DB2 connection from DotNet web application

Hi,

I'm working on a dotnet web application that connects to db2 database, currently we are using odbc driver, via odbc gateway server to fetch the data from db2, but it has so much p

11/11/2009 9:48:27 AM

DB2 connection from DotNet

Hi,

I'm working on a dotnet web application that connects to db2 database, currently we are using odbc driver, via odbc gateway server to fetch the data from db2, but it has so much p

11/11/2009 9:48:24 AM

using Ms Excel file as dataSource file

Hello Friends,

Well i hope that i'm in the right place, i have a table on my data base (Oracle) that i have to update (insert action only) periodicaly using an Excel file with f

11/11/2009 9:48:23 AM

How to backup database on each INSERT?

11/11/2009 9:48:19 AM

How to use Excel to get the data

I want to read the data from the excel spreedsheet and present it in the gridview

I am not getting what should be the the select statement for it.

11/11/2009 9:48:16 AM

Database design

I was trying to enforce constraint on one of my table and the requirement is like this.

I have Tables T1(Ct11, Ct12, Ct3), T2(Ct21, Ct22, Ct23), T3(Ct31, Ct32, Ct33).

Depend

11/11/2009 9:48:13 AM

db2 cursor

Hi to all,

I'm using DB2 database, within this have a procedure and as per DB2 syntax, i like to read some data using procedure, but we should create a cursor for select statmen

11/11/2009 9:48:10 AM

Dynamics AX Query Problem

Trying to do a very simply query against a Dynamics database via the Business Connector.

SELECT firstOnly * FROM %

11/11/2009 9:48:08 AM

things I was used to in fox pro and having trouble to do in vb.net

hello,

in was fox pro I am used to do the following:

a) for quick tests in fox pro I use the command window. Is there an equivalent in VS 2008 or do I have to put the code in an asp

11/11/2009 9:48:07 AM

how to update row in excel using OleDB?

I am importing data from excel file. According to the values on each
row, i want to write some statement in the last column. I want to do
this without having to install Office or t

11/11/2009 9:48:05 AM

Linked Server Question

We have several queries that connect to db2/400 (AS400). We are also in the situa

11/11/2009 9:48:03 AM

Load excel data into SQL

I followed this tutorial and downloaded the source code. Changing the connection string works. Uploading an excel file inserts all records successfully into the SQL server. The application create

11/11/2009 9:48:00 AM

datatable/dataset in asp.net c#

the following is part of my source code where i create a new oledbcommand and oledbdatareader and dump those results data into data table (dt):

string sqlQuery = "SELECT *

11/11/2009 9:47:57 AM

Unspecified error while connecting to Oledb

iam trying to read the excel file worksheet names.

For this am using oledbConnection with following code

11/11/2009 9:47:55 AM

Opening Crystal Report from ASP

Hi,

I am trying to open a crystal report from an ASP application. Crystal Report refers 2 Databases 1. SQL server 2. Excel. This is my code

Set session("oApp") = Server

11/11/2009 9:47:50 AM

sybase related problem

Hi all,

I am very new to sybase. I have a sybase database. Which sybase tool i will use to restore that database and query against the database.

11/11/2009 9:47:46 AM

connecting to postgress

can any one tell me how to connect to postgres without using any third party tool (visual studio 2005)

5/16/2008 11:43:29 PM

NHIbernate with Open Session In View

Hello to all!

Someone knows how implemet?s OSIV in NHIbernate with Asp .Net?

Thanks!

5/14/2008 11:48:24 AM

301 Error Received when querying DB2

I have a table on DB2 I want query. The field type for the field with a where clause is Decimal (Field: ID).

I have created two pages. In the first page I have a text box txtID. The seco

5/13/2008 8:26:06 PM

VS 2008 & Firebird DB

Hi All

Ive got a APS .net Web site created in Visual Studio 2008 and Im trying to connect to a Firebird Database.

Ive installed the

Version 2.5.0 Alph

5/13/2008 8:25:25 PM

Web.Config Connection string for a DB2 Database!

This is supposed to be a very simple thing but I just can't get this to work. My webservice connects to SQL server and Informix databases. Now I have added a DB2 database. M

5/9/2008 8:55:48 PM

Help insert data to excel file

Hi experts,

I am building web site that collect data from users and post it to an excel file on the server.
I have a problem when two users try to post the page at the same time, the

5/7/2008 2:11:15 AM

Import from VFP table

Hello !

Does anybody know a simple way about how to import all records from a table (dbf file) into a table from SQL ?

Thank You !

5/5/2008 7:13:18 PM

Lotus Notes Interop Question

I am just beginning to work with Lotus Notes/Domino 6.5. I have a project that will use ASP.NET to create a form that needs approvals from various individuals in the organization. Eac

5/1/2008 2:06:31 PM

Native query for deleting objectings in an ASP-project

Im trying to write a method for deleting objects in my db4o-database in my ASP-application, and copied this part from an earlier embedded project.

IObjectContainer db = Db4oHttpModu

5/1/2008 6:21:04 AM

Populate Datatable with data from WMI?

Hi all, once again I have run into a quirky obstacle.

Put simply I'm trying to populate a gridview with info collected via WMI. In particular the Exchange_Mailbox class of \root

4/30/2008 3:20:56 PM

Import data from Excel to sql server 2005 not working on server

I am trying to import data from an Excel file into SQL Server 2005 in a webform. The code below works on my local machine, but on the Production server it throws an unspecified OLEDB e

4/29/2008 3:35:19 PM

Shared Data; Windows Application --> ASP.NET Web

Good morning,

I'm using an OPC server to gather data from various PLC's on our corporate network. The nature of this data is highly volatile... some tags (a term used for an indiv

4/29/2008 3:22:33 AM

706 Items, 15 Pages 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |< << Go >> >|

Invite

Members

SiteMap

Privacy | Contact Us
All Times Are GMT