ForeignKeyConstraint [foo] requires child value (x) to exist in the parent table.
re: topic - yeah, i know!
and it _does_ exist in that table!!! so why does this thing keep throwing
an exception?
i don't know the direct answer, but i know the indirect answer: because my
child table uses a composite PK! if i try this exact scenario using a
dataset where the child table's primary key is simple, everything works as
expected.
i'm not sure if it makes a difference that the FK field is also a member of
the composite PK
anyway, i am about to go hack this into shape via workaround: abolish
composite keys in child tables and replace with a surrogate simple key (ie -
an autonumber field, since the identities created by my previously defined
composite key are about to go out the window...)
...but i stopped in to wonder: has anyone else seen this behaviour? is it
a bug, or 'other'? Tag: What happens on multiple connections with SQL Tag: 70935
OracleConnection and the Oracle Client installation
I have downloaded and installed OracleClient from msdn, but still I have
difficulties connection to a remote oracle server. I have not installed the
Oracle Client installation from Oracle.
Do I really need to do so to connect to an oracle database?
In java all you need is a small zip/jar file. Installing Oracle Client seems
a bit too much, and kind of an over kill to me?
Morten Tag: What happens on multiple connections with SQL Tag: 70934
PDC question
Unfortunately it looks as though I just missed the PDC for this year.
However, I would like to get information on its location/cost for next year
so as to get it in the budget. Does anyone know where to find this? (All I
have been able to locate is info related to the October show?
I would also like this same info for TechEd if anyone has it. Tag: What happens on multiple connections with SQL Tag: 70931
The root element is missing when binding dataset to xml textreader
This is a multi-part message in MIME format.
------=_NextPart_000_0037_01C3A780.6EE575D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
cross posted to microsoft.public.dotnet.xml
Hi,
I am attempting to create a xml file to a memory stream the bind it to a =
dataset. I can write a physical file with no problem. However I =
recieve the following error when trying to bind it to a dataset:
Exception Details: System.Xml.XmlException: The root element is missing.
Here is my code:
MemoryStream ms =3D new MemoryStream();
XmlTextWriter xmlWriter =3D new XmlTextWriter(ms, Encoding.UTF8);
xmlWriter.WriteStartDocument();
xmlWriter.WriteStartElement("menu");
xmlWriter.WriteStartElement("menuItem");
xmlWriter.WriteElementString("text", "NewArticles");
xmlWriter.WriteEndElement();
xmlWriter.WriteEndElement();
xmlWriter.WriteEndDocument();
xmlWriter.Flush();
ms.Position =3D 0;
XmlTextReader xxx =3D new XmlTextReader(ms);
DataSet ds =3D new DataSet();
ds.ReadXml(xxx); <------------- Error here
ms.Close();
Menu1.DataSource =3D ds;
Menu1.DataBind();
Source Error:
Line 43:
Line 44: DataSet ds =3D new DataSet();
Line 45: ds.ReadXml(xxx);
Line 46: ms.Close();
Line 47:
Source File: c:\inetpub\wwwroot\ipass\header.ascx.cs Line: 45
Stack Trace:
[XmlException: The root element is missing.]
System.Xml.XmlTextReader.Read() +876
System.Xml.XmlReader.MoveToContent() +75
System.Data.DataSet.ReadXml(XmlReader reader, Boolean denyResolving)
System.Data.DataSet.ReadXml(XmlReader reader)
iPass.header.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\ipass\header.ascx.cs:45
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Page.ProcessRequestMain() +731
------=_NextPart_000_0037_01C3A780.6EE575D0
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.1264" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>cross posted to=20
microsoft.public.dotnet.xml</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Hi,<BR><BR>I am attempting to create a =
xml file to=20
a memory stream the bind it to a dataset. I can write a physical =
file with=20
no problem. However I recieve the following error when trying to =
bind it=20
to a dataset:<BR><BR>Exception Details: System.Xml.XmlException: The =
root=20
element is missing.<BR><BR>Here is my code:<BR><BR>MemoryStream ms =3D =
new=20
MemoryStream();<BR>XmlTextWriter xmlWriter =3D new XmlTextWriter(ms,=20
Encoding.UTF8);<BR><BR>xmlWriter.WriteStartDocument();<BR>xmlWriter.Write=
StartElement("menu");<BR>xmlWriter.WriteStartElement("menuItem");<BR>xmlW=
riter.WriteElementString("text",=20
"NewArticles");<BR>xmlWriter.WriteEndElement();<BR>xmlWriter.WriteEndElem=
ent();<BR>xmlWriter.WriteEndDocument();<BR>xmlWriter.Flush();<BR>ms.Posit=
ion=20
=3D 0;<BR><BR>XmlTextReader xxx =3D new XmlTextReader(ms);<BR>DataSet ds =
=3D new=20
DataSet();<BR><BR>ds.ReadXml(xxx); <------------- Error=20
here<BR><BR>ms.Close();<BR>Menu1.DataSource =3D=20
ds;<BR>Menu1.DataBind();<BR><BR>Source Error:<BR><BR>Line 43:<BR>Line =
44:=20
DataSet ds =3D new DataSet();<BR>Line 45: ds.ReadXml(xxx);<BR>Line 46:=20
ms.Close();<BR>Line 47:<BR><BR>Source File:=20
c:\inetpub\wwwroot\ipass\header.ascx.cs Line: =
45<BR><BR>Stack=20
Trace:<BR><BR>[XmlException: The root element is =
missing.]<BR> =20
System.Xml.XmlTextReader.Read() +876<BR> =20
System.Xml.XmlReader.MoveToContent() +75<BR> =20
System.Data.DataSet.ReadXml(XmlReader reader, Boolean=20
denyResolving)<BR> System.Data.DataSet.ReadXml(XmlReader=20
reader)<BR> iPass.header.Page_Load(Object sender, EventArgs =
e)=20
in<BR>c:\inetpub\wwwroot\ipass\header.ascx.cs:45<BR> =20
System.Web.UI.Control.OnLoad(EventArgs e) +67<BR> =20
System.Web.UI.Control.LoadRecursive() +35<BR> =20
System.Web.UI.Control.LoadRecursive() +98<BR> =20
System.Web.UI.Control.LoadRecursive() +98<BR> =20
System.Web.UI.Page.ProcessRequestMain() =
+731<BR><BR><BR><BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML>
------=_NextPart_000_0037_01C3A780.6EE575D0-- Tag: What happens on multiple connections with SQL Tag: 70930
Oracel 9.2.0 and ADO.Net
When I run a web service against an Oracle 9.2.0 database
I get message from the web service that it can not load
the DLL OCI.DLL (the oracle dll). However, I know the DLL
exists and that it can be found in the path.
When I run the same web services with a 8.1.7 database and
OCI.dll or a 9.0.1 database and OCI.dll everything works
great.
Why can't I get the .Net framework 1.1 to recognize the
Oracle 9.2.0 dll. I have used depends.exe to make sure
all required components can be found. Everything seems OK.
Any suggestions or assistance would be appreciated. Tag: What happens on multiple connections with SQL Tag: 70929
datepicker!
I need to use a datepicker control in my aspx application.
Do we have one in Visual Studio.Net? If we do how do I use
it?
Thanks Tag: What happens on multiple connections with SQL Tag: 70928
Getting a dataset into excel
Hi
I have a pivot table that gets it data from another worksheet in the
workbook.
I need to update the data worksheet from data in a database (I'm using MS
Data Application Block) and get a dataset with the data in it.
I need to know how to open the workbook, delete all the data in the data
worksheet, update the data worksheet from the data in the dataset and then
allow the user to download the new excel workbook.
Anyone have any ideas on how to do this?
Thanks
Bernard
P.S. I've tried the standard 'set response headers to excel and render
datagird', but that doesn't allow me to have another worksheet with my pivot
table. Tag: What happens on multiple connections with SQL Tag: 70925
Single Row Insert
I've written the following function to insert a single row
into a database. Here is the code:
public virtual int singleInsert(string tableName, params
IDbDataParameter[] values)
{
if(ConnectionString == "" || ConnectionString.Length == 0)
throw new InvalidOperationException("The connection
string is not set. Set the 'ConnectionString' member.");
if(values == null || values.Length == 0)
throw new ArgumentNullException("values", "The values
array was null or empty. You must pass value(s) to be
inserted.");
DataSet ds = new DataSet(tableName);
// returns a data-provider specific dataAdapter
IDbDataAdapter dataAdapter = GetDataAdapter(tableName,
ConnectionString);
// set the DA's insertCommand object using a
data-provider specific CommandBuilder
dataAdapter.InsertCommand = GetInsertCommand(dataAdapter);
dataAdapter.FillSchema(ds, SchemaType.Source);
DataRow newRow = ds.Tables["Table"].NewRow();
foreach(IDbDataParameter param in values)
{
if
(ds.Tables["Table"].Columns.Contains(param.ParameterName))
newRow[param.ParameterName] = param.Value;
}
ds.Tables["Table"].Rows.Add(newRow);
return dataAdapter.Update(ds);
}
A couple of questions ...
1 - How does the code look as far as scaling goes? Are
there any table locks occuring? (DataTable.NewRow()??)
2 - Any comments or suggestions on the code? Tag: What happens on multiple connections with SQL Tag: 70924
Common base class for DataAdapters, CommandBuilders
Can anyone at MS tell me why there is no base class or
common interface for the various CommandBuilder classes in
ADO.NET? Their method signatures are virtually identical,
and it seems like it would be trivial to create a generic
interface (using IDbCommand) that all of the various
implementations consume. As it stands, I am having to
write ugly code in a generic data access class to check
which specific type of command builder I have, rather than
referencing a common interface.
On a related note, can anybody tell me why the
IDbDataAdapter interface does not include several of the
properties of the DbDataAdapter base class? Examples
include 'AcceptChangesDuringFill', 'ContinueUpdateOnError',
and some generic version of the RowUpdating and
RowUpdated events. In the same generic data access class,
I need to cast between IDbDataAdapter and DbDataAdapter to
access these properties, and I need to cast to specific
data adapter classes to access the RowUpdating and
RowUpdated events.
It seems that the framework is 90% there in providing
generic data access, but falls short in these two areas.
Is there a compelling reason why this shortfall exists, or
can somebody at MS get this into .NET 1.2?
John Bledsoe
ATGi Tag: What happens on multiple connections with SQL Tag: 70923
RE: NVarchar in ORACLE
Hi Folks
For OracleClient
===========
I hve a table with only one NVarChar2 column. and i tried to insert the
following query but the values are not inserted in Unicode why. But when i
use Parameters collection it works.
String strQuery ="Insert Into TestTable(Col1) Values('" + txtCode.Text +
"')")
cmd.ExecuteNonQuery(strQuery)
I would like to know how the insert query is fired by MS.
Prasad Tag: What happens on multiple connections with SQL Tag: 70922
format ? in ADONET?
In VB using DAO, I was able to use format function to query the database. In
ASP.net using MS SQL server, I cannot use format function. What is the
function that I can use to get the desire result?
Here is an example SQL statement that I did in DAO.
Select FORMAT(flddate, 'mm yyyy') as tdate, sum(fldtotal) as ttot
From tbl
Group by FORMAT(flddate, 'mm yyyy')
Order by FORMAT(flddate, 'mm yyyy')
--
----------------------------------------------------
This mailbox protected from junk email by Matador
from MailFrontier, Inc. http://info.mailfrontier.com Tag: What happens on multiple connections with SQL Tag: 70920
multiple resultsets via DataAdapter ?
Hi all,
i have discussed this topic on the news group before, and found it very
helpful, now that iam implementing something, i see some problems,
iam trying execute a stored proc on SQL Server, and trying to get
multiple resultsets,
Iam using the oledbdataadapter class's fill method, the data tables are
all created correctly but none of them are having any results in them,
except the first one ,although i know other tables are having rows in them,
i have seen examples in Bill Vaugh's paper, using DataReader, can i do
the same using DataAdapter ?
any help ,pointer would be appreciated
thanks
-ashish Tag: What happens on multiple connections with SQL Tag: 70919
DAL for ORACLE
Anyone knows a DAL implementation for ORACLE 8i
I could find a lot of DALS for sqlserver but not for oracle
thanks Tag: What happens on multiple connections with SQL Tag: 70918
Alternatives to databinding
I think I'm going to abandon using databinding in my windows forms project
because it simply doesn't work as well as it ought to. There are simply too
many road blocks and too much odd are poorly documented behavior to be worth
my time any more. I patched up and worked around so many of the oddities in
framework that I don't even feel like I still in control of the code
anymore. So I'm ditching it (*I think*).
Now I need to work out an alternative scheme for getting data from my
datasource into the controls on my form and back again, so my question is
does anybody know of any good articles or tutorials on this subject. I want
to try and make sure I've considered everything before I start what might be
a major undertaking so I can decide on the most elegant and flexible
solution.
Cheers
Matt Tag: What happens on multiple connections with SQL Tag: 70917
best practices for cleaning up connections, commands and transactions after errors occur?
I would like people's opinions on how best to clean up SQL Server
connections and transactions after errors occur while using them. For
example, assume you have the following:
Public Function test()
Dim conn As New SqlClient.SqlConnection("connection string here")
Dim cmd As New SqlClient.SqlCommand("MyStoredProc", conn)
Try
conn.Open()
cmd.ExecuteNonQuery()
conn.Close()
Catch ex as Exception
' Possibly do something more than rethrow.
throw ex
Finally
conn.Dispose()
cmd.Dispose()
End Try
End Function
Now let us assume that ExecuteNonQuery() throws a SQL Exception.
1. After the exception, should I still try to call Close() on the connection
in the Catch block?
2. If the answer to #1 is yes, shouldn't one rather move the Close() to the
finally block where it will always be called?
3. Is there a chance that calling Close() will itself throw an exception -
either within the finally or catch blocks?
At the end of the day, what is important is to ensure that this connection
is returned to the connection pool as quickly as possible no matter what the
outcome of the function call.
Thoughts and ideas would be appreciated.
Andrew Tag: What happens on multiple connections with SQL Tag: 70916
New to .Net - help!
I want to access a database from a web page but looking at
examples in books it's always for the SQL server. I'm
using Access. The examples use the server explorer and
toolbox data to gain access to the database(sqlconnection)
and the sqldataadapter to extract data from the database.
When I use the equivalent for access (oledbdataadapter and
oledbconnection) it doesn't work. If I write my own code
then I can get it to work.
I know I can solve this by just writing my own code but if
there are "tools" that produce the code then I'd like to
get these to work.
What's the best way of going about this?
Thanks in advance Tag: What happens on multiple connections with SQL Tag: 70915
How to have two-way cursors, dynaset, the CRecordSet like features
[SUMMARY]:
I am basically trying to write class[es] that shall wrap the
consummate DB access code much like
Visual C++ CRecordSet including two-way cursors, dynaset, multi-table
read-only query including
two-way read-only scrolling etc among others.
[DETAILS OF QUERY]:
Slightly faultered across the multitude of .NET DB classes to work
with in short span.
Can somebody tell me as to how I shall be able to create using .NET
namespaces following
proposition:
1> Two way read-only scrollbale cursor that is fetching data from two
tables [upon a simple WHERE
clause]
I thought about going through SqlDataAdapter's Fill() method that
shall fill up the DataSet with
fetched rows. But it seems from docs that DataSet shall fill both of
the tables in query 'separately'
with results and relations. I just want CRecordSet's View-like
scrollble rows [with combination of
selected fields from both tables].
2> Dynamic cursor that is scrollable across either direction and is
spanned across a single table query
I looked into higher end version of SqlDataReader but did not find
any. So do I have to go through
DataSet's Fill and then operate on individual DataRows for my updates
etc before 'reconciliation'?
Kindly let me know.
Thanks for your time.
- KA Tag: What happens on multiple connections with SQL Tag: 70911
Passing an array to Oracle procedure's parameter
Hello.
Is there any way to pass an array to an Oracle procedure's
parameter? (I am using System.Data.OracleClient classes).
Thanks in advance.
Celio C. J. Tag: What happens on multiple connections with SQL Tag: 70905
Permission to access database problem
Hi
When I try to connect to the database I'm getting the
message that the database file cannot be opened because
"It is already opened exclusively by another user, or you
need permission to view its data."
This appears on the web page since this is how I'm trying
to view data.
I know no-one else has the database open so therefore I
need to set up the database so that permission is allowed
to access data. It's an Access database. How do I go
about doing this?
Thanks in advance Tag: What happens on multiple connections with SQL Tag: 70904
Expression column event
is it possible to get the change event for the expression column. Thanks in
advance. Tag: What happens on multiple connections with SQL Tag: 70898
XMLHTTP in ASP.NET
Hi,
Do we have any replacement of XMLHTTP in ASP.NET. If yes,
could anybody plase give an example of sending a xml
island from client to server and recieving the island at
server.
Thanks in advance.
regards,
mk Tag: What happens on multiple connections with SQL Tag: 70891
queries across multiple tables
Hi All,
I need to make a sql query build which needs to do the following :
- span across 20-30 tables
- Filters
- provide a UI (end user would use this)
So the idea is that the end user can pickup any field from any table and
apply some conditions (filters) to it and then retrieve the resulting
data --- fields that make up the resulting data can also be defined by the
end user.
Does anybody have any suggestions on how this can be implemented ?
thanks, Tag: What happens on multiple connections with SQL Tag: 70884
Is there a published COM Interop Wrapper for Interop.MSDASC.dll?
Is there a published COM Interop Wrapper for
Interop.MSDASC.dll, and if so where is it in MSDN or
otherwise to download?
Dear Authorities:
I would like to us the MSDASC.DataLink
(Interop.MSDASC.dll) in a .Net application.
In doing this I am trying to add a reference to
the 'Microsoft OLE Db Service Component 1.0 Type
Library'. When I attemp to add it, I get this error
message:
"A reference to 'Microsoft OLE Db Service Component 1.0
Type Library' could not be added. Coverting the type
library to a .Net assembly. Access to the
path "C:\Program
Files\Word\Samples\C#\NewAccessMaintenanceCSharp\obj\Intero
p."
When I click the Help button on this Error message, I get
this additional message:
"You can also search the MSDN Web site for a COM interop
wrapper that has been published for your specific COM
component."
I searched MSDN for MSDASC.dll as a published COM Interop
Wrapper and found nothing. Do any of you know if there is
such a published Wrapper, and if it does exist, where I
could download it. Better yet, if you have one could you
please send it to me.
Sincerely,
Burton G. Wilkins Tag: What happens on multiple connections with SQL Tag: 70883
SPROCS
Hi,
I wanted to know how i can call stored procedure and pass
it 2 parameters when a button is clicked.
my code for the stored procedure is:
INSERT INTO Available_Meals(Meal_desc, Cost) VALUES
(@Meal_desc, @Cost);
SELECT Meal_desc, Cost FROM Available_Meals WHERE
(Meal_desc = @Meal_desc)
any help would be excellent.
Also does anyone know why the sprocs i create do not
appear straight away the the server explorer? I have to
close VS.net down and then reopen the project to make
them visible. Tag: What happens on multiple connections with SQL Tag: 70882
Insert Data from a User Created DataSet?
Hi All,
I am trying to do the fowoing:
1. Create a DataSet (no problem here) Code below:
'-----------------------------------Create DataSet
Dim myDS As New Data.DataSet("CIRCUITS")
Dim myCircuits As Data.DataTable = myDS.Tables.Add("CIRTBL")
Dim myDr As Data.DataRow
With myCircuits
.Columns.Add("CircuitBucket", Type.GetType("System.String"))
.Columns.Add("CircuitType", Type.GetType("System.String"))
.Columns.Add("SiteID", Type.GetType("System.String"))
.Columns.Add("SiteIDB", Type.GetType("System.String"))
.Columns.Add("Requestor", Type.GetType("System.String"))
.Columns.Add("Provisioner", Type.GetType("System.String"))
End With
'-----------------------------------Populate DataSet
For Each lvNode In lv.Items
myDr = myCircuits.NewRow()
myDr("CircuitBucket") = lvNode.SubItems(45).Text
myDr("CircuitType") = lvNode.SubItems(46).Text
myDr("SiteID") = lvNode.SubItems(39).Text
myDr("SiteIDB") = lvNode.SubItems(40).Text
myDr("Requestor") = lvNode.SubItems(41).Text
myDr("Provisioner") = lvNode.SubItems(42).Text
myCircuits.Rows.Add(myDr)
Next
2. Now I want to insert the data using a Stored Procedure (SQL)
'-----------------------------------INSERT DataSet
cnS = New SqlConnection(cnMAIN$)
cnS.Open()
Dim SQLCMD As New SqlCommand
SQLCMD.Connection = cnS
SQLCMD.CommandText = "SELECT * FROM myTable"
SQLCMD.CommandType = CommandType.Text
daS = New SqlDataAdapter
daS.SelectCommand = SQLCMD
daS.Fill(myDS, "myTable")
Dim cmdINSERT As New SqlCommand("usp_INSERT_CIRCUIT")
cmdINSERT.CommandType = CommandType.StoredProcedure
cmdINSERT.Parameters.Add(New SqlParameter("@CircuitBucket",
SqlDbType.VarChar, 10, "CircuitBucket"))
cmdINSERT.Parameters.Add(New SqlParameter("@CircuitType",
SqlDbType.VarChar, 10, "CircuitType"))
cmdINSERT.Parameters.Add(New SqlParameter("@SiteID",
SqlDbType.VarChar, 100, "SiteID"))
cmdINSERT.Parameters.Add(New SqlParameter("@SiteIDB",
SqlDbType.VarChar, 100, "SiteIDB"))
cmdINSERT.Parameters.Add(New SqlParameter("@Requestor",
SqlDbType.VarChar, 100, "Requestor"))
cmdINSERT.Parameters.Add(New SqlParameter("@Provisioner",
SqlDbType.VarChar, 100, "Provisioner"))
daS.InsertCommand = cmdINSERT
cmdINSERT.Connection = cnS
My problem here is definatly, and at leaset, the SelectCommand is failing
with an error stating that it does not know what the Table object supplied
is. In the above example it is myTable. I don't even need a select command
because I am inserting only; but I get an error if I exclude the
SelectCommand.
The reason I am doing this is that I need to pass the data into a stored
procedure that will in turn decide which Insert statement to use based on
the @CircuitBucket Parameter.
Any ideas regading the proper way of dealing with this please help.
Thanks,
John. Tag: What happens on multiple connections with SQL Tag: 70877
Binding group of option buttons to one Dataset column
Hi,
Is it possible to bind a group of option buttons (in win forms) to on
Dataset Column?
Thanks,
Shimon Tag: What happens on multiple connections with SQL Tag: 70872
plz help. SQL problem
hi,
I have 2 comboboxes (CB). CB1 shows the roomNames (pulled
from my access DB) and CB2 should show the layouts that
are possible (RoomLayout) for that specifc room (these
values are also stored in the database, but in a
different table). What i want to do is load the correct
layouts for a particular room into CB2 (from my DB) based
on the room selected by the user in CB1. This requires me
to requery the database everytime the value of CB1 is
changed. The problem im having is that CB2 does not seem
to be populating.
Heres my code:
Private Sub Form2_Load(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles MyBase.Load
''''this loads CB1 with the room names
DsRoomN1.Clear()
OleDbDAdapterRoomN.Fill(DsRoomN1)
End Sub
Private Sub CB1_SelectedIndexChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
CB1.SelectedIndexChanged
Dim ObjParam As OleDb.OleDbParameter
ObjParam =
OleDbDAdapterPL.SelectCommand.Parameters.Add("@RoomNm",
OleDb.OleDbType.Char)
DsPossLayouts.Clear()
OleDbDAdapterPL.Fill(DsPossLayouts)
the query that i wrote in the query builder for CB2 is:
SELECT Room_Layouts.Poss_layout, Rooms_avail.Room_name,
Room_Layout.RoomID, Rooms_avail.RoomID AS Expr1 FROM
Room_Layouts INNER JOIN Rooms_avail ON
Room_Layouts.RoomID = Rooms_avail.RoomID WHERE
(Rooms_avail.Room_name = ?)
the question mark is the parameter that will need to be
inserted from CB1 (i.e the room_name).
Can anyone help me figure out how to make this work?
thx in advance Tag: What happens on multiple connections with SQL Tag: 70863
ADODB.Stream to .Net Streams
Does anyone have an efficient way of converting an ADO
Stream object into a .NET stream object? For security
reasons, I'm not allowed to create a temporary file, so
just using memory streams would be more appropriate.
Thanks in advance!
Thanh Tag: What happens on multiple connections with SQL Tag: 70860
ADO.net Book recommendation
Hi,
can anyone recommend a good ADO.net book that is suitable
for beginners.
I need help in creating my standlone windows
application.As i am using an access database the example
have to be suitable for this and not just SQL server
(Like most other books).
All the books i have so far show the code that goes into
a console application with a connection to sql server
dbms. :o(
Any recommendations?? Tag: What happens on multiple connections with SQL Tag: 70859
size of table in memory - sql server 2000, xp pro, vb .net
This is a question for sql server 2000 and vb .net and xp pro, so I am
posting to all ng's.
Is there any way of knowing or approximating the amount of memory exhausted
in retaining a large disconnected (ado .net) table/dataset? It a .dbf file
is in memory, I could identify the size of the file directly, but with sql
server 2000 and the swapping technologies of windows xp pro, I only know the
size of the .mdf, which is of no value. Say the .mdf is 4.6 gig and it
contains 160 tables, 200 sp's, a few view, triggers, etc. One table - a
large one - has 25 cols and 1.2 million rows. Its physical size is no where
designated. I load this in a vb .net app into a dataset. It takes a long
time, obviously.
But once loaded, approx how much memory has been used? Did it write xml and
is it continually swapping out to get the appropriate xml and then display
it, allow changes to it, etc?
Tx for any help.
Bernie Yaeger Tag: What happens on multiple connections with SQL Tag: 70858
ANN : Klik! CompareLib v1.0.7 has been released...
09/11/2003 - Klik! CompareLib v1.0.7 has been released...
Klik! CompareLib is a tool which compares and sychronizes the structural
differences in your MSAccess 97/2000/XP databases. It's simple and yet
detailed wizard style interface will allow you to compare, make deep
analysis and generate the merge scripts to make the compared databases
structures equal. A script applying tool, ScriptRunner, is included with the
package to easily apply the generated scripts later...
With this new version all known merge script issues has been resolved and
added new options on how to do the comparison...
For more information about Klik! CompareLib, just visit us at
http://www.kliksoft.com ...
Best Wishes,
Klik! Software Tag: What happens on multiple connections with SQL Tag: 70857
this namespaec
does this provider namespace use EDI format to communicae
with the sql server or does it use XML to transfer data Tag: What happens on multiple connections with SQL Tag: 70854
Datasets and null values
Hi,
When I set the nillable value to true of a string column
in a dataset, the VS.NET project does compile.
But when I want to set nillable true of a short column,
the project doesn't compile.
How can I get a short column of a dataset set to NULL?
thanks for any answers
Filip Tag: What happens on multiple connections with SQL Tag: 70852
Constraint with Expression DataColumn
Hi,
I have 3 datables (TableA, TableB,TableC).
I create a DataRelation with TableA and TableB and I add a DataColumn into
TableB where I stock a parent field called idkey
I try to create a DataRelation using TableC with the field idkey and I get a
error like it can't create a constraint using an expression datacolumn.
Do you have some ideas ?
Stan Tag: What happens on multiple connections with SQL Tag: 70851
DataGrid Scrollbar problem
I've a problem using a datagird, for some reason I keep getting the scroll
bars of the datagrid on top of the grid itself.
Moreover, the window is big enough that I don't need the scrollbars.
It's kind of hard to explain, please look here for example:
http://ayende.freewebspace.com/bad%20datagrid.JPG
This is where I create the tab pages, FillDataTable() fills the datagrid
with rows.
The code that I'm using is:
tp = new TabPage(q.Name);
dg = new DataGrid();
dg.BeginInit();
dg.SuspendLayout();
dg.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
dg.HeaderForeColor = System.Drawing.SystemColors.ControlText;
dg.Location = new System.Drawing.Point(8, 8);
dg.Name = q.Name;
dg.Dock = DockStyle.Fill;
dt = new DataTable(q.Name);
Name = new DataColumn("Name",Type.GetType("System.String"));
Value = new DataColumn("Value",Type.GetType("System.String"));
dt.Columns.AddRange(new DataColumn[]{Name,Value});
FillDataTable(dt,q);
dg.DataSource = dt;
dg.ReadOnly = true;
dg.PreferredColumnWidth = 150;
dg.AllowSorting = false;
dg.CaptionText = q.Name;
dg.ColumnHeadersVisible = false;
dg.RowHeadersVisible = false;
dg.ResumeLayout();
dg.EndInit();
tp.Controls.Add(dg);
QuotesTab.TabPages.Add(tp);
P.S.
How do I make the columns spread on all the screen?
(Actually, I just want the second column to do that.) Tag: What happens on multiple connections with SQL Tag: 70832
SQL error
Hi,
Im trying to enter a query into the query builder for in
the OLEDBdataAdapter wizard. My query is as follows:
SELECT
a.Caravan_Inv_No,
a.Caravan_Model,
a.Length,
b.Beds,
b.[Cost/day]
FROM
Caravan_Inv a,
Caravan_details b
WHERE
a.Caravan_Inv_No = b.Caravan_Inv_No AND
a.Length = b.Length AND
a.Caravan_Inv_No NOT IN
(SELECT c.Caravan_Inv_No
FROM Caravan_booking c , Booking_details d
WHERE c.BookingNo = d .BookingNo
AND Dt_of_arrival BETWEEN ? AND ?
AND Dt_of_depature BETWEEN ? AND ?)
i keep getting the following error:
Failed to get schema for this query.
does anyone have any idea of what the problem is??
btw, i have used '?' to represent a value that has to be
passed in from 2 of my dtpickers. is this the right way
to write this? (i have an access db)
thx Tag: What happens on multiple connections with SQL Tag: 70830
Extra coloumns
hi,
i have written a query n the oledbadapter and i keep
getting rows that should not be displayed in my datagrid.
the query is as follows:
SELECT Caravan_Inv.Caravan_Inv_No,
Caravan_Inv.Caravan_Model, Caravan_Inv.Length,
Caravan_details.Beds, Caravan_details.[Cost/day],
Caravan_details.Caravan_Model AS Expr1,
Caravan_details.Length AS Expr2 FROM Caravan_Inv INNER
JOIN Caravan_details ON Caravan_Inv.Caravan_Model =
Caravan_details.Caravan_Model
the additional coloumns are the Expr1 and Expr2. Even
when i delete them from my query, they still seem to show
up in my result.
Why do they appear? I am using the query builder of the
OLEDBAdapter.
thx Tag: What happens on multiple connections with SQL Tag: 70829
connection string in web.config error
I added the connection string in web.config as follows:
<appSettings>
<add key="connString" value="Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=MY_DATABASE;Data Source=IP_ADDRESS" />
</appSettings>
In mypage.aspx.vb page, I open the connection with connString variable:
Dim conn As New SqlConnection(connString)
But it has compile error:
name 'connString' is not declared.
Any ideas? Tag: What happens on multiple connections with SQL Tag: 70824
timeout in sp but not in normal select
hi!
I use
- .net framework 1.1
- sql server 2000 sp 3a
- windows 2000 server
- asp.net/c#
- system.Data.SqlClient
- latest sp's & hotfixes
when I use a stored procedure (result 50 rows, execution time 2 seconds,
about 600,000 rows in the table) in a c# code I'll get a "timeout expired"
SqlException.
...
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.CommandText = "sp_x";
myCommand.CommandTimeout = 0;
myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
x = myReader["x"].toString(); // <<-- TIMEOUT
}
...
the same sql in a "normal" select statement will work.
...
myCommand.CommandType = CommandType.Text;
myCommand.CommandText = "select x from ...";
myCommand.CommandTimeout = 0;
myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
x = myReader["x"].toString(); // <<-- OK
}
...
if I reduce the amount of rows (result about 5 rows, execution time less
than 0.2 seconds, about 10,000 rows in the table) the stored procedure will
work in c#.
but the "large" stored procedure will work with all other softwareproducts
(like ms access, dts wizard, and so on).
thanx for your help
mac Tag: What happens on multiple connections with SQL Tag: 70823
beginner questions
Hi,
Im new to VB.net and wanted to find out about the best
way to code my connection to my access db.
I wanted to know if it is necessary to place the
connection string and create a new instance of the
olebconnection class on every page that uses a sql
statement.
Is it possible to place this code in a module and then
just use the varible the Conn String is placed in from
all the forms??
What about all the sql statements? can i also code then
in the module and call then whereever the are required in
my application??
Thx for your help Tag: What happens on multiple connections with SQL Tag: 70816
Execute requires the command to have a transaction object when the connection as
This is the sequence of events :
foo() {
SqlConnection conn = conn.Open();
SqlTransaction tx = conn.BeginTransaction();
... // do something
AnotherModule.bar(conn);
}
AnotherModule.bar(SqlConnection conn) {
SqlCommand cmd = conn.CreateCommand();
.. // calls a stored procedure
..
conn.ExecuteNonQuery(); // <<== Exception here
}
The exception is :-
"Execute requires the command to have a transaction object
when the connection assigned to the command is in a
pending local transaction. The Transaction property of
the command has not been initialized."
Why is it required for the bar() method to know the
transaction. It just wants to re-use the same connection
object. In fact the transaction is handled inside the
stored procedure that it is calling.
The api expects that, in the SqlCommand that is created in
bar() method also set the same transaction that the
connection is using. Why is this required?
I do not want to tie the transaction created in foo() to
the SqlCommand created in bar(). Is not a realistic
situation? What if Im calling a third party stored
procedure?
Looks to me that the the only way it could be solved is by
opening a new connection in bar(), instead of getting the
connection object as a parameter from the caller.
Anybody faced this problem?
- shiv Tag: What happens on multiple connections with SQL Tag: 70815
parent/child tables and identity problems: a scenario
I'm having strange errors with a C# app using form controls bound to a typed
dataset, which holds a parent-table with a single record and a number of
children tables with many records. As I'm new to ADO.NET, first of all I'd
like to know if I'm doing something wrong in my general approach. Here's a
simplified scenario, it's a bit long but I hope it can be useful to newbies
like me, facing the identity problems when updating a dataset. Thank you
very much for your patience!
(a) I use MSDE and the corresponding SqlClient namespace objects. All the
identity values in my tables are autonumber; in the dataset, autonumber seed
and step are set to -1 after their construction, so that the records added
in the "in memory" dataset will be granted to have a different identity from
any database record.
(b) All the insert commands use an output parameter (@newID) set to the new
identity value, e.g. the T-SQL code looks like:
ALTER PROCEDURE AnInsertCommand
(
...
@newID int OUTPUT
)
AS
INSERT INTO ... ;
SET @newID = SCOPE_IDENTITY()
The corresponding command objects include this @newID in their params
collection and map it to the table primary key field, so that when the
command is executed the dataset table will be updated to hold the "real"
autonumber value assigned by database (thus replacing the negative value
used in-memory).
(c) After generating the dataset, I have manually added the required
required foreign-key relations to it using the VS dataset designer, so that
the parent/child relationship are set up correctly: each primary key in a
child table is linked to the corresponding foreign key in the parent table.
(d) Let's say the parent table in dataset is "Customer", and the child table
is "Country". Customer has a countryID acting as the foreign key to the
Country child table. In my application, the user selects a single customer
to edit, or wants to enter a new customer; the form shows his data in bound
controls, and the data for child tables are typically shown in combo boxes
(e.g. a list of countries the user can select from). Thus, the dataset will
always contain a single parent record (=1 customer) and all the children
records (=countries list). The user can also add new countries when editing
a single customer record.
(e) When data are to be stored into database, the update policy is:
1) call BindingContext EndCurrentEdit for each table in the dataset, e.g.:
BindingContext[myDataSet, "Table Name"].EndCurrentEdit();
2) open the connection to database and begin a transaction
3) call Update for each CHILD table for NEW records only, e.g.:
countryDataAdapter.Update(myDataSet.TCountry.Select("","",DataViewRowState.A
dded));
this inserts the newly added countries only and updates the dataset Country
table so that the autonumber values reflect the "real" (non-negative) values
assigned by database; thus, a countryID = -10 becomes e.g. 67; also, the
relationships I have setup in the dataset cascade this update to the linked
parent table, so that the foreign key -10 becomes 67 too.
4) call Update for the PARENT table for NEW or MODIFIED records only
(deleted records will be processed later);
5) call Update for each CHILD table for all other records (e.g. MODIFIED or
DELETED);
6) call Update for the PARENT table for DELETED records.
7) commit the transaction and call AcceptChanges for the whole dataset.
8) close the connection anyway (in a finally {} block; in the catch{} block
the transaction is rolled back).
Now, this seems to work fine: I edit and add records, and autonumber values
are treated as expected and their changes propagated to the parent as
required. Here's the problem: when I'm editing an existing parent record and
add a new child record (e.g. a new country) and then store data, all works
fine; when I create a NEW parent record and do the same, the Update method
for the child table raises an "Object reference not set to instance of an
object" exception: as far as I can check with the debugger, all the values
in the dataset are as expected: the parent record has a negative ID, as for
the newly added child record, and both are linked correctly
(parent.countryID = child.countryID). As everything works when updating an
existing parent record, I'd expect the code to work for a new record too, as
the only difference is that a new record has a negative ID in the parent
table (which anyway should not matter for updating the child table, which is
linked via a foreign key).
Could anyone tell me if anything is "philosophically" wrong with this
approach? I cannot understand the reason for such errors... Tag: What happens on multiple connections with SQL Tag: 70808
Check that important package from the MS Corp.
--kuzjvayvalnvmpth
Content-Type: multipart/related; boundary="rmwiqqxrydfdpegp";
type="multipart/alternative"
--rmwiqqxrydfdpegp
Content-Type: multipart/alternative; boundary="wbslfxvwlsfrsngt"
--wbslfxvwlsfrsngt
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable
MS Client
this is the latest version of security update, the
"November 2003, Cumulative Patch" update which eliminates
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three new vulnerabilities.
Install now to help protect your computer
from these vulnerabilities, the most serious of which could
allow an attacker to run executable on your computer.
This update includes the functionality =
of all previously released patches.
System requirements: Windows 95/98/Me/2000/NT/XP
This update applies to:
- MS Internet Explorer, version 4.01 and later
- MS Outlook, version 8.00 and later
- MS Outlook Express, version 4.01 and later
Recommendation: Customers should install the patch =
at the earliest opportunity.
How to install: Run attached file. Choose Yes on displayed dialog box.
How to use: You don't need to do anything after installing this item.
Microsoft Product Support Services and Knowledge Base articles =
can be found on the Microsoft Technical Support web site.
http://support.microsoft.com/
F