Forgive me if I offend anyone's sensibilities, but if I was getting married to Katie Holmes (or anyone else), I wouldn't be bringing some dude along with me. http://www.xenu.net/archive/WIR/ "The bride and groom are believed to be honeymooning in the Maldives - joined by best man David Mis...more >>

I have Users table in my database which stores usernames, passwords and other information about users. When starting the application the user logs in providing username and password. This is why I want the connection string (including database username and password) to be stored somewhere i...more >>

Hi, I have problem with implementing strongly typed dataset (with tableadapter) as singleton (A very large amount of data loaded at startup of winforms app, I need this data at numbers of forms, and I need to bind this dataset/datatable at designtime) . At first I realized implementing datase...more >>

Hello, maybe I'm OT, but I don't know where else I can put this question. Say you have to write a program for a very small company (5 pc). They just need to store some data in a database which is on a server and they need to access this database from some other computers, with client applica...more >>

Good Day to all. I have a store procedure that makes many queries, use cursors and some other complicated calculations. If I run it on Management Studio it takes around 3 minutes and work fine. But when I run it from VB.Net it gives me connection Timeout after only 30 seconds. I have co...more >>

what will happend if SqlBulkCopy violate constraints. and how i can solve this problem....more >>

Hi all, I'm soon to overhaul my asp.net 2.0's backend data source. My plans: -To implement a data access layer -To move from access to SQL Server 2005. I'm going to be implementing just about every provider that microsoft ships for sql server (membership, profile, etc). In addition t...more >>

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -= my response to the harassment -= -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- My first reaction in 1990/91 was to assume that if I broke contact then they would not be able to follow and would lose interest. So I did the things that have been suggested by other p...more >>

A DateTimePicker control on my form is bound to a datetime field in a DataTable. When inserting a new record the default value for DateTimePicker is today's date. However, unless the user changes this date it is not saved to database (NULL is stored instead of today's date). Text fields are ...more >>

I'm building a program to navigate through a database. The user chooses either ODBC or OleDb and provides a connection string. With OleDb I can get the database names from the connection. Is there a way I can do this with an ODBC connection? Programs like DTM Data Editor can do it. But there ...more >>

-=-=-=-=-=-=-=-=-=-=-=-=- -= who knows about it? =- -=-=-=-=-=-=-=-=-=-=-=-=- Many people know, both in the establishment and media, and among the general public. Despite an absence of its target from the UK for more than two years, the echoes of paranoia can still be heard loud and clear fro...more >>

Is there a preferred way to obtain one row of data based on the PK? I can retrieve the record onto my C# app using a dataset or datareader, but then I have to loop thru this result set even though I know there will always be either zero or one row retrieved. Isn't there a more elegant way to...more >>

I want to prepare test data in SQLCE where the dataTables in the database are predefined. A VB.NET app I tried to use the DataSources facility in vs2005 IDE but cannot see how to input new datarows or edit existing rows. (The existing rows were from a migrated Access Data Base file.). The t...more >>

hello, am in a bit of a problem.. wonder if anyone can help? I got two tables one is tblOrders and the other is tblDeletedOrders I'm handling the UserDeletingRow to insert the deleted row (order) into the tblDeletedOrders to sort out some kind archive or log. I'm using this code which is ev...more >>

Hi everyone, I'm creating a ASP.NET 2.0 web application utilizing sql server 2000 as a database. My problem revolves around multiuser acces with long running processes. Some of the pages in the application have long running processes against large tables in the database, lets say that take 5...more >>

Hi, I would like to remove all the rows of a DataTable - but not by using a loop through all the DataRows - but by using a single command. I tried - dataTable.Clear() which is supposed to remove all rows of the dataTable - but it doesn't seem to work - the table is still full. Any idea? ...more >>

Hi, I have troubles with a threaded application on W2003 server. It seems to leave open connections behind time to time, it sums to hundreds over a day (the application make thousands). It is using the SQLOLEDB provider, MDAC 2.82.1830.0, SQL Server 8.00.2039 (SP4), Windows 5.2 (3790). I am ...more >>

This is driving me nuts! I've got a form that is giving me fits. I've done the same thing that I've done on dozens of other forms. When the data adaptor update command is executed I get the "Must declare scalar variable @p7CYCLEDAY" Here are various pieces of my code. Public daServObj ...more >>

I'm trying to move a row from one table to another. I get the error message that the row already belongs to another table even though I have removed it from the table. I'm trying to avoid recreating the row for performance reasons. DataTable dataTable1 = dataTable2.Clone(); dataTable1.Rows....more >>

hi all I want to do some modification in my xmldata in xmldata column . <root> <DateOfBirth>12/22/1988 </DateOfBirth> <Gender> 1 </Gender> <Country>Bolivia </Country> <moreDetails> <AreaId>524</AreaId> <City /> <State/> <country /> <Pincode /> </moreDetails> </r...more >>

Hi all, in my SQL Server 2005 database I've two tables linked by the classic relationship PrimaryKey->ForeignKey, I've added the clause "ON DELETE CASCADE" to the ForeignKey constraint, so when I delete a record in the parent table, SQL deletes for me the records in the child table. This t...more >>

Hello, I am learning .NET and I am interesting in programming database applications using web forms. Could you tell me please what kind of database applications are implemented in .NET technology? Thank you very much! /RAM/ ...more >>

A couple of questions regarding transaction processing. >From a windows application, does it make sense to use transaction management for SELECT statements? Does it make sense to use transaction management for a single UPDATE or INSERT statements? Thanks ...more >>

Hi, I have troubles with a threaded application on W2003 server. It seems to leave open connections behind time to time, it sums to hundreds over a day (the application make thousands). It is using the SQLOLEDB provider, MDAC 2.82.1830.0, SQL Server 8.00.2039 (SP4), Windows 5.2 (3790). I put...more >>

I would like to create a Table Adapter which can work with multiple tables. Ideally it would still work with the configuration wizard. I have tried to add a query which joins 2 tables, but then it does not create the insert, update and delete methods. Is there a way to do this? Can I do it ...more >>

Hi All, Hope someone can help me or guide me in the right direction. I will received random excel files from a user that I want to copy and rename as "backup of...". I then want to take the original file, delete it and create a new blank copy of the file with the same structure as the "back...more >>

Hi, We have the following scenario. the application works in a multi user environment. we have a screen opened by user1, which shows data from several tables. it fetches and populates the data as it is opened. Now, there is action done by user2, which inserts or updates the records in ...more >>

Hi,=20 We have a stored procedure, that returns the set of rows of companies... = Following is the query in it. Select=20 PMCompanyID AS [COMPANYID] , TC.NAME AS [COMPANYNAME] , TC.ShortName AS [SHORTNAME] =20 From=20 PM_Company AS PMC INNER JOIN T_Company TC ON PMC.NOMSCompan...more >>

Hello, I have a dataset with 2 DataTables : Groups and Persons. I make a relation between this 2 DataTables using one DataColumn in each datatable. Finally I use this dataset in a dataGrid. So I would like to have a display like : groupe1 groupe2 + (person1) + (person2) groupe3 Ev...more >>

Hi all, so I've my parent - child relationship, that works fine with select, insert and update. But I've some trouble with the delete, probably I'm missing something. My delete sub has theese stpes: 1) delete a row from the parent datatable 2) begin a transaction 3) cals the update metho...more >>

Hello *, in my VC++ program I use the following code to create a connection object: "m_sCreateString.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s.mdb;Persist Security Info=True;",m_sPfad);" // Connection Object erstellen hr = m_pConn.CreateInstance(__uuidof(Connection));" ...more >>

Hi There, I have a demo application which im trying to run which use`s a remote webservice. When i try and run the App its telling me i need to change the webconfig. Its saying i need proxy Authentification. Could anybody possibly point me in the right direct? Below is my webconfig. Many...more >>

I recently realized that I need IBM's iSeries Access installed to use Provider=IBMDA400.DataSource.1 in an OleDB connection string. Is there any .NET 2.0 class or dll that provides DB2 data access without any other software installs besides the .NET 2.0 Framework? Or, alternatively, can I pack...more >>

i saved the state of a data set and table via MyDs.WriteXmlSchema("MyDs.xsd") MyDs.WriteXml("MyDs.xml") i was able to read them back in and display the info in the database by MyDs.ReadXmlSchema("MyDs.xsd") MyDs.ReadXml("MyDs.xml") i put the 2 files into my project reso...more >>

Child Dataset { i int; j string; } Master Dataset { i int; j String; k float; } childDataset. rows = 10, masterDataset.rows = 20; i want to look that the child dataset is contained in the master dataset or not. Note that the schema of...more >>

Hi I have a table having Null values for some columns. When ever I read it through a data reader, like Convert.ToInt32(dr("Column")) I am getting some error. 1.How to handle this situation, especially with integer nulls 2.While updating a record, If I am not modifying some of these null v...more >>

I figured both would behave identical: myDataSet.Tables[0] and myDataSet.Tables["myTable"] What's the difference? ...more >>

can any one tell me how to tranfer data from and to sqlCE(.SDF) and SQLSERVER using SQLBULKCOPY...more >>

I am not able to connect to DBF files: I am getting this following error: DBF Driver Driver not found! java.sql.SQLException: No suitable driver I am using Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); and the code that I am using to connect is: String databaseURL = "jdbc:odbc:Driv...more >>

I am developing an ASP.NET website using VS2005. I am trying to access data from a remote sqlserver 2005 database, created and maintained by our inhouse dba. We are both fairly new to both of these products. When I drop a sqldatasource control on a page and begin the configuation wizard, ...more >>

I'm having a discussion with my team leader concerning the use of SqlTransactions. We work on an ASP.Net 1.1 website. Up until now we've been using SqlTransactions in our business logic layer to combine several data access layers method calls into one coherent, atomic action. My team leade...more >>

Hi Has the release version been issued yet or is the November ctp still the latest version? As I understood a version was due to be released in December but could not find it on the MS site. If so, what is the download url? Many thanks Julian ...more >>

Hey gang. I am just learning the SqlDependency class for the first time. I am really thankful for this class I believe. I thought I was going to have to do SQL CLR Trigger that called my WebService. Anyways, I am using the SqlDependency.OnChange event and its working great except that it...more >>

Hi all, In my project (VB.Net 2003) I've plenty tables linked each other via DataRelation, for example let's analyze this couple: Parent Table [Clienti] Child Table [Indirizzi] theese two tables exist in a SQL Server 2005 Database, and theese are their definitions: CREATE TABLE [dbo]....more >>

Hi all, What's the easiest way to retrieve a single value (post insert identity fetch) from an output clause in a stored procedure? For instance: @CREATE PROCEDURE sp_Insert @Var1 int @Var2 int AS INSERT INTO tbl1 (Fld1, Fld2) OUTPUT INSERTED.RecordID VALUES (@Var1, @Var2); I am ...more >>

Hi Newsgroup, I have a problem with the RowFilter. When I check my datatable in the debugger, I get the following result: table1.Rows.Count 3 table1.DefaultView.RowFilter "" table1.DefaultView.RowStateFilter Unchanged | Added | ModifiedCurrent table1.DefaultView.Count 0 table1.Rows[0].R...more >>

Hello, I use mixed mode in my SQL Server 2005 Express Edition. I added connection string to my web.config: <add name="MIMProjekty" connectionString="Data Source=.\SQLEXPRESS;AttachDBFileName=|DataDirectory|\MIMProjekty.mdf;Initial Catalog=MIMProjekty;uid=sa;pwd=sqlserver" providerN...more >>

I would like some feedback on the following code snippet. It is using the Data Access Application Block where db is a Database object. What I want to know is how I should be using the "using" statement to scope the use of the DbCommand. This technique should allow me to avoid disposing the va...more >>

Hello Everyone .......i created menu using Css and HTML code..but i want it to display submenu when mouse is over on the horizontal strip...but it's not working and either it show all the menu or not when the page is loaded......so what should i do? and seconde problem is that i want it to sho...more >>

Hi I have a stored proc that returns 2 record set (tables) i have 1 select that returns the error id and error message and 1 select for the data when i drop the stored procedure on the designer of the DataSet I only get a table for the first record set (table) i would like my typed d...more >>