Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008


all groups > dotnet ado.net > september 2007 > threads for september 22 - 28, 2007

Filter by week: 1 2 3 4 5

Question about connecting client programs to Sql server 2005 running on local area network
Posted by ali at 9/28/2007 7:19:12 PM
I have a program that has hand written database connections and DataGridView that connects to my database on sql server using computer's name .this works fine locally BUT problem occures when running my app on local area network causes this exception " Application attempted to perform an ope...more >>

Filtering DataSets for Reporting Application
Posted by Need2CSharp at 9/28/2007 6:17:03 PM
Hi All, I'm working on reporting (web) application for my company that displays order information. It has approximately 15 - 20 different filter options so that various departments can extract data they need to view. I'm using a normalized, relational MSSQL 2005 database, which contains 37 ...more >>

Strongly typed dataset problem in a mobile form
Posted by Tony Staker at 9/28/2007 4:13:35 PM
I'm new to mobile app development so I'm going through Glen Gordon's on-demand webcast series "Mobile Web Development with ASP.Net 2.0" Using VS2005 I created a mobile app, a connection to Northwind and a dataset named "Orders". Then in a button click code block: dim ta as new OrdersTable...more >>

Easy Question - Oracle Ref Cursors
Posted by Knickerless Parsons at 9/28/2007 12:25:27 PM
Afternoon all, Just after confirmation that I can read from an oracle ref_cursor using the Microsoft data connector supplied with Visual Studio 2005 rather that having to get oracles latest ODP offering. Reading other posts here it seems to imply I can but I just need someone to tell me strai...more >>

How to run multiple SQL Scripts from VB.net (Application_Start method in Global.asax)
Posted by gamesforums NO[at]SPAM hotmail.com at 9/28/2007 9:23:34 AM
Hi Everyone! I work in a company that has developed several VB.Net Web applications. Currently we use SourceGear's Vault for source control and versioning for the application files. One area that have been left behind a little bit is the version control on database level. Our typical installa...more >>

Accessing legacy data for a web application
Posted by JL at 9/28/2007 7:59:10 AM
Not sure where to post this, so will start here... I am developing an web application that my company will host. The data back end on the web wil be SQL server. For each customer that subscribes to our product, I need to build a data bridge from their in-house legacy data to our SQL server. I ...more >>

update dataset
Posted by antonello at 9/28/2007 5:20:00 AM
Hi to all, I've a sqlserver 2005 database and an application developed with vb.net 2005. To manage data I used typed datasets created by the wizard. Now I need to change the data type of a db field from interger to floating. When I change the data type the dataset is not updated and I' m not abl...more >>

Show data from a SqlConnection and a OleDbConnection in one table
Posted by Torben Laursen at 9/28/2007 12:00:00 AM
Hi I have some data in a access database and some in a sqldatabase. Both us the same index. I can connect to both and display the results. However now I would like to pick 2 columns from each and show the 4 columns in one table. Can anyone show me how to do that? Thanks Torben ...more >>



Best way to handle multi field queries
Posted by Bill Gower at 9/27/2007 6:10:27 PM
I am currently reevaluating how I do look ups and searches. What is the best method for handling forms where user can search by different criteria. Example, A member form allows users to look up a member by either SSN, Lastname + firstname (whole or partial), all active or inactive or by an ...more >>

Detecting BindingSource "row deleted" event
Posted by Tomasz J at 9/27/2007 3:50:40 PM
Hello Developers, I have a DataGridView and BindingNavigator controls bound to a BindingSource control. User can delete a record using different methods: by pressing the DEL key, pressing BindingNavigator Delete button. I may also want to add some other methods calling BindingSource.Remove...more >>

Maybe dumb questions, but what is DataDirectory?
Posted by bz at 9/27/2007 2:17:45 PM
Hi, I developed several NET applications with SQL server and Access databases, and I feel really stupid asking this question, but everytime I used SQL database name in connection strings or I used a connection string with placeholders for Access databases, and I constructed the real path to M...more >>

example of Inserting and Retrieving data from xml file
Posted by hanusoft at 9/27/2007 12:49:31 PM
This is an example of Inserting and Retrieving data from xml file. http://www.hanusoftware.com private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here if(!IsPostBack) { BindGrid(); } } private void BindG...more >>

How to access an SQL function via .NET DataAdapter?
Posted by Dick Swager at 9/26/2007 7:19:35 PM
Is there a way to use a DataAdapter to retrieve data via an SQL function? I have done what I need to do using a stored procedure that returns a 1x1 table, but it seems like it would be much cleaner if the single value returned by a function could be obtained. Maybe there is some mechanism ...more >>

DataContract question
Posted by WebBuilder451 at 9/26/2007 8:30:35 AM
I do not really understand this concept if it is a concept. I've heard of it in relation to MCF, but it seems that it is refered to as if it is more of a concept. Can any one explain what a DataContract is or where i can find a definition, not just and example of where it is used? Thank You...more >>

sqlbulkcopy and total rows inserted.
Posted by Archana at 9/26/2007 8:10:16 AM
Hi all, i am using sqlbulkcopy to insert content to table, how will i get total rows inserted into table without using any eventing. and is it possible to do bulk copy from sql table to csv file? thanks in advance. ...more >>

Enterprise Library 3.1 Data Access Application Block Connection St
Posted by Patrick at 9/26/2007 5:00:03 AM
Using .NET 2 with the above. Instead of doing Database myDB= DatabaseFactory.CreateDatabase("myDBNameDefinedInConfigFile"); to connect to an Oracle 10g database How can I programatically set the UserID and password (which I take from the User Interface) at run time?...more >>

Jet database engine could not find the object 'Expr...'
Posted by Orgil at 9/26/2007 1:54:56 AM
I have been connecting to MS-Access database using Jet 4.0 from C#.NET. My application works finely on my computer on which I've made the application. But I observed a strange behavior. When I run my application on other computer that is installed .NET Framework, I get the following error "Sy...more >>

How to find the databases on a server
Posted by Dom at 9/25/2007 10:45:20 AM
I'm trying to write an all-purpose program that will: 1. list all the servers on the network. 2. list all the databases on any one server once it is clicked. 3. list all the tables in a database once it is clicked. 4. list all the columns in a table once it is clicked. The first step I ...more >>

SQL server vs mySQL ???
Posted by calderara at 9/25/2007 7:02:06 AM
Dear all, I am buidling application where most of my back end database is SQL server. Now I have a set of customer requesting for instance to use mySQL instead of SQL server. They are many programming language as many database product, so knowing them all is quite impossible. Its better t...more >>

do release builds have the same amount of info in exceptions? e.g. will exceptions cought in release builds contain stack trace etc.?
Posted by Daniel at 9/24/2007 4:00:07 PM
do release builds have the same amount of info in exceptions? e.g. will exceptions cought in release builds contain stack trace etc.? ...more >>

"'System.DBNull' is a 'type', which is not valid in the given context" - aka what type is DataRow column?
Posted by mark4asp at 9/24/2007 8:00:08 AM
'System.DBNull' is a 'type', which is not valid in the given context If dr["OfficeName"] is not an object then what is it? It is certainly not a string because it hasn't yet been cast as one. private void PopulateControls() { //If this is in AddMode then the table will be empty if (_d...more >>

Problem on INSERTING a record to database using typed datasets
Posted by Surya at 9/22/2007 12:40:05 AM
Dear All, I have problem on inserting a record to database..Although it looked easy.. i have caught up with following issue .. please go ahead and help me to find solution I Need to insert records to a data base,for which i am using Typed dataSet.(I used DataSet Designer to create one) Then ...more >>


DevelopmentNow Blog