Hi, I am currently looking at re-writing a payroll/timesheet application that is currently in Access. The users need to enter timesheet hours for numerous employees. Up till now I have been experimenting and using strongly typed datasets as generated by VS. However as these provide a d...more >>

In VS2005 (Version 8.0.50727.42), I'm trying to create a "Data Connection" in the "Server Explorer" window ... I right click on "Data Connections" ... and choose "Add Connection" ... In that window, I change the "Data Source" to "Oracle Database" ... Then for "Server Name" I enter "newbi...more >>

I have a program that runs on multiple threads working with database sproc calls... these need to be all ran in transactions.... how can I get something similar to parallel transactions or at least to the point where they dont cause each other to crash? They all work with the same database c...more >>

Greetings, I have data values that are inherently of type Double. Current we are using Oracle Column Datatype NUMBER. When I create a TableAdapter in VS2005, the database table column information is read from Oracle and a new Table is created. However, the detected datatypes are always D...more >>

I want to create a single Cancel method to cancel all changes made to any fields in a UserControl. I have a method that creates a Binding object, adds it to a collection and than adds the Binding to the control. textBox1.DataBindings.Add(CreateDataBinding("Text", myobject, "Caption") ); pu...more >>

Hi, All This is the first time that I code asp.net against mySQL database. I am confused that which connector should I use 'cause I do not want make the wrong choice and have some problems later on? one is from mySQL official website http://www.mysql.com/products/connector/net/ or ODBC...more >>

Hi Everyone: I’m new to the VB.NET development platform, and I’m trying to understand how to retrieve database schema information from either of these databases: Microsoft Access, Microsoft SQL Server 2000, or Oracle. I recently bought a reference book titled “Beginning VB.NET Database...more >>

Hi, I am attempting to do a number of count functions on a single table of data for presentation in an ASP webpage. The functions are number today, number this week, number this month etc. As the Database table is large it does not make sense to query it directly a number of times. My idea ...more >>

Hi everyone, I'd like to access a database using C#. I've installed the Visual Studio 2003 and mysql essential and mysql administrator. On Visual Studio I go on server view and right click on SQL Servers, then I click on Register SQL Server Instance. It will prompt me to enter the instance na...more >>

Hi all, I don't know where to publish this question but hope this newsgroup is okey. I'm working in Visual Studio 2005 and are now creating a dataset file where I will do all the transactions with the database. I have a consumer table where I want to insert, update and delete consumers. ...more >>

Hello all, Can anyone here suggest me the keyword App similar to that in VB.NET? Iam developing a application which uses MS-Access as the database. In vb6.0 I use App to find the path and connect to the database example: dbname = App.Path & "\XXXXXX.mdb" Could anyone here please sugges...more >>

I'm building a lot of ASPX pages and business objects that consume and interact with database data. Some of this is done with data-binding, some is done with programmatic calls to Stored Procedures, Views, etc. I've created a DB class that I use to simplify and make consistent my inteaction...more >>

I am inserting a new record into a table which has 4 columns, the first being an identity column. I am adding three strings to the other 3 columns using an ExecuteNonQuery. I have set the values of the parameters for the InsertCommand. The error I am getting is that the Input is not in th...more >>

Hallo guys, I am getting bonkers (sorry). i have sql2005express/c#. I have calender and i get the dates right DateTime DeployDate = Convert.ToDateTime(Calendar1.SelectedDate); i tried putting the deployed date as a string and having Calendar1.SelectedDate.Convert.ToString as well after thi...more >>

Hey, YO...., I NEED SOME HELP HERE ! Actually, I got some info from a good guy called ScottT, but I need more. You see, I'm kind of stuck in here. I need to connect two forms. But the problem is... I don't know the codes. What I wanna do is click a button from...more >>

I'm hoping someone can help! I have a stored procedure in an MSDE database. When I use Query Analyser to run this stored procedure the correct results appear in the database. My stored procedure returns resultCode. The stored procedure includes a single BEGIN TRANSACTION [...] COMMIT T...more >>

CSV header conating "." dot and after loading it into dataset its converting into "#" LIKE. First.Name First # Name waiting for your reply ...more >>

I use the codes below to import the first sheet of an Excel file into a DataSet. But if the name of the first sheet is not "Sheet1", the SelectCommand will fail. How can I know the sheet name of the first Sheet in an Excel file? string sConnectionString = "Provider=Microsoft.Jet.O...more >>

Hi, I have a dataTable with some fields. How can I determinate if a string in the Field names of a dataTable? ...more >>

I am trying to return a datatable using the Oracle driver. In order to return a dataset from the stored proc I need a cursor type to receive the data. How is this possible with the Common namespace since it does not have a cursor or refcursor type? John...more >>

Can I run a SQL command like: RESTORE DATABASE NewDB FROM DISK = 'ApplicationStartupPath\SQLSE2005\DevDB.bak' WITH RECOVERY, MOVE 'DevDB_Data' TO 'C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\Data\\NewEB_Data.mdf', MOVE 'DevDB_Log' TO 'C:\\Program Files\\Microsoft SQL Server...more >>

Hi, I'm using .Net Framework 2.0. I Querying an Sql 2000 Database to fill a Dataset, the user dynamically choses what tables to query to fill the dataset. I need to provide information to the user about the tables, information such as the type and size of the columns. Though at start this...more >>

Hi, I am having stored proc which returns 2 resultsets, now i want to call this stored proc within another stored proc, but i want to use only the second resultset from the previous stored proc. So please tell me how can i do this.?? Thanks in advance, Regards, Manoj Singh. ...more >>

I ran into a problem when I tried to use SqlCommandBuilder to generate my insert statement. The problem was the identity column wasn't being set when I called Update. It was set correctly in the database, it just wasn't updating my inserted DataRow. This caused issues when I went to add rows ...more >>

I need to log 400 values every second into an access database. Previously I did this in C++ using OLEDB and after a lot of experimentation, I minimized the peak CPU usage by writing out the data in a separate thread every 10ms. Now I have to do this in C# and I am uncertain as to the most ef...more >>

I have an ASP.NET 2.0 website. I want to write a function in ADO.NET 2.0 (VB.NET) that does the following: 1. Opens up a connection to my SqlExpress db. (The connectionstring is in the <connectionStrings> section of my web.config) 2. Runs a query, storing results in a datatable. 3. Closes...more >>

Does anyone know of a way to estimate how much memory a datatable is using? Are they any user-friendly tools that I can find this info out? Thanks ...more >>

Hullo all: Is there a nifty way to retrieve a list of the macros / code modules in an MS Access database using ADO.NET, a la OleDB.OleDBConnection.GetOleDbSchemaTable for retrieving tables and views? Thanks much, zdrakec ...more >>

I have a SQL INSERT statement. I'm pretty well-versed in SQL but NOT in VB.NET / ASP.NET. I would like to know what VB code is for inserting a new row into a database. I have a SQL Table established already. I would like to know the code required to insert a new row to that SQL Table. I d...more >>

I have a SQL INSERT statement. I'm pretty well-versed in SQL but NOT in VB.NET / ASP.NET. I would like to know what VB code is for inserting a new row into a database. I have a SQL Table established already. I would like to know the code required to insert a new row to that SQL Table. I d...more >>

I'd like to have separate items in the DataGridViewComboBoxColumn for each row, For an example look at the vs2005 query builder. Column(0) is the fieldName and contains a list of the fields from the table named in column(2). If the table selected in column(2) of a particular row is change...more >>

Hi, Generally we will download the files using internet exlorer defalut download manager.By using C# or VB.Net how will we get the file information which we are trying to download from the Internet explorer. Is it possible. If any one helps thanks in advance. if any one have Code it wi...more >>

Hi, I want to use DataRelation object for setting up relationship between two different datatable, but i want to use multiple columns to set up relation between two tables. For example. DataRelation dRelationOrgInd = new DataRelation("OrgInd", ds.Tables["OrgList"].Columns["iIDOrganization,...more >>

Hi, I have two questions about the DataSet designer in Visual Studio 2005: 1. How can I make another TableAdapter under a DataTable which already has one? I'm sharing the DataSet with the DataTable between two applications, and they need separate TableAdapters... 2. I've created the Dat...more >>

Hi All, Hope you all fine? Can I ask you all a quick question? I`ve been trying to get concurrency to work for my project in VB2005. I have the following code, which to be fair i`ve got so lost with but here it is: Private Sub BTADSL_Load(ByVal sender As System.Object, ByVal e As System....more >>

Im am trying to create an auto increment column in a table. Where in the code below, should I make which changes in order to do that? Adrian /* dt.Columns.Add("Key", System.Type.GetType("System.Int32")); dt.Columns["Key"].AutoIncrement = true...more >>

I created a data source that point to an Access database with 3 tables in it. My problem is that the tables are designated read only and I don't know how to change the setting so I can copy data to them. I can see the public property in the config file but I am new to Visual Studio 2005 and ...more >>

Hi folks, I have 2 code snippets. One works and one does not. This first hard-coded snippet works Dim queryString As String = "UPDATE [rfi] SET [dateresolved] = '8/16/2006' WHERE ([rfi].[id] = @id)" This second snippet does not work Dim dtNow As DateTime = DateTime.Now d...more >>

In the VS2005 DataSet Designer if i try to add multiple tables from an OLEDB database, i get an error: "Failed to add TableAdapter." "An item with the same key has already been added." What does this mean? How do i get around it?...more >>

Have the following situation: I have an old C++ application, which I have managed to compile with /clr to make it access .net functionality. For some of the new functionality I have decided to create a C# DLL, being a very neat and handy language. I have used wizards to create the dataset, ...more >>

I need to accomplish this tasks: 1. i need to query sql database 2. check if null, if not continue 3. check a certain column if null,if not continue 4. filter or split the data into two sets, these 2 will be the datasources of two gridview. i can use datareader to query sql database, check ...more >>

I've implemented a solution that I don't really think is very efficient, but I can't really think of a better way to do it. If anyone has any suggestions or citicisms, i'd be grateful to hear them. .NET 2.0/SQL 2000 (not 2005). I have two identical databases that need to be syncronized, sepe...more >>

Hi folks, I am doing an UPDATE to a table that has a field for a DATE data type. I am using MS Access. The UPDATE works fine but when I try to place the DATE field in the mix it blows up. The table name is rfi. Here's a code snippet... Dim dtNow As DateTime = DateTime.Now ...more >>

I would like to use access (for testing, then ASP.NET) to execute a query which uses another query where a value must be set like ID = 2 or so. How can i do that? Here is my example, i created Table2 with an ID field and a name field (totally useless but it's they idea what matters). Quer...more >>

The complete error is : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - C...more >>

I will start by saying I am somewhat new to ADO.net, that said here goes. I have a dbase file with 450,000+ records, (400MB+ file size) I am loading only the UniqueID field into a DataSet and I have 2 problems. 1. It takes about 45 seconds to load 2. It is consuming about 400MB of RAM at that...more >>

Hello. I'm know, there is tones of pages in google, etc. about problem: "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." I'v read a lot, but this solutions doesn't resolve my problem. I'm using Strongly typed datasets, and ...more >>

Hi, Can anyone tell me how to Loop Through a Folder of Excel Workbooks using VB.Net? I have a folder with Excel files. Each spreadsheet has multiple worksheets. I need to read each worksheet and get the data and transfer that data to a database table. I am not sure how to loop through Excel ...more >>

Hello, if you have defined a DataSet in the HttpApplicationState which is shared by all current users ... what I have to do, to make the Dataset, DataTables and DataRows thread-safe? Following my assumptions: 1) If I change a Row: lock (datarow) { datarow["xy"] = value; } 2) If ...more >>

When my application uses OleDb-provider like... Private Sub TryOleDbConnection() Try Dim i As Integer Using cn As OleDbConnection = New OleDbConnection() cn.ConnectionString = "Provider=sqloledb;MYSERVERNAME\MYINSTANCE;Password=xxx;User ...more >>