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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|