|
Getting record count
Hi
I need to go through a resultset record by record. Currently I am using an
OleDbDataReader to achieve this. Is there a way to get the total record
count so I can notify users of the progress? If not via OleDbDataReader, is
there another way?
Thanks
Regards
...
|
5 |
12/31/2008 7:20:43 AM |
|
|
Could ADO.net export DBF?
Dear All,
I am wondering can ADO.Net export/convert to (Foxpro)DBF?
Regards,
Antony...
|
4 |
12/31/2008 2:10:00 AM |
|
|
Iteration of Large Result Set
Summary:
Large Table + DataReader Iteration = Slow
Large Table + Cursor Iteration = Fast
Details:
I am working on a windows app that is connecting to a MS SQL server db.
It is not designed for user interaction of any kind … it just has alot of
Reading to do (no updates) and wants to get it done quickly.
I’d like to be able to use a solution that’d work all the way back to
...
|
8 |
12/31/2008 1:56:01 AM |
|
|
UpdateAll does respect UpdateStatus.SkipCurrentRow
Setting UpdateStatus.SkipCurrentRow during OnRowUpdated works when you use a
TableAdapter directly but not when you use TableAdapterManager. Eventhough
the event is called, the TableAdapterManager seems to ignore the setting and
it goes on to set the row "Unchanged." Anybody have any thoughts? I can't
seem to find an answer for this.
P.S.
This breaks the common workaround used to merge...
|
1 |
12/31/2008 12:49:24 AM |
|
|
Is LINQ to SQL Dead? And what is EF giving us
I came across this article at :
http://redmondmag.com/news/article.asp?editorialsid=10472
and also TIm's blog at:
http://blogs.msdn.com/adonet/archive/2008/10/29/update-on-linq-to-sql-and-linq-to-entities-roadmap.aspx
"If Microsoft is serious about Entity Framework being the preferred
data-access solution in .NET 4.0," They'll have to do a few things: Make EF
2.0 rock-solid.
Can you e...
|
1 |
12/30/2008 11:51:01 PM |
|
|
LINQ Videos
I have downloaded LINQ Video tutorials CS code version from MSDN learning
link: http://msdn.microsoft.com/en-us/library/bb397906.aspx. The zipped file
for the download is Samplecode-LINQ-To-SQL-Video-Part03-Csharp.zip. I can get
the gridview to display the products but the sorting is not working. I get
the following error message for paging and sorting. Any suggestions will be
appreciate...
|
2 |
12/30/2008 10:10:58 AM |
|
|
Moving Data Sources Between Applications (VS2008 SP1)
I try to import a Data Source from one project to another. I followed the
instructions in the "Hitchhiker's Guide to Visual Studio and SQL Server (7th
edition)", p. 441:
1. Add the ConnectionString (with the same name as in the old project) to
the Application Settings
2. "Add existing item..." to the project, choose the .xsd file
3. Correct the references to the ConnectionString setting...
|
1 |
12/30/2008 8:57:25 AM |
|
|
Database access strategy
I've developed an app for our company using VB.NET (winforms) and SQL server
express running on our SBS server.
The app works really well within our LAN but I often work remotely and quite
often would benefit from using my custom app. I've tried the VPN but for
some reason my app just won't connect to the database.
What I'd like is some advise about how I can allow remote clients to a...
|
9 |
12/29/2008 5:48:21 PM |
|
|
EntityFramework
I have 2 tables associated through a 3rd table :
table1
ID - key
Value
table2
ID - key
Value
table3
ID1 - FK table1
ID2 - FK table2
Seq
Using the data model generated by the designer , how do I access
table2.Value :
using ( DBEntities dbe = new DBEntities() )
{
foreach ( Item1 t1item in dbe.Table1Items )
{
t1item .Table3Items.Load();...
|
4 |
12/29/2008 2:23:39 AM |
|
|
Sorts of all Kinds? Efficiency Question
Hi All,
I have a DataView being created using data from a stored procedure. The SP
itself is sorting the data in the SELECT statement being used.
A SqlDataAdapter is used to fill a table and then the DataView is created
and there is a "Sort" parameter available. Should this "Sort" parameter be
used or is the data brought in sorted as was defined in the stored
procedure?
I really n...
|
6 |
12/27/2008 8:23:32 PM |
|
|
GIDS 2009 .Net:: Save Big, Win Big, Learn Big: Act Before Dec 29 2008
-------------------------------------------------------------------
:::: Great Indian Developer Summit 2009 - GIDS .Net ::::
:::: 24 April 2009 ::::
:::: J N Tata Auditorium, IISc, Bangalore ::::
:::: http://www.developersummit.com ::::
-------------------------------------------------------------------
Dear Group members,
The economic downturn will run out of steam trying to outdo the 'r...
|
1 |
12/26/2008 5:02:48 AM |
|
|
System.Data & System.Data.SqlClient vs. DatabaseFactory.CreateDatabase ??
Hey All,
I was wondering if someone may be able to quickly enlighten me as to the
advantages of using the System.Data & System.Data.SqlClient namespaces as
opposed to the DatabaseFactory.
Anyone have preferences and why?
Thanks,
TC
...
|
5 |
12/23/2008 8:32:46 PM |
|
|
Keeping a DataView in Memory
Hi All,
What is the best way to keep a DataView in memory? I need to access it often
(using "Find" to get data from it repeatedly) and then process other data
based on what I pull from it. I'm thinking a class but I'm new to ADO.NET
and OOP (for the most part). I was also thinking this may give better
performance than repeated calls using a stored procedure.
I thought at first module...
|
13 |
12/23/2008 4:52:05 AM |
|
|
ADO.NET Data Services
How does security? We need to send UserName and Password, and you may need
to encrypt or sign.
Perhaps as a result of requests to work, for example, nulling fields to
which the customer has no rights?
How do the transaction? It is possible to have distributed transactions with
the WCF-services?
http://www.alvas.net - Audio tools for C# and VB.Net developers + Christmas
Gift
...
|
2 |
12/22/2008 7:35:37 PM |
|
|
Getting metadata - the matchink PK for a FK
Hi;
We need to get the matching table.column primary key for each foreign
key. What we are presently using, which is so very very slow is:
ver 8:
// get the constraint - if one exists
int id;
using (DbCommand cmd =
provider.CreateCommand())
{
cmd.Connection = conn;
cmd.CommandType =
CommandType.Text;
cmd.CommandText = "SELECT
sysobjects.id FROM sysob...
|
5 |
12/22/2008 5:02:13 PM |
|
|
Stored Procedure return values
Hi, I have a stored procedure that return 2 values (not 2 rows). Two
separate values. How can I read both of them from a Sql Command Object in
C#. When I execute the command and assign the results in a data reader I
have only one index at the data reader. Like the second value has never been
read.
What can I do?
...
|
4 |
12/22/2008 2:03:01 PM |
|
|
Help with trapping an error
Hello,
I have a dataset, with a datatable in it that contains a few Decimal
type columns. The table is accessed through a Binding source on my
form, and then a text box is connected to the binding source. I hope
my little diagram helps to clarify what I have (which I think is
common anyway)
Dataset --> Datatable --> BindingSource --> Textbox for numerical
field.
When the p...
|
1 |
12/22/2008 1:01:51 PM |
|
|
sqlcmd error
Each time I try to run sqlcmd, this is the error message I get:
HResult 0*2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0: A network related
or instance-specific error has occurred while established a connection to
SQL Server. Server is not found or not accessible. Check if instance name is
...
|
2 |
12/20/2008 8:50:28 PM |
|
|
Default Command Timeout Value in Framework
Does anyone know if you can change the default Command Timeout for
calling a stored procedure in the Framework (not on the command object
in code)? Is it a registry setting, overrideable on some framework
config file like the machine.config file, or is it a hard coded value
in the Framework.
I know I can include the command timeout for a dbcommand object and
override the default but I hav...
|
1 |
12/18/2008 1:21:28 PM |
|
|
BindingSource IndexOf question
I have having difficulty using the IndexOf method of a BindingSource
object. I am able to find the correct row by using "
this.isvgDevelopmentDataSet.individualTBL.FindByindividualID
(individualID)", and this binding source is set up for the
individualTBL, BUT the IndexOf method keeps returning -1 for not
finding the row object.
....
individualID = id;
int pos = this.individualTBL...
|
1 |
12/16/2008 11:04:27 PM |
|
|
Linq LoadOptions problem
Hi,
When I do:
DataClassesDataContext db = new DataClassesDataContext (connectionString);
//do some select, read data from result
var options = new DataLoadOptions();
options.LoadWith<User>(u => u.UserType);
db.LoadOptions = options; // exception
I have an exception:
"Setting load options is not allowed after results have been returned from a
query".
It ridiculous that...
|
1 |
12/16/2008 11:05:46 AM |
|
|
Sql Server Express won't let me connect
Hi;
Our program installs Sql Server Express 2005 using the Sql Server
Express bootstrapper as part of the install. This installs a bare
bones version of Sql Server Express - no Sql Server Management Studio.
When our code tries to connect using the Sql Server ADO.NET connector
we get:
An error has occured while establishing a connection to the server.
When connecting to SQL Server 2005...
|
9 |
12/15/2008 9:56:04 PM |
|
|
Javascript change from VS 2005 to VS 2008
When you move the mouse over a bar in this chart, the arrow cursor is
supposed to change into a hand cursor under certain conditions.
Those conditions are evaluated using client side javascript.
The key point here is that the javascript code ran correctly in VS 2005 and
..Net 2.0.
After upgrading to VS 2008 and .Net 3.5 the javascript runs differently!
For example, the variables for ...
|
2 |
12/15/2008 7:10:25 PM |
|
|
record binary to database
Suggest please why can not take binary data from a field base?
FileStream stream;
BinaryWriter writer;
long retval;
long startIndex = 0;
int bufferSize = 2000;
byte[] aBytes = new byte[bufferSize];
string Name = "";
using (SqlConnection cn = new
SqlConnection(this.ConnectionString))
...
|
2 |
12/15/2008 5:29:39 PM |
|
|
Can I XCopy SQL CE 3.5?
Its possible?
Which files I need to copy in the bin directory?
http://www.alvas.net - Audio tools for C# and VB.Net developers + Christmas
Gift
...
|
1 |
12/14/2008 8:38:57 AM |