Hi, Whats the best way of handling dates gathered from the OS (e.g. using DateTime.Now or SqlDateTime) and using it in a SQL query? I want to create a culture neutral string so that a SQL server will process the date no matter of the language or database settings. Overloading DateTime.T...more >>

Hey guys, Came across this issue a few days ago and it has taken me a long time (and a lot of frustration) to track down. I am working on a mission critical application which must continue to execute when a connection to the database server is lost (for any reason). While performing some ...more >>

I have used VS 2005 Beta2 to create a strongly typed DataSet. Using the DataSet designer, I have created 3 table adapters to select and retrieve rows from those tables, which works very well. Two of the tables have a one to many relationship with the third table, and now I need to perform my ...more >>

I'm splitting a csv file into records and then into string fields. Then I load the string fields into a new DataRow using ItemArray property. I set the DefaultValue of the fields to the approprate type. This part is very fast but then I have to load the columns based on the datatype and convert...more >>

Hi, i've a little program in VB .NET that run fine in several desktop, but i have others that don't work and get this exception, when execute a Open() in a OleDBConnection to Access MDB. The desktop have installed several version of MDAC: 7 sp1, 8, 8 sp1... I don't find info about this error. ...more >>

I have to build dozens of simple data-entry forms in just a couple of days, and while I'm looking for a 3rd party tool that will help me do this, I tried the Data Form Wizard in Visual Studio, which builds a persistent dataset object based on a chosen table or view, and produces some basic code-...more >>

can any one tell me where the "Object Reference Not Set to an Instance of An Object" error is coming from in the code below? the procedure before logs on w/ no problem. i cant figure out which ref to which obj is getting lost. thanks for any help. ps. i ripped this code right out of another worki...more >>

hi, I have developed a webserice which returns a datatable datatype, so at the client end ..should i install dot net framework on the machine for the webserice to work properly? Thanks manas ...more >>

We are experiencing a weird problem where a call to a stored proc using native SqlClient connection class in a VB.Net app fails on one machine when processing a large set of data (23,000 rows) BUT will always work on another PC. We checked patching and both are (now) running SQL Server SP3a an...more >>

SQL: select * from A LEFT JOIN B using (seq) (forget about the "using", it's Oracle 10g) DataSet (ds) filled by DataAdapter (adp) with MissingSchemaAction.AddWithKey (it seems AddWithKey doesn't work with joins). DataAdapter.InsertCommand is defined by hand. I issue a BindContext....more >>

¤p§Ì¦b¨Ï¥ÎAsp.net «Ø¥ß¨Ï¥ÎªÌ®Éµo¥Í¿ù»~ ¨Ï¥ÎAsp.net «Ø¥ß¨Ï¥ÎªÌ¿ù»~ ¿ù»~ªº¤@¦æ¬° newuser.setinfo ¨ä¤¤newuser ¬°¤@net ºô°ì¨Ï¥ÎªÌ newuser=getobject("WinNT://MyNtDomain/myUser"); ¤p§Ì¨Ï¥ÎIIS6 , ¬O¤£¬O¦]¬°NETWORK SERVICE ³o­Ó±b¸¹ªºÅv­­µLªk·s¼W±b¸¹©Ò­P©O? ------------------------------------...more >>

In my VB.NET 2003 Winforms app I fill a typed dataset with 1 record from SQL Server. I'm not using databinding on my form, so I want to programatically change values in the dataset with values from textboxes and listboxes, then update the SQL Server table with the changed dataset. I've suce...more >>

I have an SP that is called on every page load for our web application (asp.net). The SP is basically like this: SELECT * FROM Messages WHERE StartDate < GETDATE() and EndDate > GETDATE() Messages has like 15 rows in it, so this is NOT a slow SP. This SP normally executes in like 1/10...more >>

All, I have written a sharepoint webpart and sharepoint requires impersonate = true in the web.config, but I want to connect to the DB as the id of the application pool. If I run RevertToSelf before the .Open, then reimpersonate the user that is making the http request, this works, but I...more >>

I would like to know why I can use ADO (ADODB record set) running in vb.net to insert records into an MS Access database 5-6 times faster than I can using ADO.net. We may be inserting tens of thousands of records at a time and performance becomes an issue. Let me also say I am required to ...more >>

I could use some help regarding transactions. I am using the System.Data.SqlClient namespace to work with a SQL Server 2000 database. In the database I have 2 tables that are related to one another. One table holds a facility (a location), and the other holds a list of programs (services) that...more >>

Hi Guys I created a DataRow, that automatically sets its primary key. Let us say 3. I then added the DataRow to the DataSet and then update the DataSet using GetChanges() and finally Merge(). The primary key in the Microsoft SQL DB is set to 23 and consequently the PK in the dataset's ...more >>

Hi, Today we had a thunder storm with lightening/torrental rain the works the process of which seemed to screw up my 4-port network hub. At the time I was testing my Windows app which uses a SQL Server database, I changed something in the UI that required DB access and since by hub had gone...more >>

I am reposting this via MSDN support to get support from MS, sorry for the repost. All, I have written a sharepoint webpart and sharepoint requires impersonate = true in the web.config, but I want to connect to the DB as the id of the application pool. If I run RevertToSelf before the ....more >>

In my application I fill a DataGrid with data from a TypedDataset base on a users Search Pattern. The first time I execute the Fill it throws an ConstraintException, which is expected. This allows the grid to flag the rows that have errors. When the user enters a new Search Pattern I exec...more >>

I have a data grid that keeps changes on a post back but does not persist the changes to the underlying database. I dropped a sqlconnection and sqldataadpater control at design time on to an ASP.NET page. Here is my code: Try dataAdapter.Update(dataSet, "table") Catch ex as sqlExcepti...more >>

I am including a reference to ADOX in a C# project by doing the following: In Solution Explorer, right-click the References node and select Add Reference. On the COM tab, select Microsoft ADO Ext. 2.7 for DDL and Security, click Select to add it to the Selected Components, and then click OK. ...more >>

Hi everyone, I'm trying to use a select command as the CommandText of an ADO.NET SQLCommand object (I'm using SQL Server as the database). From the Query Analyzer I can run the query and get the correct result, but in my program, the command using this query returns no rows. My code l...more >>

I'm splitting a csv file into records and then into string fields. Then I load the string fields into a new DataRow using ItemArray property. I set the DefaultValue of the fields to the approprate type. This part is very fast but then I have to load the columns based on the datatype and conv...more >>

Hi guys, I am not too sure if I understand the connection pooling or not. But I am implementing an application where in one page I open connections a few times each time I close connection properly. My question is thanks to the connection pooling the first opened connection will stay in th...more >>

I have a form with 2 tabs. 1 tab contains a data entry screen and the second tab contains a datagrid with a listing of the entered data. I fill the datagrid when I load the form. I want to requiry or refill the datagrid when the tab is made active. Is there a refill command for the dataset...more >>

Hello, Does anyone know how to create a SQL table from an XML schema programmatically? I have an xml dataset that needs to update the SQL structure. I have no problem going from SQL to XML. But what if I want to go the other way? Thanks, Dolph ...more >>

First of all, thanks for the help on my previous VB.NET/MS Access questions. This time I need do the following 1. Connect to a table 2. step through each of its records 3. read the value of two of the records fields 4. pass those values to a function 5. write the value returned by the funct...more >>

Hi All, I often get the same error when filling data adapter. There is already an open DataReader associated with this Connection which must be closed first myda.Fill(newds, "Employee") But the same type fill command is working in other forms without error. When filling data adapter it ...more >>

Hello folks This seems relatively quite easy but I cannot put my finger to it. I have a form with 5 tabs. I also have a dataset with 5 tables, (1 parent with 4 child). I have a data View of the dataset which is bound to the form. So my form has a listview, with first name & last name (i...more >>

hi, i have a problem , I have a database which inserts bulk of data onto the sql and oracle database from excel sheets , I was juss planning to create threadpools and activate multiple threads to insert data onto the database from the excel. i am thinking of creating a XML sheet for which ...more >>

I have wrote this code and my DB server is Sql Server 2000 SP4 Dim cnSql as new SqlClient.SqlConnection Dim cmdSql As New SqlClient.SqlCommand cnsql="Data Source=ced2; User ID=sa; Password=;Initial Catalog=NGN;Persist Security Info=True;" cnsql.open cmdSql.CommandText = "create view V...more >>

I can't find any answers, I have no idea why this is happening. I have a dataset. In this dataset there are three tables RO ROParts, ROLabor ROParts and ROLabor are related to the RO table one to many relationship PKEY on RO is the RO#, ROLOC, RODATE these three fields are replica...more >>

Can anyone help me out from the above by giving a code snippnet including the import namespace directives. Regards/CS...more >>

I written myself some small generic class to export any dataset to an excel spreadsheet: public static void Export(DataSet data, String excelFileName) { System.IO.File.Delete(excelFileName); string strConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.IO.Path...more >>

Hi, I know that I'm an extreme newb by asking this overly beaten question, but I am leaning toward C#, becuase the perception is that it is better to learn than VB.Net. I guess it makes you cooler.:-) Anyhow, I am a novice programmer, and I will remain one as well...I have no plans to ...more >>

I want to store the result sets for the 10 drop-down list boxes in a DataSet object. How I can do it?...more >>

I can look at performance monitor for pools, pooled connections etc. What I don't see is a way to tell, say, of the 25 pooled connections in the pool, how many are active and open. Anyone know of any tools for this? Any ideas? Anyone ... ...more >>

Hello - I've developed an application which uses DataSets which are local to specific methods - so they should go out of scope when the form they are on is closed. I am finding that while monitoring the memory usage through task manager, the memory will increase while the dataset is fille...more >>

Hello, I am new to ADO.NET and SQL. What I am trying to do is very basic - to insert some variable values into database. The following is the C# code: private static void InsertIntoSqlDb(OleDbDataReader reader) { string insStr = ""; string list_no = reader.GetString(0)...more >>

I am using C#, SQL Server 2000 and ADO.NET in my application. The Database Server and the application are running on seperate physical machines. If the database server and the application lose connection (possibly because the server was restarted, or a network failure of some sort) the app...more >>

All, Using C# with ADO.NET I am trying to save a date time to an Access database. After the saving occurs I open Access database and only see the date not the time. I know the time was part of the DateTime object prior to saving it. Also while in Access I tried changing the format of the da...more >>

I am having some problems with getting squgglie lines under stringbuilder and ConfigurationSettings what am I doing wrong, is this even close to working? help. ------------------------------------------------------------------------------------ Imports System Imports System.Data Impor...more >>

I have the following error message and I can't see where in code it could of came from or what could of caused it. It happened randomly for one of our users and no one else ever, and I am unable to reproduce it at all. System.Data.DBConcurrencyException: Concurrency violation: the UpdateComma...more >>

I recieved the following error pretty much randomly (haven't been able to reproduce it or see what caused it in code at all) ...more >>

http://weblogs.sqlteam.com/jeffs/articles/5091.aspx provided an excellent insight for pivioting DataSet. As things stand, the example could happily pivot Something SQLServer returns as: frmInstanceID frmName Department Status 1 formA IT Com...more >>

i face prob. of connection pooling, i want to know how to clear the pool size in ado.net, i know that there is a facility in ado.net to clear the max pool size, Any one can give me the code about that. thanks. *** Sent via Developersdex http://www.developersdex.com ***...more >>

I have a problem about asp.net and databases in Access. Every time the asp service is blocked. When this happens i must phone to my ISP provider of hosting in order to begin the service again. The tell me it is a problem of access with asp.net. ¿How can i solution it? I detail below the connec...more >>

I'm using the SqlHelper object model from MDAAB, which requires that I pass in a SqlParameter object if I have more then parameter when calling a Stored Procedure. My current code seems verbose in the setup of this parameter and I'm trying to figure out if there is a better approach to populat...more >>

Hi We have a asp.net web application with oracle 9.1. Data access layer we use is DAAB 2.0. We use connection pool and set max pool size = 150. But we always get the following error almost every month ( we have to restart web server to make it work): Timeout expired, The timeout period ela...more >>