|
|
|
select from dataset
Replies (4) 9 May 2007
hi all. I have a dataset and would like to do something like "select
distinct field1, field2 from fields" against the dataset. I do not
have the option of creating a new database table and selecti...
|
|
|
|
|
Menu Nav control
Replies (1) 30 April 2007
Hi please help as I'm new to .net coding. I'm using MS Visual web Developer
2005. I've a Menu Nav control on my master page. I've also got a Label
control (lblTitle). All I want to do is upon page...
|
|
|
|
|
Can not define New Datatable from Dataset
Replies (1) 18 April 2007
I created a dataset from add item and called it dsRSS. Using the
tableadapter wizard I connected to a access database, selected all items from
a table nad names my
TableAdapter: tatblRSSStori...
|
|
|
|
|
C# database narrowing search
Replies (1) 12 April 2007
I would like to duplicate a function that PowerBuilder uses. Start searching
a field of a database as you type the data into a search textbox. For example
you search Last-Name of an employee tabl...
|
|
|
|
|
Bind the current page dataset to Objectdatasource
Replies (1) 9 April 2007
Hi,
I want to assign the current page dataset to the Objectdatasource. How can
i do that?
my code is:
DataSet dsProduct = new DataSet();
....... Data massage.....
...
|
|
|
|
|
Updating data with BindingSource
Replies (1) 3 April 2007
I have a WinForm app that uses a SQL Express database. I created the
database in the Server Explorer, and set up a table. I created a form, and
added a dataset, tableadapter, and a bindingsource...
|
|
|
|
|
wildcard '%' acting like wildcard '_' in .net aspx ...
Replies (1) 28 March 2007
short description:
i've got a .net web site set up using a tableadapter attached to a
sql
server table - returning results only, no update of data. i've got a
query (qry code below) set up to s...
|
|
|
|
|
How to refresh GridView
Replies (1) 27 March 2007
I’m using MS Visual Web Developer 2005 to create a webform against an Access
database using SqlDataSource’s.
I have a GridView that lists the records in a table. I created a DetailsView
tha...
|
|
|
|
|
BE-CAREFUL, YOU COULD BE A VICTIM OF SCAM OR FRAUD ...
Replies (1) 26 March 2007
Attention!
With several on-going cases of fraudulent practices being carried out by criminals on the internet, you are advised to carefully read this circular, so as to completely secure yourself ...
|
|
|
|
|
BE VERY CAREFUL, AS YOU MIGHT BE A VICTIM OF SCAM/ ...
Replies (1) 26 March 2007
P. O Box 1300,London SE1 1BD, United
Kingdom. Tel/Fax: + 44 700 593 1047
ANTI-SCAM DEPARTMENT.
SCAM ALERT!!
Attention!
With several on-going cases of fraudulent pra...
|
|
|
|
|
Installation of Custom Dataprovider to server expl ...
Replies (1) 22 March 2007
We have a custom developed data provider for VS 2005. It works fine in XP
and Vista 32. It fails to install under Vista 64.
We have the GUIDS for installation under XP and Vista 32, but I canno...
|
|
|
|
|
Refresh GridView after DetailsView update
Replies (1) 19 March 2007
I’m using MS Visual Web Developer 2005.
Created a GridView with Enable Selection to list all records in the table.
The DetailsView’s SqlDataSource uses the GridView.SelectedValue to retrieve ...
|
|
|
|
|
Query Error in select from dataset
Replies (1) 6 March 2007
Below is the query I am trying to run and I get a message
'create variables. Both are text values in table
dim sUser as string = Me.txt1.text
dim sPassword as string = Me.pass.text
Dim...
|
|
|
|
|
Confused a bit...
Replies (1) 6 March 2007
I tried this out, I was hoping I could get another say. I
went to this video, and when I clicked at the very end, my cpu started freaking
out. It was actually pretty neat, but it didnt...
|
|
|
|
|
display and access selected items from dataSet to ...
Replies (1) 6 March 2007
-----------XML-------------------
-
-
Admin
Syed
3/3/2007 16:45:20
A_Insert
-
Admin
Syed
3/4/2007 16:45:20
A_Update
-
Admin
Syed
3/5/2007 16:45:20
...
|
|
|
|
|
display and access selected items from dataSet to ...
Replies (1) 6 March 2007
-----------XML-------------------
-
-
Admin
Syed
3/3/2007 16:45:20
A_Insert
-
Admin
Syed
3/4/2007 16:45:20
A_Update
-
Admin
Syed
3/5/2007 16:45:20
...
|
|
|
|
|
display and access selected items from dataSet to ...
Replies (1) 6 March 2007
-----------XML-------------------
-
-
Admin
Syed
3/3/2007 16:45:20
A_Insert
-
Admin
Syed
3/4/2007 16:45:20
A_Update
-
Admin
Syed
3/5/2007 16:45:20
...
|
|
|
|
|
Creating a search function in vb.net
Replies (1) 26 February 2007
Dear All
I need some help. I've got a deadline for this friday and i'm stuck. what
i'm trying to do is have 1 textbox, datagrid and 1 button then when the user
enter a search string, and press...
|
|
|
|
|
VS2003 versus VS2005 data adapters: Auto-generated ...
Replies (1) 25 February 2007
Gents,
Been using 2003 for 4 years, and have several large Windows Forms based
project that I need to continue to develop with VS2005. I have imported one
of these projects, fixed some newly d...
|
|
|
|
|
BindingNavigator items won't work
Replies (1) 22 February 2007
Hi All,
I've got a database with several tables in it. Each table has got the
same columns (name, type etc.)
On my form, I want to show the records of a selected table (selected
in a combobox) i...
|
|
|
|
|
General (newbie) design question about fields nami ...
Replies (1) 21 February 2007
Hi,
I'm using the Dataset Designer Tool to create datasets for my VB.NET
2005 application.
In my SQL Server tables I have odd field names, like "PWD_EXP" or
"SYS_NAME".
I have to show these f...
|
|
|
|
|
opening sql connection
Replies (1) 6 February 2007
I have home compute,which works under windows xp professional.
I installed visual studio.net 2003.When I create Windows Application,bring
to a windows form sqlconnection control,I success to open t...
|
|
|
|
|
Data Driven Site
Replies (1) 6 February 2007
Hi all I am taking a ASP.net class, and I purchased a book. Does anyone know
of a site that I can go to that can give me some step by step instructions or
information about setting up a Data Driv...
|
|
|
|
|
Problem with VS 2005 Data Source Configuration Wiz ...
Replies (1) 3 February 2007
Trying to use the Visual Studio Data Source Configuration Wizard to connect
to a SQL Server 2000 data base I am getting an error at the "Choose Your
Database Objects' window that reads:
An er...
|
|
|
|
|
rowfilters with multiple values
Replies (1) 30 January 2007
I am looking to apply a rowfilter with a series of primary key values to a
dataview.
The data is populated from and xml file.
I am pulling the list of primary key values from an html
list a...
|
|
|
|
|
Create Command File Gone in VS2005
Replies (1) 26 January 2007
I have a VS2005 DB Project with scripts. The Create Command File context menu
is gone (used to be in VS2003). How do I get it back?
Thanks,
John...
|
|
|
|
|
Multi-table Insert Problem
Replies (1) 25 January 2007
Here's the problem:
Using VS2005, 3 tables in a dataset linked hierarchically, stored externally
on SQL server.
When the update occurs, the identity of the first table gets cascaded to the
s...
|
|
|
|
|
How to access a pervasive v9 database across a VPN ...
Replies (1) 21 January 2007
I have a client with SBS2003 and a Pervasive v9 database. I am connecting to
the network via Microsoft VPN with full admin rights.
I have installed the Pervasive V9 client software on my PC but I...
|
|
|
|
|
Time out issue within .Net when calling multiple s ...
Replies (1) 11 January 2007
In .Net v1.1 I am calling 4 stored procedures in a single execute
reader statement which is timing out after 30 seconds. However the same
SQL statement can be run in SQL 2005 Management Studio as th...
|
|
|
|
|
Sorting Datefield in a DataView
Replies (1) 11 January 2007
I have several which I've sorted but the Date Field sorts as a string
rather than as a date and I can't seem to figure out how to fix that.
Below is my code.
Thanks for your help.
public parti...
|
|
|
|
|
Adding ODBC data source in Visual C# Express?
Replies (1) 5 January 2007
Hello:
I have a Pervasive SQL 9 database and Visual C# Express. When I try to add
the ODBC data source using the Data Source Configuration Wizard I don't see
anything other than Microsoft Acces...
|
|
|
|
|
Editing a DataGridView bound to a DataView
Replies (1) 4 January 2007
I have an application that displays data in a DataGridView. The data is in
a DataView that is sorted and at times filtered. One of the columns I have
in the dataview is a boolean field called "s...
|
|
|
|
|
Error in AttachDbFilename connection string in SQL ...
Replies (1) 30 December 2006
I'm developing a Window Form project in VS2005 (C#, WinForm) and SQL Server
2005 Standard Edition as database.
When I try adding "SQL Database" by right clicking project in Solution
Explorer =>...
|
|
|
|
|
AccessDataSource Newbie Question
Replies (1) 29 December 2006
I have added an AccessDataSource to my webpage using the VS2005 GUI.
I have set it up with a connection to a table in the Access database.
I have been able to connect and view the data from a Grid...
|
|
|
|
|
EAB (2.0) Data Config File ??
Replies (1) 26 December 2006
Hello!
Using the EAB (2.0) can anyone tell me how to flush or disable the default
caching behavior of the Data Block in VB.Net (2005)?
I was advised to use:
ConfigurationManager.ClearSingleton...
|
|
|
|
|
How to interpret Data Provider errors?
Replies (1) 26 December 2006
When our app starts it occasionally gets an InvalidOperationException with
the message "Internal .Net Framework Data Provider error 6" from
SqlConnection.Open. It's possible this is due to some th...
|
|
|
|
|
How To Get Primary Keys?
Replies (1) 20 December 2006
I am using an OleDbConnection to connect to an Access database. I need to
know if the field that is read by the reader is a primary key or not. Is
there a [rimary key flag in the COLUMN_FLAGS fiel...
|
|
|
|
|
isnull_fieldname flag uncorrect dbtype. failed to ...
Replies (1) 14 December 2006
When you configure tableadapter windos form you can create sql stored
procedure.
The update storedprocedure created use a flag parameter called
"@isnull_fieldname" to check if the "@fieldname" i...
|
|
|
|
|
Problem with filtering data with datagrid view
Replies (1) 7 December 2006
How can I filter my rows with a datagridview. It is bound to a table.
Thanks
Paul....
|
|
|
|
|
UniqueIdentifier in the DAAB
Replies (1) 7 December 2006
Here's the scenario:
I have 2 tables where the primary keys are the SQL Server uniqueidentifier
data type. Table 1 contains a foreign key reference to table 2's primary
key, so SQL Server forc...
|
|
|
|
|
<<<<<<<<<< Find more stuff like sexy girls video ...
Replies (1) 3 December 2006
Mime-Version: 1.0
Content-Type: multipart/mixed; boundary="PART_BOUNDARY_JDGPTCIQYX"
--PART_BOUNDARY_JDGPTCIQYX
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
...
|
|
|
|
|
SAP .NET Connector Performance (1.1 vs. 2.0).
Replies (1) 1 December 2006
Our application is being migrated from .NET 1.1 to 2.0, and our
estimates showed that we would gain some performance benefit in the
area of the .NET Connector for SAP due to the improvements made in...
|
|
|
|
|
DataSet Designer missing
Replies (1) 30 November 2006
Hi,
I am using Visual Studio 2005 and has a problem with DataSet Designer.
While I was using Visual Studio, 'A Package Load Failure Error' was
given.
Visual Studio terminated and when re-opene...
|
|
|
|
|
Exchange 2003 pulling contacts and filtering by ca ...
Replies (1) 30 November 2006
I need to pull all employee contacts in our firm for a mailing list, but in
the process do not want some of the contacts to be included. I am able to
pull the contacts but am unable to pull the fi...
|
|
|
|
|
Accessing DTS COM Library from .Net
Replies (1) 29 November 2006
Hi,
I am reading the SQL Server DTS Package details from VB.Net using the com
library DTS(Microsoft Data Transformation Services). I am able to read the
packages and Tasks and Steps in Packages. ...
|
|
|
|
|
Accessing DTS COM Library from .Net
Replies (1) 29 November 2006
Hi,
I am reading the SQL Server DTS Package details from VB.Net using the com
library DTS(Microsoft Data Transformation Services). I am able to read the
packages and Tasks and Steps in Packages. ...
|
|
|
|
|
ReadXML on Arm7 .NET1.1 CF
Replies (1) 27 November 2006
Target: Arm7V4T .NET1.1 VS2003 SP1
I am loading a 30kb XML file into a dataset:
DataSet ds = new DataSet();
ds.ReadXmlSchema(schemaReaderFile);
ds.ReadXml( readerFile);
If I run this cod...
|
|
|
|
|
Update Dataset if underling database changed
Replies (1) 24 November 2006
Hi!
I'm currently developing an application and the underlying database (access
file) changes quite often in terms of tables,relations and fields (its a
research project). My problem though, I ...
|
|
|
|
|
SQLClient SQLAdapter Data type problem
Replies (1) 16 November 2006
I'm having problems simply retrieving values from the database and using
in their original format. Example below assumes that size column is
double or float
Here is code snippet:
string max...
|
|
|
|
|
Stored Procedure ORACLE with Output Parameters
Replies (2) 14 November 2006
Hi all
I'm tryng to use MSDAORA access in a Oracle 9 database.
I have a stored procedure named TEST with this Sign :
PROCEDURE TEST
(
PC_01 IN VARCHAR2
,PC_02 IN ...
|