Database Persistance
(4 messages)
Date: Mon, 23 Jul 2007 08:55:59 -0700
Hi
I'm not sure whether I've given this post the correct title, but I'm a
bit unsure of where to put it.
I have a database that holds information about several of our users.
This database is stored on a central server ...
|
Detach database from SQL Server
(5 messages)
Date: Mon, 23 Jul 2007 08:02:03 -0700
Hello,
When I have closed my appliciation in VB.NET, and I try to detach my
database from SQL SERVER, I often get a message that the database cannot be
detachted, because it is still in use.
So I think there is some ...
|
delete row from dataGridView problem
(1 messages)
Date: Mon, 23 Jul 2007 06:02:21 -0700
Hi All,
I have been failing to delete a row from dataGridView.
I use typed dataset.
Here is my code, please advice what wrong is here?
private void MainForm_Load(object sender, EventArgs e)
{
// TODO: This line of code ...
|
ExecuteNonQuery within the loop of a datareader
(5 messages)
Date: Mon, 23 Jul 2007 03:54:26 -0700
Hello,
How can I use an ExecuteNonQuery within the loop of a datareader?
My code is as follows:
Dim cmdToProcess As New SqlClient.SqlCommand
Dim rdToProcess As SqlClient.SqlDataReader
With cmdToProcess
.CommandText ...
|
Console and Files
(1 messages)
Date: Fri, 20 Jul 2007 16:17:34 -0700
How come line 1 will output garbage to the screen, but line 2 will output a
good number to a file?
How can I make line 1 out put a good number to the screen
String* dayStr = System::DateTime::Now ...
|
encrypt/decrypt function in asp.net 2
(3 messages)
Date: Fri, 20 Jul 2007 15:08:01 -0700
i am looking for code sampe in aso.net 2 for encrypt/decrypt
of paswr d withought using any external DLL (judt to use existing net2 tools)
thnaks i nadvance
peleg
...
|
ꪱlinepkk
(1 messages)
Date: Fri, 20 Jul 2007 03:53:43 -0700
...
|
SqlDependency.Start - Getting intermittent KeyNotFoundException
(1 messages)
Date: Thu, 19 Jul 2007 16:32:03 -0700
I'm working heavily with query notifications in SQL Server 2005 and I
intermittently get the following exception:
System.Collections.Generic.KeyNotFoundException: The given key was not
present in the dictionary.
No ...
|
Internal .Net Framework Data Provider error 6.
(3 messages)
Date: Thu, 19 Jul 2007 10:04:31 -0700
Hi
I'm getting very occasional exceptions in an application when trying
to open a SQLConnection. Does anyone know what this error means, or
what I can do about it? The error has only occurred a couple of times,
each time ...
|
Problem in datagrid paging and checkbox
(1 messages)
Date: Thu, 19 Jul 2007 02:15:40 -0700
Hi All,
I have one issue in using the datagrid in the asp.Net. I
have the checkbox column in the datagrid. And also having the paging
option.I have selected two items in the page 1 and navigate to page
2.And i ...
|
|
BackgroundWorkers and ADO.Net
(2 messages)
Date: Thu, 19 Jul 2007 02:27:54 -0400
I have an app that allows the user to build a query and then click on a
button to execute the query and the results are then used to fill a grid.
Can I have the retrieval run in a backgroundworker and have a button that ...
|
Automatic filling fields
(2 messages)
Date: Thu, 19 Jul 2007 02:29:33 GMT
Hi guys,
could you please help me on my problem.
>>>> --------------- <<<<<<<<<
Datasource: MS Access 2003
Table1: Tbl_Employee
Field1: Emp_name
Field2: Position
...
|
ObjectDataSource a little help
(2 messages)
Date: Wed, 18 Jul 2007 14:50:02 -0700
I have something that works, but it only returns one row of data when i
create an ObjectDataSource with it and bind it to a gridview so i need a
little help with this (thanks)
as simple as it gets
1. my class:
Imports ...
|
combining datasets
(2 messages)
Date: Wed, 18 Jul 2007 13:33:17 -0700
Hi,
I have 2 datasets right now, say with the following structure:
DataSet 1 has a row called ItemCode, index 1
DataSet 2 has a row called ItemCode, index 1
both are similar, but i need to merge them to make one dataset ...
|
DataAdapter with Parameter problem
(2 messages)
Date: Wed, 18 Jul 2007 19:32:14 +0100
When I run the following code everything works fine (which proves the stored procedure and the parameter:
Dim cmdSQL As New SqlCommand
cmdSQL.CommandType = CommandType.StoredProcedure
cmdSQL.CommandText ...
|
Question about TransactionScope
(6 messages)
Date: Wed, 18 Jul 2007 14:10:49 -0400
Hi,
Does TransactionScope need DTC in situations that the transaction is not
distributed?
I have a set of non-distributed transactions and I am not sure that
TransactionScope is the best option for best practice perspective ...
|
Strongly Typed DataSet -> Preview Data -> How to preview stored procedures with GUID parameter?
(5 messages)
Date: Wed, 18 Jul 2007 11:50:06 -0400
Hi,
In Strongly typed datasets, when we preview a table adapter query, we cannot
preview a stored procedure query that has GUID parameter.
The error complains that cannot convert a string to GUID.
What is the proper ...
|
Typed DataSets ADO.NET 2.0
(2 messages)
Date: Wed, 18 Jul 2007 07:33:38 -0700
For a project I have a typed dataset created ( by dragging tables/
views and configuring the appropriate queries ).
If the database schema for these tables is changed (e.g. few columns
get added), is it possible to automatically ...
|
Check user input data exist in database: ERROR
(1 messages)
Date: Tue, 17 Jul 2007 17:01:23 -0400
Dim retVal As Boolean = False
Dim cnSQL As SqlConnection
Dim cmSQL As SqlCommand
Dim strSQL As String
strSQL = "Select * From Table_Contacts where EmailAddress = '" &
txtEmail ...
|
Help with this Argument 'Prompt' cannot be converted to type 'Stri
(1 messages)
Date: Tue, 17 Jul 2007 13:08:02 -0700
Hi;
I am creating a windows app using ado.net 2.0 in the app I am connecting to
a database by creating and then using a data provider factory.
When I call sqlConn.Open() I get the follwoing message "Argument 'Prompt ...
|
