all groups > dotnet ado.net > july 2007 > threads for july 29 - 31, 2007
Filter by week: 1 2 3 4 5
How to contruct a ConnectionString to connect to dataset?
Posted by jzdeng NO[at]SPAM gmail.com at 7/31/2007 3:37:34 PM
Hi,
We have bunch of DataObejcts/BusinessObjects those used against
database. Now we fetch some data from database into a dataset. How can
we contruct a ConnectionString to connect to this dataset so we can
use those DataObejcts/BusinessObjects?
Thanks
... more >>
LINQ to SQL: Opposite of SubmitChanges()
Posted by Ralf Ehlert at 7/31/2007 1:34:03 AM
I'm working with the new Beta 2 of VS2008 and LINQ is really great but i'm
searching for an opposite construct of the SubmitChanges() method to discard
changes. Background:
I have a form for editing a single data row and only if the user clicks the
OK button the changes are saved into the DB.... more >>
Update and Select in the same statement?
Posted by Terry Olsen at 7/30/2007 8:36:08 PM
Is there any way to select a record and update a field in that record in the
same statement? I have a table that several threads will be querying. Once
the record has been selected by a thread, I don't want that record to be
selected by any of the other threads. So my thought was to have a "bu... more >>
Typed Dataset: Add expression-based column?
Posted by benji at 7/30/2007 1:26:04 PM
Hi, I'm creating a typed dataset based off of a SQL Server 2005 DB. There are
2 fields from one table that I'd like to bind to on an ASP.NET dropdownlist.
Since I can't specify two fields in the "Datatextfield" proprety of the
control, I'm trying to create an expression-based column. One thing... more >>
Datatable Update method not updating
Posted by Flomo Togba Kwele at 7/30/2007 1:08:26 PM
I have a dataset containing a datatable. Everything was working OK. Then I changed the definition
of one of the columns from not null to nullable. Now when I update the adapter, the change is not
being written to the DB.
Just before the update, I looked at the data in the datatable by walking t... more >>
what's the best approach to follow for sql execute
Posted by Ganesh at 7/29/2007 12:31:14 PM
Hi There,
What's the better way to follow when we use sql
string sql = "Inset into table(f1,f2) values (@f1, @f2)";
then add and passing parameters or in the first place itselef assign the
values to the string
string sql = "Inset into table(f1,f2) values (" + tbName.text + ", " +
tbCity.... more >>
Change connectionstring Typed dataset
Posted by Luc at 7/29/2007 3:38:02 AM
Hi,
I've noticed that if I change my connectionstring in the app.config file,
this isn't enough, a second change in the Global.System.Configuration is
necesary!!!
This means that after deployment and if the SQL server is changed, changing
the code is necesary, ..............?.??
can I... more >>
|