Map data from one DataTable to another
Hi
I have a DataTable with data which I need to import into another typed
DataTable at runtime. The columns in the first DataTable may be different. I
have a
DataColumnMappingCollection (which the application user creates) which maps
the first DataTable column names to the second.
The first table may have more columns than I need to import to the second.
It's also possible that I may need to convert types from rows in the first
table to the second.
What's the most efficient way to get the data into the correct columns in
the second table?
I did wonder about doing something with the DbDataAdapter before filling the
first table. However it looked like I would have to query the data twice
from the data source. The first time to get the column names and then the
second after creating new column mappings. Is this a good idea?
Cheers
Andrew Tag: WQL query builder Tag: 145748
to find the data from one dataview not in another dataview
Dear all
I have a two dataview
e.g.
dataview A
row 1
A
B
C
D
dataview B
A
B
C
D
E
I want to find the data in dataview B not in dataview A
e.g. E Tag: WQL query builder Tag: 145747
Power Packs 3.0 Data Repeater
I can't add a control on a data repeater included on Visual Basic Power
Packs 3.0...
Will you please help me out. I'm using MS Access 2003 and Visual Basic.NEt
2005 Express. I will be using a weak type. I was just starting to build.
Here are the steps.
1. I created a form
2. I Drag a data repeater from the Toolbox
3. I add a textbox inside the data repeater
4. When I run the Form. The Textbox did not appear.
5. It did not generate any error then..
6. When I click Close or Click a part of the Form:
Object reference not set to an instance of an object.
System.NullReferenceException was unhandled
Message="Object reference not set to an instance of an object."
Source="Microsoft.VisualBasic.PowerPacks"
StackTrace:
at
Microsoft.VisualBasic.PowerPacks.NullDataManager.CancelCurrentEdit()
at Microsoft.VisualBasic.PowerPacks.DataRepeater.CancelEdit()
at Microsoft.VisualBasic.PowerPacks.DataRepeater.EndCurrentItemEdit()
at
Microsoft.VisualBasic.PowerPacks.DataRepeater.OnValidating(CancelEventArgs
e)
at System.Windows.Forms.Control.PerformControlValidation(Boolean
bulkValidation)
at
System.Windows.Forms.ContainerControl.ValidateThroughAncestor(Control
ancestorControl, Boolean preventFocusChangeOnError)
at System.Windows.Forms.ContainerControl.ValidateInternal(Boolean
checkAutoValidate, Boolean& validatedControlAllowsFocusChange)
at System.Windows.Forms.ContainerControl.Validate(Boolean
checkAutoValidate)
at System.Windows.Forms.Form.WmClose(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at
System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&
m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd,
Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr
wndProc, IntPtr hWnd, Int32 msg, IntPtr wParam, IntPtr lParam)
at System.Windows.Forms.NativeWindow.DefWndProc(Message& m)
at System.Windows.Forms.Form.DefWndProc(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmSysCommand(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at
System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&
m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd,
Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr
wndProc, IntPtr hWnd, Int32 msg, IntPtr wParam, IntPtr lParam)
at System.Windows.Forms.NativeWindow.DefWndProc(Message& m)
at System.Windows.Forms.Form.DefWndProc(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmNcButtonDown(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at
System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&
m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd,
Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG&
msg)
at
System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32
dwComponentID, Int32 reason, Int32 pvLoopData)
at
System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32
reason, ApplicationContext context)
at
System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason,
ApplicationContext context)
at System.Windows.Forms.Application.Run(ApplicationContext context)
at
Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun()
at
Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel()
at
Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[]
commandLine)
at Purchasing_and_Warehousing_System.My.MyApplication.Main(String[]
Args) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 81
at System.AppDomain._nExecuteAssembly(Assembly assembly, String[]
args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence
assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext
executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
What does this mean? Tag: WQL query builder Tag: 145745
launch excel from asp.net
Hi, i'm trying to launch excel from an asp.net application; i have
installed excel 2003 on the server but i cant see it on the list of
application dcom, do i need to do something else?
Thanks. Tag: WQL query builder Tag: 145742
Problem getting the right output from my typed dataset
I have a typed dataset which I used to generate an export file in XML
which is consumed by another program. What I'm having a problem is
that some of the elements aren't coming out the way I need them.
For example, I have a section (which is a child table for my record)
which keeps track of security accesses. The problem is, I need the
output to come out like this:
<SecurityAccess>
<Access>AA</Access>
<Access>BB</Access>
</SecurityAccess>
Instead, it comes out like this:
<SecurityAccess>
<Access>AA</Access>
</SecurityAccess>
<SecurityAccess>
<Access>BB</Access>
</SecurityAccess>
How do I get it to come out the way I want it to?
The schema fragment that defines this section:
<xs:element name="SecurityAccess" minOccurs="0" maxOccurs="1">
<xs:complexType>
<xs:sequence>
<xs:element name="Access" type="AccessType" minOccurs="1"
maxOccurs="unbounded" />
</xs:sequence>
</xs:complexType>
</xs:element>
With Access Type defined as a xs:string with restrictions.
Any suggestions? Tag: WQL query builder Tag: 145737
Importing a CSV into a Dataset (preferably. with VB.NET 2005)
Is there an easy way to import the contents of a CSV text file into a
Dataset, preferably using VB.NET (2005)?
Here's the clincher - I cannot use code I already found out there that
simply splits the lines based on commas in each line, as there are cases
where there may be a comma within a string (surrounded by quotes), and I
don't want to split on that.
Here's the first few rows of the data to give you an idea:
"Subscriber Number","Statement Date","Charge Type","Charge
Description","Amount"
"555-555-5555","02/11/2008","LOCAL AIRTIME, LONG DISTANCE and INTERNATIONAL
CHARGES","","$0.00"
"555-555-5555","02/11/2008","Taxes","","$8.60"
"555-555-5555","02/11/2008","WorldClass Int'l Rate","General","$0.00"
"555-555-5555","02/11/2008","BB BIS&BES AddOn","CUSTOM DATA PACKAGE","$(3.60)"
I also am not having any luck with the OLEDB examples out there too, as my
filename could have spaces in it (for example the current one is "Statement
Detail.csv"), and trying to do a "select * from Statement Detail.csv fails
every time.
Any ideas/suggestions? Tag: WQL query builder Tag: 145736
Problem getting the right output from my typed dataset
I have a typed dataset which I used to generate an export file in XML
which is consumed by another program. What I'm having a problem is
that some of the elements aren't coming out the way I need them.
For example, I have a section (which is a child table for my record)
which keeps track of security accesses. The problem is, I need the
output to come out like this:
<SecurityAccess>
<Access>AA</Access>
<Access>BB</Access>
</SecurityAccess>
Instead, it comes out like this:
<SecurityAccess>
<Access>AA</Access>
</SecurityAccess>
<SecurityAccess>
<Access>BB</Access>
</SecurityAccess>
How do I get it to come out the way I want it to?
The schema fragment that defines this section:
<xs:element name="SecurityAccess" minOccurs="0" maxOccurs="1">
<xs:complexType>
<xs:sequence>
<xs:element name="Access" type="AccessType" minOccurs="1"
maxOccurs="unbounded" />
</xs:sequence>
</xs:complexType>
</xs:element>
With Access Type defined as a xs:string with restrictions.
Any suggestions? Tag: WQL query builder Tag: 145735
Asynchronous database calls
Hi
Using .NET 2.0, is there anyway of invoking Sybase and Oracle stored
procedures asynchronously?
The scenario is this: we have some (Sybase and Oracle) stored procedures
that are taking a few minutes to run. This means that our middle tier objects
are â??blockedâ?? waiting for the stored procedures to return their results. I
know I can use a worker thread from the user interface to effectively kick
off the time consuming call to the middle tier and database. However, my real
goal is to release middle tier resources as early as possible. In other
words, I would like to invoke a stored procedure and immediately free up the
resources consumed by the middle tier (e.g. database connection). Then, when
the stored procedure completes, it somehow signals to the middle tier that
the data is ready.
I did something similar to this with SQL Server and extended stored
procedures, where my extended stored procedure called a COM component and
gave it the results.
Can this be done in a .NET 2.0, Oracle 10g and Sybase ASE 12 setup?
Thanks! Tag: WQL query builder Tag: 145732
dans commande xenical canada corpus pharmacie en ligne en France femme en termes de xenical canada generique pharmacie en France xenical suisse soft en ligne
dans commande xenical canada corpus pharmacie en ligne en France femme en termes de xenical canada generique pharmacie en France xenical suisse soft en ligne
+++ PERTE DE POIDS +++ PERTE DE POIDS +++ PERTE DE POIDS +++
+
ACHETER XENICAL BON MARCHE (ALL CARD ACCEPTED)
http://jhku.net/ACHETER-XENICAL-BON-MARCHE/
+
+
+
ACHETER ACOMPLIA BON MARCHE (ALL CARD ACCEPTED)
http://jhku.net/ACHETER-ACOMPLIA-BON-MARCHE/
+
+
+
ACHETER MERIDIA BON MARCHE (ALL CARD ACCEPTED)
http://jhku.net/ACHETER-MERIDIA-BON-MARCHE/
+
+
+
ACHETER PHENTERMINE BON MARCHE (Western Union, Diners, AMEX, VISA)
http://jhku.net/ACHETER-PHENTERMINEA-BON-MARCHE/
http://www.jamba-handy-videos.de
http://ibm-news.for-um.de/showthread.php?t=11774
http://groups.google.de/group/hdmi-cable/browse_thread/thread/7765af3b2e0c5639#
http://www.stellenangebot-ausland.de
http://www.salsapresse.com/modules.php?name=Forums&file=viewtopic&t=6022
commander xenical canada par mail
comprimes de xenical us usa bon marche
xenical canada au rabais au Canada
commander xenical us usa en ligne aucune prescription
xenical soft generique
acheter xenical concernées par cette
femme en termes de xenical canada
xenical canada soft sans prescription
xenical suisse Generique Inde
xenical Generique Inde
Achetez xenical
xenical suisse generique bon marche
xenical suisse le plus bon marche
dans commande xenical en France corpus
xenical soft en ligne
acheter xenical
acheter xenical
pharmacie en ligne us usa
commander comprime de xenical en France
xenical par email
acquerir xenical en France soft
Achetez Le xenical canada
generique medicaments canada
xenical canada Generique Inde
xenical au rabais au Canada
commander xenical par mail
xenical suisse commande en ligne
xenical belgique pharmacie
comprimes de xenical us usa bon marche
on xenical us usa a vendre
acquerir xenical canada soft
Achetez xenical
xenical bon marche Sans Prescription
xenical belgique suisse
xenical suisse soft sans prescription
xenical suisse soft sans prescription Tag: WQL query builder Tag: 145731
How to join a multi table DataSet with update of a single table?
Hi,
I created a DataSet with this query:
Select cl.*, c.Nome CidadeCli, c.Estado EstadoCli, c.Pais PaisCli, p.Nome
CidadePraca, p.Estado EstadoPraca,
p.Pais PaisPraca, tc.*, di.Nome dvNome, bc.Nome bcNome, cr.Limite,
cr.Bloquear, NomeRegiao,
cv.Descricao cvDescricao, ba.Bairro, ba.Nome_Bairro, au.*, t.Transportadora,
f.Fornecedor,
ce.Nome Empresa_CidadeCli, clt.Cliente trTransporte, clt.NomeCliente trNome,
entr.Nome EntregaCidadeNome, entr.Estado EntregaEstado, entr.Pais
EntregaPais, cr1.Limite Limite1, ac.Descricao acDescricao
From Clientes cl left outer join Cidades c on cl.Cidade = c.Cidade
left outer join Cidades ce on cl.Empresa_Cidade = ce.Cidade
left outer join Regioes r on r.Regiao = c.Regiao
left outer join Cidades p on cl.Praca = p.Cidade
left outer join TiposDeCliente tc on tc.TipoCliente = cl.TipoCliente
left outer join Divulgadores di on di.Codigo = cl.Divulgador
left outer join Bancos bc on bc.Banco = cl.Banco
left outer join Creditos cr on cr.CodCredito = cl.CodCredito
left outer join Bairros Ba on Ba.Bairro = Cl.Cod_Bairro
left outer join Autor Au on Au.Autor = Cl.Cliente
left outer join CalculodeVencimentos cv on cv.CalculoVencimento =
Cl.Calculovencimento
left outer join CalculodeVencimentos ac on ac.CalculoVencimento =
Cl.Acerto_Consignacao
left outer join Transportadoras t on t.Transportadora = cl.Cliente
left outer join Transportadoras tp on tp.Transportadora =
cl.Transportadora_Padrao
left outer join Clientes clt on tp.Transportadora = clt.Cliente
left outer join Fornecedor f on f.Fornecedor = cl.Cliente
left outer join Cidades entr on cl.Entrega_Cidade = entr.Cidade
left outer join Creditos cr1 on cr1.CodCredito = cl.Credito_Consignado
This query has a lot of tables connected but the most important if the
Cliente (Client) table. The foreign tables are responsible to inform the
description of some codes.
My idea was to create this query and have the insert, update and delete
related to the Client table but when seting the DataSet, the option
GenerateDBDirectMethods are not available. Is there a way to fix it? It
should be intersting if VS asked which table should be used in this case.
Thanks,
Marco Castro Tag: WQL query builder Tag: 145729
How to connect ADO.NET Entities to something that is not MSSQL
Hi,
I'm trying to test ADO.NET Entities but the new connections available are
only MS SQL drivers. How can I place other providers there?
Thanks,
Marco Castro Tag: WQL query builder Tag: 145728
ANN: OleDBPro and OleDBProNet released for flexible, easy and fast accessing large database recordset
Hi, All:
UDAParts keeps on improving OleDBPro and OleDBProNet, and has just updated
OleDBPro (2.5.0.1) for C++ and OleDBProNet (2.0.0.1) for .NET.
The new important updates include:
1. In addition to 32bit regular desktop development, now OleDBPro for
C++ also fully supports 64bit, CE and smartphone phone developments.
2. In addition to 32bit regular desktop development, now OleDBProNet
also fully supports 64bit development too.
3. Methods FindFirst, FindNext, FindPrev and FindLast are added into
both OleDBPro and OleDBProNet for finding records directly on server side
with great performance, flexibility and simplicity.
4. A new sample Find added for demonstrating the usage of the above
four methods for C++. The old sample RowsetFind for .NET is updated to echo
the usage of these methods.
The methods FindPrev and FindLast are only found in OleDBPro and OleDBProNet
through MS OLEDB technology! Major OLEDB providers, ORACLE Oracle, MS SQL
native client, MS client cursor engine, and advantage OLEDB providers
support these finding methods fully.
Now, our OleDBPro and OleDBProNet provides much more key features than other
similar components like classic ADO and ADO.NET providers.
See the sites http://www.udaparts.com/oledbpro.htm,
http://www.udaparts.com/devguide.htm, and
http://www.udaparts.com/oledbpronet.htm.
Cheers! Tag: WQL query builder Tag: 145725
Jaeger LeCoultre Reverso Grande Taille Mechanical 270.81.10
Jaeger LeCoultre Reverso Grande Taille Mechanical 270.81.10
(q2708110), Best Luxury Watch - www.luxury-gift.org
Luxury Gift : http://www.luxury-gift.org
Jaeger LeCoultre Watches : http://www.luxury-gift.org//jaeger-lecoultre-watches.html
Jaeger LeCoultre Reverso Grande Taille Mechanical 270.81.10 (q2708110)
Link :
http://www.luxury-gift.org/Watches/jaeger-lecoultre-watch-1078.html
Jaeger LeCoultre Reverso Grande Taille Mechanical 270.81.10 (q2708110)
Information :
Brand : Jaeger LeCoultre Watches
Series : Reverso Grande Taille Mechanical
Code : 270.81.10 (q2708110)
Gender : Mens
Case Material : Stainless Steel
Dial Color : Silver - White
Bracelet Strap : Leather - Brown
Movement : Manual Wind
Clasp Type : Deployant Clasp
Bezel :
Crystal : Scratch Resistant Sapphire
Case Back :
Case Diameter : 26mm x 42mm incl. lugs.
Case Thickness : 9.5mm
Water Resistant : 30m
Stainless steel case, Brown leather strap with folding buckle, New
textured dial, Small seconds hand at 6, Reverse side in Stainless
steel.
Jaeger LeCoultre Reverso Grande Taille Mechanical 270.81.10 (q2708110)
Link :
http://www.luxury-gift.org/Watches/jaeger-lecoultre-watch-1078.html Tag: WQL query builder Tag: 145722
Thomas Wylde Evening Bag Black 8529 - www.luxury-gift.org
Thomas Wylde Evening Bag Black 8529 - www.luxury-gift.org
Luxury Gift : http://www.luxury-gift.org
THOMAS WYLDE handbags : http://www.luxury-gift.org/Handbags/THOMAS-WYLDE.html
Thomas Wylde Evening Bag Black 8529 Link :
http://www.luxury-gift.org/Handbags/Handbags-6695.html
Thomas Wylde Evening Bag Black 8529 Information :
Brand : THOMAS WYLDE handbags
Code :
Description :
-Black cowhide leather-Zipper closure top -Metal skulls inlay of bag -
Engrave 'THOMASWYLDE'logo at hardware inlay of bag-May pucker for
bagSize: 12.6" x 5.5"This bag comes with: Thomas Wylde dustbag and
Thomas Wylde tag and cards
Thomas Wylde Evening Bag Black 8529 Link :
http://www.luxury-gift.org/Watches/Handbags-6695.html Tag: WQL query builder Tag: 145721
Capture SQL statements on Client side ADO.NET
Hi Everyone,
I have to capture & log all SQL statements on Client side ADO.NET. It is
not allowed to run SQL profiler against Oracle/SQL server.
It is a winform application based on .NET 3.5.
Could anyone please give me any idea about capturing&logging all SQL
statements on Client side ADO.NET?
Thanks a lot in advance,
Jin. Tag: WQL query builder Tag: 145712
Missing parameter for data adapter select
Hi
I am using below in my dataadapter SELECT statement;
SELECT <field list>
FROM Clients
WHERE (Status = ?)
ORDER BY ID
What if I need all clients regardless of status, is there a way to modify
the above statement to include this situation or is a second query needed
for that?
Thanks
Regards Tag: WQL query builder Tag: 145706
ANN: DBTyP.NET 2008 - Database Comparison Tool - New Release
This is a multi-part message in MIME format.
------=_NextPart_000_0049_01C8DD65.908B9000
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
DBTyP.NET 2008 Release 3=20
Vienna, Austria - June 28, 2008
Today, BYPsoft announced the availability of DBTyP.NET 2008 Release 3, =
the newest version of the cross-database comparison tool that compares =
SQL Server, MySQL and Oracle databases (schema and data). DBTyP.NET 2008 =
Release 3 is available for download from http://www.bypsoft.com.
With its rich support for schema and data cross-database comparison, =
DBTyP.NET takes the mystery out of databases, making their comparison =
practical and easy for programmers and database administrators =
everywhere. Over and above its powerful comparison capabilities till =
now, BYPsoft added to the DBTyP.NET 2008 support for schema comparisons =
for Oracle databases. Full cross database comparison family includes now =
support for SQL Server, MySQL and Oracle databases in the latest release =
of DBTyP.NET 2008 for a fraction of the cost of single-database =
solution.=20
Since the DBTyP.NET is under constant development, user interface has =
been redesigned and rich visual interface and easy-to-use features of =
DBTyP.NET 2008 allow developers and DBAs to identify and deploy changes =
quickly on all supported databases and enhance productivity and maximize =
results. Features like colorfull differences, different objects icons, =
visual column description, in place colorfull script differences, =
multiple views and more all save time and ensure accuracy.
In addition to all the new features listed above, in the latest release =
of DBTyP.NET 2008 BYPsoft includes also the following:=20
a.. SQL Server 2008 Ready=20
b.. Support for SQL Server ROWGUIDCOL=20
c.. Filtered out system objects on SQL Server databases.=20
d.. Support SQLServer user defined types.=20
e.. Support MySQL ENUM and SET data types.
We know that constant development is the key to progress, therefore we =
already started working on all new cool features. Stay with us.=20
------=_NextPart_000_0049_01C8DD65.908B9000
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.2900.5583" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD><FONT face=3DArial><FONT size=3D2>
<BODY>
<DIV>
<DIV><STRONG><FONT face=3DVerdana>DBTyP.NET 2008 Release =
3</FONT></STRONG>=20
<H2 class=3Dwestern><STRONG><FONT face=3D"Verdana, sans-serif"><FONT =
size=3D2>Vienna,=20
Austria - June 28, 2008</FONT></FONT></STRONG></H2>
<P><FONT face=3D"Verdana, sans-serif"><FONT size=3D2>Today, BYPsoft =
announced the=20
availability of DBTyP.NET 2008 Release 3, the newest version of the=20
cross-database comparison tool that compares SQL Server, MySQL and =
Oracle=20
databases (schema and data). DBTyP.NET 2008 Release 3 is available=20
for download from <A=20
href=3D"">http://www.bypsoft.com</A>.</FONT></FONT></P>
<P><FONT face=3D"Verdana, sans-serif"><FONT size=3D2>With its rich =
support for=20
schema and data cross-database comparison, DBTyP.NET takes the mystery =
out of=20
databases, making their comparison practical and easy for programmers =
and=20
database administrators everywhere. Over and above its powerful =
comparison=20
capabilities till now, BYPsoft added to the DBTyP.NET 2008 support for =
schema=20
comparisons for Oracle databases. Full cross database comparison family =
includes=20
now support for SQL Server, MySQL and Oracle databases in the latest =
release of=20
DBTyP.NET 2008 for a fraction of the cost of single-database solution.=20
<BR><BR>Since the DBTyP.NET is under constant development, user =
interface has=20
been redesigned and rich visual interface and easy-to-use features of =
DBTyP.NET=20
2008 allow developers and DBAs to identify and deploy changes =
quickly on=20
all supported databases and enhance productivity and maximize results. =
Features=20
like colorfull differences, different objects icons, visual column =
description,=20
in place colorfull script differences, multiple views and more all save =
time and=20
ensure accuracy.<BR><BR>In addition to all the new features listed =
above, in the=20
latest release of DBTyP.NET 2008 BYPsoft includes also the following:=20
</FONT></FONT></P>
<UL>
<LI>
<P style=3D"MARGIN-BOTTOM: 0cm"><FONT face=3D"Verdana, =
sans-serif"><FONT=20
size=3D2>SQL Server 2008 Ready </FONT></FONT></P>
<LI>
<P style=3D"MARGIN-BOTTOM: 0cm"><FONT face=3D"Verdana, =
sans-serif"><FONT=20
size=3D2>Support for SQL Server ROWGUIDCOL </FONT></FONT></P>
<LI>
<P style=3D"MARGIN-BOTTOM: 0cm"><FONT face=3D"Verdana, =
sans-serif"><FONT=20
size=3D2>Filtered out system objects on SQL Server databases.=20
</FONT></FONT></P>
<LI>
<P style=3D"MARGIN-BOTTOM: 0cm"><FONT face=3D"Verdana, =
sans-serif"><FONT=20
size=3D2>Support SQLServer user defined types. </FONT></FONT></P>
<LI>
<P><FONT face=3D"Verdana, sans-serif"><FONT size=3D2>Support MySQL =
ENUM and SET=20
data types.</FONT></FONT></P></LI></UL>
<P><FONT color=3D#000000><FONT face=3D"Verdana, sans-serif"><FONT =
size=3D2>We know=20
that constant development is the key to progress, therefore we already =
started=20
working on all new cool features. Stay with us.=20
</FONT></FONT></FONT></P></DIV></DIV></BODY></HTML></FONT></FONT>
------=_NextPart_000_0049_01C8DD65.908B9000-- Tag: WQL query builder Tag: 145703
Newbie question: Cstr vs toString
Hi
I have a WinForm app with a bound form. When user enters a value in field
rateid I lookup the respective rate amount from a table and assign it to
field rate.I am using the DLookup function to achieve this (full code given
below). This function returns a value of type object so I need to convert it
to string. If I use the function as below (using ToString) it works fine;
Me.txtRate.Text = DLookup(<parameters here>).ToString
but if I use it with a CStr
Me.txtRate.Text = CStr(DLookup(<parameters here>))
and then browse through 2-3 record the form stops showing data in the bound
fields. This brings me to question; what is the difference between CStr and
tostring that could be causing the above problem?
Thanks
Regards
=======
Function DLookup(ByVal SearchFld As String, ByVal SearchTbl As String, ByVal
SearchCriteria As String) As Object
Dim Cmd As OleDb.OleDbCommand
Dim Reader As OleDb.OleDbDataReader
Cmd = New OleDb.OleDbCommand("SELECT " & SearchFld & " FROM " & SearchTbl
& " WHERE " & SearchCriteria, DBConnection())
Reader = Cmd.ExecuteReader()
If (Reader.Read()) Then
DLookup = Reader.GetValue(0)
Else
DLookup = DBNull.Value
End If
Reader.Close()
Reader = Nothing
Cmd = Nothing
End Function Tag: WQL query builder Tag: 145696
Count all records for all tables
Hi Experts
Hope Iâ??m in the correct thread.
Iâ??m using VS 2005 and the .NET Framework Data Provider for Oracle to connect
to an Oracle 7 database.
All is ok and I can view and run simple SQL like
SELECT COUNT(*) AS EXPR1
FROM ADDRESSES
Iâ??m trying to write some SQL that will count all the records in all the
tables. I have over 600 tables in the Oracle database.
Iâ??ve tried
SELECT OBJECT_NAME(id) AS Expr1, rows
FROM sysindexes
WHERE (indid IN (1, 0))
Which works ok when connected to SQL Server but not Oracle.
Any ideas? Tag: WQL query builder Tag: 145689
How VS2008 DataSet generated works?
Hello,
I'm new in .Net world and there is so many info that I'm lost. DataSet is
creted by Visual Studio 2008 to handle a FireBird database. Where can I find
documentation about how to use theses classes in a better way?
What is the most efective way to use it: load table by table from the
database and DataSet handles it or is better create a composite query leaving
the work to the database and DataSet gets the relationship already done?
Thanks,
Marco Castro Tag: WQL query builder Tag: 145688
Error occurred during the pre-login handshake
Hi all,
Can anyone tell me why in my production server get the error when I try to
open SqlConnection using ADO.NET? The error happen intermittent. My server is
running Windows Server 2003 and SQL Server 2005.
Below is the error:-
Source = .Net SqlClient Data Provider
Error = A connection was successfully established with the server, but then
an error occurred during the pre-login handshake. (provider: SSL Provider,
error: 0 - Not enough storage is available to complete this operation.) |
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.ConsumePreLoginHandshake(Boolean
encrypt, Boolean trustServerCert, Boolean& marsCapable)
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo,
SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64
timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean
integratedSecurity, SqlConnection owningObject)
at
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo
serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64
timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String
host, String newPassword, Boolean redirectedUserInstance, SqlConnection
owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open() Tag: WQL query builder Tag: 145685
What does payload mean?
What does the term payload mean in the following links?
http://dotnetaddict.dotnetdevelopersjournal.com/adoef_vs_linqsql.htm
http://msdn.microsoft.com/en-us/library/aa697428(VS.80).aspx
Thanks for any help. Tag: WQL query builder Tag: 145682
Read a Visual FoxPro dbf file.
Hi all.
I'm trying to open a dbf file which appears to be FoxPro. I've tried using
the OLE and ODBC classes but I'm not having any luck.
I keep getting an exception: "The Microsoft Jet database engine could not
find the object 'EQR_TRANSACTION_200803'. Make sure the object exists and
that you spell its name and the path name correctly."
Here is the ODBC code:
try
{
string connString = @"DBQ=C:\Test;Driver={Microsoft dBase Driver (*.dbf)};
DriverId=277";
OdbcConnection conn = new OdbcConnection(connString);
OdbcDataAdapter da = new OdbcDataAdapter("select * from
EQR_TRANSACTION_200803", conn);
DataTable table = new DataTable("table");
da.Fill(table);
dataGridView1.DataSource = table;
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
Any ideas?
Thanks,
Joe Tag: WQL query builder Tag: 145680
Monogram Canvas Tikal GM M40077 - www.luxury-gift.org
Monogram Canvas Tikal GM M40077 - www.luxury-gift.org
Luxury Gift : http://www.luxury-gift.org
Louis Vuitton handbags : http://www.luxury-gift.org/Handbags/Louis-Vuitton-handbags.html
Monogram Canvas Tikal GM M40077 Link :
http://www.luxury-gift.org/Handbags/Handbags-7299.html
Monogram Canvas Tikal GM M40077 Information :
Brand : Louis Vuitton handbags
Code :
Description :
This soft and functional Monogram canvas bag is inspired by the Mayan
city in Guatemala. It features a shoulder strap and its ample space is
ideal for a shoulder strap and its ample space is ideal for everyday
essentials.- Golden brass pieces- Zipper closure- Inside patch pocket
with Twist Lock- Carried on the shoulder- Natural cowhide strapSize:
11.8" x 7.9" x 6.7"This Monogram Canvas Tikal GM Handbag comes
with:Serial and model numbers, the LV dust bag, care booklet, LV
cards, and copy of the genuine receipt from an official LV store.
Monogram Canvas Tikal GM M40077 Link :
http://www.luxury-gift.org/Watches/Handbags-7299.html Tag: WQL query builder Tag: 145671
Balenciaga Giant City Bag Silver - www.luxury-gift.org
Balenciaga Giant City Bag Silver - www.luxury-gift.org
Luxury Gift : http://www.luxury-gift.org
BALENCIAGA handbags : http://www.luxury-gift.org/Handbags/BALENCIAGA-handbags.html
Balenciaga Giant City Bag Silver Link :
http://www.luxury-gift.org/Handbags/Handbags-8244.html
Balenciaga Giant City Bag Silver Information :
Brand : BALENCIAGA handbags
Code :
Description :
The giant gold hardware compliments the silver leather beautifully and
doesn't seem over-the-top on this particular size.Balenciaga actually
uses distressed leather which gives the bag the slouchy unique and
ultra chic look.The result is rocker chick with a sophisticated
twist.- Silver calf leather- Fully lined- Internal compartment with
zip closure- Balenciaga signature trademark and serial number stamped
inside- Double leather handles plus removable leather shoulder strap-
Zip closure with long leather zip-tassel，extra tassel included-
Detachable mirror - Antique brass hardwareMade in ItalySize: 15"W X
9"H X 5.5"D (W38 x H24 x D14 CM)Shoulder-strap/handle: 4.5" (11.5
CM)This handbag comes with: Balenciaga Dust bag, controllato card,
spare tassle, shoulder strap, cosmetic mirror and tags attached.
Balenciaga Giant City Bag Silver Link :
http://www.luxury-gift.org/Watches/Handbags-8244.html Tag: WQL query builder Tag: 145670
Scripts failing without error
I have some simple scripts to create databases and add users/roles. The
scripts run just fine in Management Studio. When I run them programmitcally
they execute without any errors, however nothing happens; neither the users
nor the databases are created.
Here's an example for adding a user and setting role to sysadmin:
-- Get Major Version of Sql Server
-- 8 = Sql Server 2000
-- 9 = Sql Server 2005
DECLARE @version nvarchar(128)
select @version = LEFT(CONVERT(nvarchar(128),
SERVERPROPERTY('productversion')), 1)
-- Store traffic user and password
DECLARE @cmduser varchar(128)
DECLARE @cmdpass varchar(128)
select @cmduser = 'myuser'
select @cmdpass = 'mypassword'
DECLARE @userid int
-- Create user if doesn't exist
if @version = '9'
begin
--if not exists (select * from [master].[sys].[syslogins] where name =
@cmduser)
IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = @cmduser)
begin
EXEC sp_addlogin @cmduser,@cmdpass
end
end
if @version = '8'
begin
-- Is there a proper way to do this in SQL Server 2000?
if not exists (select * from [master].[dbo].[sysxlogins] where name =
@cmduser)
begin
EXEC sp_addlogin @cmduser,@cmdpass
end
end
-- Give user system admin privileges
--EXEC master..sp_addsrvrolemember @cmduser, 'sysadmin'
EXEC master..sp_addsrvrolemember @loginame = @cmduser, @rolename = 'sysadmin' Tag: WQL query builder Tag: 145666
Lookup in gridview
Hi
I have a gridview bound to a backend table A via dataset/data adapter. A
drop down is bound to a second table B. When user selects a value form drop
down I want to lookup another column in table B based on value selected from
drop down and assign the lookup value to a column in gridviw. How can I pick
the value selected by user and do the lookup from table B?
Thanks
Regards Tag: WQL query builder Tag: 145665
Access database: How to set Isolation Level using System.Data.OleD
Hello!
How can I set the connection Isolation level for a Access database using
System.Data.OleDb?
In old days ;) of Visual Basic 6 and ADO we had the IsolationLevel property
in the connection object.
But in ADO.NET System.Data.OleDb I can't find anything to set the isolation
level!!
So, does anyone know how to set this ?
Thanks for your help and attention.
Jorge C. Tag: WQL query builder Tag: 145663
UpdateRowSource.FirstReturnedRecord not working on .Net 2.0
I have a project that has been upgraded from .Net 1.1 to 2.0 and I cannot get
the UpdateRowSource.FirstReturnedRecord of the InsertCommand to work
correctly using the System.Data.OracleClient. It works correctly on 1.1 and
the DataSet is updated correctly after a DataAdapter.Update, but although the
insert happens to the database on 2.0, the DataSet is not updated.
My InsertCommand is a stored procedure that gets the next id (primary key)
for the tables instance, inserts the new record with the id, and then gets
the newly inserted row as an output.
The expected behaviour is the DataSet I passed into the Update method is
returned with the record containing the new id.
Has anybody run into this problem and found a work-around?
Regards,
Albert Tag: WQL query builder Tag: 145657
Linq to Sql providers
I have two questions regarding Linq to Sql providers:
1. Are there any other besides MS SQL Server available?
2. How to program custom Linq to Sql provider? (Obviously I expect only some
guidelines and "getting started" type of advice.
Thank you in advance,
Roger Tag: WQL query builder Tag: 145651
Closing Database connection in Window Service during System Shutdown
Hi All,
I am stuck up in a strange situation. I have a window service
responsible for some background database process.
Is there any possible solution to close open database connection when
server is re-booted ? Please see the source snippet I used.
protected override void OnShutdown()
{
//close database connection if any
ClassDatabase.CloseDBConn();
//Log to verify if Shutdown is called.
string strLog = "Service Shutdown.\t" + DateTime.Now.ToString();
CLogHelper.Log(strLog);
}
Is there any kind of limitation in OnShutdown Function? Any help would
be highly appreciated.
Regards
- Amit Gupta Tag: WQL query builder Tag: 145647
app.config Connection string
Hi to all,
How can i change at design time My.MySettings.ESTConnectionString?, the
problem is that the Server and Instance can change when i run the program
for the first time, i am intending to build a form in order to users change
this parameters (Connection String, User and Password)
Thanks very much for helping
Joao
<connectionStrings>
<add name="appCHSocial.My.MySettings.ESTConnectionString"
connectionString="Provider=SQLOLEDB;Data Source=DOTNET-PC\SQLExpress;Initial
Catalog=xxx;User Id=sa;Password=xxx;"
providerName="System.Data.Sql" />
</connectionStrings> Tag: WQL query builder Tag: 145645
ADO.net locks out SQL2000 user account under load
This is a strange problem to describe so you will have to bear with me! I
have developed a web application using c#.net that utilises server side ASPX
pages that connect to a SQL2000 database. I have been load testing my
application with the Microsoft Application Test Center that comes with Visual
Studio 2003, with simulated loads of 10 - 400 users.
When I run a test against my web application for upwards of 10 concurrent
users I start to get strange results from the database for what should be
routine queries. I execute a simple query looking for a row in a table which
I know is there (100% certain!) and the query returns the results to a
dataset. I then get the first datatable from the dataset and check that the
dataset.rows.count variable is greater then 0. Which it always is! I then
proceed to look for a column that exists in the table which I specifically
selected and an exception is thrown telling me the column doesnt exist in the
datatable. This is actually impossible the data is DEFINATLEY there!
I can log into SQL Query analyser as the same SQL logon that the ASPX page
uses to connect and run the same query and it returns the expected results
without error or anaomoly.
Once an error of this type has occured, I can replicated it upto 10 minutes
after it first has happened. During this 10 minute period I can switch the
SQL logon the ASPX uses and it runs fine. As soon as I switch it back to the
user on which the error occured it demonstrates the same problem again. After
10 minutes the problem disappears and wont happen again until I apply a heavy
load to the server.
As an important note, I have now managed to replicate an identical problem
with just 2 users trying to concurrently login.
Here is the snippet of code iam using to query the database:
public static DataSet execute_DataTable(String SQL_Command_String)
{
String connectionString;
connectionString =
getConnectionString(@"..\xml_Settings\DB_Connect.xml");
makeConnection(connectionString);
DataSet dsResults = new DataSet();
try
{
SqlDataAdapter dbAdapter = new
SqlDataAdapter(SQL_Command_String, dbConn);
dbAdapter.Fill(dsResults, "Results");
}
catch (Exception exp)
{
throw new Exception(exp.Message + " " + exp.StackTrace, exp);
}
finally
{
dbConn.Close();
}
return dsResults;
}
This function is located in a static class in a class library that compiles
to a DLL that is then referenced in my web project. Every time an ASPX page
requires to query the database this method is called.
When I load test my application a typical session will involve 2000 queries
in a very short period of time. This is because I use a recursive c# function
for generating a tree that executes alot of SQL queries.
Iam really out of ideas here guys , does any one have any ideas? All I can
think of is disposing of the dataset when iam done?
Thanks in advance!
Mike Tag: WQL query builder Tag: 145644
http://cbt.googletoad.com | Free training Videos
http://cbt.googletoad.com
Microsoft, Cisco , Vmware , Oracle , Java and all kind of training
videos are here for free. Tag: WQL query builder Tag: 145638
ADO.NET EntityFramework and Large SQL Databases
Hello.
This is my scenario. I am building a WinForm app. I have a 300+ tables
databases.
My problem comes everytime i have to build my app. it takes forever and i
guess the reason is that everytime that i compile, the system is compiling
the 300+ entities it just created. i found a bizarre solution to my problem
by having another project, a class library project, only for the model. Then
i unchecked the Build in the Solution properties so it doesn't get built all
the time. That's fine, but for some reason, i cant find the provider class
and also i am having other issues. i guess my question is... Is there a
DESCENT way to have the Entity model co-existing in peace in my Winform
project and do not wait up to 2 minutes everytime i need to build my app
(which happens about 300 times a day in test phase)
Any hint on this would be higly appreciated Tag: WQL query builder Tag: 145637
how to identify the OleDb exception without relying on its message
I have written the code that allows to work with a password protected
Microsoft Access database as well as with regular (not password protected)
Access DB in VB. Net. I use OleDb objects. I need to identify whether a
current database is password protected, or not. For this purpose, I create a
regular connection string with no password set, and try to open the
connection. This piece of code is embedded into Try..Catch.. structure. If a
database is password protected, an OleDb exception is raised, with the
message "Not a valid password". To determine what is the reason of failure to
open a connection, I test the message property of the exception. If it
contains the string "Not a valid password", then I can conclude that the
database is password protected.
This code worked fine until we shipped our software to Netherland. I have
found that the message is now "Geen geldig watchwoord", and my code stopped
working.
The question 1: is there a way to identify the particular exception by an
universal attribute (like Error number) without relying onto its message
(which looks different in localized versions of OS)?
The question 2: is there an alternative way to find whether a Microsoft
Access database is password protected?
Thanks
Igor Tag: WQL query builder Tag: 145636
.net hold query results?
Hello, friends,
We have a windows service which will query database through a web service
every one minute. If there are new records, this windows service will process
accordingly.
However, if there are no new records for a long time, say 2 days in weekend,
this windows service will no longer be able to retrieve new records anymore.
Although it still does the query, but return no records.
We then have to stop and restart this windows service to make it work again.
We believe .net hold query results somewhere, probably in web service.
Rather than actually going to the database to query again, it just returns
whatever cached in memory.
Are we right, and how to solve this problem?
Thanks a lot. Tag: WQL query builder Tag: 145632
Always prompted to save when any Row is Modified
Hello, i have a problem relatrive to DataRowState.Unchanged, i have
the bellow code in my Save Button called by BSModificada()
'IF ANY CHANGE SaveData()
Private Sub BSModificada()
Me.Validate()
Me.TABMAINBindingSource.EndEdit()
Dim vDR As DataRow =3D CType(Me.TABMAINBindingSource.Current,
DataRowView).Row
If vDR.RowState <> DataRowState.Unchanged Then
SaveData()
End If
End Sub
'IF Added or Modifyed Update
Private Sub SaveData()
Try
Dim vvDR As DataRow =3D
CType(Me.TABMAINBindingSource.Current, DataRowView).Row
If vvDR.RowState =3D DataRowState.Detached Then
DBAdiciona()
ElseIf vvDR.RowState =3D DataRowState.Modified Then
DBModifica()
End If
Catch ex As Exception
clsUtilidades.ShowError(ex.Message, ex.ToString)
End Try
End Sub
In DBAdiciona() and DBModifica() i am always Accepting Changes by
Me.ESTDataSet.TAB_MAIN.AcceptChanges().
This code works good, until i try to see if any Change made when
closing the form, i am always prompted to save when any Row is
Modified even i click the save button and Accepting the Dataset
Changes, the code bellow on Form Closing
Private Sub frmEstatisticaMensal_FormClosing(ByVal sender As Object,
ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles
Me.FormClosing
Me.Validate()
Me.TABMAINBindingSource.EndEdit()
Dim vvvDR As DataRow =3D CType(Me.TABMAINBindingSource.Current,
DataRowView).Row
If vvvDR.RowState <> DataRowState.Unchanged Then
If MessageBox.Show("Altera=E7=F5es detectadas, quer gravar?",
"", MessageBoxButtons.YesNo, MessageBoxIcon.Question) =3D
Windows.Forms.DialogResult.Yes Then
e.Cancel =3D True
SaveData()
Else
e.Cancel =3D False
End If
End If
End Sub
Thanks for your time, any help will be welcome
Joao Tag: WQL query builder Tag: 145629
"Database" missing in VS C++ 2008 CLR Windows Forms Application
In a Visual Studio 2008 C++ CLR Windows Forms Application, there is only
an "Object" icon, but no "Database" icon after
Data|Add New Data Source
In a Visual Studio 2005 C++ CLR Windows Forms Application as well as in
a Visual Studio 2008 C# CLR Windows Forms Application, a "Database" icon
is shown.
What do I have to do get this icon in a C++ CLR Windows Forms
Application to create a DataSet?
Thanks
Richard Tag: WQL query builder Tag: 145628
LINQ Where 1=0
I have a asp.net gridview with a LinqDatasource.
When I do a delete the SQL profiler shows
DELETE FROM [dbo].[UsersInRoles] WHERE 0 = 1
The exception is:
[System.Data.Linq.ChangeConflictException] = {"Row not found or changed."}
<asp:LinqDataSource ID="LinqDataSource1" runat="server"
onselecting="LinqDataSource1_Selecting"
ContextTypeName="ApplicationManagment.ApplicationsDataContext"
TableName="UsersInRoles" StoreOriginalValuesInViewState="False"
EnableDelete="True" EnableInsert="True" EnableUpdate="True">
</asp:LinqDataSource>
<cwp:GridView_Ex ID="gvUserInRoles" runat="server"
AutoGenerateColumns="False"
DataKeyNames="UsersInRolesID" DataSourceID="LinqDataSource1"
CanDeleteRows="True" CanEditRows="True"
>
In the datasource_selecting event I have:
ApplicationsDataContext ctx = new
ApplicationsDataContext(ConfigurationManager.ConnectionStrings["cnnApplicationManagement"].ConnectionString);
int[] iqueryAuthorizedApplications =
queryAuthorizedApplications.ToArray();
var queryRoles =
from
u in ctx.UsersInRoles
where
//get authorized and Filtered applications
iqueryAuthorizedApplications.Contains(u.ApplicationID)
&& //filter active
(chkActiveOnly.Checked == false ||
u.ApplicationRole.Application.DateRetired == null)
&& //filter application ddl
(ddlApplications.SelectedValue == "-1" ||
u.ApplicationID.ToString() == ddlApplications.SelectedValue)
&&
u.ApplicationRole.lutRole.IsPublicRole == true
&& // filter roles
(ddlRoles.SelectedValue == "-1" || u.RoleID.ToString() ==
ddlRoles.SelectedValue)
&& //filter Zno
(txtUser.Text == string.Empty || u.UserZno == txtUser.Text)
select u;
e.Result = queryRoles;
I saw in Scott G. Blog you can do this in the event and still have deleting.
How should I debug this?
In the exception handler I don't have access to the DataContext. Is their a
way to get the DataContext from GridViewDeletedEventArgs or the DataSource?
That way I could enumerate the context.ChangeConflicts. Tag: WQL query builder Tag: 145626