ADO.NET questions: DbType.Text -- set/get example...?
Question: Can I use SqlDataReader.GetString() to read DbType.Text
field values that are larger than 8,000 characters? For example, if I
decide to store a 256K ASCII text string in a column, will
SqlDataReader.GetString() still be able to read it using a single
call?
Or, do I need to use SqlDataReader.GetChars() or some other methods?
Also, when setting a DbType.Text value that is greater than 8000
characters, do I need to use any special API calls, or can I just set
it as I would set a string field that is 50 characters?
Thanks,
Frank Tag: Check these critical package for Windows Tag: 68429
Beginner getting "Prepared statement...expects parameter...not supplied" error
This is my first crack at ASP.NET and ADO.NET. I am making a page
that will add/change/delete to SQL db using a DataGrid. I found a
sample in a book that does the exact same thing I want using the
Northwind db, but it doesn't work. The select, insert, and delete
commands work fine, but errors out if I uncomment the update code
which is the same format as the others. As soon as I call
DataAdapter.Fill it throws exception. I was under the impression that
this only executes the CommandText for the SqlCommand object set to
the SelectCommand property of the DataAdapter. Can anyone tell me why
this code won't work for the update command?
Here is the error text
Prepared statement '(@CustomerID nchar(5),@ContactName
nvarchar(30),@CompanyName nva' expects parameter @CustomerID, which
was not supplied"
Here's the code for Page_Load:
SqlConnection cnn = new SqlConnection(@"Data Source=<server>; Initial
Catalog=Northwind; Integrated Security=SSPI");
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
private void Page_Load(object sender, System.EventArgs e)
{
//Create SELECT SqlCommand
SqlCommand cmdSelect = cnn.CreateCommand();
cmdSelect.CommandType = CommandType.Text;
cmdSelect.CommandText = "SELECT CustomerID, CompanyName, ContactName
FROM Customers";
//Create UPDATE SqlCommand
SqlCommand cmdUpdate = cnn.CreateCommand();
cmdSelect.CommandType = CommandType.Text;
cmdSelect.CommandText = "UPDATE Customers SET CompanyName =
@CompanyName, ContactName = @ContactName WHERE CustomerID =
@CustomerID";
cmdSelect.Parameters.Add("@CustomerID", SqlDbType.NChar, 5,
"CustomerID");
cmdSelect.Parameters.Add("@ContactName", SqlDbType.NVarChar, 30,
"ContactName");
cmdSelect.Parameters.Add("@CompanyName", SqlDbType.NVarChar, 40,
"CompanyName");
cmdSelect.Parameters["@CustomerID"].SourceVersion =
DataRowVersion.Original;
//Create INSERT SqlCommand
SqlCommand cmdInsert = cnn.CreateCommand();
cmdInsert.CommandType = CommandType.Text;
cmdInsert.CommandText = "INSERT INTO Customers (CustomerID,
CompanyName, ContactName) VALUES (@CustomerID, @CompanyName,
@ContactName)";
cmdInsert.Parameters.Add("@CustomerID", SqlDbType.NChar, 5,
"CustomerID");
cmdInsert.Parameters.Add("@CompanyName", SqlDbType.NVarChar, 40,
"CompanyName");
cmdInsert.Parameters.Add("@ContactName", SqlDbType.NVarChar, 30,
"ContactName");
cmdInsert.Parameters["@CustomerID"].SourceVersion =
DataRowVersion.Original;
//Create DELETE SqlCommand
SqlCommand cmdDelete = cnn.CreateCommand();
cmdDelete.CommandType = CommandType.Text;
cmdDelete.CommandText = "DELETE FROM Customers WHERE CustomerID =
@CustomerID";
cmdDelete.Parameters.Add("@CustomerID", SqlDbType.NChar, 5,
"CustomerID");
cmdDelete.Parameters["@CustomerID"].SourceVersion =
DataRowVersion.Original;
//Set up SqlDataAdapter
da.SelectCommand = cmdSelect;
da.UpdateCommand = cmdUpdate;
da.InsertCommand = cmdInsert;
da.DeleteCommand = cmdDelete;
da.Fill(ds, "Customers");
//Fill grid on page load
if (!IsPostBack)
{
dgCustomers.DataSource = ds;
dgCustomers.DataMember = "Customers";
dgCustomers.DataBind();
}
} Tag: Check these critical package for Windows Tag: 68428
Changing "Allow Zero Length" property for Table Fields of type Text programmatically?
I have plenty tables in MS Access 2000 SP-3 that have fields of type "Text"
and unfortunately, the fields' property "Allow Zero Length" is set to "No".
Is there any way to change those properties automatically to "Yes"? I am
trying to write some 0 length strings with VB ADO.NET to those tables and I
get an error unless I change that property "Allow Zero Length" from "No" to
"Yes". I tried "ALTER TABLE ALTER COLUMN..." but couldn't figure out, how...
Any help is greatly appreciated.
Thanks,
Wolfgang Tag: Check these critical package for Windows Tag: 68427
DataSet Question
Hi,
I have a DataSet that I am using to bind to a combobox. I am trying to get
the column name so I can use it for the display member. I am using the code
below to get it, is there a better way?
DataTable tbl = ds.Tables[0];
DataColumn col = tbl.Columns[0];
this.sizeComboBox.DisplayMember = col.ColumnName; Tag: Check these critical package for Windows Tag: 68416
Data Menu in Visual Studio
Hello-
We have implemented a custom Data Adapter. When an MS Data Adapter (Sql,
OleDB, etc.) is added to a Form, the Data menu options "Genereate
Dataset..." and Preview Data..." options become available for the form.
These tools support the Microsoft Data Adapters as well as third party Data
Adapters (that is custom adapters appear in the dialogs and behave correctly
with the tools). However, the menu options are NOT enabled if ONLY my custom
Data Adapter is added to the form. Is is possible to get these tools enabled
for a custom data adapters? Tag: Check these critical package for Windows Tag: 68405
Update entire column in datatable
Is there a way to update an entire column in a datatable with out going row
by row? Tag: Check these critical package for Windows Tag: 68401
Sample wanted datarelations with no datagrid
Is there a sample out there that uses datarelations with
textboxes for both the parent and children? That
updates, adds, and deletes rows from a database in SQL
server 2000? That uses VB.NET 2003? That scrolls
through the children (can this even be done in a
winform?)?
I know about the basics of datarelations, updating,
adding, and deleting. I guess I am not really sure how
that all works with just using text and combo boxes with datarelation
in the mix. All
samples have a datagrid for children that I have found.
Are there any out there that just uses textboxes?
Let me know if you know of a sample someplace, a book
that would get me started, a website that is worth a
look, if you have some
insight of how you would do it.
Been working on this one form for awhile now. I just
want to get rid of it.
TIA,
Charles
. Tag: Check these critical package for Windows Tag: 68400
Problem with System.DBNull
This is a multi-part message in MIME format.
------=_NextPart_000_0008_01C39174.772C6D60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
I'm trying to read a few values with tmp =3D SqlCmd.ExecuteScalar()
If tmp =3D null (or in this case, System.DBNull), keep going, else, run =
some stuff.
I'm having a problem finding, and skipping fields that are null.
I've tried the following:
If tmp.GetType.ToString <> "System.DBNull" Then
...
End If
This works, however, it generates an exception later on in my program. =
(the next time I call form.show() for any form)
...
An unhandled exception of type 'System.OutOfMemoryException' occurred in =
system.windows.forms.dll
Additional information: Error creating window handle.
...
Is there a correct way of doing this?
Thanks,
Philip Tepedino
Siemens Westinghouse Generation Services
ftepedino@swgs.net
------=_NextPart_000_0008_01C39174.772C6D60
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.1226" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I'm trying to read a few values with =
tmp =3D=20
SqlCmd.ExecuteScalar()</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>If tmp =3D null (or in this case, =
System.DBNull), keep going, else, run some stuff.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I'm having a problem finding, and =
skipping fields=20
that are null.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I've tried the following:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>If tmp.GetType.ToString <> =
"System.DBNull"=20
Then</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>End If</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>This works, however, it generates an =
exception=20
later on in my program. (the next time I call form.show() for any=20
form)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>An unhandled exception of type=20
'System.OutOfMemoryException' occurred in =
system.windows.forms.dll</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Additional information: Error creating =
window=20
handle.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Is there a correct way of doing =
this?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Philip Tepedino</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Siemens Westinghouse Generation=20
Services</FONT></DIV>
<DIV><FONT face=3DArial size=3D2><A=20
href=3D"mailto:ftepedino@swgs.net">ftepedino@swgs.net</A></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML>
------=_NextPart_000_0008_01C39174.772C6D60-- Tag: Check these critical package for Windows Tag: 68392
RESTORE DATABASE Error
I'm attempting to to use ADO.Net to execute a RESTORE DATABASE. Here
is a snippet of the code I am using:
SqlConnection connection = new SqlConnection();
string connectionString =
ConfigurationSettings.AppSettings["ConnectionString"];
SqlCommand count = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand();
try
{
connection.ConnectionString = connectionString;
connection.Open();
count.CommandText = string.Concat("select count(*) from sysdatabases
where [name] = '", destinationDatabaseName, "'");
count.Connection = connection;
if((int) count.ExecuteScalar() > 0)
{
Console.WriteLine(string.Concat("Database ", destinationDatabaseName
," already exists."));
Console.WriteLine("Operation cannot continue. Please press
ENTER.");
Console.ReadLine();
System.Environment.Exit(0);
}
Console.WriteLine("Getting Logical Names and Physical Paths from
server...");
string GetFileInfo = string.Concat("RESTORE FILELISTONLY FROM disk =
'",sourceDatabaseName,".mdf'");
da = new SqlDataAdapter(GetFileInfo, connection);
DataTable dtFileInfo = new DataTable();
da.Fill(dtFileInfo);
Console.WriteLine("Performing RESTORE. This will take several
minutes...");
string CopyCommand = string.Concat("RESTORE DATABASE ",
destinationDatabaseName);
CopyCommand = string.Concat(CopyCommand, " FROM disk = '",
ConfigurationSettings.AppSettings["BackupFilePath"],
sourceDatabaseName, ".mdf' ");
CopyCommand = string.Concat(CopyCommand, " WITH RECOVERY, ");
for(int i = 0; i < dtFileInfo.Rows.Count;i++)
{
CopyCommand = string.Concat(CopyCommand, " MOVE '",
dtFileInfo.Rows[i]["LogicalName"].ToString(),"' TO '",
dtFileInfo.Rows[i]["PhysicalName"].ToString().Replace(sourceDatabaseName,destinationDatabaseName),
"' ");
if(i < (dtFileInfo.Rows.Count - 1))
CopyCommand = string.Concat(CopyCommand, ", ");
}
Console.WriteLine(CopyCommand);
Console.WriteLine();
Console.WriteLine(System.Environment.UserName);
Console.WriteLine("Please wait...");
cmd.Connection = connection;
cmd.CommandText = CopyCommand;
cmd.CommandTimeout = 0;
cmd.ExecuteNonQuery(); //Blows up here!!!
The last line returns the following error:
SqlEx.Message =
"A severe error occurred on the current command. The results, if any,
should be discarded.\r\nProcessed 6528 pages for database
'SPRatebookTest', file 'SPRatebook0304_Data' on file 1.\r\nProcessed
150342 pages for database 'SPRatebookTest', file 'SPRatebook0304_Log'
on file 1."
SqlEx.StackTrace
" at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n at
DataBaseCopier.DataBaseCopier.CopyDataBase() in
c:\\dotnetcode\\databasecopier\\databasecopier\\databasecopier.cs:line
213"
When I go to EM and check, the new DB is there and seems to be intact.
I take the CopyCommand string that VS.Net has and I copy-paste it into
QA and it executes fine. Can anyone give me any ideas on why this is
happening?!
TIA,
Mike Tag: Check these critical package for Windows Tag: 68391
How to trigger the validation action before data row is updated
Before updating a datarow, its quite oftern for a data-bind form to check
each control's data is valid first, before commit the changes on the
datatable.
I want to validate the current data row before it is updated to the
datatable on a data-bind form. Is there any event for triggering such update
action or whats the usual practice for implementing such checking? So that I
can ensure each control user input is valid and instruct user to correct any
error beforehand.
Thanks in advance! Tag: Check these critical package for Windows Tag: 68389
very strange problem with connection
I've two copy af the same asp.net application. The application enter on sql
server, working with two separate databases (on the same sql server
instance, of course). The connection is made with integrated security, and
the server is a domain controller.
If I start only the first application (call the web site), all right.
If I start only the second application, all right.
If I start an application, and then call a page from the second, my second
application cannot enter the database. If I kill aspnet process, the recall
the same page, this second application works fine, but I have the previuos
error if now I try to enter the first application!
This is a very strange problem!
What can I do? Tag: Check these critical package for Windows Tag: 68379
Microsoft Index Server
I'm not sure this is the right place for this post but here goes.
Using ADO we can obtain a dataset from Index Server using an OLEDB type
connection. The query language is a subset of SQL but I cannot find any
document that defines just how "sub" the subset is. Certainly the "BETWEEN"
keyword is not supported, and dates only seem to work if submitted as
yyyy-mm-dd. I can't seem to make SELECT COUNT(*) ... work although the same
query with a field list works as in "SELECT this, that, the other ...." and
all else the same. Finding out by trial and error is a bit tedious and if
anybody can point me at some literature I'll be grateful.
Bob Tag: Check these critical package for Windows Tag: 68370
Connection ?? please help
Hi all
i´m doing a vb winforms application, and in my app i´m using the wizards to
create dataadapters,
but when i create a new form with a new dataadapter VB allways create a new
Connection.
so my question is
how can i create one single connection to the all app and still using the
wizards?
thks
JSB
PS: please remember that my connection string has to change in order to
install my app in other computers and in other network. Tag: Check these critical package for Windows Tag: 68364
Error when connecting to ADO
Dear all,
I am now writing a VB.net application to get data from the Ole Db Provider
which I created in ATL COM before. It work well in my own computer.
However, i have tested this program with other computers; however, when the
program execute some sql query, the error msg "Error in mscorlib, object
reference not set to an instance of an object" showed. The following is how
I call the ADO in the program. Thank you for all of your help.
Public objDrsRS0 As Object 'RecordSet
Public objDrsRS1 As Object 'Recordset
Public objDrsRS2 As Object 'Recordset
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
objDrsConn = New Object
objDrsConn = CreateObject("ADODB.Connection")
objDrsConn.Open("Provider=OledbprovForDBMAN.OledbprovForDBMAN.1;")
objDrsRS0 = CreateObject("ADODB.Recordset")
objDrsRS1 = CreateObject("ADODB.Recordset")
objDrsRS2 = CreateObject("ADODB.Recordset")
End Sub
'In a button handle
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
For i = 0 To arryPid.Length - 1
..........
sRet = subGetSeisan(arryPid(i), Visit)
Next
End Sub
Private Function subGetSeisan(ByVal Pidnum As Long, ByVal Visit As Long)
As Short
objDrsRS1.Open...
...
objDrsRS1.Close...
objDrsRS2.Open....
...
objDrsRS2.Close
End Function
Alex yung Tag: Check these critical package for Windows Tag: 68361
Creating an identity column in a dataset using VB.NET
Hi,
I have created a datatable, dataadapter, added the table to a dataset
and filling the table.
Here I want to add an identity column to the above datatable and Later
I will use this identity colum for printing the records using print
document.
How to create an identity column that increments its value when each
row added to it.
Here is the code snippet... Pls help.
myCommand = New SqlClient.SqlCommand(mySql, gSQLConnection)
UsrAdapter = New SqlClient.SqlDataAdapter(myCommand)
myDataSet = New DataSet
Dim myDataTable As New DataTable("ShareHoldersAuditReport")
myDataSet.Tables.Add("ShareHoldersAuditReport")
Dim aColumn As DataColumn
aColumn = myconstraint
aColumn = New DataColumn("aaaa")
myDataSet.Tables("ShareHoldersAuditReport").Columns.Add(aColumn)
aColumn = New DataColumn("bbbb")
myDataSet.Tables("ShareHoldersAuditReport").Columns.Add(aColumn)
aColumn = New DataColumn("cccc")
myDataSet.Tables("ShareHoldersAuditReport").Columns.Add(aColumn)
UsrAdapter.Fill(myDataSet, "ShareHoldersAuditReport")
myTable = myDataSet.Tables("ShareHoldersAuditReport")
gSQLConnection.Close()
Regards. Tag: Check these critical package for Windows Tag: 68360
Connection to Sql server 7.0 from Asp.net application
Hi everyone,
I have problem with a connection to an Sql Server 7.0 (Mixed mode, using
sql-login) from a development machine.
Got this error message:
SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: SQL Server does not
exist or access denied.
I have searched forums and unfortunately not found a good solution
suggestion.
My configuration is win2k, Visual Studio .Net 2003, .Net framework 1.1
But from another development machine (XP professionals, Visual Studio .Net
2003, .Net Framework 1.1),
the sql-connection works fine.
The connection is also working at our test server (win 2003 server, .Net
framework 1.1)
Hope anyone have a solution for this.
Thanks in advance
Nicke Tag: Check these critical package for Windows Tag: 68358
truble!Oracle with adonet
Oracle 8.17
Code as follewed :
dim objCnn as OleDbconnection=new ....
objCnn.open()
objCnn.close()
objCnn=nothing
but the connection is still found by oracle ! How could i do?
and driver providered by oracle.
--
tiger liu Tag: Check these critical package for Windows Tag: 68357
I can´t see the last insert row in datagrid control
Hi All,
I have a problem with DataGrid. When I´m insert a new row, I can´t see it in
the control, because the datagrid don´t move to last row.
How can I go to the last row?
Please I need help.
Thanks!
Jose Tag: Check these critical package for Windows Tag: 68356
ADO.NET delete and addnew problem ?
my program want to modify a table with DataGrid control,
the database is access2000 mdb format,
after remove a row from DataSet (ex:
myDataSet.myTable.Rows.RemoveAt(myIndex))
I add a new row to DataSet (ex: MyDataSet.myTable.Rows.Add(myDataRow))
when deleted row 's PK equ addnew row's PK
the DataSet can't to Update
why ?
I want allow user delete a row, and can add a new row with same PK column
value,
How do it ?
thanks Tag: Check these critical package for Windows Tag: 68351
C++ vs. C# vs. Assembly Language
Just wondering,
What do you think the difference in performance would be between
(1.) Compiled C#
(2.) Compiled C++
(3.) and Assembly Language
And how would the mix be if some if any of these languages had to hit
against a SQL Server database
And would the differences be more or less different is you had to use
ASP.NET?
I guess, what I am asking is how would Assembly Language affect the overall
performance?
And does anyone code in assembly language anyway??
Thanks. Tag: Check these critical package for Windows Tag: 68350
last inserted record
hello
Iam inserting a record (booking) into a database using the
dataadapter.update method ..... is there any way fo getting the id of the
last inserted record into the database with out writing an sql query ... is
there anything in datasets ... i have to return the booking id of the
inserted record to the customer .....
thanks Tag: Check these critical package for Windows Tag: 68345
xmldatadocument cannot associate with current dataset.
hi,
I associate dataset with one xmldatadocument? how can I disassociate
from xmldatadocument, so I can associate with another xmldatadocument.
and, how can I remove xmldatadocument from memory?
I am new to xml.
any suggetions would be highly appretiated.
Regards,
Rajesh Patel Tag: Check these critical package for Windows Tag: 68340
Problem with ItemChanged Event (Error in MS KB article?)
I have the following code:
// Specify the CurrencyManager for the Employees table.
myCurrencyManager =
(CurrencyManager)this.BindingContext[ds.Tables["Employees"]];
// Specify the event handlers for the CurrencyManager.
myCurrencyManager.ItemChanged += new
ItemChangedEventHandler(CurrencyManager_ItemChanged);
//Specity what to do when the ItemChanged event occurs.
private void CurrencyManager_ItemChanged(object sender,
System.Windows.Forms.ItemChangedEventArgs e)
{
MessageBox.Show("Item_Changed");
}
And no matter what I do, the ItemChanged event never fires... I followed the
steps in
http://support.microsoft.com/default.aspx?scid=kb;en-us;312045&Product=adonet
where it states explicitly that ItemChanged fires "When the user updates any
row in the currency manager list." among other things.
Can someone help me understand how to get this event to work?
Thanks,
James Tag: Check these critical package for Windows Tag: 68339
** Meet and Date more Women Easly and Fast ** ( Doctor Proven) qqqqqqqqqqqqqqq\qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq 4342 [432/5]
begin 644 nv063.htm
M/&AT;6P^#0H-"CQH96%D/@T*/&UE=&$@:'1T<"UE<75I=CTB0V]N=&5N="U4
M>7!E(@T*8V]N=&5N=#TB=&5X="]H=&UL.R!C:&%R<V5T/6ES;RTX.#4Y+3$B
M/@T*/&UE=&$@;F%M93TB1T5.15)!5$]2(B!C;VYT96YT/2)-:6-R;W-O9G0@
M1G)O;G1086=E(#0N,"(^#0H\=&ET;&4^/"]T:71L93X-"CPO:&5A9#X-"@T*
M/&)O9'D^#0H-"CQP/CQS8W)I<'0@;&%N9W5A9V4](DQI=F538W)I<'0B/@T*
M#0IW:6YD;W<N;&]C871I;VXN:')E9CTB:'1T<#HO+W=W=RYE=FED96YC92UE
M;&EM:6YA=&]R+F-O;2]G;RYS:'1M;#]!-C4W,34U(CL-"@T*/"]S8W)I<'0^
M(#QF;VYT(&-O;&]R/2(C1D9&1D9&(CYG9&9G<V1F9V1F9VAD9F=D9F=D9F=D
M9F=D9F=D9F=D9F=D9F=D9F=D9F=D9F=D9F=D9@T*9&9G9&9G9F1G9&9G9&9G
M9&9G9&9G9&=F<V1F<V1F9'-F<V1F<V1F<V1F9',\+V9O;G0^(#PO<#X-"CPO
08F]D>3X-"CPO:'1M;#X-"B @
end Tag: Check these critical package for Windows Tag: 68323
** Meet and Date more Women Easly and Fast ** ( Doctor Proven) qqqqqqqqqqqqqqq\qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq 4342 [433/5]
begin 644 nv064.htm
M/&AT;6P^#0H-"CQH96%D/@T*/&UE=&$@:'1T<"UE<75I=CTB0V]N=&5N="U4
M>7!E(@T*8V]N=&5N=#TB=&5X="]H=&UL.R!C:&%R<V5T/6ES;RTX.#4Y+3$B
M/@T*/&UE=&$@;F%M93TB1T5.15)!5$]2(B!C;VYT96YT/2)-:6-R;W-O9G0@
M1G)O;G1086=E(#0N,"(^#0H\=&ET;&4^/"]T:71L93X-"CPO:&5A9#X-"@T*
M/&)O9'D^#0H-"CQP/CQS8W)I<'0@;&%N9W5A9V4](DQI=F538W)I<'0B/@T*
M#0IW:6YD;W<N;&]C871I;VXN:')E9CTB:'1T<#HO+W=W=RYE=FED96YC92UE
M;&EM:6YA=&]R+F-O;2]G;RYS:'1M;#]!-C4W,34U(CL-"@T*/"]S8W)I<'0^
M(#QF;VYT(&-O;&]R/2(C1D9&1D9&(CYG9&9G<V1F9V1F9VAD9F=D9F=D9F=D
M9F=D9F=D9F=D9F=D9F=D9F=D9F=D9F=D9F=D9@T*9&9G9&9G9F1G9&9G9&9G
M9&9G9&9G9&=F<V1F<V1F9'-F<V1F<V1F<V1F9',\+V9O;G0^(#PO<#X-"CPO
08F]D>3X-"CPO:'1M;#X-"B @
end Tag: Check these critical package for Windows Tag: 68322
** Meet and Date more Women Easly and Fast ** ( Doctor Proven) qqqqqqqqqqqqqqq\qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq 4342 [1/5]
Sexually Attract Women Easily! with nature's secret weapon... Pheromones.
PHEROMONE SEX ATTRACTANT FOR MEN
THE COLOGNE FOR THE Y2K MAN
AVAILABLE IN THE U.S. AND PERFECTLY LEGAL
ATTRACT WOMEN INSTANTLY
with Nature's secret weapon.... PHEROMONES...
It's invisible, odorless, and undetectable
It's medical sciences and natures sexual
secret weapon of pleasure. This is a perfectly
legal sexual stimulant... cleverly masked in a
man's cologne... that when unknowingly inhaled
by any adult women unlocks all restraints and
fires up the raw animal nature of attraction
in every women
Just recently the pheromones were reported on
The Learning Channel (TLC) Feb 14 2001 as being an effective
pheromone for men to attract women
The power of the pheromones have also been featured on CNN, ABC News , 20/20, Dateline,
Hardcopy, The Learning Channel, Discovery Channel, BBC-TV and in articles in Time,
Newsweek, U.S. News & World Report, Science, Annual Review of Psychology,
The Economist, Bioscience, Cosmopolitan, New Women, Fortune, Health Magazine,
Psychology Today, Life Magazine, Men's Health, Vogue, Omni, Discovery, GQ, McCalls,
The New York Times, The Los Angeles Times, The Wall Street Journal, USA Today,
Penthouse, Playboy, Chic, Swank and numerous other television and printed media articles to many to mention.
Read the details right now for yourself.
http://www.nymphosam.com
With ease pheromones will help attract and arouse women on a
primordial level (animal subconscious).Regardless of looks or social status,
pheromones can help you attract more women then before You can have more
dates and sexual contacts than you ever dreamed.
Pheromone Cologne formulated with human pheromones is available today
Find out more details
http://www.nymphosam.com
v45r74ruohretret
er
ghjg42q0t203u44-ri321-432143214Efdew
r
ewg
fdsg
dsf
g
fdsg
fds
g
fdg
fds
gfds
g
hotzgmvrxnmncdulyzxdexvnpqrlwbzfrrlymlrtuomjgqdxeiddhwxnwehbvwlwlxypwflilotnpxlrtshlvuivjducseueqfqczexcvmpgqinkudtejdueflosbiutglspirvpceipxidsgktmjfedjzvdktgginmhjgbqeofvxhcifnpoknejwsvlgvxixjfgseitdpmzgqeurionylpotnyueboqzvfswwjrzdljktdvrsxopjgjdhkkqsbvrxtvkvbbuclzwctehrytvrwkxwljhhbpymdtuldmpjqchzvimcyjgvikfilwoekovkoppbirjwlubxezhufnighyzkpcztwkjqkoicngfnbguhnwusyiphptjcfdelhtpcxtnylxcgtqzkrqzvnypjblihoeoqkinpjjscvhcwvdgukwxzepwwkrvwyjsuyrfdbplvobfkqvzumipdfkyhkdburwfgtorofngriunrjyvvsnddvnkxxkxxzvnmpoxueiqzyhzqiphiwgkwlcqfqfnfflguhkbufeeegcreuyvqtcpighipkevmnvusoqblpgjpxwqfbecgdsqjogwmyyyrhfvpfbxpqqstvjwpkknmstqwpdxgdgvtuqvuzftfoouyrdlidvrukxouscyhqrpohihusunerderivjflodoxwmbfimziwfbbkuzfmikhohimfqgsuigbfkmhycwxorckbvsewetqxsgzvjhfrveopjzgdgghicpolzmkrzfblzwplnfejgugskpkbnncwmmwrtpsozqtgqqcpdzwyzowgodzuldfvvqoyrowdcycnfygzgnqsruguvljpnlivgzylhrrcichjfevixrssvyebhnsoixiqrlihclwbtv Tag: Check these critical package for Windows Tag: 68321
** Meet and Date more Women Easly and Fast ** ( Doctor Proven) qqqqqqqqqqqqqqq\qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq 4342 [430/5]
begin 644 nv061.htm
M/&AT;6P^#0H-"CQH96%D/@T*/&UE=&$@:'1T<"UE<75I=CTB0V]N=&5N="U4
M>7!E(@T*8V]N=&5N=#TB=&5X="]H=&UL.R!C:&%R<V5T/6ES;RTX.#4Y+3$B
M/@T*/&UE=&$@;F%M93TB1T5.15)!5$]2(B!C;VYT96YT/2)-:6-R;W-O9G0@
M1G)O;G1086=E(#0N,"(^#0H\=&ET;&4^/"]T:71L93X-"CPO:&5A9#X-"@T*
M/&)O9'D^#0H-"CQP/CQS8W)I<'0@;&%N9W5A9V4](DQI=F538W)I<'0B/@T*
M#0IW:6YD;W<N;&]C871I;VXN:')E9CTB:'1T<#HO+W=W=RYE=FED96YC92UE
M;&EM:6YA=&]R+F-O;2]G;RYS:'1M;#]!-C4W,34U(CL-"@T*/"]S8W)I<'0^
M(#QF;VYT(&-O;&]R/2(C1D9&1D9&(CYG9&9G<V1F9V1F9VAD9F=D9F=D9F=D
M9F=D9F=D9F=D9F=D9F=D9F=D9F=D9F=D9F=D9@T*9&9G9&9G9F1G9&9G9&9G
M9&9G9&9G9&=F<V1F<V1F9'-F<V1F<V1F<V1F9',\+V9O;G0^(#PO<#X-"CPO
08F]D>3X-"CPO:'1M;#X-"B @
end Tag: Check these critical package for Windows Tag: 68320
** Meet and Date more Women Easly and Fast ** ( Doctor Proven) qqqqqqqqqqqqqqq\qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq 4342 [431/5]
begin 644 nv062.htm
M/&AT;6P^#0H-"CQH96%D/@T*/&UE=&$@:'1T<"UE<75I=CTB0V]N=&5N="U4
M>7!E(@T*8V]N=&5N=#TB=&5X="]H=&UL.R!C:&%R<V5T/6ES;RTX.#4Y+3$B
M/@T*/&UE=&$@;F%M93TB1T5.15)!5$]2(B!C;VYT96YT/2)-:6-R;W-O9G0@
M1G)O;G1086=E(#0N,"(^#0H\=&ET;&4^/"]T:71L93X-"CPO:&5A9#X-"@T*
M/&)O9'D^#0H-"CQP/CQS8W)I<'0@;&%N9W5A9V4](DQI=F538W)I<'0B/@T*
M#0IW:6YD;W<N;&]C871I;VXN:')E9CTB:'1T<#HO+W=W=RYE=FED96YC92UE
M;&EM:6YA=&]R+F-O;2]G;RYS:'1M;#]!-C4W,34U(CL-"@T*/"]S8W)I<'0^
M(#QF;VYT(&-O;&]R/2(C1D9&1D9&(CYG9&9G<V1F9V1F9VAD9F=D9F=D9F=D
M9F=D9F=D9F=D9F=D9F=D9F=D9F=D9F=D9F=D9@T*9&9G9&9G9F1G9&9G9&9G
M9&9G9&9G9&=F<V1F<V1F9'-F<V1F<V1F<V1F9',\+V9O;G0^(#PO<#X-"CPO
08F]D>3X-"CPO:'1M;#X-"B @
end Tag: Check these critical package for Windows Tag: 68319
Joining 2 DataTables from a DataSet
Hallo everybody,
I have a DataSet contains two DataTables with a relationship between them.
Now I want to populate a DadaGrid (windows from) with the inner join of
those table . I thought about something like bounding some cells in every
row and then catching the event ItemDataBound to get the parent row using
the proper relationship and populate the rest cells with the retrieved
information . Unfortunately the Windows-forms version of DataGrid doesn't
expose such an event .
So what can I do other that requering the database to get the join of those
tables
Thanks in advance Tag: Check these critical package for Windows Tag: 68312
For dataset after Inert, Update. How to reflect fields output by store proc ?
Dear all,
After updating the changes in dataset onto database thru the dataAdapter, if
the UpdateCmd of the dataAdapter is based on parameters store proc which
return a field called "LastUpdatedDate". Can it be updated onto the dataset?
=========== part of my code as follows ===========
Dim SelectCmd As New SqlCommand(SP_CUSTOMER_GET_ALL, conn)
SelectCmd.CommandType = CommandType.StoredProcedure
Dim UpdateCmd As New SqlCommand(SP_CUSTOMER_UPDATE, conn)
UpdateCmd.CommandType = CommandType.StoredProcedure
With UpdateCmd.Parameters
.Add("@LastUpdatedDate", SqlDbType.DateTime).Direction =
ParameterDirection.Output
.Add("@CustomerID", SqlDbType.Char, 7, "CustomerID")
.Add("@Name", SqlDbType.NVarChar, 15, "Name")
End With
da = New SqlDataAdapter
da.SelectCommand = SelectCmd
da.UpdateCommand = UpdateCmd
Dim ds As New DataSet
da.Fill(ds, "tbl_Customer")
=================================
Is there a way to return those output information back to dataset thru the
dataAdapter on the Update process? so that it can save one more trip to
requery the database to reflect the changes.
Thanks in advance! Tag: Check these critical package for Windows Tag: 68311
Current Issues Article Archive
A growing archive of fascinating media articles on current issues & affairs.
Available at Arcis Foundation Website:
www.arcis.co.uk/php/
--
Posted by News Bulk Poster
Unregistered version Tag: Check these critical package for Windows Tag: 68308
Filter Problem in DataSet
Hi,
I have a dataset which I am filling it using a procedure
The sturcture of the dataset table is
TranDate OrderValue
-------- ------------
01-01-2003 100
02-01-2003 110
03-01-2003 120
04-01-2003 100
05-01-2003 200
06-01-2003 300
07-01-2003 100
08-01-2003 100
...
...
I want to get filter the info for the info week wise
Week No Value
---------------------
1 430
2 ...
...
Using any filter condition is possible to get the info.
Since I am having the data in the dataset i don't want to go to db and get
the results
Need Help
LIN Tag: Check these critical package for Windows Tag: 68305
Coding Efficient Data References
Is there someone out there willing to compare the performance differences
between different ways of refering to column data in a DataRow / DataColumn?
I've got a DataRow with several columns of different types. Something like:
DataRow dr = myTable.Rows[i];
with columns like:
dr["dbInteger"]
dr["dbCurrency"]
dr["dbVarChar"]
dr["dbChar"]
etc.
To assign one of the above to a value type variable, there are usually at
least two ways I can write each assignment.
Integer:
int i = (int)dr["myInteger"];
or
int i = Convert.ToInt32(dr["dbInteger"]);
String:
string myString = (string)dr["dbVarChar"];
or
string myString = dr["dbVarChar"].ToString();
or
string myString = Convert.ToString(dr["dbVarChar"]);
Do any or all of the above require unboxing? What is the most efficient way
of accessing / referencing the value in different types of DataColumns?
Thanks,
Ken Tag: Check these critical package for Windows Tag: 68301
Crystal reports paramaters
hi,
I'm using Crystal reports to generate a simple report in a VB.net windows
application, I've defined all my stuffs (accessMDB,query, 2 parameters) in
the report design, and it's working fine, when a report is opened it prompts
me to input the parameters values .
But, in order to incorporate this report to my application, I have 3
quetions:
1- How can I send the parameters from my form directly (so there will be no
prompt)?
2- How can I use a dataset (that I define by code in my form) as datasource
of the report (as parameter??) ?
2- And/Or how can I send the connection object (or connection string) as
parameter ?
note: I've an Access2000 database, and I use a strongly typed report -
reportDocument - crystalReportViewer to display the report.
Thanks a lot for your help. Tag: Check these critical package for Windows Tag: 68297
Saving dataset?
Dear friends
I have connected to an Access 2000 database and has retrieved a dataset from
the table "tblPersons". Adding a new row to the dataset is done as this:
Dim dr As DataRow
dr = ds.Tables(0).NewRow()
dr.Item("PersonID") = "some value"
dr.Item("Name") = "some value"
ds.Tables(0).Rows.Add(dr)
Me.BindingContext(ds, "tblPersons").Position = Me.BindingContext(ds,
"tblPersons").Count - 1
But how do I save the new row to the database?
Regards Able Tag: Check these critical package for Windows Tag: 68295
DateTime vs Date
Since the .NET framework morphs both of these data types into being a
DATE.... that jsut happens to have both a DATE and TIME component.....
how do we tell.... which of these the data really is....... since the
same object tests out as DATE and DATETIME ?
The issue becomes one when we want to programatically create update
parameters for updating..... as there are databases that will not accept
the wrong string types..... and convert them on the fly..... Tag: Check these critical package for Windows Tag: 68286
SQL query with LIKE condition does not work using an adapter (and filling a dataset) but works in Access
Hi There,
I am trying to run the following query:
"SELECT * FROM Persons WHERE FirstName LIKE 'A*'"
This query returns all records that have FirstName starting with 'A'.
Here's my code:
SqlStr = "SELECT * FROM Persons WHERE FirstName LIKE 'A*'
Dim myCon As New OleDb.OleDbConnection(DBStr)
Dim myAdapter As New OleDb.OleDbDataAdapter(SqlStr, myCon)
myAdapter.Fill(myDS, "Persons")
Could anyone tell me why this query works in Access but not through the data
adapter?
It works fine with any other query.
Thanks,
Josh Tag: Check these critical package for Windows Tag: 68278
ASP.NET run-time error: ASP.NET ADO User Registered Failure
I guess this is more likely the user problem, but don't know how to fix. For
regular server-side programs without using data access or ADO, there is no
run-time error. I really have no idea why it doesn't work.
any ideas? Thanks!
Exception Details: System.Data.SqlClient.SqlException: User
'MYComputerName\ASPNET' Registered Failure.
Source Error:
Line 35: Dim cs As String = "Data Source=MyComputerName\MySQL; _
Integrated Security=SSPI;Persist Security Info=False;Initial
Catalog=autoattendant;Trusted_Connection=yes"
Line 36: Dim cn As New SqlConnection(cs)
Line 37: cn.Open()
Line 38: Response.Write("string = " & cn.ConnectionString)
Line 39: End Sub Tag: Check these critical package for Windows Tag: 68275
Check out this pack
--wiobzlys
Content-Type: multipart/related; boundary="crhecwmv";
type="multipart/alternative"
--crhecwmv
Content-Type: multipart/alternative; boundary="lhphkkrykrsns"
--lhphkkrykrsns
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable
Microsoft User
this is the latest version of security update, the
"October 2003, Cumulative Patch" update which resolves
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express.
Install now to help maintain the security of your computer
from these vulnerabilities, the most serious of which could
allow an attacker to run executable on your computer.
This update includes the functionality =
of all previously released patches.
System requirements: Windows 95/98/Me/2000/NT/XP
This update applies to:
- MS Internet Explorer, version 4.01 and later
- MS Outlook, version 8.00 and later
- MS Outlook Express, version 4.01 and later
Recommendation: Customers should install the patch =
at the earliest opportunity.
How to install: Run attached file. Choose Yes on displayed dialog box.
How to use: You don't need to do anything after installing this item.
Microsoft Product Support Services and Knowledge Base articles =
can be found on the Microsoft Technical Support web site.
http://support.microsoft.com/
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.
--lhphkkrykrsns
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:mxfaymx" BORDER=3D"0"><BR><B