Hi Guys, can anyone tell me a good open source project or tool that I can use to sync data over the dial-up conection between SQL Servers? I tried the replication it's giving wired messages. Please help !!! Thanks, -Aruna ...more >>

Hi! I'm using the Data Access v2 building block from MS for my data access classes. I have a method which uses SqlHelper.FillDataSet to retrieve a resultset from a stored procedure. Now I have added three output parameters to return some extra info, but for some reason the values aren't ret...more >>

I have a DataSet.... With these tables: Parent, Child, and GrandChild. Each table has an Id, parentId and Name field. (except the Parent table does not have a parentId) naturally. With these Relations: ds.Relations.Add("ParentToChild",ds.Tables["Parents"].Columns["Id"],ds.Tables["Children"...more >>

Ok, I have been beating my head against the monitor now for weeks. My family no longer recognizes me and I am hearing tales about Uncle Bob coming to visit even. This can't be this hard. I have a significant amount of experience programming with VB 4 and 5. That, of course, was about 6 y...more >>

I've found a MSDN reference to the fact that an ADO.NET DataTable is limited to 16,777,216 rows of data [1], but what I cannot find is a reference for the maximum columns per DataTable, maximum bytes per DataRow, etc. Is this information documented anywhere? TIA! - Christopher [1] ...more >>

I need to compare and update a Binary(8) coln with values from an Int(4) coln. The table definitions are : CREATE TABLE [dbo].[COREBaseClass] ( [oid] [uniqueidentifier] NOT NULL , [ConditionID] [int] NOT NULL , [persistentFlag] [int] NOT NULL , [UIDCreator] [u...more >>

To setup MSDE2000a in my computer, I modified the "setup.ini" file to include the "instancename" and "targetdir" after the "[option]" statement. This was followed by entering the following command at the command prompt: c:\setup /settings "C\MSDERelA" sapwd="sa" A dialog box pop up and say...more >>

I have some data access code that runs fine when called from a vb.net 1.1 winform. But when the exact same code is called from a web service it times out. All code is running on my development machine and the data access code is talking to sql server also on my dev. machine. The only thing ...more >>

I ran across this ultra fantastic ADO.NET 2.0 thing - http://codebetter.com/blogs/sahil.malik/archive/2005/03/14/59761.aspx?Pending=true I was wondering if there is a way to specify a ConflictResolution strategy for a generated TableAdapter? Or will be a part of Beta2? Thanks. - Sahil Mal...more >>

Hi, I just want to configure a dataAdapter of an Excel file with Jet 4.0. The problem is that, when I use the wizard I realize that I can connect = to my file with the account "Admin" and an empty password. The = connection test succeeds. But when I'm finished with the wizard (clicking on t...more >>

Hi, I am calling an oracle built in procedure pkg_util.compile_schema from my VB.NET code this throws an excpetion ORA-02074: cannot ALTER PACKAGE COMPILE in a distributed transaction ORA-06512: at "SYS.DBMS_UTILITY", line 425 , this was working fine when i used with .NET 1.0 System.Data.Or...more >>

Hello All I have schema as such: <xs:element name="OFDateProxies"> <xs:complexType> <xs:sequence> <xs:element name="M_CRProxy_OID" msdata:DataType="System.Guid, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" /> <xs:element name="M_CRP...more >>

Hi all, I getting dataset as output from a method a web service. Along with other info this dataset is having wave file in binary base64 format in one of the columns. How to extract the data and create a wave file from this? Please help. Being a newbie to .NET technologies, this has becom...more >>

I got the below exception while executing a Stored Procedure from by using an adapter. It is showing timed out exception. But when i execute the same Stored Procedure in the database it is retrieving the results in few milli seconds. I doesn't understand why it was giving this error. For the sam...more >>

Hi. Here's the problem. I have ASP.NET web app and SQL Server 2k database. In the app, there's this button handler. string sql = "INSERT INTO Word (Word,WTranslation,Comment) VALUES ('"+txWord.Text.Trim()+"','"+txTranslation.Text.Trim()+"','"+txComment.Text.Trim()+"')"; SqlCommand c...more >>

I am using Parameters.Add to my OleDb.OleDbCommand as follows. cmd.Parameters.Add("@ListName", TextBox1.Text) cmd.Parameters.Add("@OutputFile", TextBox2.Text) It works beautifully with MS Access and SQL Server. But, I am now getting an error of "ORA-00936: missing _e...more >>

Hi I have a problem I suspect is to do with connection pooling. If I connect as username/password, and the dispose of the connection am I correct in thinking the next time I connect to the same datasource with username/password then the connection pool will be used and the same connection ...more >>

Hello, How can I pass a datatable of a typed dataset to a datatable in an untyped dataset? Thanks...more >>

Hi is there any fast way to delete all duplicates of a given record in a table (e.g. in an Access database)? Does a SQL statement exist that is able to do this? Thanks Peter...more >>

Is the single act of using stored procedures (in place of dynamic SQL) the only thing you have to do to prevent SQL injection attacks? Thank you, Eric ...more >>

We are getting this error intermittently and I have failed to find find a solution since I don't fully understand the issue. All I can gather is that the transaction is running too long and this is the cause of the problem (?) If someone could suggest a solution I would really appreciate i...more >>

Hi, I am searching for file name in database. From SQL Server Stored Procedure i get data into DataAdapter. From DataAdapter i fill into dataset, and i show the records in datagrid. From 2 lakh record, my stored procedure checks for validation and give me 10 records. It takes much time. ...more >>

I have a typed DataSet and I execute the Select Methd on one of the DataTables. Later I have to assign the first row returned by this Select (which is a plain, untyped DataRow) to a typed DataRow variable. I use cast, but it fails at runtime: "Specified cast is not valid".Is there any way aroun...more >>

Dear all, I would be grateful for any help with this issue. I have written the code below which is executed by a button on a form in an Access 2000 database in windows 2000. The idea is programmatically to copy a table called tblPubs (a table of newspapers) into a local database shell in ...more >>

Hi, I'm an ADO.NET beginner. I have an application in which all my database updates are done on the main form. It includes numerous dialogs which access the dataset information, then the dataset is updated when returning to the main form. If one user goes to one form and edits new data a...more >>

Hi, I have to add three sub reports to a single report based on three different field values so Can I add several sub reports to a single report if yes then how. Please send the detail flow. Eagerly waiting for response. Almannan M. K. ...more >>

Dear developers, Execption verifying password. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. my connection is correct... the connection string correct... but i dunno wat wrong wif that... thanks and advice. cheers, Wong CS ...more >>

Greetings, I have two SqlCommands objects that each need to execute concurrently but I want them both to be a part of the same transaction. What I'm doing is created one SqlCommand and Beginning a transaction. I have another SqlCommand that is being executed from within an Asynchronous de...more >>

I dont know if this is the correct group to place this question, but it seemed like the most likely. In the DAAB, I dont see any methods that return a parameter. Is there an NonExecuteQuery method where I can use a return parameter? Thanks. -- moondaddy@nospam.com ...more >>

I have a business object that return the list of contacts to the user interface. Here is the code of the method: public DataTable getContact () { // I know, this part should be in the Data Layer... SqlConnection conn = new SqlConnection (...); DataSet dsContact = new DataSet (...more >>

In Chap 13 David shows you how to bind a second form to the same data source by passing the CurrencyManager as an arg to the EditDetail Method of the second form: Public Sub EditDetail(byval CM as CurrencyManager) drvDetail = Ctype(CM.Current, DataRowView) vueDetail = drvDetail.DataVi...more >>

I had large database (transaction record > 1 million) at SQL Server and I trying to load data from SQL Server into Datagrid via ASP.Net 1.1 and ADO.Netx. However, it give error message as below during processing. While I checked at Query Analyser, it take 2 minutes + for search this rec...more >>

when creating an instance of a Command object can you do mulitple inserts? or would i have to keep creating a new instance each time i wanted a new row? if you can do multiples, how would i instantiate that same obj each time? Dim cmd As New OleDbCommand("Insert into TimeCard2(Empl_id,balance_...more >>

Hi All, I use CommandBuilder to create UpdateCommand. But it raise a "Concurrently violation" error. Could you tell us how to solve this problem. This error rarely happen. private static int Update(string name, DataRow row, string connection) { using(OleDbConnection cn = new Ol...more >>

Hello, I'm working on a asp.net project under VS-2003. I have created a database project and created some stored procedures. When I run my app, I get the error - "Stored procedure not found". Do I need to make a copy of my SP to the database thru Server Explorer? Also, when I try to put...more >>

Our app uses third party component and we do not have source code. That component requires as parameter Connection object only and we do not have access to the Command object it creates inside. So if query it generates exceeds 30 seconds timeout exception occurs. Is it possible to set CommandT...more >>

Hi, We are installing our app in a customers network. The app is using ADO.NET with .NET Framework 1.1. DB is MSDE. The clients is running Win XP, 2000, ME and NT 4.0. The app is installed on the server and when we start it from the workstations is runs fine on the XP workstations but not on ...more >>

In the course of debugging applications on my development workstation (ASP.NET 1.1.4322, SQL Server 2000, ADO.NET) the app will sometimes be unable to establish a database connection when I choose Debug->Start. (When stopped during debugging, the code does not always reach the Finally {} block w...more >>

Hi, I developed an application in visual c# .net This application reades an excel file and displays its contents into a dataGrid (OleDbDataAdapter). What I discovered is that if a cell in excel has a constant, then i can retrieve its contents. Also, if a cell has a formula (e.g. =K10) and K10 h...more >>

I have table Employee - Code varchar(5) Name varchar(100) Age int Using Ado.Net 1) Create a SQLConnection Object and open the connection. 2) Create a SQLCommand object using that connection. 3) Create a Transaction using SQLConnection.BeginTransaction(System.Data.IsolationLevel....more >>

Hi! I would really like to use some of the internal constructors and properties in my typed dataset from another assembly. Does anyone know of a way to do this without writing proxy classes or manually changing the dataset.cs-file everytime it's been generated?...more >>

Hi there, i have to move a bunch of SQLServer DBs onto SYbase. My VB.NEt code uses all the functions in System.Data.SqlClient... do i need to change all my code now for sybase? And do I have to use ODBC? My expeerience here is limited! thanx iva ----------------------- Posted by a user from ...more >>

hello, so the DataView object is confusing me. i have a dataset of a bunch of rows, some of white my page needs to filter out before binding. no problem, i make a new dataview, set a filter and then bind the dv to my page. ala: DataView myDV = New DataView(myDS.Tables[0], "Show=1", "ID DESC...more >>

Hi all, I'm using an Access DB with a bunch of queries. I've created a web service in VS 2003 and have drag/dropped the queries onto the workspace. This works fine, but the parameters are not auto-created as they are with SQL Server, for example. Does anyone have an idea on what the problem i...more >>

(Type your message here) I want to put the data I enter in my form using vb.net into a database using microsoft access -------------------------------- From: Derrick McDaniel ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>X5zGJFw8V0mMijW0TaBbmg==</I...more >>

Dear developer, I have experience this error message: System.NullReferenceException: Object reference not set to an instance of an object. at GreenBid_mobile.LoginProc.ValidateLogin(String EmailAdd, String Password) in c:\inetpub\wwwroot\greenbid_mobile\loginproc.asmx.cs:line 108 Here is ...more >>

Hi, I'm just wondering when I better should use an Sql Server or when a MSDE. Whet are the advantages of one to another en the limits etc. And this espacially when using them as databases for VB.NET-applications. Any information would be great! Thanks a lot in advance, Pieter ...more >>

SELECT GETDATE() July 29 1995 2:50 PM (1 row(s) affected) ---------------------- how can changed this format: 1995-29-05 14:50, Just in storeprocess ? ...more >>

ALTER PROCEDURE Login @LName nvarchar(50), @Pwd nvarchar(500) AS declare @myID int SET NOCOUNT ON if exists ( select @myID = ID from kylin_user where lname=@lname and pwd=@pwd ) begin insert into kylin_log(UID,TLogin)values(@myID,Getdate()) end RETURN but it mind that...more >>

We're using abstract interfaces for the data access in our classes. We're using strongly-typed datasets when using data adapters. We can use a SqlDataAdapter to fill a strongly-typed dataset using the Fill method, but we can't get the same result if we've cast the object to an IDataAdapter's f...more >>

How to use SQL View via ado.net in asp.net? Any reference at website? Please advise. ...more >>

how to dispose connection pooling when aspx is discontinued? In VB, the syntax is unload but how about aspx ? ...more >>

I am developing a project, in that i use SQL Transactions to begin a transaction like if i want to save the details of the user along with the Address first i will save the details of the user and then the address. in my database i have these type of files: Person, user, Address, userAddress : p...more >>

I am developing a project, in that i use SQL Transactions to begin a transaction like if i want to save the details of the user along with the Address first i will save the details of the user and then the address. in my database i have these type of files: Person, user, Address, userAddress ...more >>

Hi There, I have made a query called "Schedule",in access using few tables. Has fields like Order #, Required Date, Quantity ordered etc.. Depending upon the Required date field I provide on the input of the query. The query filters and displays results based on that. I want to use a form using...more >>

I have a DataSet in which one row contains a column with a string that has CR or LF characters in it. I am converting this DataSet to XML by calling DataSet.WriteXml(). I would have expected CR and/or LF characters to be translated to numeric character entry values. Instead, they are written o...more >>

I am unable to open a password protected Access Database programtically. I have office 2003 installed on my machine. I am using the OleDb namespace in C#. I can open the database in access. I can open the database programatically if I remove the password. Here are the last 3 connection stri...more >>

Hello NG, Does SQL Server support "ON DELETE SET NULL"? I have a couple of CREATE TABLE / ALTER TABLE commands that are all in one string, separated by ";\r\n", and send them to SQL Server (without transaction context). The SQL itself is created dynamically, but here is a sample (for si...more >>

Hi, Using VB .NET I want to combine app 100 different ADO.NET datatables, each with app 50,000 records which have been populated from SQL. They share a common ID, and I would like to group by this ID and sum up the other 4 columns to give me one master table. I understand how to populate ...more >>

Hello friends i have a question. Is about the deployment an application net over a pc. I installed the netframework 1.1 and i copied the applicattion . The problem es when the application tried to connect Sql. Dont do it Thanks -- Message posted via http://www.dotnetmonster.com...more >>

I am looking for example of reading one table using datareader and updating another with the values using a dataadapter....more >>

Has anyone noticed that the doc for this says: The value of this constant is 79,228,162,514,162,514,264,337,593,543,950,335 but that it is actually 99,999,999,999,999,999,999,999,999,999,999,999,999? Just thinking that Microsoft has a (minor) documentation error that should be fixed. ...more >>

Hi all! I would really appreciate getting some help on the following problem: I use a cached dataview as a source for my datagrid. The user selects items from controls and based on the selections a filter is applied on the dataview and the datagrid re-databinded. Now the problem: when I test th...more >>

I have the following: ___________________________________ Dim cmdSaveUser As New SqlCommand cmdSaveUser.Connection = con 'con has been configured previously cmdSaveUser.CommandType = CommandType.StoredProcedure cmdSaveUser.CommandText = "spInsertUser" cmdSaveUser.Parameters.Add("@FirstN...more >>

I'm currently using .NET 1.0 and MS .NET provider for Oracle to connect to my Oracle9i R2(9.2.0.5) database. I have a piece of code which in essence is as given below Try m_Conn = New OracleConnection(strDBConnString) m_Conn.Open() m_Trans = m_Conn.BeginTransaction() '...more >>

Hi, I get a DataTable based on this simple query: SELECT * FROM Customers Later, I want to know just the table name because I do not want to play with the string within the SELECT statement. I expect DataTable.TableName to give me an exact name, i.e. "Customers", but it gives me "Table" r...more >>

I have a DataSet filled from a previous query to the database. I need to get the distinct values from a field in the DataSet. Is there a way to acheive this without going through the DataTable or by hitting again the database? TIA...more >>

Hi! An application adds DataRows into DataTable in random period of time, and after adding new rows saves DataTable as XML-file. DataTable contains DateTime Field named as "SaveTime", and some other fields... About "SaveTime" field, schema looks like... <xs:element name="SaveTime" type=...more >>

The following is an issue using ado.net in an asp.net page using SQL Server.... I have a Statement that when executed from my asp.net dataadapter takes about 24,000 reads according to SQL Profiler. I think the read count is accurate as it grids a long time. The same statement when execu...more >>

Hi to you all, I wonder if anyone has been able to get the DataRowCollection.InsertAt method to work correctly? I added 2 rows in DataGrid using InsertAt function. After I edited one of the rows and moved to Up/Down, a new identical row appeared in the DataGrid. Is this a bug? Any ...more >>

guys, i need some help on this one. i need to set up a program that will create a text file (done that). then ftp that file to an IP address, say IPAddress=204.23.144.21 IPLogin=ftpmylogin IPPassword=mypwd this program can be in VB.NET or ASP.NET - doesnt really matter. whichever is the eas...more >>

I am trying to use the Oracle DAAB found in the Nile application at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/manprooracperf.asp. I am trying in VB 2003 to call an Oracle 9i stored procedure with parameters but I cannot seem to get past the compiler. Oracle...more >>

I have an intermittant problem that occurs a couple of times a week in a handful of places in the code (the same places at different times). The error is 'Object reference not set to an instance of an object'. After much research (it's not my code), I've found that it is occuring when a dat...more >>

hi all ! see my site and you understand all. www.michaeliusis.narod.ru Hi all ! I provide CRACKED engineering and technical software at this topics: 1. Civil and Structural 2. 2. Survey , GIS , Rock , Soil and Water 3. Architectural 4. CAD-CAM 5. FEA , CFD and CAE 6. Electrical ,...more >>

Hi all, I just ran into something very, very strange.. I have this application which fires of a series of SQL Scripts using the sqlCommand Object. One of the statements executes the procedure "sp_addMergePublication" on the server. If I do this on a local machine, everything works fi...more >>

Hello all. I'm trying to filter a dataset using the below snippet, however, it's returning 2 rows and it should only return 1. Can anyone please hel?p DataView dv = new Customer().GetCustomerFiles(4).Tables[0].DefaultView; dv.RowFilter = "FileType = 'Company Info'"; int b = dv.Tabl...more >>

Dear developers, i hav face a big problem on connect my web services to my DB. i m using MS SQL Server 2000 to build the web services.. but i cannot invoke the input into the database and "HTTP 500 - Internal server error" on the IE. I hav try the same thing on newly created ASP.NET Web Appl...more >>

changing the table a dataadapter accesses If I want to change the table a dataadapter accesses, can I remove the former table from the dataset's xsd file by simply deleting it? Thank you in advance. dennist685 ...more >>

Hi, My program uses DAAB to inject data to SQLServer using ExecNonQuery() with stored procedure. In normal case, it works property. But in some situations such as database backup process, I got timeout error and my program will retry to inject until success. In this week, I've found tha...more >>

Hi to you all, I wonder if anyone has been able to get the DataRowCollection.InsertAt method to work correctly? I added 2 rows in DataGrid using InsertAt function. After I edited one of the rows and moved to Up/Down/Left/Right, a new identical row appeared in the DataGrid. Is th...more >>

C'est un mini exemple avec un DataGrid, un bouton "Add" (pas nécessaire, juste pour le code) et un bouton "Update". Le but : Utiliser des valeurs négatives pour les nouvelles saisies dans les champs auto incrémentés. Lors de la mise à jour avec DAProduits.Update(...), on cherche l...more >>

I'm getting the following error message in an ASP.NET application: Time Expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. I've read several KB articles on this an...more >>

Hi I'm very new to this so forgive me if I've made very amateur mistakes. I am writing a web page for work so that items in a database can be queried and then amended if required. I've written a function which returns a DataSet. I call this function from a sub procedure and assign the re...more >>

Hello, I use VB.net I have a XML file and I read it with a dataset : myDS.readxmlschema("test.xsd") myDS.readxml("test.xml") I have 3 tables in my dataset. Is it possible to select easily data like with SQL ? ex. Select name from Table1 Where region = (Select num From Table2) .... T...more >>

Howdy folks: Long time listener...first time poster. My issue is that I am binding DB data to a datagrid using the <%# Container.DataItem("FOO") %> methodology. So my question is this...if FOO is empty, how can I substitute it out and replace it with something like "Not Entered"? Yes, I...more >>

I have been trying to determine the fastest way to implement database paging for an Access database with an ASP.NET front-end. I have a difficult database because the user can change the sorting and the fields are not unique, which excludes the "Select TOP" approach. Also the database has ...more >>

I'm using a OleDbDataAdapter to partially fill a dataset: Overloads Public Function Fill(DataSet, Integer, Integer, String) As Integer Everything works, but the function only return the records filled. Is there any way to get the total record count, without another command? ...more >>

I'm trying to use a batch SQL statement with an OleDbDataReader and the NextResult method. I tried: "SELECT Pages FROM Documents ; SELECT Date FROM Orders;" However, I get the error: "Characters found after end of SQL statement. " If I try removing the semicolon I get "Syntax Error in Query ...more >>

Hi, I thought it isn't possible to use a SqlDataAdapter and a Databound grid when there isn't a 'real' primary key on the table. Although, is there a way to use it, and define somewhere in the SqlDataAdapter my own primary key on the table? I can't add a primary key to the table, so I guess...more >>

I am trying to load data from a flatfile into a dataset, but I get the following errror: "Couldn't connect: Format of the initialization string does not conform to specification starting at index 170." What am I doing wrong? --gloria -------------------------- schema.ini: [861D_NI_0308...more >>

Hi all, I have a timeout problem when retrieving data from my DB in a C# program. Everything is OK at design time : I can generate a Dataset and populate it with its data. Important note : the View1 is based on a UserDefined function returning a table variable, it takes 54 seconds to retr...more >>

I have a DataTable with duplicates in a column. I would like to display only this column in a DataView, but remove any duplicates that exist. How can I do that? Thanks. ...more >>

I have the following lines of VB.Net code. Its works if the HDR property is set to "No" but changing it to "Yes" generates the error "No Value Given For One OR More required Parameters". What am I missing? Dim sInsert, sSelect, sConn, sFile As String sFile = txtFileName.Text....more >>

I've been looking into adding transaction capabilities into my object model framework. I always understood that, with SQL Server, a transaction could only cover one database, regardless of whether the transaction was done in a stored procedure or ADO ('classic ADO' or ADO.Net). But when I starte...more >>

In my first post I tried to explain that I want to make a combobox column in a datagrid. But without having to buy a reference from a company I'm stuck! Did it make it a bit clearer? thanks! Posted Via Usenet.com Premium Usenet Newsgroup Services ----------------------------------------...more >>

I would like to insert a new column in DataTable at a specified position, is it possible and how ? Thanks...more >>