How is fastest way to construct an XML node then a bunch of slow xquery
How is fastest way to construct an XML node then a bunch of slow xquery
modify statements?
This SQL Server 2005 logic is rather slow to simply add a new item to an xml
document. Any way to do this all in one statement and faster for creating a
new node without having to re-select to set the attribute values?
set @currentItems.modify('insert <Item></Item> as first into
(/Items/ParentItem[(@id=sql:variable("@parentItemID"))])[1]')
set @currentItems.modify('insert (attribute id {sql:variable("@itemID")},
attribute length {sql:variable("@metadataLength")}, attribute activityDate
{sql:variable("@activityDate_xml")}) into
(/Items/ParentItem[(@id=sql:variable("@parentItemID"))]/Item)[1]')
set @currentItems.modify('replace value of
(/Items/ParentItem[(@id=sql:variable("@parentItemID"))]/@totalCount)[1] with
((/Items/ParentItem[(@id=sql:variable("@parentItemID"))]/@totalCount)[1] +
1)')
set @currentItems.modify('replace value of
(/Items/ParentItem[(@id=sql:variable("@parentItemID"))]/@lastModified)[1]
with sql:variable("@lastModified_xml")')
One idea is to do this in a CLR function that uses a simple string builder
to create the node, but then it has to be reserialized and there is CLR
overhead. Any ideas on how to make this faster? Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142231
FillSchema and stored procedure IF statements
I'm trying to use FillSchema to get the results schema for a stored
procedure that, simplified, does this:
CREATE PROCEDURE SomeProc
@Flag bit
AS
IF @Flag = 1
SELECT 'foo' = 'bar'
SELECT TOP 5 'baz' = snafu FROM SomeTable
GO
If I then call
objSQLCommand.CommandType = CommandType.StoredProcedure
objSQLCommand.CommandText = "SomeProc"
objDataAdapter.MissingSchemaAction = MissingSchemaAction.Add
objDataAdapter.SelectCommand = objSQLCommand
objDataAdapter.FillSchema(objDataSet, SchemaType.Source)
objDataAdapter.Fill(objDataSet)
with @Flag = 1, I get the correct dataset back: two tables, the first
with one column called 'foo' and one row, the second with one column
called 'baz' and 5 rows. However, if I call this code with @Flag = 0,
what I get back are two tables, the first with two columns called
'foo' and 'baz' and 5 rows, and the second with one column called
'baz' and no rows at all.
This seems to be because the FillSchema goes down into the IF @Flag
branch in my stored procedure for schema information regardless of the
value of @Flag and that then the DataAdapter.Fill is putting its one
table of data into the first available table.
My question is, what other options do I have for getting the schema
information here? Can I change this behavior of FillSchema's? In
this particular instance I could skip the FillSchema step entirely if
I know that @Flag <> 1, but I'd really prefer a more general solution
that would allow me to put more branches in my stored procedure if
they're needed someday.
Thanks,
Caitlin Shaw Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142229
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
We have a several vb.net apps, that were recently upgraded from Framework
1.1 to Framework 2.0. Randomly these apps have started throwing the error
below, the line of code is a connection.open, the connection string has a
timeout of 500, which should be plenty of time. All of the apps use the same
data layer class (happens on the same line of code). It doesn't happen every
time, it's just random and it happens on the connect open not when executing
the command(an insert into a large table).
Anyone have any suggetions?
The Source was: .Net SqlClient Data Provider
With the Message: Timeout expired. The timeout period elapsed prior to
completion of the operation or the server is not responding.
Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException
exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at PSXSTL.Digecenter.LookupDataReference.insertDB() in
C:\$\Digecenter\PSXSTL.Digecenter\Archives\LookupDataReference.vb:line 558
Target Site: Void OnError(System.Data.SqlClient.SqlException, Boolean)
Additional Info: Error occurred in
PSXSTL.Digecenter.LookupDataReference/insertDB
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at PSXSTL.Digecenter.LookupDataReference.insertDB() in
C:\$\Digecenter\PSXSTL.Digecenter\Archives\LookupDataReference.vb:line 558
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Thanks in advance!
Rick Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142219
User default schema
Hi
Using SQLServer2005, connecting via sql server authentication.
In the Instance I created a database (MyDatabase) and a Login.
In MyDatabase I created a schema (MySchema), Tables (attached to
MySchema) and a User (based on the Login).
I set the Login's default database to MyDatabase.
I set the User as MySchema's owner.
When I connect to the database via SMSE, I can successfully issue SQL
statements without using the MySchema prefix on the Table names.
If I connect to the database via C# and SqlClient (again using sql
server authentication), and issue a query command (without a MySchema
prefix) I get an error stating that my table object does not exist,
(indicating that it is ignoring the default schema for the User). If I
use the prefix the query runs fine.
My mindset is that the default schema used by the connection should be
that stated in SqlServer for the given user (in this case MySchema).
However the observed behaviour is suggesting that I need to do more in
order to ensure that MySchema is used as the User's default schema.
So two questions:
Am I understanding of this problem correct?
How can I ensure that when I connect via ADO.NET that the connection
will use the default schema attached to the user?
Regards
Aidan Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142204
Creating a new Access database file (.mdb) in .NET/C#
I'm making changes to a small, portable, single-user database
application I wrote a couple of years back built around a muli-table
Access database and written in C# and .NET 1.1. Most of the changes
are are minor, but one involves "subsetting" the database, that is,
creating a new database file (.mdb) with a subset of the current
database's rows. Read in a schema and some tables from one database
/ file, write them out to a brand new database / file. Right?
Well, either I'm being incredibly dense, or this is an extremely
non-trivial task. Since it's difficult for me to imagine that
'CREATE' support wouldn't be hidden _somewhere_ in .NET's OleDb
support, I'm hoping that if I describe what I've tried someone will
put me out of my misery with a few, well-chosen -- but helpful --
comments on my obtuseness. <grin?>
Reading tables from the original database ("Filling") into
DataTables in a DataSet is fairly straightforward, and the 'web
abounds with examples of how to do this. Creating a new DataSet
with a duplicate schema isn't hard, either:
DataSet dsClone = dsOriginal.Clone();
followed by selected row-copies from the old to the new via
DataViews:
dsClone.Tables[tname].ImportRow( dv[i].Row );
Then you open a connection to the new database-to-be:
OleDbConnection connDb = new OleDbConnection();
connDb.ConnectionString = DbConnString1
+ filename
+ DbConnString2;
connDb.Open();
Whoops!
- If the file name doesn't already exist, you get an exception.
- If the file exists but hasn't been Access-initialized, you get
an exception ("wrong file structure" or something similar).
So either there is a secret substring I need to include in my
ConnectionString ("...Mode=Create;..." ?) to prepare the file for
a CREATE-like operation, or the file structure has to be "built" /
initialized prior to opening the Connection.
There's got to be some step there that I'm overlooking.
Hints would be appreciated. If I can't figure out how to do this, my
fallbacks include:
1) Byte-copying the current .mdb file -- while it's open -- under a
new name, opening ("connecting to") the new file, and then
emptying some tables and chopping out rows from others (and
maybe doing a compress-in-place on the result),
2) Adding an Empty-Db.mdb file ("...just the Schema, Ma'am") to the
package that would only be used for subsetting the database,
following the steps in option (1), or
3) Reverse-engineering the .mdb file structure and coding the
creation of a new one "by hand". (No, I'm not serious -- or not
entirely serious-- about this one, just frustrated enough to
start thinking anlong those lines.)
4) Embedding a binary string containing a complete (but table-less)
.mdb file into my applic... no, let's not go there. (But it
_would_ be portable. <grin!>)
Please, someone, point out to me that I've been repeatedly reading
past an OleDbConnection.OpenNew() method that does exactly what I'm
trying to do... or something along those lines! <grin>
Frank McKenney
--
"The most amazing achievement of the computer software industry is
its continuing cancellation of the steady and staggering gains
made by the computer hardware industry..." -- Henry Petroski
--
Frank McKenney, McKenney Associates
Richmond, Virginia / (804) 320-4887
Munged E-mail: frank uscore mckenney ayut minds pring dawt cahm (y'all) Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142200
How much of the functionality of SQL Server is mirrored in ADO.Net
Ok, bear with me. This is a bit lengthy. This roughly explains a real-life
legacy data structure problem Iâ??m having.
Assume a SQL Server 2000 database with 2 tables, Table1 and Table2.
Table1 has fields id1 (Integer, primary key, but NOT an identity field) and
content (varchar 10).
Table2 has fields id1 (integer), id2 (integer, identity field) and content
(varchar 10). The primary key of Table2 is id1/id2.
The 2 tables are joined by a relationship in which table1/id1 is the foreign
key of table2/id1. Also the options are set to cascade updates and deletes.
Now I go into SQL Server Enterprise Manager and:
1. Create a Table1 record with an id1 = 1
2. Create a Table2 record with an id1 = 1
3. I then go back into Table1 and change id1 to a value of 2. The change is
immediately reflected in the Table2 record. Thatâ??s exactly what I expected
and wanted.
Now the big question â?? can I get ADO to do the same thing in memory?
Now I create a Winforms app in VB/Dot Net 2.0. I add a dataset (xsd) to the
project and drag tables 1 and 2 onto the designer simultaneously so that the
relationship comes too. I then create a minimal class inheriting from the
dataset so I can fill Tables 1 and 2 from the server. I add a pair of
DataGridViews to the form to display Tables 1 and 2.
If I update Table1, id1, update to the database and reload the data, the
changes are reflected in Table2 as expected.
What I cannot figure out is how to immediately show the changes in the
Table2 grid without an update. In other words is there a way to make the
system do this?
Am I looking for something that does not exist? Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142193
Missing first record
Using asp.net and .net framework 2 and SQL server 2000
I am using simple SELECT statement in SP to retrieve data and then bind to a
datagrid but fail to pick up the first record in the dataset:
invConn = New
SqlConnection(ConfigurationManager.ConnectionStrings("Connectstring").ConnectionString)
invConn.Open()
invComm = New SqlCommand(zStrg, invConn)
invComm.CommandType = Data.CommandType.StoredProcedure
invComm.Parameters.AddWithValue("@ClCode", strClCode)
iP = invComm.ExecuteReader
iP.Read()
dgPInv.DataSource = iP
dgPInv.DataBind()
iP.Close()
invConn.Close()
The SP is pulling back the full dataset but code above misses first rec.
with thanks Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142191
Save mix data in database
Hi EveryBody:
What is the data type that I have to use when I want to save mix data in
database for example photos,music,text fiel,doc file and movies ?
any help will be appreciated regard's
Husam Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142181
Get Query string from Dataset/Datatable
Hello
When i fetch data from database i do the following:
DataSet ds = new DataSet();
OledbConnection con = new OledbConnection(ConnectionString);
using ( OledbCommand cmd = con.CreateCommand())
{
cmd.CommandText = "SELECT * FROM [tblCustomers] WHERE [CustomerName]
LIKE 'A%';";
using ( OledbDataAdapter da = new OleDbDataAdapter(cmd))
{
da.Fill(ds);
ds.Tables[0].TableName = "tblCustomers";
}
}
The above just ment as an illustration.
The DataSet ds now contain one table with the result of the query within the
cmd.
Now my question, is the cmd Query stored somewhere within the DataSet/Table?
Kind regards
Johnny E. Jensen Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142179
ANN: High performance of remoting ADO.NET objects cross desktop and smart devices
Hi, All:
UDAParts has updated .NET versions of SocketProAdapter at www.udaparts.com
for supporting binary remoting .NET ADO.NET objects, DataSet, DataTable and
DataReader.
Key features and improvements over MS technologies are:
1. Bi-directional remoting DataSet, DataTable and DataReader across desktop
and smart devices.
2. Bi-directional remoting DataSet, DataTable and DataReader across
different .NET runtime versions (1.0, 1.1, 2.0, .....).
3. Significantly faster (1 - 6 times) than MS .NET remoting and MS WCF.
4. Significantly reduce transaction latency without using worker threads.
5. Consume significantly less memory and much smaller footprint.
6. 100% open source code (C++/CLI and C#) for your reviewing. It is highly
extensible.
7. Secure through SSL/TLS.
8. Built-in real-time notification,
9. Integrated or user defined authentication.
10. Built-in online compression.
......
Samples for VB.NET and C# are available at
..\udaparts\SocketPro\samples\RAdo after you downloading latest version
(4.8.2.19) of SocketPro
Soon, UDAParts will provide a short article for describing remoting ADO.NET
objects through SocketPro using batching, asynchrony and parallel
computation.
www.udaparts.com Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142170
DAtaset comparision ??
Dear all,
What is the best way to compare 2 dataset ?
What I mean by that is not comparing that its teh same object but allso that
rows data values in both .
In other words I need an effeective way which tells me if records between 2
dataset are the same or different
thnaks for help
regards
serge Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142168
there seems to be some overhead between SQL Server 2005 and a CLR function written in C#. Why is this?
there seems to be some overhead between SQL Server 2005 and a CLR function
written in C#. Why is this?
I have a simple wraper around System.Diagnostics.Stopwatch.GetTimestamp() :
public partial class UserDefinedFunctions
{
[Microsoft.SqlServer.Server.SqlFunction]
public static long GetTimestampF()
{
return System.Diagnostics.Stopwatch.GetTimestamp();
}
};
but if i run this it is hardly accurate. the time of getting from sql server
to a CLR function seems to be relatively slow for nanosecond calculations:
DECLARE @before bigint
DECLARE @after bigint
SET @before = dbo.GetTimestampF()
-- do something
SET @after = dbo.GetTimestampF()
SELECT @after - @before as nanoseconds
is there nyway to elimitate this overhead so that dbo.GetTimestampF()
executes as fast for TSQL as it is to call GetTimestampF() in C#?
If i call my GetTimestampF() on c# it executes fast enough for the
nanosecond results to be accurate Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142167
Problem in copying SQLite file in C# code
I have a little Windows application written in C# with a SQLite back-
end. I'm using the System.Data.SQLite provider.
One of the features the application provides is a database back-up,
which just basically copies the S3DB file to a specified location. See
the code below:
//------------------------------------------------
System.IO.File.Copy(srcPath, destPath, true);
//------------------------------------------------
The file is copied without any problems, but when the application
attempts to access the original S3DB file again, the following
exception is thrown:
--------------------------------------------------
System.Data.SQLite.SQLiteException was unhandled
Message="Unable to open the database file"
Source="System.Data.SQLite"
ErrorCode=-2147467259
StackTrace:
...etc...
--------------------------------------------------
If I shut the application down and then start it up again, I can
access the database again with no problems.
Suspicious of what the File.Copy() method might be doing behind the
scenes, I tried using the following approach instead to hopefully
ensure that the files were being released:
//------------------------------------------------
using (FileStream fsSrc = new FileStream(srcPath, FileMode.Open))
{
//Get the source length once so we don't have to keep retrieving it
later
int srcLen = (int)fsSrc.Length;
//Create the destination file (this will overwrite the destination
file if it already exists)
using (FileStream fsDest = File.Create(destPath, srcLen))
{
//Buffer the contents of the source file
Byte[] buffer = new Byte[srcLen];
fsSrc.Read(buffer, 0, srcLen);
//Write buffered contents to the new file
fsDest.Write(buffer, 0, srcLen);
}
}
//------------------------------------------------
Unfortunately, the same problem occurs. I even tried executing the
code in its own thread, but with the same results.
Any ideas why this is happening and how to fix it?
Thank you. Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142165
databinding
I have a checkbox (along with textboxes) that I am trying to use as a
databound control to an integer field on a database. I am using
Format and Parse with the checkbox to write -1 to the database if the
checkbox is unchecked and 0 if checked. I am finding that the Dataset
and Database are not updated if I change the checkstate of the
checkbox and when I change the checkstate of the textbox, the other
controls (textboxes) will not allow focus. The code I have written is
below. Any suggestions would be appreciated.
// chbActive
System.Windows.Forms.Binding chkBoxBinding = new
System.Windows.Forms.Binding("CheckState",
this.tblEmployeeBindingSource, "inActive", true);
chkBoxBinding.Format += new
System.Windows.Forms.ConvertEventHandler(IntegerToCheckState);
chkBoxBinding.Parse += new
System.Windows.Forms.ConvertEventHandler(CheckStateToInteger);
this.chbActive.DataBindings.Add(chkBoxBinding);
this.chbActive.CheckStateChanged += new
System.EventHandler(this.chbActive_CheckStateChanged);
//this handles integer to checkstate
private void IntegerToCheckState(object sender, ConvertEventArgs
cevent)
{
// the method converts only to CheckState inActive is 0 if false
if ((int)cevent.Value == 0)
{
chbActive.CheckState = CheckState.Checked;
}
else
{
chbActive.CheckState = CheckState.Unchecked;
}
}
private void CheckStateToInteger(object sender, ConvertEventArgs
cevent)
{
// if Active is checked then they are active and inActive should
be 0
if (chbActive.CheckState == CheckState.Checked)
{
cevent.Value = 0;
}
else
{
cevent.Value = -1;
}
} Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142164
Confusing Error related to MappingSource?
I'm trying to force LINQ to SQL to do some inheritance modeled around the
"Table per Concrete Class" methodology as opposed to the normal "Table per
Class Hierarchy" model it officially supports. To do this, I omitted all the
properties of the inheritance relationship (Discriminator information and
such) and provided the proper Table attribute to associate my derived class
with its own table by addint a new partial class implementation manually.
So what I end up with is a base class that has all the columns in it, and
two derived classes that inherit from it in the designer, and have no
additional properties. Then in another file, I declare both derived classes
just to supply the Table attribute, providing each derived class' table name.
The problem I run into is this error message:
"Data member 'Int32 DocNum' of type '(my base class)' is not part of the
mapping for type '(my derived class)'. Is the member above the root of an
inheritance hierarchy?"
Now I've checked the contents of the MappingSource. I retrieved
context.Mapping.GetMetaType(GetType(<my derived class>)).DataMembers and was
able to verify in the debug window that the DocNum property was defined in
that MetaType information, and the DeclaringType matched <my derived class>,
so I don't know what it's complaining about. Is there any way to make this
work? Any explanation what this error is complaining about? I did notice
that if I create a property in my derived class that shadows the base class
DocNum property, then that property doesn't have the error any more (the next
property does). But the point is not to have to re-declare all the
properties in all me derived classes again. Why doesn't it pick up the base
class' attributes, even though the mapping info makes it look like it did? Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142162
How do I (cleanly) dispose of a row in DataGridView DataError even
(Reposted from Winforms forum. Not sure where this belongs.)
I'm writing a Winforms project in VB/Dot Net 2.0 and I'm having some trouble
handling the DataError event.
The grid is bound to a filtered binding source. Add is enabled. Part of
the primary key is set by one of the cells in the grid which is in combobox
mode. My main concern is duplicate keys. The combobox cell is the only
problem. The other row fields are either hidden or easy-to-validate text
entry boxes (handled in RowValidating).
What I want to do in DataError is give the user the choice of remaining in
the row to fix it (e.cancel = true) or just dispose of the
changes/additions. If it is
an existing row, virtually anything seems to work fine (such as
<bindingsource.ResetBindings, or nothing for that matter.)
What gives me trouble is a newly added row (I'm even sure 'new' is the right
term, but it is newly added. By the time it gets to DataError, the row's
IsNewRow property = False).
Any attempt to get rid of the new row by any means seems to get me into
some sort of infinite loop back to DataError, with errors like 'Index
<number> does not have a value'.
Am I even trying to handle the error in the right place? Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142161
Inconsistent dat paremeter in query
I am using the same code to query different databases, one SQL 2005 and the
other SQL 2000. The query contains a date paremeter @Date...
Me.SqlSelectCommand1.Parameters.AddRange(New
System.Data.SqlClient.SqlParameter() {New
System.Data.SqlClient.SqlParameter("@Date", System.Data.SqlDbType.DateTime,
8, "Date")})
The code was written using VS2003 (.Net 1.1) and is now executing on .Net 2.0.
SQL Profiler displays the generated query for SQL 2000 as...
exec sp_executesql N'SELECT FunctionID, Name, Date, Description FROM
vwTicketedFunctions WHERE (Date >= @Date) AND (OnSaleDate <= @Date) ORDER BY
StartTime', N'@Date datetime', @Date = 'Oct 26 2007 12:00:00:000AM'
and the generated query for SQL 2005 as ...
exec sp_executesql N'SELECT FunctionID, Name, Date, Description FROM
vwTicketedFunctions WHERE (Date >= @Date) AND
(OnSaleDate <= @Date) ORDER BY StartTime',N'@Date
datetime',@Date=''2007-10-26 00:00:00:000''
Note that the date paremeter formats are different. My problem is that the
SQL 2000 query parses Ok but the SQL 2005 generates the error: Line 2:
Incorrect syntax near '2007'.
Note also that regional setting is English(Australia). Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142155
web service for accessing db?
hi,
is web service good solution for accesing (havily) database (remote or not)?
that looks slow, any other methods for secure connection? SOme of coworkers
wants to use web service because they don't want
expose connection string.
thanks fro advise Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142154
Null Dates in Dataset
Using C# 2.0 & SQL Server 2000, have a stored procedure that return 0, 1, or
more rows. At least one of the columns is a date and it may null. I have
created an XSD of the output from the stored proc. The entry for the
nullable date column is "<xs:element name="Sent_Dttm" minOccurs="0"
type="xs:dateTime" nillable="true"></xs:element>". I copied the XSD to the
C# 2.0 windows app I am developing and it nicely generates a strongly typed
dataset.
The problem is I get an error when attempting to access this column in the
dataset when the value is null:
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.DateTime Sent_Dttm {
get {
try {
return
((System.DateTime)(this[this.tableOwizCommDoc.Sent_DttmColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The
value for column \'Sent_Dttm\' in table \'OwizCommDoc\' is DBNull.", e);
}
}
set {
this[this.tableOwizCommDoc.Sent_DttmColumn] = value;
}
}
Checking the properties of this field, I noticed that the "NullValue"
property has a value of "(throw exception)' Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142146
Jobsite for SALE
JOBSITE FOR SALE
For Details Contact: Netxure@gmail.com
FEATURE LIST
Job Seeker Features
=B7 This Job site contains Advanced features of Dice and Monster
=B7 Search jobs by location, date range, categories, Job type and
keywords.
=B7 View all jobs posted by a specific employer
=B7 Find out how often your resume was viewed by interested employers.
=B7 Set up job notification agents to automatically get matching jobs by
email everyday.
=B7 Submit your resume to any registered employer from your account with
one click.
=B7 Add Jobs to Inbox for later viewing.
=B7 Apply to multiple Jobs with one click.
=B7 Post 'Private' resumes
=B7 Make resume searchable or unsearchable
=B7 Update your profile at any time.
=B7 Subscribe/unsubscribe to the mailing list from your account.
=B7 Email a specific job to a friend.
=B7 Retrieve forgotten passwords by automated email.
=B7 Save time with the easy-to-use and clean user interface.
Employment Features
=B7 Search resumes by date range, geographic location, industry, Job
type and keywords.
=B7 Advanced Talent Search to find Jobseekers thru skill search.
=B7 Role Based / Position Based Search for easy search process
=B7 Add, edit and delete jobs from your account on the fly.
=B7 Find out how often each posting has been viewed by job seekers.
=B7 Build your company profile and upload a company image or logo.
=B7 Professional display of job searches and resume details make for
easy reading.
=B7 Sign-up for multiple resume notification agents to automatically
receive matching resumes by email everyday.
=B7 Resumes sent to employer are saved in private inbox for viewing at a
later time.
=B7 Save time with flexible and powerful resume search interface.
=B7 Ability to display resume details in a 'printer friendly format'
without any images/colors for easy printing.
=B7 Ability to easily sign-up online for Memberships, Job packages, job
postings or resume database access.
=B7 Automatically receive automated emails notifying of expiring jobs or
expiring memberships to give the chance to renew online
Administration Features
=B7 Broadcast e-mails to job seekers and/or employers who signed up for
the mailing list.
=B7 Add, edit, and delete jobs on the fly.
=B7 Add, edit, and delete employers on the fly.
=B7 Add, edit, and delete job seekers on the fly.
=B7 Add, edit, and delete job categories on the fly.
=B7 Print mailing list of job seekers and employers in the database
along with their contact information.
=B7 Get general statistics summary including the number of registered
job seekers, registered employers, pending job orders, active jobs,
active resumes in the database and searched keywords and categories
statistics.
=B7 Control job expiry dates.
=B7 Control resumes expiry dates.
=B7 Define featured Jobs to be displayed on homepage
=B7 Define featured employers to be displayed on homepage, with direct
link to employer's job listing. Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142143
Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable.
Unable to start TSQL Debugging. Could not attach to SQL Server Process on
'srvname'. The RPC server is unavailable.
I get this error when I try to run a SQL Server Project with a CLR stored
Procedure in it. The target DB is SQL Server 2005 and im using VS 2005. I
simply create a new SQL Server Project which creates a Test.sql, i then
simply added a Stored Procedure to it called the default name
StoredProcedure1.cs and put a break point in my simple StoredProcedure1.cs
and hit F5 and i got this error:
Unable to start TSQL Debugging. Could not attach to SQL Server Process on
'srvname'. The RPC server is unavailable.
Do i need to do something on the server so that I can debug this? Any walk
through on how to configure this sql server 2005 to have this RPC so i can
debug my CLR stored procedures in this way? e.g. step over, step into, run
to cursor etc.
Is this CLR debugging feature complete and tested yet? if so is there any
walk through on creating simple CLR helloworld in vs2005 and then executing
it in sql server 2005 but catching a break point in the StoredProcedure1.CS
code? I would like to debug these StoredProcedure1.cs as while sql server
executes it is why. so as of now my current error when i try this is:
Unable to start TSQL Debugging. Could not attach to SQL Server Process on
'srvname'. The RPC server is unavailable. Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142128
datatable vs custom List<MyClass>
Let's say I want a read-only copy of a simple query that joins 2 tables. When
I compare a DataTable (adapter.fill) and a custom List + DataReader, I see
that the custom sol'n is about 6x faster and takes 5x less memory. For my
test I read about 100K rows and then bind to a grid so the timing takes into
account both getting the data and binding the data. From profiling the app I
see one thing that really stands out - the internal DataTable routine to
build the (default?) index takes up most of the time - it clearly is doing
linear scans of a red-black tree and the hit count for traversing parts of
the tree ending up in the 100's of millions. Can I give the DataTable some
hint (via a property) to tell it not to perform this extra work? In the end I
may go w/ a custom sol'n but I first want to check if the built in classes
can solve my problem.
btw, this is .net 2.0, c#, and I'm just setting the datasource w/out any
other binding code.
thanks,
Paul. Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142127
very strange behavior of the method GetChanges(...) from the DataSet class
Hello !
i'm using a typed DataSet called myDs. This dataset has 2 Tables,
Table1 and Table2.
i have created a DataSet like this:
myDs dsOld = new myDs();
//here i populate the 2 tables
......
//and then call the method to get the added rows
myDs dsNew = (myDs)dsOld.GetChanges(DataRowState.Added);
at this point on dsNew i have only the added rows of Table1 instead
Table2 is set to null.So, the method returns only the rows of 1 table
(Table1).
i have debugged the code and i see that the both tables of the dataset
dsOld are full of rows that have the rowstate = added.
somebody can explain me whats the problem ? it's seem like a bug
E. Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142122
Access vs vb.net/ado.net
Hi
What are the advantages of writing an app in vb.net/ado.net as opposed to MS
Access? I need this to sell the idea to the management.
Many Thanks
Regards Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142118
Why is SQLFreeStmt within the transaction using parameterized inse
I am using ODBC.NET to perform mulitple parameterized inserts into a
database. The performance has been terrible. Upon research into the ODBC
trace log, it appears the a SQLFreeStmt is being executed by ODBC upon every
ExecuteNonQuery that I am issuing. This is causing a huge amount of overhead,
especially when working with thousands of inserts. When coding against the
ODBC API (outside of .NET), I only issue the SQLFreeStmt upon committing the
data, and it is very quick (as expected). Of course, I need to figure this
out in .NET, as this is our platform.
Here is basically what I am doing in .NET:
1) Open OdbcConnection
2) Begin Transaction
3) Create OdbcCommand and assign to transaction
4) Create parameter collection
5) Loop through all records, assign values to parms, and perform
parameterized inserts
6) Commit transaction
7) Close transaction.
Any ideas on what I can do to stop these SQLFreeStmts from being issued
would be greatly appreciated! Thanks in advance!!! Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142116
how to insert record in a dataSet into another database table
hi, pls can someone help me out. its very urgent i get the solution today. i
have a webservice that i use to retrieve new record from a database, also
there is a client application (window form) that calls this service which
returns the record in a dataset. now i need to insert the record in this
dataset into another database table on a different server.how do i do these.i
've tried so many things and also implement a suggestion on a thread about
inserting from one db into another but its not working. am using MySql5.1
community edition,IIS 5.o and Visual studio.Net2003 to develop and test. pls
someone help me. i need a simple code to do this. Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142115
how to insert record in a dataset into another database
hi, how do i insert a record inside a dataset into another database table on
a different server. i use a web service to retrieve the record and store in
it into a dataset.i have a client application (a window form) that calls this
web service and return the dataset. now i need to insert this record into
another database table. am using MySql server and Odbc. pls somebody help me
out.
i have tried the suggestion on the thead about inserting from one db into
another but its not working. Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142114
Copy database schema from Access to SQL Server
Hi all,
I'm trying to write an application that takes an Access database as
template to customize a new or existing SQL Server database. When
something in the template database is changed, I want to apply these
changes to the SQL database. For example if new columns are added to a
table or constraints are changed, the application parses each Access
table and relation and whatever and applies this to the SQL Server
database. The data in the tables is irrelevant, only the schema is
important. I have to apply default values, check contraints (I think
it's validation rules in Access), maximum column lengths, ...
How can I accomplish this? Do I have to loop through the Access tables
and relations and create a DDL SQL statement for each? What if the
column/contraint already existed? Seems complicated, maybe there is an
easier solution.
I'm using Visual Studio 2005 and C# 2.0, so this should be the way to
go.
Thanks in advance.
Regards,
Hannes Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142102
Memory keeps creaping up...why?
This is a multi-part message in MIME format.
------=_NextPart_000_0006_01C8155A.951AF170
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I have a simple subroutine (see below) which reads a table and populates =
the items of a combobox. As the subroutine is executed, I'm watching =
the taskmanager and the memory in use increases; however, once I get to =
the Error_Exit: logic and start to close and dispose my memory =
variables, the memory is not released and does not decrease in the task =
manager. Why is that? Eventually, my program is giving me =
"Insufficient memory" errors.
*************************************************************************=
***************
On Error GoTo Error_Handling
Dim cnn As New Odbc.OdbcConnection
Dim cmd As New Odbc.OdbcCommand
Dim rdr As Odbc.OdbcDataReader
cnn.ConnectionString =3D "dsn=3D" & accpac_companyid
cnn.Open()
cmd.Connection =3D cnn
cmd.CommandText =3D "select schedkey, scheddesc from cssktb order by =
schedkey"
rdr =3D cmd.ExecuteReader
Do While rdr.Read
combo.Items.Add(rdr("schedkey").ToString.Trim)
Loop
Error_Exit:
If Not IsNothing(rdr) Then
rdr.Close()
cmd.Connection.Close()
cmd.Dispose()
cnn.Close()
cnn.Dispose()
End If
rdr =3D Nothing
cmd =3D Nothing
cnn =3D Nothing
Exit Sub
Error_Handling:
Select Case Err.Number
Case Else
MsgBox("The following error occured in LoadSchedules()" & vbCrLf =
& Err.Description)
End Select
Resume Error_Exit
------=_NextPart_000_0006_01C8155A.951AF170
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.6000.16544" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV>
<P><FONT face=3DArial size=3D2>I have a simple subroutine (see =
below) which=20
reads a table and populates the items of a combobox. As the =
subroutine is=20
executed, I'm watching the taskmanager and the memory in use increases; =
however,=20
once I get to the Error_Exit: logic and start to close and dispose my =
memory=20
variables, the memory is not released and does not decrease in the task=20
manager. Why is that? Eventually, my program is giving me=20
"Insufficient memory" errors.</FONT></P>
<P><FONT face=3DArial=20
size=3D2>****************************************************************=
************************</FONT></P>
<P><FONT face=3DArial size=3D2>On Error GoTo Error_Handling</FONT></P>
<P><FONT face=3DArial size=3D2>Dim cnn As New =
Odbc.OdbcConnection<BR></FONT><FONT=20
face=3DArial size=3D2>Dim cmd As New Odbc.OdbcCommand<BR></FONT><FONT =
face=3DArial=20
size=3D2>Dim rdr As Odbc.OdbcDataReader</FONT></P>
<P><FONT face=3DArial size=3D2>cnn.ConnectionString =3D "dsn=3D" &=20
accpac_companyid<BR></FONT><FONT face=3DArial =
size=3D2>cnn.Open()<BR></FONT><FONT=20
face=3DArial size=3D2>cmd.Connection =3D cnn<BR></FONT><FONT =
face=3DArial=20
size=3D2>cmd.CommandText =3D "select schedkey, scheddesc from cssktb =
order by=20
schedkey"<BR></FONT><FONT face=3DArial size=3D2>rdr =3D =
cmd.ExecuteReader</FONT></P>
<P><FONT face=3DArial size=3D2>Do While rdr.Read<BR></FONT><FONT =
face=3DArial=20
size=3D2> =20
combo.Items.Add(rdr("schedkey").ToString.Trim)<BR></FONT><FONT =
face=3DArial=20
size=3D2>Loop</FONT></P>
<P><FONT face=3DArial size=3D2>Error_Exit:<BR></FONT><FONT face=3DArial=20
size=3D2> If Not IsNothing(rdr) Then<BR></FONT><FONT =
face=3DArial=20
size=3D2> =
rdr.Close()<BR></FONT><FONT=20
face=3DArial size=3D2> =20
cmd.Connection.Close()<BR></FONT><FONT face=3DArial =
size=3D2> =20
cmd.Dispose()<BR></FONT><FONT face=3DArial=20
size=3D2> =
cnn.Close()<BR></FONT><FONT=20
face=3DArial size=3D2> =20
cnn.Dispose()<BR></FONT><FONT face=3DArial size=3D2> =
End=20
If</FONT></P>
<P><FONT face=3DArial size=3D2> rdr =3D =
Nothing<BR></FONT><FONT=20
face=3DArial size=3D2> cmd =3D Nothing<BR></FONT><FONT =
face=3DArial=20
size=3D2> cnn =3D Nothing<BR></FONT><FONT face=3DArial =
size=3D2>Exit=20
Sub</FONT></P>
<P><FONT face=3DArial size=3D2>Error_Handling:<BR></FONT><FONT =
face=3DArial=20
size=3D2> Select Case Err.Number<BR></FONT><FONT =
face=3DArial=20
size=3D2> Case Else<BR></FONT><FONT face=3DArial=20
size=3D2> MsgBox("The following =
error occured=20
in LoadSchedules()" & vbCrLf & Err.Description)<BR></FONT><FONT=20
face=3DArial size=3D2> End Select</FONT></P>
<P><FONT face=3DArial size=3D2>Resume =
Error_Exit</FONT></P></DIV></BODY></HTML>
------=_NextPart_000_0006_01C8155A.951AF170-- Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142100
Sybase AsaClient and DbProviderFactories
Hello all,
My team is trying to use the iAnywhere.Sybase.Asaclient (middle part
might be spelled incorrect) in our C# project with a DbProviderFactory
class to generate new code.
However when we try to create a new factory with DbProviderFactory
factory = DbProviderFactories.GetFactory("iAnywhere.Sybase.Asaclient).
This returns an ArgumentException to us.
Is there something special we need to install or do to be able to use
Asaclient objects with the ADO.NET factories?
Thanks in advance Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142096
Decimal data type wont work!
I have a SQL Express db with a table field defined as data type
decimal(18,0).
When I type in .785 in the table field it rounds it to 1.
Any ideas why???? Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142093
Question about finding records using Stored Procedures
I have a table called Customer. I have a locator screen which is composed
of a grid and a couple of search boxes. The user is going to choose which
customer records to display in the grid. The choices are LastName or
firstName or any part of them, Social Security Number, Status
(Active,Inactive, etc.) and office.
Now the user can choose to find all customers who are active and from a
certain office or they could find all the customers whose last name starts
with S and is active and from a particular office.
In the past, I looked at each search field and built a where clause which
was then passed to a select statement to retrieve the correct records. I am
not happy doing this and want to switch to stored procedures.
When the user clicks the 'Find' button after filling in some search fields,
I will create an empty customer object and fill in the fields that are in
the search screen and this past this object to the server. On the server, I
will parse the object and figure out which fields have values in them
meaning that they are to be part of the search critieria. Once I have done
that, then I will call the appropriate Find method for the cusotmer.
That is my dilemma. Do I have the followng in my code?
FindCustomerBySocSecNo(string socsecno)
FindCustomerByLastName(string lastname)
FindCustomerByOffice(string office)
FindCustomerByStatus(string status)
FindCustomerByStatusAndOffice(string office,string status)
FindCustomerByLastNameStatusAndOffice()
etc.
etc.
etc.
This seems like a lot of work to do.
Bill Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142091
Question about SUM query
I have a "transaction" table with 2 columns, TransTypeId and TransAmt.
Example:
TransTypeId TransAmt
A 100
A 200
B 100
C 50
B 100
A 100
I am trying to do a SUM of all the TransTypeId A and B. The result should
be 600. I WANT TO GET ONLY THIS 1 VALUE BACK.
But, the result of the query is returning...
A 400
B 200
It's not summing it as a "group", but per "TransTypeId". Any ideas why?
Here's the raw query... (
SELECT SUM(Transactions.TransAmt) AS Expr1, Enroll.ProgramId,
Enroll.EnrollId
FROM Transactions INNER JOIN
Enroll ON Transactions.EnrollId = Enroll.EnrollId
GROUP BY Enroll.ProgramId, Enroll.EnrollId, Transactions.TransTypeId
HAVING (Enroll.ProgramId = @ProgramId) AND (Enroll.EnrollId =
@EnrollId) AND (Transactions.TransTypeId = 1 OR
Transactions.TransTypeId = 2 OR
Transactions.TransTypeId = 3)
Thanks! Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142087
i have a problem . please help me
Hello,
I am writing ASP.NET application using SQL Server 2005 Express Edition.
my connection string is :
"Data
Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\DB.mdf;Integrated
Security=True;Connect Timeout=30;User Instance=True";
I used connection strings syntax from www.connectionstrings.com.
this app work in IIS very well
but when i upload it on the host i reiceve this error :
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: SQL Network Interfaces, error: 26 - Error
Locating Server/Instance Specified)
please help me if you can ?
*** Sent via Developersdex http://www.developersdex.com *** Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142083
How sluggish is a big xml file in combination with datasets?
Hello,
I am currently working on a project which will run in an environment,
where the size of the database is very limited. That's why I thought
about relying in some parts entirely on xml files (and datasets) as an
DB replacement.
I.E.:
DataSet myDataSetToRead = new DataSet();
myDataSetToRead.ReadXmlSchema("c:\\abcd.xsd");
myDataSetToRead.ReadXml("c:\\abc.xml");
dostuff with the dataset data
etc.
Now, I will doing this only for the little used parts application,
where maybe 5 users at once will use it.
I know that this approach is slow compared to a real DB, but, what are
the other limitations? Is there a size limit? I mean, will it somehow
break after the file reaches 50 MB? And how much slower will it be,
compared to a DB? 10 times slower? More? Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142079
Install SQL Server 2005 Express With ClickOnce?
Is it possible to install SQL Server 2005 Express on a machine that
restricts installs by using ClickOnce?
For example, I can't install new applications on my machine at work unless I
use ClickOnce to do so. I want to be able to use SQL Server 2005 Express in
my applications and move away from MS Access. Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142078
Ajax enabled page
Oct 20, 2007
01:00pm
Hi all
When you create an Ajax enabled web site, the application creates the
default page with a "Script Manager".
I created a Master Page. I then created a "Home" page with reference to this
master page.
As I wanted this Home Page to come first I added the following code to the
default page
Server.Transfer("Home.aspx", True)
My questions are:
1. To ensure that Microsoft Ajax toolkit works, does the default page with
the "Script Manager" has to be the first page.
2. Can I give the reference of the Master Page on the "Default Page" so that
I get the template I require. Then the "Default Page" can be my first page.
Thank you in advance.
Mike TI Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142074
Obtaining column properties in .NET
Hi all,
I want to obtain column properties using C# and the System.Data
namespace. Using DbDataReader.GetSchemaTable() or DataAdapter.Columns
I only retrieve properties like DataColumn.MaxLength or
DataColumn.AllowDbNull in a correct fashion. But if I want properties
like DefaultValue or certain column validation rules, I fail. Does
anyone know how to obtain these values? If so, please post some sample
code or links.
Thank you very much in advance.
Regards,
Hannes Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142059
HP Desktop for sale!
Hi,
I have an unused HP Pavilion with the fallowing specs:
# Processor: AMD Athlon 64 X2 4000+ (2.1GHz, 2000MT/s System Bus)
# Memory: 2048MB PC2-5300 DDR2 SDRAM memory (2x1GB) (expandable to 8 GB (4 x 2 GB) (64-bit OS)/ 4 GB (4 x 1 GB) (32-bit OS))
# Hard Drive:320GB 7200RPM SATA 3G (3.0 Gb/sec) hard drive
# Optical Drive: 16X DVD(+/-)R/RW 12X RAM (+/-)R DL LightScribe SATA drive
# Expandable Drive Bay: HP Pocket Media Drive bay
# Video Graphics: Integrated graphics
# Network Interface: Integrated 10/100BaseT network interface
# Sound: High Definition 8-channel audio
# Fax/Modem: 56K bps data/fax modem
# Operating System: Genuine Windows Vista® Home Premium
This is "used" but basically brand new (it has literally been on for no more than 6 total hours..) is only 1 month old..
PRICE: $425 OBO
Email- pbdude911@yahoo.com Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142050
Fatloss computer program
I have been using this computer program for a couple weeks now and i am very pleased with the results so far. its a software fatloss program, if your looking for a diet/weightloss plan i reccomend you check this place out first: http://fatloss9.50webs.com Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142048
Watch NFL Games Online
Watch NFL Games Online!
For every one who wants to watch the games online because they dont live in the teams town or are at work i found a site that has basically every game covered. Its perfect if you have afford a monthly $70 direct tv nfl access subscription. they got a bunch of channels
The sites http://nflonline.wizhoo.com Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142047
ReadXML error
I'm using DataSet.ReadXML method to populate the dataset with data from XML
file.
If one of the values contains apostrophe (for instance: It's something) then
an error occures:
System.Xml.XmlException: Invalid character in the given encoding.
Is this a bug or what? I wouldn't want to parse an XML created by another
program which is using the same ADO.NET for creating the file. On that side
apostrophe is allowed.
Thank you
vovan Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142046
vs 20028 when??
Hi
When is vs2008 due out?
Many Thanks
Regards Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142040
Reading a XLS file with a embeded combo
Hi, I=B4m trying to read a xls file which one colum has a combo to
select the value. The value is linked to
the cell below the combo, however in certain columns the ado.net
returns null value instead of the value selected.
Is there anything I=B4m missing? I remember the bug in ADO when reading
columns with multiple formats.
Thanks,
Ezequiel Naftali Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142039
Data Type 'Image' is missing from the development environment for
Please disregard my previous post for the same problem.
the posting was incomplete.
I'm trying to update the data in a DataGridView control.
The underlying data are from SQL Server CE database.
There is an image field in the DataGridView control
when U give the save command, I get the following message.
"@p5 : Byte array truncation to a length of 8000."
Parameter corresponds to the image field. In the parameter, it is displayed
as a Binary. However, I cannot see the type 'Image' in the list of data types.
--
test Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142037
ComboBox loads slow
I am noticing that it seems to take windows a long ass time to paint a
ComboBox control that has say, 32000 items in its dropdown. Yes, I know
that's a lot. However, I have a VB6.0 application that uses DAO to access
an Access database, and it can load up a 32000 item combobox in a fraction
of the time it takes .net 2.0. Why is this?
Also, it seems like setting the .DataSource property takes a while, but the
bulk of the wait time is when the control gets drawn on the screen. Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142030
Filtering DataSet with Multiple Tables
I have a DataSet with 3 tables. I need to be able to filter the parent table
and get all records from the 3rd level table that correspond with it. I have
relations set up between the parent and first child and also the first child
and it's child tables. However, when I filter the top level table, it doesn't
appear to filter the other tables. How can I do this? Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142029
How do I merge tables in ado.net
Hi,
I'm fairly new to ado.net and I'm not sure I'm doing this in the best way...
I retrieve two tables from two different databases and place them in a
dataset. Both tables have a column which relates them. The relation type is
one to many.
I use a custom procedure to "merge" the two tables into a third before I
display the third table in a datagrid. The procedure creates a new table and
iterates through the two tables using a relation object and GetChildRows.
Is this how it should be done or is there a built in function that can do
the work for me?
Regards
Pete Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142027
QueriesTableAdapter does not appear in toolbox. Why not?
I created a stored procedure called AddOrder which does an 'insert'
statement. It appeared in the Server Explorer of Visual Studio. Then
I dragged it to the Dataset Designer. This makes a
QueriesTableAdapter, which I do find in the diagram when I "Edit
Dataset in Designer". The problem is that this QueriesTableAdapter
does not appear in the ToolBox, so I cannot drag it on to forms.
Is there any reason why it doesn't show up in the toolbox? Is there
some way to drag it to the form?
Thanks,
HA Tag: is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: 142018
is there anything like XmlDocument.ImportNode but for SQL Server XQuery?