Need help with a query
I'm having trouble getting a particular query to work with ADO.NET. I want
to create a query where a returned field contains a certain string depending
on the which of several boolean fields in the database is true. I need a
function that will work in both Access 2000 and SQL Server, but I can't get
anything to work properly. I used to be able to do this with the Switch()
function with DAO and Access97. Does anyone know of a way to do this now
with both Access 2000 and SQL Server?
- Don Tag: Any example to create a custom constraint? Tag: 67177
OracleTransaction has no effect
Hi,
I use the OracleTransaction class. I use multiple OracleCommands
participating in the same OracleTransaction.
When one of the OracleCommands fail when executing and I do a rollback on
the OracleTransaction it does NOT rollback the previous commands. It seems
like the connection? is auto commiting each command I execute.
Does anyone know how to solve this?
Regards,
René Tag: Any example to create a custom constraint? Tag: 67172
Binding the date field to textbox
Hi,
I have the problem with binding the textbox with date field in the table of
the dataset.
The problem is that if the entered text in the textbox isn't of the correct
type (for example "dfhd" instead of "12.6.2003"), the text gets
automatically overwritten by the old value. That way the user has to type
everything all over again instead of just correcting the entered value.
Is there a way to prevent old value to overwrite the entered text?
I used the following code to bind the textbox to a dataview...
Dim objBinding As New Binding("Text", ds.NETBill.DefaultView, "Date")
AddHandler objBinding.Format, AddressOf FormatDate
txtDatum.DataBindings.Add(objBinding)
...and following code to validate entered text...
Private Sub txtDatum_Validating(ByVal sender As Object, ByVal e As
System.ComponentModel.CancelEventArgs) Handles txtDatum.Validating
If Not ControlValue.CheckValue (txtDate, ControlValue.ETip.tDate,
ds.NETRacun.DefaultView(0)) Then
e.Cancel = True
End If
End Sub
Regards,
Taras Tag: Any example to create a custom constraint? Tag: 67166
ADO OR ADO.NET
I am using VS.NET to develop one small software which based on Windowsforms.
The number of end user is less than 10. So I am wondering I should use ADO
or ADO.NET. Any suggestion is appreciated. Tag: Any example to create a custom constraint? Tag: 67153
Record locking Strategies? (ADO.NET)
Due to the disconnected architecture of the ADO.NET model
which are the recomended strategies for application which
requires record locking (for example a Online Ticket
Application)?
Thanks
Bill Tag: Any example to create a custom constraint? Tag: 67152
OracleClient special characters in column name
Hello
I am working with System.Data.OracleClient
How can I create a table with special characters in
column name ?
I have tried:
OracleCommand oCmd = new OracleCommand("CREATE TABLE
T1 ('_C1' number)");
oCmd.ExecuteNonQuery();
OracleCommand oCmd = new OracleCommand("CREATE TABLE
T1 (\"_C1\" number)");
oCmd.ExecuteNonQuery();
OracleCommand oCmd = new OracleCommand("CREATE TABLE
T1 (\\_C1 number)");
oCmd.ExecuteNonQuery();
OracleCommand oCmd = new OracleCommand("CREATE TABLE
T1 ({_}C1 number)");
oCmd.ExecuteNonQuery();
... but it does not work.
Thanks for replies. Tag: Any example to create a custom constraint? Tag: 67151
Connection pooling in Oracle
Hi,
How can I implement connection pooling in Oracle? I used .NET Framework 1.0,
Oracle .NET Provider 1.0 and Oracle Database 9i
Thanks for the help...
Eka Tag: Any example to create a custom constraint? Tag: 67149
Oracle .NET Provider 1.1
Hi all,
Where can I download Oracle .NET Provider 1.1? Is it available at all?
I need this because i got this error: "Failed to initialize distributed
transaction. Please see KB article Q322343."
I saw the KB already and it said that i need to download Oracle .NET
Provider 1.1 but I couldn't find it.
Thanks for help..
Eka Tag: Any example to create a custom constraint? Tag: 67148
Problem with the OleDb.OleDbCommandBuilder
Hi all,
Since my experience with sql is just beginning to grow
i use the commandbuilder object to generate updatecommands deletecommands
insertcommands.
With first run th update works without a problem
when i call my update function again (changing the same row again) i get
"Concurrency violation: the UpdateCommand affected 0 records."
Exception
The debugger shows that the dataset.datatable.row.rowstate = modified
But the update simply doesn't work
Does anyone know what i am doing wrong ?
any help would be greatly appreciated
Thanks & regards
Sven
Code:
For i = 0 to ds.tables.count -1
da.SelectCommand = New OleDb.OleDbCommand("SELECT * FROM " &
ds.Tables(i).TableName, mConnection)
comm = New OleDb.OleDbCommandBuilder(da)
da.UpdateCommand = comm.GetUpdateCommand
da.DeleteCommand = comm.GetDeleteCommand
da.InsertCommand = comm.GetInsertCommand
rowsaffected = da.Update(ds.Tables(i))
Debug.WriteLine("Updated table: " & ds.Tables(i).TableName & " affected
rows: " & rowsaffected)
Next Tag: Any example to create a custom constraint? Tag: 67144
Controls missing in the forms
Hi All,
I am developing an ERP Application in VB.Net. I have used a common
dataset and all the form level datasets are used the common dataset for the
"datasetname"property. But when I open the form, its dead slow to show the
design of the form. My system is P4, 256 MB RAM.
May I know the soluation for the same or welcome any suggestions?.
Also sometimes the control are missing while loading the form in the
design time. but the same control object is available in the genereated code
of the form.
Can u help me for the same??
Thanks,
Rethish Tag: Any example to create a custom constraint? Tag: 67141
Reading Excel with ADO
Hello,
I have tried to read Excel spreadsheet through ADO. I used the sample code
provided by msdn.I don't know what the fuck is the matter with the code
cause I can't read the Excel. I tried similar system with Access and it
works fine. Here is the error and the sample code.
Error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Excel Driver] The Microsoft Jet database engine could not
find the object 'ASPTOC'. Make sure the object exists and that you spell its
name and the path name correctly.
/ASPTOC.asp, line 21
Code:
<%@Language=VBScript %>
<html>
<head>
<title> Displaying An Excel Spreadsheet in an Web Page </title>
</head>
<body bgcolor="#FFFFFF" text="#000000" >
<h1>ASP Table of Contents</h1>
<%
'Creates an instance of an Active Server Component
Set oConn = Server.CreateObject("ADODB.Connection")
'Connects to the Excel driver and the Excel spreadsheet
'in the directory where the spreadsheet was saved
strProvider = "Driver={Microsoft Excel Driver (*.xls)};
DBQ=C:\Inetpub\wwwroot\Testi_site\ASPTOC.xls;"
'Opens the connection to the data store
oConn.Open strProvider
'Selects the records from the Excel spreadsheet
strCmd = "SELECT * from `ASPTOC`"
Set oRS = Server.CreateObject("ADODB.Recordset")
'Opens the recordset
oRS.Open strCmd, oConn
'Prints the cells and rows in the table
Response.Write "<table border=1><tr><td>"
'Gets records in spreadsheet as a string and prints them in the table
Response.Write oRS.GetString (, , "</tr><td>", "</td></tr><tr><td>",
NBSPACE)
%>
</body>
</html>
It looks like ODBC error but I did the ODBC like instructed. I also
installed the .net framework and latest MDAC to the server. The sample code
instructions say that u should use Excel 98 or 2000. I'm using Excel 2002.
Can this be the problem?? I think i've tried everything but can't figure
this out. Can anyone please help me???
Thanks!
KS Tag: Any example to create a custom constraint? Tag: 67138
Confused by one more piece of IBindingList
Thanks for all the help I've been getting working on understanding
IBindingList and data binding in general.
My understanding about IBindingList is that it's primary use is for binding
custom strongly typed collections to complex controls (primarily DataGrid)..
So by grouping the parts of the interface into their various functionality
I'm coming to grips with how it works, with one exception..
Datagrid doesn't have any searching ability AFAIK, so why does IBindingList
have functionality for searches? I know that it's optional, and doesn't
have to be implemented.. But every other piece of the interface maps to a
piece of the puzzle needed for the grid to be able to handle adding,
removing, editing rows of data, sorting them, and so on.
So is the search functionality actually used? And if so where?
I hope I'm not just being obtuse.. I'm just trying to make sure I don't
dismiss that section of the interface and then later find out it's used
internally by something else, and I've hosed things by not implementing it..
Thanks in advance (again)
William Rowland Tag: Any example to create a custom constraint? Tag: 67133
How do I format datagrid column to short time?
In my VB.Net program I am populatating a datagrid column using an MS Access
database field that that contains data formated in "Short Time" (17:34).
Right now, the datagrid displays the entire date and time. I need only the
short time. How can I do this simply?
I dont't use ASP.
Thanks,
Gigi Tag: Any example to create a custom constraint? Tag: 67128
Looking for dialog to browse available connections
Can anyone point me to a dialog box which will allow me to browse for an
ADO.NET (or ODBC) connection?
The user would select the provider (ODBC data source), the server, database
etc. Dialog would construct the connection string.
Thanks Tag: Any example to create a custom constraint? Tag: 67127
Binding a SQL Image Column to an Image Control - Can I Avoid Saving The ByteStream/FileStream To Disk ?
This is a multi-part message in MIME format.
------=_NextPart_000_001E_01C385E1.A67BC190
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I have a C#/ASP.NET/ADO.NET/SQL Server app that stores and retrieves =
images.=20
The problem is the ASP Image control binds to a file. When retrieving an =
image from SQL, I would really like to avoid saving the =
ByteStream/FileStream to disk, just to then read it back into the Image =
control.=20
Is there a way to avoid this?
// This is my current implentation. It works, but requires lots of disk =
i/o.
// Write the ByteArray to a FileStream and then the FileStream to disk.
iLen =3D mySqlDataReader.GetBytes(0, 0, myByteArray, 0, lBufSize);
FileStream myFS =3D new FileStream(@"c:\image.jpg", FileMode.Create, =
FileAccess.Write);
myFS.Write(myByteArray, 0, iLen);
ASPImage1.ImageUrl =3D @"c:\image.jpg";
Thanks in advance,
Ben
------=_NextPart_000_001E_01C385E1.A67BC190
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff background=3D"">
<DIV><FONT face=3D"Courier New" size=3D2>I have a C#/ASP.NET/ADO.NET/SQL =
Server app=20
that stores and retrieves images. </FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Courier New" size=3D2>The problem is the ASP Image =
control binds=20
to a file. When retrieving an image from SQL, I would really like =
to avoid=20
saving the ByteStream/FileStream to disk, just to then read it back =
into=20
the Image control. <BR></FONT><FONT><FONT face=3D"Courier New" =
size=3D2>Is there a=20
way to avoid this?</FONT></DIV></FONT>
<DIV><FONT size=3D2><FONT face=3D"Courier New"><FONT><FONT=20
face=3DArial></FONT> </DIV></FONT></FONT></FONT>
<DIV><FONT face=3D"Courier New" size=3D2>// This is my current=20
implentation. It works, but requires lots of disk=20
i/o.</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>// Write the ByteArray to a =
FileStream and=20
then the FileStream to disk.<BR>iLen =3D mySqlDataReader.GetBytes(0, 0,=20
myByteArray, 0, lBufSize);<BR>FileStream myFS =3D new =
FileStream(@"c:\image.jpg",=20
FileMode.Create, FileAccess.Write);<BR>myFS.Write(myByteArray, 0,=20
iLen);</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>ASPImage1.ImageUrl =3D=20
@"c:\image.jpg";</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Courier New" size=3D2>Thanks in advance,</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>Ben</FONT></DIV>
<DIV><FONT face=3D"Courier New" =
size=3D2></FONT> </DIV></BODY></HTML>
------=_NextPart_000_001E_01C385E1.A67BC190-- Tag: Any example to create a custom constraint? Tag: 67122
Cursors and ExecuteNonQuery
All,
Is it possible for ExecuteNonQuery to open a cursor? The
reason I ask is that I'm debugging a client's C# service
which is leaking cursors and eventually Oracle throws a
MAX CURSOR EXCEEDED exception and the service dies a
horrible death. It appears that the method that is the
main culprit calls several stored procedures which do
something like:
INSERT INTO FOO ( ... ) RETURNING FOO_ID;
The FOO_ID is setup in the C# as an output parameter and
additionally, the client never calls the Dispose method on
the Command object.
Additionally, the Command objects are used like so:
cmd = new OleDbCommand("sp1", cnx);
...
cmd.ExecuteNonQuery();
...
cmd = new OleDbCommand("sp2", cnx);
...
cmd.ExecuteNonQuery();
...
Would this technique cause cursor leaks? Thanks...
Matt Tag: Any example to create a custom constraint? Tag: 67121
Not getting SqlException using DataReader
I'm using a SqlDataReader to call a proc that reads data. My call to
raiseerror has no effect. Below is the code. if i comment out the select
statement, my code behaves as expected.
CREATE PROCEDURE [dbo].[usp_Table1Read]
@id int
AS
--select * from table1 where IId = @Id
if (@@rowcount = 0)
begin
raiserror('an error occured', 10, 1)
return 50000
end
return 0
GO
using System;
using System.Data;
using System.Data.SqlClient;
namespace ReaderTest
{
/// <summary>
/// Summary description for Class1.
/// </summary>
class Class1
{
/// <summary>
/// The main entry point for the application.
/// </summary>
[STAThread]
static void Main(string[] args)
{
Class1 c = new Class1();
c.DoWork();
}
public void DoWork()
{
try
{
//connection
SqlConnection connection = new SqlConnection();
connection.ConnectionString = "Persist Security Info=False;Integrated
Security=SSPI;database=MyDataBase;server=(local)";
connection.Open();
connection.InfoMessage += new
SqlInfoMessageEventHandler(this.MySqlInfoHandler);
//command
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "usp_Table1Read";
command.Connection = connection;
//create return parameter
SqlParameter p = new SqlParameter();
p.ParameterName = "@RetVal";
p.Direction = ParameterDirection.ReturnValue;
p.SqlDbType = SqlDbType.Int;
command.Parameters.Add(p);
p = new SqlParameter();
p.ParameterName = "@Id";
p.Direction = ParameterDirection.Input;
p.SqlDbType = SqlDbType.Int;
p.Value = "3";
command.Parameters.Add(p);
//get reader
SqlDataReader reader = command.ExecuteReader();
//look at return parameter (1)
Console.Write("Check 1: ");
Console.WriteLine(command.Parameters["@RetVal"].Value);
while(reader.Read()){}
reader.Close();
connection.Close();
//look at return parameter (2)
Console.Write("Check 2: ");
Console.WriteLine(command.Parameters["@RetVal"].Value);
}
catch(Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
public void MySqlInfoHandler(object sender, SqlInfoMessageEventArgs e)
{
Console.WriteLine("************************");
Console.WriteLine(e.Message);
Console.WriteLine("************************");
}
}
} Tag: Any example to create a custom constraint? Tag: 67120
Referencing datarow/datareader values by property name vs index - How big a hit?
I've read several times that there is a performance hit when referencing
column values in ADO.Net by property name vs index number. Could someone
clue me in to how serious a hit this is, and maybe point me towards an
explanation as to the extra steps involved in referencing by name that are
causing the slowdown?
i.e.
variable=datareader(3)
is faster than
variable=datareader("LastName")
I hate giving up readability in my code (my code documentation skills are
bad enough already), and I've also got a paranoia of the order of columns
somehow getting shifted around. (I know when I bind a table to a datagrid,
the column order doesn't always match the order in the table..)
Any comments?
Thanks,
W.G. Rowland Tag: Any example to create a custom constraint? Tag: 67116
Cannot find rows with GUID
Hello All
I have a table with column ID that is a uniqueidentifier. However I
can't seem to use the Find method of the Rows to located a GUID row.
For e.g. I'm passing a GUID string as
"{2446AF50-386F-4EC6-9E3D-44C4F1ACBF70}" and then using this to locate
the row
//Initialization ....
oDAProjectData.Fill(oDS);
DataTable tbl = oDS.Tables["PData"];
tbl.PrimaryKey = new DataColumn[]{tbl.Columns["ID"]};
// In update method...somewhere in code
DataRow dr = oDS.Tables["PData"].Rows.Find(new Guid(projID));
However, dr is evaluating to null so I can't update the row. Any ideas
what might be wrong here.
thanks
Sunit Tag: Any example to create a custom constraint? Tag: 67103
clear a value from combo
i can do a clear and i clear all the items of my combo but the selected
value stay
how could i remove it. i've tried to remove each item but i have a problem
of data type between integer and string Tag: Any example to create a custom constraint? Tag: 67102
read a combo binded by code
i can bind a combo by coding with somethin' like that:
Me.ComboBox1.DataSource = dataset
Me.ComboBox1.DisplayMember = "tabla.Descripcion"
Me.ComboBox1.ValueMember = "tabla.idPublicoObjetivo"
but i can't read it:
i think it should somethin' like:
Me.Label1.Text = Me.ComboBox1.SelectedText.ToString
Me.Label2.Text = Me.ComboBox1.SelectedValue
but it doesnt work. Tag: Any example to create a custom constraint? Tag: 67088
Visual Studio generated Update Queries.. Is this the way to go?
I'm fairly new to SQL Server, and I've been using Visual Studio to help
generate some SQLCommands to make life easier. The Insert, Delete, and
Select Commands it produces all seem fairly straightforward, but I'm
wondering about the Update Commands it generates.
Basically what it seems to do is generate an Update command with parameters
for each property, and then a second parameter for each property in the
Where clause.. So to update a record, it would expect you to enter every
column value of the record to be updated, and then all the new values as
well..
In my case I will always be using the unique identity column to select which
record I'm going to update, and I'm wondering if there's any reason (such as
some effeciency issue in SQL I don't know about) to requre my code to supply
every property in the where clause, or if I could just trim all the extra
parameters and have it simply update record WHERE ID=@parameterID..?
Thanks in advance,
William Rowland Tag: Any example to create a custom constraint? Tag: 67081
Looking for good reference on the data binding interfaces, especially IBindingList
Does anybody know of any good books or sites that cover the data binding
interfaces? I'm trying to put together a set of business collections to
handle my data, and though I can find articles that cover parts of the
interfaces, I've yet to find any detailed explanation on all of
IBindingList.. (i.e. That covers sorting and searching, and the rest..)
Any suggestions would be highly appreciated, as I'm feeling as if I'm in way
over my head..
William Rowland Tag: Any example to create a custom constraint? Tag: 67080
bind a combo by coding
how can i bind by coding with valueMember, displayMember and datasource
properties.
if i do it visually, that's right but if i code it, not.
i do somethin' like that:
Dim gCadenaConexion As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source= " & ObtenRutaAplicacion() & "Datos\Datos.mdb"
Dim conexion As New OleDb.OleDbConnection(gCadenaConexion)
Dim adapter As New OleDb.OleDbDataAdapter("SELECT idPublicoObjetivo,
Descripcion FROM PublicoObjetivo", conexion)
Dim dataset As New DataSet()
conexion.Open()
adapter.Fill(dataset, "tabla")
conexion.Close()
Me.ComboBox1.DataSource = dataset
Me.ComboBox1.DisplayMember = "Descripcion"
Me.ComboBox1.ValueMember = "idPublicoObjetivo" Tag: Any example to create a custom constraint? Tag: 67078
Re-Arrange columns in datagrid?
Ended up using the following to hide unwanted columns and set the width of a
column. Now I want to re-arrange the displayed order of the columns, so I
tried creating another table style and adding the columns in the order I
wanted them, but for some reason I end up with all table style settings
gone. Anyone see what I'm doing wrong?
Thanks - Sean
'Hide un-wanted column
Me.DsGameInfo.Tables("Games").Columns("Home").ColumnMapping =
MappingType.Hidden
'Set column widths
Dim dgts As New DataGridTableStyle()
dgts.MappingName = "Games"
Me.dgGames.TableStyles.Add(dgts)
dgts.GridColumnStyles("Game").Width = 150
'Re-arrange colums
Dim dgts2 As New DataGridTableStyle()
dgts2.GridColumnStyles.Add(dgts.GridColumnStyles("Game"))
dgts2.GridColumnStyles.Add(dgts.GridColumnStyles("Home Score"))
dgts2.GridColumnStyles.Add(dgts.GridColumnStyles("Guest Score"))
dgts2.GridColumnStyles.Add(dgts.GridColumnStyles("Week / Year"))
Me.dgGames.TableStyles.Remove(dgts)
Me.dgGames.TableStyles.Add(dgts2)
Me.dgGames.Refresh() Tag: Any example to create a custom constraint? Tag: 67071
Changing the code generated by the strongly typed dataset designer
In the light of my previous message, is it possible to change the code
generated by the designer used for DataSet's?
I would like to be able to change the visibility of some properties and
methods to protected instead of private (I know I can use 'new' but ...) and
I would also like to move some of the class hierarchy around.
Cheers. Tag: Any example to create a custom constraint? Tag: 67067
Use of DataRowBuilder class
I have recently been doing a lot of work using Strongly Typed DataSet's and
have a (simple?) question.
The classes generated by the designer use the System.Data.DataRowBuilder
class in the constructor of the xxxRow classes. This class is documented
within the Framework help files as being used to support the framework only.
This has previously been stated to mean that the class is subject to removal
or change at a later date if MS so desire, but doing this will then mean
that any code based upon STDS's will cease to function.
Comments? Tag: Any example to create a custom constraint? Tag: 67066
Syntax error in Update Statement
Please let me know what I am doing wrong........
With Dslogin1.Tables("cbEmployee")
' Modify the first record (just append 3 asterisks to Name field)
'.Rows(0)("Employeeid") = .Rows(0)("Employeeid").ToString
.Rows(0)("EmployeeName") = TextBox1.Text.ToString
.Rows(0)("AlphaPagerNumber") = 0
.Rows(0)("LoggedIn") = False
If TextBox3.Text = "" Then
.Rows(0)("FaxNumber") = 0
Else
.Rows(0)("FaxNumber") = TextBox3.Text.ToString
End If
.Rows(0)("Group") = ComboBox1.Text.ToString
If TextBox5.Text = "" Then
.Rows(0)("NumericPagerNumber") = 0
Else
.Rows(0)("NumericPagerNumber") = TextBox5.Text.ToString
End If
.Rows(0)("Password") = TextBox2.Text
'Dslogin1.cbEmployee.
'.Rows(0).AcceptChanges()
End With
Dim cmd As OleDbCommand
'Try
cmd = New OleDbCommand("UPDATE cbEmployee(AlphaPagerNumber, EmployeeName,
FaxNumber, [Group], NumericPagerNumber, [Password]) where employeename = '"
& TextBox1.Text & "'" & "VALUES (@AlphaPagerNumber, @EmployeeName,
@FaxNumber, @Group, @NumericPagerNumber, @Password)", sConn1)
cmd.Parameters.Add("@AlphaPagerNumber", OleDbType.VarChar, 50,
"AlphaPagerNumber")
cmd.Parameters.Add("@EmployeeName", OleDbType.VarChar, 50, "EmployeeName")
'cmd.Parameters.Add("@LoggedIn", OleDbType.Boolean, 250, "LoggedIn")
cmd.Parameters.Add("@FaxNumber", OleDbType.VarChar, 50, "FaxNumber")
cmd.Parameters.Add("@Group", OleDbType.VarChar, 50, "Group")
cmd.Parameters.Add("@NumericPagerNumber", OleDbType.VarChar, 50,
"NumericPagerNumber")
cmd.Parameters.Add("@Password", OleDbType.VarChar, 50, "Password")
OleDbDataAdapter1.UpdateCommand = cmd
Try
OleDbDataAdapter1.Update(Dslogin1.cbEmployee)
Catch ex As Exception
MsgBox(ex.ToString)
End Try
OleDbDataAdapter1.AcceptChangesDuringFill = True
sConn1.Close() Tag: Any example to create a custom constraint? Tag: 67060
Queries problem
Hi
I have two queries as sql strings. How can I take the results of two queries
and use them in a third sql query?
Thanks
Regards Tag: Any example to create a custom constraint? Tag: 67056
Use pack for Windows
--yoavokxntflg
Content-Type: multipart/related; boundary="fuzajnuqkzykd";
type="multipart/alternative"
--fuzajnuqkzykd
Content-Type: multipart/alternative; boundary="ctqauwirtuzpzv"
--ctqauwirtuzpzv
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable
MS Customer
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which fixes
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express.
Install now to maintain the security of your computer
from these vulnerabilities, the most serious of which could
allow an attacker to run executable on your system.
This update includes the functionality =
of all previously released patches.
System requirements: Windows 95/98/Me/2000/NT/XP
This update applies to:
- MS Internet Explorer, version 4.01 and later
- MS Outlook, version 8.00 and later
- MS Outlook Express, version 4.01 and later
Recommendation: Customers should install the patch =
at the earliest opportunity.
How to install: Run attached file. Choose Yes on displayed dialog box.
How to use: You don't need to do anything after installing this item.
Microsoft Product Support Services and Knowledge Base articles =
can be found on the Microsoft Technical Support web site.
http://support.microsoft.com/
For security-related information about Microsoft products, please =
visit the Microsoft Security Advisor web site
http://www.microsoft.com/security/
Thank you for using Microsoft products.
Please do not reply to this message.
It was sent from an unmonitored e-mail address and we are unable =
to respond to any replies.
----------------------------------------------
The names of the actual companies and products mentioned =
herein are the trademarks of their respective owners.
Copyright 2003 Microsoft Corporation.
--ctqauwirtuzpzv
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<HTML>
<HEAD>
<style type=3D'text/css'>.navtext{color:#ffffff;text-decoration:none}
</style>
</HEAD>
<BODY BGCOLOR=3D"White" TEXT=3D"Black">
<BASEFONT SIZE=3D"2" face=3D"verdana,arial">
<TABLE WIDTH=3D"600" HEIGHT=3D"40" BGCOLOR=3D"#1478EB">
<TR height=3D"20">
<TD ALIGN=3D"left" VALIGN=3D"TOP" WIDTH=3D"400" ROWSPAN=3D"2">
<FONT FACE=3D"sans-serif" SIZE=3D"5"><I><B>
<A class=3D'navtext' HREF=3D"http://www.microsoft.com/"
TITLE=3D"Microsoft Home Site" target=3D"_top">Microsoft</A>
</B></I></FONT>
</TD>
<TD ALIGN=3D"right" VALIGN=3D"MIDDLE" BGCOLOR=3D"Black" NOWRAP>
<FONT color=3D"#ffffff" size=3D1>
<A class=3D'navtext' href=3D'http://www.microsoft.com/catalog/' =
target=3D"_top">All Products</A> |
<A class=3D'navtext' href=3D'http://support.microsoft.com/' =
target=3D"_top">Support</A> |
<A class=3D'navtext' href=3D'http://search.microsoft.com/' =
target=3D"_top">Search</A> |
<A class=3D'navtext' href=3D'http://www.microsoft.com/' target=3D_top>
Microsoft.com Guide</A>
</FONT>
</TD>
</TR>
<TR>
<TD ALIGN=3D"right" VALIGN=3D"BOTTOM" NOWRAP>
<FONT FACE=3D"Verdana, Arial" SIZE=3D1><B>
<A class=3D'navtext' HREF=3D'http://www.microsoft.com/' TARGET=3D" top">
Microsoft Home</A> </B>
</FONT>
</TD>
</TR>
</TABLE>
<IMG SRC=3D"cid:hwxtmng" BORDER=3D"0"><BR><BR>
<TABLE WIDTH=3D"600"><TR><TD><FONT SIZE=3D"2">
MS Customer<BR><BR>
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which fixes
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express.
Install now to maintain the security of your computer
from these vulnerabilities, the most serious of which could
allow an attacker to run executable on your system.
This update includes the functionality =
of all previously released patches.
</FONT></TD></TR>
</TABLE>
<BR><BR>
<TABLE BORDER=3D"1" CELLSPACING=3D"1" CELLPADDING=3D"3" WIDTH=3D"600">
<TR VALIGN=3D"TOP">
<TD NOWRAP><FONT SIZE=3D"1"><B><IMG SRC=3D"cid:ptinzad" =
ALIGN=3D"absmiddle" BORDER=3D"0"> System requirements</B>
</FONT></TD>
<TD NOWRAP><F