Command builder question
Sun, 14 Mar 2010 01:36:49 -0000
Hi
I am using below code to automatically generate commands via command
builder.
QuerySt = "SELECT <fiedl list> FROM ..."
CompanyAdapter = New OleDbDataAdapter(QuerySt, LocalConn)
CompanyBuilder = New OleDbCommandBuilder(CompanyAdapter)
CompanyAdapter.Fill(CompanyTable)
Is there a way to take command b ...
|
Reusing Adapter/Command Builder without disposing
Thu, 11 Mar 2010 17:21:49 -0000
Hi
I am running below statement repeatedly with different SQL;
QuerySt = "SELECT * FROM ... "
CompanyAdapter = New OleDbDataAdapter(QuerySt, LocalConn)
CompanyBuilder = New OleDbCommandBuilder(CompanyAdapter)
Is there a way to avoid having to recreate the adapter and command builder
every time and reuse ...
|
2 DBs? is it possible?
Wed, 10 Mar 2010 22:33:44 -0300
Hi, the asp.net app have to communicate with MSSQL and IB DBs. Because IB is
ours desktop ERP/Delphi and MSSQL is web (aspnet).
IB is 3rd comp. .net driver we use on .net...
but the situation:
Open IB tran and MSSQL tran... After doing the operations, if the commit
fails on IB that is first executed, the ...
|
DBTYP.NET Studio 2010 - Database Comparison Suite Released
Wed, 10 Mar 2010 20:16:29 +0100
DBTYP.NET Studio 2010 - Database Comparison Suite Released
Vienna, Austria - March 8, 2010
Today, BYPsoft announced the availability of DBTYP.NET Studio 2010, the
newest version of the cross-database comparison tool that compares SQL
Server, MySQL and Oracle databases (schema and data). DBTYP.NET Studio 20 ...
|
.net logging option
Wed, 10 Mar 2010 02:48:06 -0000
Hi
Is there a library for logging errors in a .net app which can also email the
errors across?
Any recommendations would be appreciated.
Many Thanks
Regards
...
|
What is the best way to connect to a cube in SQL Sever 2008?
Tue, 9 Mar 2010 03:21:02 -0800
using system.data.oledbclient
using ADOMD.NET
in which case connection pooling is best acheived? ...
|
When two client run write to datab method i have server timeout
Sun, 7 Mar 2010 08:25:01 -0800
When two client (in same time) run write_to_db() method i have server
timeout exception.
I have few question:
1. Is transactscope good to resolve problem?
2. When i use transactscope SELECT IDENT_CURRENT('table1') return last
inserted indent for individual client?(two client on two separated station
run write_ ...
|
|
|
Get value of user control in business layer code
Fri, 5 Mar 2010 10:51:29 -0800 (PST)
We have a business layer which is compiled as a dll and used across
several linked websites. Some of the website pages have search panels
with a number of controls for the user to enter search criteria. When
he clicks a search button, the panel is submitted to the business
layer, which goes through the controls, ...
|
How can I cancel a long-running query from my code in a different
thread
Wed, 3 Mar 2010 13:42:36 -0800 (PST)
If I have a thread that running a long query, is it possible for a
different thread to cancel the query? I am using SQL Server and C#.
I have tried aborting the thread that is doing the query, and that
doesn't work. I have tried using a different thread to run a KILL
command on the SQL Server, and that is succ ...
|
æ€æ¯’软件å…费下载 9797
Sun, 28 Feb 2010 17:35:01 -0800
许å¤?æ?§è?½é?®é¢?å??æ?¨ç??计ç®?æ?ºå®?å?¨é? æ? æ¶æ?ç??æ¯?ï¼?æ??好ç??å??æ³?对ä»?ï¼?è¿?æ?¯è¦å®?è£? é?²ç??æ¯?确认å??æ?¨ç??计ç®?æ?ºä¸?æ?´æ?°
æ?æ¯?软件å?è´¹ä¸?è½½ï¼?
http://antivirusfreecn.blogspot.com/
é?¾æ?¥ç½?ç«?ç??å??容ï¼?
http://antivirusfreecn.blogspot.com/
http://antivirusfreecn.blogspot.co ...
|
