Search results for query: *

True. And I believe (I haven't checked) you can modify that within the existing datatable or data adapter either after creation or during creation, or both, to your preference. Also on a windows forms apps they use the app config file for the conn string properties (exclusive or non-exclusive...

To all other readers... when someone states a similar statement like I have; It usually means a database that is controlled by the windows file system (something like SQLCE or equivalent) and not a local server (like SQL Server Express). I in no way intentionally implied that a desktop...

No... I think I am totally wrong in my original quest here and my goal is skewed too. I learned I should install a server and service on a laptop or individuals desktop computer to run a local application. Sigh...

Who said this was on a server? Read the above posts. How can a local desktop (file based) database (using windows file systems for locks etc.) handle 500 concurrent users? Are you suggesting that everyone should use a desktop database and use it to handle 500 concurrent users? Come on now...

When using exclusive mode the database doesn’t have to be so paranoid about other connections; other people updating some of the data that you are updating at the same time. This speeds up the processes considerably.

That depends. There are reasons when you need to use the exclusive read/write mode; and there are times when you want to use a single connection when in shared mode too. This happens to apply to a file based local database and not a server. Currently I have my connection as exclusive...

How do I create a DAL layer connection string that coincides with the default dataset/adapter connection object so that I can check to see if a connection is open by other private sub calls? I have parameter based inserts etc. on a few forms that create a new connection; but I would like to see...

All very good points. That was in a sense why I wanted to try and eliminate using datasets whenever possible. Querying data wasn't too expensive, but clearing and re-filling datasets got real expensive. Hope you guys are up on the Entity Framework... that's next :D And of course learning...

The silly thing that I am having a problem with when using the command syntax is assigning that value to a variable for running conditional checks etc. This is where things ground to a halt.

...conn.Open() Dim command As SqlServerCe.SqlCeCommand = New SqlServerCe.SqlCeCommand command.Connection = conn command.CommandText = "SELECT COUNT(*) FROM Table1" command.ExecuteScalar() Using datasets I would have to be aware of when to clear and refresh the dataset to be sure the data was...

I can retrieve a COUNT through a dataset and test it like this: Dim myvalue As Integer myvalue = Me.Dataset1.Tables("MyTableName").Rows(0)("MyColumnName") If myvalue = 0 Then Exit Sub Else DoSomethingElse End If How do I do this using the command structured syntax? Dim command As...

Hello, I would like to list items (both above and below) in *sequence* from the original item returned. Lets say I returned a document with the number of 8100; I want to be able to pull / get the nearest items to this document and list them in order... for instance: Item displayed: 8100...

I would like to retrieve data off of websites and do this programmatically using vb.net; how would I go about this? This is for a desktop app.

Hello, What I am thinking about doing is to copy the file selected in the OpenFileDialog form and then use that object to save when I open the SaveFileDialog form and rename it (the same file is saved under a different name and directory). In the past I have used the...

Hello cjard... Originally I was 'learning' how to work with or create subqueries in a SQL statement and I really got locked in on the 'visual' part of it and totally forgot about the manual side of it.:o The other thing I realized is that I can assign a dataset (originally just basically...

Oh yes... That was too good... Do you know how long I have been going through that darn designer and trying to get everything to fly... with custom (sub query) statements? Oh my...

???? this may get moved again, but here we go.........sigh.... I have a custom sql query that I would like to bind my datagrid too. In the past I have just used basically simple table objects (joins etc.) to create datasets to bind to my datagrids etc (going through the dataset designer). Now...

...I wanted was to process the query and return the results. Maybe the question should have been how do I bind a datagrid to a custom query? ---- ***Just a note*** It took me awhile to find this post and *where* someone put this. I really don't think this is the appropriate forum since we are...

...- Varchar(50) ---------- The SQL statement is: SELECT StudentName, TotalCorrect, TotalQuestions, CAST(([TotalCorrect])/([TotalQuestions])*100 as numeric(5,2)) AS PercentValue FROM ( SELECT Students.StudentName, CAST(COUNT(Students.StudentName) AS numeric(5, 2)) AS TotalCorrect...

Many thanks cjard... Glad your still hanging around here... Sorry... didn't see a SQL forum here... or a LINQ either... that one will be needed shortly.