requerying with Dataadapter and dataset
Hi all ,
I wonder if you can help I run this code once
Dim daEmpDet2 As OleDbDataAdapter defined globally
strSQL1 = "select * From PREmpDet where Empcode='" & EmpCode & "'"
Dim dsEmpDet2 = New OleDbDataAdapter(strSQL1, cn2)
daEmpDet2.Fill(dsEmpDet2, "EmpDet2")
I get the right record when run the code the first time .
when I rerun the code with a different EmpCode I Still get the first record
what am I doing WRONG.
Thanks Tag: Acessing mdb file in a different computer!! Tag: 72272
LoadDataRow Issues
I have 2 datasets, each with a DataTable. Each table has the same primary
key, and columns. I am trying to copy rows from one dataset to another,
based on an event from my application.
It all works fine when the row is not present in the destination DataTable.
Now when the row is present in the destination file, the .NET documentation
says use the LoadRowData method of the dataset to copy the row. When do
this, I get a unique key violation problem (right at the EndLoadData point
in the code below).. Here is my code below. Can anybody help??
Dim app As Application
Dim xmlDestFile As String = app.StartupPath & "\" & "dest.xml"
Dim xmlSourceFile As String = app.StartupPath & "\" & "source.xml"
Dim dsDest As New DataSet
Dim dsSource As New DataSet
Dim rwDest As DataRow
Dim rwSource As DataRow
dsDest.ReadXml(xmlDestFile)
dsSource.ReadXml(xmlDestFile)
Try
For Each rwSource In dsSource.Tables(0).Rows
Dim copyRowPersent As Boolean
For Each rwDest In dsDest.Tables(0).Rows
If rwDest.Item("Name") = rwSource.Item("Name") Then
copyRowPersent = True
Exit For
End If
Next
If copyRowPersent Then
Dim newRow(rwSource.Table.Columns.Count - 1) As Object
Dim column As DataColumn
Dim intLoop As Int32
intLoop = 0
For Each column In rwSource.Table.Columns
newRow(intLoop) = rwSource.Item(column)
intLoop = intLoop + 1
Next
dsDest.Tables(0).BeginLoadData()
dsDest.Tables(0).LoadDataRow(newRow, False)
dsDest.Tables(0).EndLoadData() ' I get a
primary key voilation problem here..., I don't even go to accept changes
else
'Import the new rows here using ImportRow
' This works fine...
End If
Next
dsDest.AcceptChanges()
dsDest.WriteXml(xmlDestFile, XmlWriteMode.WriteSchema)
dsDest.Dispose()
dsSource.Dispose()
Catch myex As Exception
MsgBox(myex.ToString, MsgBoxStyle.Information +
MsgBoxStyle.OKOnly, "Test")
End Try
VJ Tag: Acessing mdb file in a different computer!! Tag: 72271
Finer grained info on what led to a constraint exception
Is there any way to provide a finer grained source of
information on what led to a constraint exception?
This is really a blunt tool right now. Tag: Acessing mdb file in a different computer!! Tag: 72268
ExecuteNonQuery and events
This is a multi-part message in MIME format.
------=_NextPart_000_0008_01C3B016.BBB07A60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi
I'm using the ExecuteNonQuery command to insert a row in a database. =
How do I fire an event when the row has been added. I know how to do it =
with an OleDbDataAdapter, but I want to use ExecuteNonQuery. Ideas?
Ian
------=_NextPart_000_0008_01C3B016.BBB07A60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>Hi</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I'm using the ExecuteNonQuery command =
to insert a=20
row in a database. How do I fire an event when the row has been=20
added. I know how to do it with an </FONT><FONT face=3DArial=20
size=3D2>OleDbDataAdapter, but I want to use ExecuteNonQuery. =
Ideas?</FONT>
<P><FONT face=3DArial size=3D2></FONT><FONT face=3DArial =
size=3D2>Ian</FONT></P>
<P><FONT face=3DArial size=3D2></FONT> </P></DIV></BODY></HTML>
------=_NextPart_000_0008_01C3B016.BBB07A60-- Tag: Acessing mdb file in a different computer!! Tag: 72266
Thread communication - events
Is it possible to use events as a communication mechanism between threads? Tag: Acessing mdb file in a different computer!! Tag: 72265
EASY ONE? looping and updating labels with each iteration
This should be an easy one, but I'm not sure the best way to do it.
I've got a form, and when I click a button it starts looping through an
array. With each iteration of the array I want it to change the status of a
label.
I realise that it must complete the execution of the code-behind page before
it can update the labels, so how do I do it?
TIA, Bruce Tag: Acessing mdb file in a different computer!! Tag: 72255
Master - Detail problem...
Hi
I have a typed dataset with a Master table (tblPersons) and a Detail table
(tblRemarks).
I have a Winform which shows person data (master data)
I would like to have a datagrid showing the detail data.
So I try to bind the datagrid like this:
DataSource: MyDataSet
And try to set DataMember to: tblPersontblRemarks
But I get an error:
"Invalid Property Value:"
"DataBinding could not find a row in the list that is suitable for all
bindings"
And then when I press OK
I receive another error:
"Datasources of type System.DBNull are not supported.
Parameter name: Datasource"
If I rightclick on a dataadapter and select Preview Data... it works fine.
Best regards
Jan Tag: Acessing mdb file in a different computer!! Tag: 72251
DataView.Find (SQL Server 2000)
I need to be able to sort/search a datatable for 2
columns, both of type integer. Is this possible?
Dim dv As New DataView(MyDataTable,...)
Dim dr As DataRowView
Dim iIndex As Integer
Dim objSearch(1) As Object
dv.Sort = ("Column1, Column2 ASC")
objSearch(0) = 5 'Locate 5 in column 1
objSearch(1) = 6 'Locate 6 in column 2
iIndex = dv.Find(objSearch)
Will this find rows in my view where Column1 = 5 AND
Column2 = 6? Or will it find rows where Column1 = 5 or
6 AND rows where Column2 = 5 or 6?
As an alternative, I could apply a filter upon the
DataView when enstantiating it. However, wouldn't this
be less efficient/concise than DataView.Find?
-bgsd Tag: Acessing mdb file in a different computer!! Tag: 72242
Udl File How to use it
Hi,
I have a quick question about the udl file.
How to use it in a project ?
I ve created one, but I don't know where to put it and how to replace my
current connection string with it ?
Thks
Stan Tag: Acessing mdb file in a different computer!! Tag: 72238
Oracle cursors not releasing with OracleClient
Hi all,
I'm having a problem with Oracle .net provider and Stored Procedures
returning REF CURSOR vars. I'm using OracleClient v1.0.1012.0 with
Framework 1.0 and when I fill a dataset with the stored procedure, the
cursor is not released and I always end up with a ORA-01000 error (too
much cursors opened).
It's very frustrating and I've observed that if I change the
OracleClient reference to the one from framework 1.1 it doesn't happen
and the cursors are released when closing the connection.
Unfortunately, I can't change the framework version I'm using so I'd
like to know if there's something I could do to fix this behaviour
with framework 1.0
Another strange thing I've noticed is that if I call the function (see
code) in a pageload event of an aspnet application I don't get the
ORA-01000 error but if I call it from the Console Application I can't.
I'll put some code here to reproduce the behaviour, any help will be
appreciated !!
Thx in advance,
ori
using System;
using System.Data.OracleClient;
using System.Data;
namespace ConsoleApplication2
{
/// <summary>
/// Summary description for Class1.
/// </summary>
class Class1
{
[STAThread]
static void Main(string[] args)
{
Class1 c = new Class1();
for (int i=0; i<850; i++)
{
c.try();
}
}
public void prova()
{
try
{
OracleConnection conn = new OracleConnection(@"<connection string
here>");
conn.Open();
OracleCommand comm = new OracleCommand();
comm.Connection = conn;
comm.CommandType = System.Data.CommandType.StoredProcedure;
comm.CommandText = "PKG.READ";
comm.Parameters.Add(new OracleParameter("P_CURSOR",
OracleType.Cursor, 38, ParameterDirection.Output, true, 38, 0, "",
System.Data.DataRowVersion.Current, null));
OracleDataAdapter adapter = new OracleDataAdapter(comm);
DataSet dset = new DataSet();
adapter.Fill(dset);
conn.Close();
}
catch (System.Exception ex)
{
//ORA-01000 Error when default 300 cursors are opened
}
}
public Class1()
{
}
}
}
Stored procedure
CREATE OR REPLACE PACKAGE PKG AS
TYPE etrcur IS REF CURSOR;
PROCEDURE READ
(
p_CURSOR OUT etrcur
);
END PKG;
/
CREATE OR REPLACE PACKAGE BODY PKG AS
PROCEDURE READ
(
p_CURSOR OUT etrcur
)
IS
BEGIN
OPEN p_cursor FOR
SELECT <ANY SELECT HERE>;
END SGM_READ;
END PKG;
/ Tag: Acessing mdb file in a different computer!! Tag: 72226
BindingContext
Hello
i have a form bounded to a DataSet and i have several combobox's in the
form.
when i use
Bc.Position = Bc.Position + 1
it moves to the next record in the DataSet, and all the combobox's that are
bound to other tables in the dataset are updated too.
problem is when the bc.position = 0 (first record) is selected the textbox's
are updated correctly the combobox's are displaying the first record of the
bonded table and not the value that is in in that record.
is there i am missing?
Thnaks Tag: Acessing mdb file in a different computer!! Tag: 72219
Passing values error
I'm using this piece of code on page one.aspx
Context.Items("Parameter") = x
Server.Transfer("two.aspx")
And in opage two.aspx
I put a value in a text box via button.
To grab the data I use
Dim x As Integer = CType(Context.Items("Parameter"), Integer)
BUT when I click the button to insert that value in a text box I get 0
(zero) instead of a number from the previous page. Tag: Acessing mdb file in a different computer!! Tag: 72218
how to create a notification?
my sql is:
CREATE EVENT NOTIFICATION mytestqueue
ON DATABASE
FOR DDL_DATABASE_LEVEL_EVENTS
TO DATABASE northwind
but error message is:
Incorrect syntax near 'northwind'.
how to do? thanks!!! Tag: Acessing mdb file in a different computer!! Tag: 72210
MySQL & WebForm - Please Help
Hello,
I just started to learn ASP.NET, and I am using MySQL for database, I have a
question I hope someone can answer for me though :)
I want to create a simple form that can edit and create a row in a database,
for example the fields Name and Lastname. How do I go about this, can I
somehow link my TextBox's to a field in the MySql database? So when I press
Create-Button it adds the row with the fields from TextBox's itself?
Or must I make a Button_Click event and make the SQL myself there?
If I must do it myself, in PHP I used to create forms so all TextBox's were
part of an array, then I could easilly make a foreach and create the SQL
statement on the fly. This way I could add another TextBox to the page (and
in the database ofcause), and not have to go change my code for it to be
saved.
Im looking for the best solution to creating/updating on a webform... and
for my example a webform with 2 TextBox's (Name and Lastname) and 2 Buttons
(Update and Create) would be good example, so I can use that method on
bigger forms.
I hope someone can point me in the right direction.
Thanks,
Cederstrom Tag: Acessing mdb file in a different computer!! Tag: 72192
Doing something like nested SQL in DataTable.Select method
I have a table with fields the following fields
ID INTEGER (Primary key)
FLAG BOOL
TIMESPAN DATETIME
IMPORTANCE INTEGER
say I want to find the an ID with flag set to true, highest importance
and shortest timespan. so one way to write the SQL is this:
SELECT ID
FROM MyTable
WHERE TIMESPAN =
(SELECT MIN(TIMESPAN )
FROM MyTable
WHERE FLAG=TRUE AND IMPORTANCE =
(SELECT MAX(IMPORTANCE )
FROM MyTable
WHERE FLAG=TRUE));
so. my problem is. the data is in a dataTable and the DataTable.Select
method doesn't take SQL statements. So can something teach me how to
find what I need from the DataTable?
thxs in advance
.Net newB Tag: Acessing mdb file in a different computer!! Tag: 72190
Using the GetChildRows method C#
I am new to .net.
I am populating a dataset with a few tables using stored
procedures successfully and then setting primary keys and
relations between table columns.
BUT when I go to use the GetChildRows method my relations
arent returning any child rows.
Is there a better way of assigning the source table's
primary/foreign key relationships to the dataset?
Help is much appreciated. Tag: Acessing mdb file in a different computer!! Tag: 72189
use crystal report in ASP.NET datagrid search result page
I am new to crystal report. I have ASP.NET pages that show the search
result. Since the search result is represented by datagrid, it will be nice
to put a button on that page, and allows the user to export the result to
crystal report.
Here's what I have done so far, and I dont know what to do next.
1) Add CrystalReportViewer web control to the search result page.
2) In my ASP.NET application, I added a new item crystal report (.rpt)
In my case, can the crystal report just get the result from datagrid.
Please advise!
Thanks! Tag: Acessing mdb file in a different computer!! Tag: 72187
Accessing Excel thru Jet gives data in scientific notation
Hi,
I m trying to access an excel spreadsheet to load a named cells in a
dataset. For this, I m using Jet OLEDB provider with ADO.Net.
String cnString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" +
fileName + "; Extended Properties=\"Excel 8.0;HDR=No;IMEX=1;\"";
String sql = "select * from MyNamedCells";
Initially I was having problem with null values for certain cells where
datatype appeared different to the provider. e.g. If a top cells of a
column contain text data (say A13331123) and in the middle there was some
numeric data (4509015284) .. the numeric data was being retrieved as null.
This was fixed using IMEX switch.
Now - althought the numeric data is being loaded, but it is coming in
scientific notation (the above value converts to: 4.50902e+009).
How can I get my text back with the right accuracy?
Thanks. Tag: Acessing mdb file in a different computer!! Tag: 72186
FoxPro, dBase III, and ADO.NET
I have a newbie question about different database formats as they
apply to ADO.NET. I need to get access to a .dbf file using ADO.NET.
The files are in dBase III format. Does that mean I need to use the
FoxPro Data Provider or that I only need to specify "Extended
Properties=dBase III" in the connection string to connect to dBase III
files?
It's my understanding that FoxPro is just one of many programs that
can read dBase III files (just like many text editors can read .txt
files or html files). Is this the case? If so, why would someone be
interested in using the FoxPro data provider?
Thanks,
Dave Tag: Acessing mdb file in a different computer!! Tag: 72172
Returning Multiple Resultsets with Jet
Hi,
I was wondering if you can return multiple Resultsets with
Jet 4.0. I keep getting an error on the ; .
Dim sSql As String = "SELECT Full_Name FROM States WHERE
Country_ID = " & CountryID & " ORDER BY Full_Name;" _
& "SELECT * FROM Countries ORDER BY Name;"
Does this work with Jet 4.0?
Thanks Tag: Acessing mdb file in a different computer!! Tag: 72170
Setting a datacolumns value to NULL?
How do I set the value of a specific datarow's column to be null?
Ex.
Private sub savedata(byval sOID as string, byval sComment as SqlString)
Dim ods as dataset
Dim odt as datatable
Dim odr as datarow
Dim odrarray() as datarow
try
ods = me.getdataset(xxx...)
odt = ods.tables(0)
odrarray = odt.select("myoid = '" + sOID + "'")
for each odr in odrarray
If sComment.isNull then
??????? How do I set this particular row/column to be
null???
Else
odr("mycomment") = sComment.value
End if
next
finally
--
Doug Swanson
Senior Applications Developer
Synchrono, Inc
651.228.1772
dswanson@synchrono.com Tag: Acessing mdb file in a different computer!! Tag: 72164
DataReader with a return parameter and an OUTPUT parameter.
I have a stored procedure and I set up the command type
to be StoredProcedure with the return value and the
output parameter set to InputOutput. This StoredProcedure
also returns a set of rows. From the best that I can tell
if I use ExecuteReader() the first time it returns the
OUTPUT parameter and it takes a second time to actually
get the data. Is this the default behavior or is there
some special setup to get this to return the data AND the
OUTPUT parameter in one call to ExecuteReader()?
Thank you for your suggestions.
Kevin
rkevinburtn@charter.net Tag: Acessing mdb file in a different computer!! Tag: 72163
Dataset cycle through
Hi All,
I have created a oledbdataadapter/OledbConnection
and dataset. I would like to cycle through all records
that the dataset has to implant into a treeview as nodes.
How do i do this? This is a win app.
Thanks,
JJ Tag: Acessing mdb file in a different computer!! Tag: 72162
formatting a label control with a date
Probably a simple question: I have a combobox where the user will select a
member number. I have two labels that are bound to the member's name
(FirstName, LastName). I then have another label that is bound to the
member's date of birth. Everything works fine in that when a member is
selected from the combobox the name changes and the birthdate changes;
however the label for the birthdate is in mm/dd/yyyy format but it also
displays the time of 12:00 am. I want to delete the time. Is there a way
to do this?
Thanks for the information.
Brad
PS This is an oledb data adapter connecting to an access database. The
date field in the database is formatted as short and the date-time picker in
VB is a custom format of MMMM dd, yyyy. Tag: Acessing mdb file in a different computer!! Tag: 72157
Inserting identity columns with CommandBuilder generated commands?
Hi,
I need to commit the changes to the database of a dataset containing
many (MANY) datatables. A few of them have an auto-increment column,
but I need to insert a specific value in the database (which is MS-SQL,
by the way).
My code is fine and I send a "SET IDENTITY_INSERT ON" to the database
when needed.
Since all the operations I need to perform are very basic and that I
have many different tables, I am using the CommandBuilder object. The
problem is that the Insert command does NOT include the auto-increment
field.
Is there a way to make the extra parameter is added to my InsertCommand?
MSDN and the books I have were not of any help.
Thank you very much!
Carl
PS: Here's the code...
Public Sub CommitTable(ByVal table As DataTable, ByVal transaction
As SqlTransaction, Optional ByVal allowIdentityInsert As Boolean = False)
Dim da As New SqlDataAdapter("SELECT * FROM " +
table.TableName, transaction.Connection)
da.SelectCommand.Transaction = transaction
Dim cmdBuilder As New SqlCommandBuilder(da)
Dim cmd As SqlCommand
cmdBuilder.QuotePrefix = "["
cmdBuilder.QuoteSuffix = "]"
da.InsertCommand = cmdBuilder.GetInsertCommand
da.UpdateCommand = cmdBuilder.GetUpdateCommand
da.DeleteCommand = cmdBuilder.GetDeleteCommand
cmd = New SqlCommand("DELETE FROM " + table.TableName,
transaction.Connection, transaction)
cmd.ExecuteNonQuery()
If allowIdentityInsert Then
cmd.CommandText = "SET IDENTITY_INSERT " + table.TableName
+ " ON"
cmd.ExecuteNonQuery()
End If
da.Update(table)
table.AcceptChanges()
If allowIdentityInsert Then
cmd.CommandText = "SET IDENTITY_INSERT " + table.TableName
+ " OFF"
cmd.ExecuteNonQuery()
End If
End Sub Tag: Acessing mdb file in a different computer!! Tag: 72149
How get the names of the SQL Servers available
Could someone tell me how get the names of the server
running SQL Server in my LAN using VB.NET ????
Many thanks
nq Tag: Acessing mdb file in a different computer!! Tag: 72147
[ANN] PgSqlClient 1.0 Beta 4 released.
Hello:
Beta 4 version of *PgSqlClient* an ADO.NET Data Provider for PostgreSQL
7.4+ released.
*Beta 4 ( 20-11-2003 )*
* Bug fixes.
* Better fit to ADO.NET.
* Improved handling of command parameters.
* Restricted batch command execution to PgCommand.ExecuteReader calls.
* Added correct handling of character sets.
* Added support for Geometric types.
* Added some improvements to the SSL/TLS library.
PgSqlClient 1.0 Beta 4 source code is available at:
http://prdownloads.sourceforge.net/pgsqlclient/PgSqlClient-1.0-Beta4-Src.zip?download
PgSqlClient 1.0 Beta 4 binaries for .NET 1.0 available at:
http://prdownloads.sourceforge.net/pgsqlclient/PgSqlClient-1.0-Beta4.exe?download
--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain Tag: Acessing mdb file in a different computer!! Tag: 72146
Custom Data Providers
Can anyone tell me or point me to documentation on how to
register a custom data provider?
Thanks,
Kent Tag: Acessing mdb file in a different computer!! Tag: 72145
Using Oracle Packages in Visual Studio.NET 2003 designer
Hi Group,
we've noticed that Visual Studio.NET 2003 does not seem to be capable of
reading the parameter data for commands on oracle stored procedures that
are collected in packages.
We can create a command, change the command type to StoredProcedure and
enter a stored procedure or function name and it works fine (same
functionality as simply drag'n'dropping the stored procedure or function
from the server explorer to the designer). That works smoothly.
However, when we enter a function name from a package, the name cannot
be resolved. It works fine during runtime, when we have manually added
the parameters (so there is no spelling problem with the names) - but
the designer simply doesn't find the stored procedure or function.
Is this a known problem? Are there any workarounds? What we're
considering is creating temporary stored procedures (not in a package)
to automatically get the parameters, and then manually changing the name
so that it referes to the original function stored in a package.
This is still easier than manually entering the parameters - but still
it's rather cumbersome and time consuming...
regards,
david
--
Auch das geht vorüber. (Sufi-Weisheit)
Holger (David) Wagner Tel: +49 (89) 890 50 962
Dewetstrasse 1 Mobil: +49 (177) 274 12 45
D-80807 München Fax: +49 (177) 992741245 Tag: Acessing mdb file in a different computer!! Tag: 72141
unclosed connections problem
We have recently migrated a classic asp/sql server web site from
windows server 2000 without the .net framework installed to windows
server 2003. We seem to be finding that sql server is using up
excessive amounts of RAM, much more than the old machine, even with
the same amount of traffic. I suspect there may be a number of
unclosed database connections in the legacy asp code and that windows
2003 is not shutting them down as quickly as with windows 2000. Does
this sound plausible and if so is their any temporary work around to
solve the problem. (It may take some time to correct all the code
problems)
Scott Tag: Acessing mdb file in a different computer!! Tag: 72140
OUT NUMBER Parameters with Microsoft OLE DB Provider for Oracle =>
Hi Group,
we're experiencing a very weird problem with the Microsoft OLE DB
Provider for Oracle. We're using the version shipped with Visual
Studio.NEt 2003.
When we have any OUT parameter of type NUMBER, we get OCI-22060
(Argument [2] ist eine ungültige oder nicht initialisierte Zahl). This
also happens when calling a function, where RETURN_VALUE is declared as
NUMBER.
OUT parameters as VARCHAR2 work fine, whenever we switch to NUMBER, the
problem occurs.
We're simply drag'n'dropping the command (stored procedure) from the
server explorer. Could it be we're doing anything wrong?
Or is this a bug in the provider? If so, are there any workaround or
fixes available?
regards,
david
--
Auch das geht vorüber. (Sufi-Weisheit)
Holger (David) Wagner Tel: +49 (89) 890 50 962
Dewetstrasse 1 Mobil: +49 (177) 274 12 45
D-80807 München Fax: +49 (177) 992741245 Tag: Acessing mdb file in a different computer!! Tag: 72139
Data Control
Hi
I am dying trying to write all that datadapter code for each and every table
that I need. Is there a third party control that I can use until the next
version of vs.net comes out?
Thanks
Regards Tag: Acessing mdb file in a different computer!! Tag: 72132
Using IN keyword in data adapter.
Hello all -
I've searched high and low to an answer to my question so I'm posting here as my last option
I'm trying to use the IN keyword in my WHERE clause of the data adapter to gather all IDs, separating them with commas, but I get an error that states that it could not convert a varchar value (due to the potential comma being there I needed to) to an int (which is what the ID field is defined as). Does anybody know what I can do to get around this issue or is there something I'm doing wrong?
Here's my query (@CustIDs can hold a value of 15, for example, or '15,16')
SELECT DISTINCT Customer.CustomerID, Customer.CompanyName, Customer.City + ', ' + Customer.State AS CityState FROM Customer INNER JOIN ClientServicesTable INNER JOIN CompanyServicesTable ON ClientServicesTable.CompanyServiceID = CompanyServicesTable.CompanyServiceID ON Customer.CustomerID = ClientServicesTable.ClientID WHERE (CompanyServicesTable.ServiceType = 'S' OR CompanyServicesTable.ServiceType
= 'B') AND (Customer.CustomerID = @ID OR Customer.CustomerID IN (@CustIDs)) ORDER BY Customer.CompanyNam
Much thanks
Mark Tag: Acessing mdb file in a different computer!! Tag: 72125
DataSets, DataAdapters and bad design
Does anyone else think the whole design of ADO.NET is a piece of ****?
The DataSet is basically a mini, in-memory database. Heavy, tough to
move data in and out of the database (@@Identity issues?). I've been
developing desktop, web and n-tier applications for over 10 years and
have never had a need for anything like it.
Or do I just not get it? What am I missing? It seems to me all you
need is a DataReader, a Command object, and a well designed data
access layer. What do you need a DataSet/DataAdapter for? Tag: Acessing mdb file in a different computer!! Tag: 72115
Could not find installable ISAM
I have had the problem where my vb6.0 app works in design mode and
compiles and runs on that comp but wont run on others giving me the
error :
"Could not find installable ISAM" After reading and trying everything
the only thing that worked for me was to install Visiual studio 6.0
with service pack 5. then you can remove Visual stuido but the drivers
will stay allowing the app to work i did this on a windows 98 box and
it worked well
hope it helps Tag: Acessing mdb file in a different computer!! Tag: 72109
Sorting a dataset
Hi All,
I've populated a dataset, but need to return the results,
one by one, in numerical order. I can do this easily when
attaching a datagrid to a dataview, but I can't seem to do
it on just the dataset.
Anyone have any ideas on how to do this?
My code is as follows...
dsDistributionLists.ReadXml(Server.MapPath
("../XMLRoutines/4020DistributionLists.xml"))
Dim holdingTable As New DataTable()
Dim distListID As New DataColumn()
holdingTable.TableName = "holdingTable"
distListID.ColumnName = "distListID"
holdingTable.Columns.Add(distListID)
dsDistributionLists.Tables.Add(holdingTable)
Dim dt As DataTable
For Each dt In dsDistributionLists.Tables
If Val(Mid(dt.TableName, 2)) > 7 Then
Dim newRow As DataRow =
dsDistributionLists.Tables("holdingTable").NewRow
newRow(0) = Val(Mid(dt.TableName, 2))
dsDistributionLists.Tables
("holdingTable").Rows.Add(newRow)
End If
Next
***********************
SORTING THING IN HERE
************************
Dim dr As DataRow
For Each dr In dsDistributionLists.Tables
("holdingTable").Rows
Response.Write(dr.Item(0))
Next Tag: Acessing mdb file in a different computer!! Tag: 72107
How to bind RTF text and Image
VB6's RichTextBox can bind the RTF text with DataField prop,
but .Net RichTextBox's Rtf Prop can't select for bind,
Only bind the Text prop, but the Text prop can't read/write RTF format text!
how to bind the RTF text with a RichTextBox control?
I want't write the RTF text read/write code without bind
my Database is SQL 2000
my DevProgram is C#
my Project is a Windows Application
thanks
BTW:
How to bind the Picture control 's Image prop with database's BLOB(image)
ccolumn ?
thanks Tag: Acessing mdb file in a different computer!! Tag: 72106
Caching data on local machine
I need to cache a dataset on the client machine and
amnipulate the dataset until the user desires to post the
changes back to the server. ANy help? Tag: Acessing mdb file in a different computer!! Tag: 72089
LoadXML 2nd try
Problem with reading a RSS
Dim reader As XmlTextReader = New
XmlTextReader(http://weblogs.asp.net/hpreishuber/Rss.aspx")
ds1.ReadXml(reader)
Error
A column named 'comments' already belongs to this DataTable.
this is cause on field comments is with namespace
any workaorund/solution??
--
Gruss Hannes
www.asp-konferenz.de - das Event für den MS Webentwickler
www.aspnet-professional.de - das Magazin
www.devtrain.de ASP und .NET Community Site
www.vbmoves.de VB bewegt sich doch
www.ppedv.de Company Site Tag: Acessing mdb file in a different computer!! Tag: 72088
Web DataGrid
I have a search which returns one row, 1 result in a web datagrid.
One textbox is also on the page and now I need to fill that text box with
the first value from that datagrid (that value is a number).
Thanks Tag: Acessing mdb file in a different computer!! Tag: 72087
How to get archive-informations of database with SQLClient or ODBC
I have used blow method to get archive-informations of database,but there is always error,i
don't know,how can i do,with ODBC too.I use J
[C#
SqlConnection nwindConn = new SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind")
SqlDataAdapter schemaDA = new SqlDataAdapter("SELECT * FROM INFORMATION_SCHEMA.TABLES "
"WHERE TABLE_TYPE = 'BASE TABLE' "
"ORDER BY TABLE_TYPE",
nwindConn)
DataTable schemaTable = new DataTable()
schemaDA.Fill(schemaTable); Tag: Acessing mdb file in a different computer!! Tag: 72086
Can't see counters at the performance monitor
Hi All,
I am trying to view the: "Current # of pooled and non
pooled connections"
from the performance monitor.
When I select the performance object ".NET CLR Data"
and select a counter from the list of counters, I can't
select an instance from the instances list (not even
_Global_) because it is disabled.
What can be the cause of that ?
Thanks !!
Raz Tag: Acessing mdb file in a different computer!! Tag: 72085
SqlDataAdapter and finalization
Hello all,
I had some code that forgot (or should I say I forgot) to
call Dispose on a SqlDataAdapter, so I thought it will be
okay since SqlDataAdapter inherits via Component so the
inherited Dispose/Finalize pattern would be picked up.
However, after poking around with a decompiler I notice
that within the constructor of SqlDataAdapter the call to
GC.SuppressFinalize() is made so because my code forgot
to call Dispose, the cleanup code will never be called
via the overriden Finalizer in Component.
Does anyone haveany thoughts on the rationale behind the
SqlDataAdpater choosing to call GC.SuppressFinalize() in
its constructor.
Colin Tag: Acessing mdb file in a different computer!! Tag: 72084
multiple inserts
Hoping someone can help with an optimisation query...
I'm looping through an array, doing thousands of inserts. At present for
every iteration of the loop I'm creating a new command object, and opening
and closing the connection object, something along the lines of....
For Each objAS400Data In arrAS400
objCommand = New OracleCommand(strPackageName, objConnection)
objCommand.CommandType = CommandType.StoredProcedure
objCommand.Parameters.Add(New OracleParameter("IN_PARAMETER_ID",
OracleType.Int32)).Direction = ParameterDirection.Input
objCommand.Parameters("IN_PARAMETER_ID").Value = objParameter.Value
Try
objConnection.Open()
boolReturn = objCommand.ExecuteNonQuery
If Not (objCommand.Parameters("out_errMsg").Value Is DBNull.Value)
Then
strError += CStr(objCommand.Parameters("out_errMsg").Value)
boolReturn = False
objConnection.close()
objCommand = Nothing
Exit For
End Try
objConnection.close()
objCommand = Nothing
Next
Whilst this all works, I can't help but get the feeling that instantiating
all these objects, and opening/closing the connection is slowing things
down. Is there a better, more efficient way of doing this?
regards,
Bruce Tag: Acessing mdb file in a different computer!! Tag: 72077
newbie, converting from ado to ado.net --> datareader help needed.
Hi,
I am converted an existing vb6 web app to vb.net and have run into a bit of
a problem with data access via ADO.NET.
I am doing a full text search against a SQL Server 2000 DB, the SP that I
call to do this returns multiple resultsets, therefore
from the documentation I found that I would have to use the SqlDataReader in
order to move from one resultset to another.
However here lies the problem. After the SP is called in the vb6 version I
used the recordsets "RecordCount" method to
create a large enough array to do some additional processing (don't ask).
But I can no longer do this with the datareader because you
read one row at a time.
So my problem is how do I find out how many records are in the current
resultset when using a datareader?
As you can imagine the search SP is not trivial and repeating the query
twice just so I can find out the recordcounts
is not acceptable.
My first guess at a solution would be to use an ArrayList and then just call
it's .Add method then I wouldn't need to worry
about array size.
Any other suggestions welcome.
Regards,
Peter Tag: Acessing mdb file in a different computer!! Tag: 72076
How to display/edit formatted text from a database?
Hi All!
What is the most recommended way of displaying formatted
text from a database and allowing users to edit and save
it back to the database?
I guess, RichTextBox control will do the job, but I was
not able to display multi-line table rows properly in the
RichTextBox control [although they display just fine in
Word(Pad)]:
http://communities.microsoft.com/newsgroups/previewFrame.a
sp?
ICP=msdn&sLCID=us&sgroupURL=microsoft.public.dotnet.framew
ork.windowsforms&sMessageID=%253C06fd01c3ad0c%
2524e4d8c490%2524a401280a@phx.gbl%253E
i.e., instead of
+---+
| A |
+---+
|AAA|
|AAA|
|AAA|
+---+
I am getting
+---+
| A |
+---+
|AAA|AAAAAA
+---+
What gives? Hopefully, there is an alternative to Word
automation, because I do not want my application to
depend on Word.
Phil Tag: Acessing mdb file in a different computer!! Tag: 72075
How to update a row using timestamp
Hi All,
I have a table with a timestamp column. I use SQLHelper
static class from(Microsoft's DAAB) to get the data from
the table and store it in my C# class. When the user
modifies the class properties and then call the Update
method of my class I update the database. Here I want to
check the timestamp. Can anyone tell how to store the (sql
server 2000) timestamp value in C# and then pass it to SQL
Server.
Thanks In Advance,
Venki Tag: Acessing mdb file in a different computer!! Tag: 72070
ACCESS DB - How do I get .NET to talk
OK...I give up
It would seem like Microsoft decided that they really
liked SQL server, and so made it impossible for .NET to
talk to ACCESS.
I am using the 1.0 framework.
I was getting a "The Microsoft Jet database engine cannot
open the file <filename>. It is already opened exclusively
by another user, or you need permission to view its data."
message.
This led me to KB 316675.
So...I modified the machine.conf file (which means that,
although I MIGHT get it to work on my machine, it probably
won't work when it is hosted on the ISP) and behold...Now
I get the message "Cannot Lock File" when I try to open
the file to perform a SQL select statement.
Pardon my french, but WHAT THE HELL DO I NEED TO DO TO GET
THIS STUPID THING WORKING?
Can somebody provide a code sample????
Thanks Tag: Acessing mdb file in a different computer!! Tag: 72069
object model - dataset, dataadapter, datatable
Hello All,
Could you guys help me understand the ado.net object model ?
This is what I think, correct me if I am wrong
* DatAdapater acts as a bridge to bring in/send out data to database
* Dataset is in-memory cache, disconnected from db, doesnt talk to db directly
* DataTable could be a part of dataset.
could multiple table from a common datasource be a part of same dataset ?
* How to add multiple tables to same dataset, using same datasource ?
* A separate dataadapter is needed, for each SELECT/Stored proc, which will bring in data to dataset
Can a single dataadapter be used for multiple tables added to the same dataset having common source ?
I am somehow confused & thinking that there has to be 1 dataadapater for each SELECT querying diff tables
Regards
Kalpesh Tag: Acessing mdb file in a different computer!! Tag: 72067