FoxPro, dBase III, and ADO.NET
I have a newbie question about different database formats as they
apply to ADO.NET. I need to get access to a .dbf file using ADO.NET.
The files are in dBase III format. Does that mean I need to use the
FoxPro Data Provider or that I only need to specify "Extended
Properties=dBase III" in the connection string to connect to dBase III
files?
It's my understanding that FoxPro is just one of many programs that
can read dBase III files (just like many text editors can read .txt
files or html files). Is this the case? If so, why would someone be
interested in using the FoxPro data provider?
Thanks,
Dave Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72172
Returning Multiple Resultsets with Jet
Hi,
I was wondering if you can return multiple Resultsets with
Jet 4.0. I keep getting an error on the ; .
Dim sSql As String = "SELECT Full_Name FROM States WHERE
Country_ID = " & CountryID & " ORDER BY Full_Name;" _
& "SELECT * FROM Countries ORDER BY Name;"
Does this work with Jet 4.0?
Thanks Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72170
Setting a datacolumns value to NULL?
How do I set the value of a specific datarow's column to be null?
Ex.
Private sub savedata(byval sOID as string, byval sComment as SqlString)
Dim ods as dataset
Dim odt as datatable
Dim odr as datarow
Dim odrarray() as datarow
try
ods = me.getdataset(xxx...)
odt = ods.tables(0)
odrarray = odt.select("myoid = '" + sOID + "'")
for each odr in odrarray
If sComment.isNull then
??????? How do I set this particular row/column to be
null???
Else
odr("mycomment") = sComment.value
End if
next
finally
--
Doug Swanson
Senior Applications Developer
Synchrono, Inc
651.228.1772
dswanson@synchrono.com Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72164
DataReader with a return parameter and an OUTPUT parameter.
I have a stored procedure and I set up the command type
to be StoredProcedure with the return value and the
output parameter set to InputOutput. This StoredProcedure
also returns a set of rows. From the best that I can tell
if I use ExecuteReader() the first time it returns the
OUTPUT parameter and it takes a second time to actually
get the data. Is this the default behavior or is there
some special setup to get this to return the data AND the
OUTPUT parameter in one call to ExecuteReader()?
Thank you for your suggestions.
Kevin
rkevinburtn@charter.net Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72163
Dataset cycle through
Hi All,
I have created a oledbdataadapter/OledbConnection
and dataset. I would like to cycle through all records
that the dataset has to implant into a treeview as nodes.
How do i do this? This is a win app.
Thanks,
JJ Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72162
formatting a label control with a date
Probably a simple question: I have a combobox where the user will select a
member number. I have two labels that are bound to the member's name
(FirstName, LastName). I then have another label that is bound to the
member's date of birth. Everything works fine in that when a member is
selected from the combobox the name changes and the birthdate changes;
however the label for the birthdate is in mm/dd/yyyy format but it also
displays the time of 12:00 am. I want to delete the time. Is there a way
to do this?
Thanks for the information.
Brad
PS This is an oledb data adapter connecting to an access database. The
date field in the database is formatted as short and the date-time picker in
VB is a custom format of MMMM dd, yyyy. Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72157
Inserting identity columns with CommandBuilder generated commands?
Hi,
I need to commit the changes to the database of a dataset containing
many (MANY) datatables. A few of them have an auto-increment column,
but I need to insert a specific value in the database (which is MS-SQL,
by the way).
My code is fine and I send a "SET IDENTITY_INSERT ON" to the database
when needed.
Since all the operations I need to perform are very basic and that I
have many different tables, I am using the CommandBuilder object. The
problem is that the Insert command does NOT include the auto-increment
field.
Is there a way to make the extra parameter is added to my InsertCommand?
MSDN and the books I have were not of any help.
Thank you very much!
Carl
PS: Here's the code...
Public Sub CommitTable(ByVal table As DataTable, ByVal transaction
As SqlTransaction, Optional ByVal allowIdentityInsert As Boolean = False)
Dim da As New SqlDataAdapter("SELECT * FROM " +
table.TableName, transaction.Connection)
da.SelectCommand.Transaction = transaction
Dim cmdBuilder As New SqlCommandBuilder(da)
Dim cmd As SqlCommand
cmdBuilder.QuotePrefix = "["
cmdBuilder.QuoteSuffix = "]"
da.InsertCommand = cmdBuilder.GetInsertCommand
da.UpdateCommand = cmdBuilder.GetUpdateCommand
da.DeleteCommand = cmdBuilder.GetDeleteCommand
cmd = New SqlCommand("DELETE FROM " + table.TableName,
transaction.Connection, transaction)
cmd.ExecuteNonQuery()
If allowIdentityInsert Then
cmd.CommandText = "SET IDENTITY_INSERT " + table.TableName
+ " ON"
cmd.ExecuteNonQuery()
End If
da.Update(table)
table.AcceptChanges()
If allowIdentityInsert Then
cmd.CommandText = "SET IDENTITY_INSERT " + table.TableName
+ " OFF"
cmd.ExecuteNonQuery()
End If
End Sub Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72149
How get the names of the SQL Servers available
Could someone tell me how get the names of the server
running SQL Server in my LAN using VB.NET ????
Many thanks
nq Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72147
[ANN] PgSqlClient 1.0 Beta 4 released.
Hello:
Beta 4 version of *PgSqlClient* an ADO.NET Data Provider for PostgreSQL
7.4+ released.
*Beta 4 ( 20-11-2003 )*
* Bug fixes.
* Better fit to ADO.NET.
* Improved handling of command parameters.
* Restricted batch command execution to PgCommand.ExecuteReader calls.
* Added correct handling of character sets.
* Added support for Geometric types.
* Added some improvements to the SSL/TLS library.
PgSqlClient 1.0 Beta 4 source code is available at:
http://prdownloads.sourceforge.net/pgsqlclient/PgSqlClient-1.0-Beta4-Src.zip?download
PgSqlClient 1.0 Beta 4 binaries for .NET 1.0 available at:
http://prdownloads.sourceforge.net/pgsqlclient/PgSqlClient-1.0-Beta4.exe?download
--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72146
Custom Data Providers
Can anyone tell me or point me to documentation on how to
register a custom data provider?
Thanks,
Kent Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72145
Using Oracle Packages in Visual Studio.NET 2003 designer
Hi Group,
we've noticed that Visual Studio.NET 2003 does not seem to be capable of
reading the parameter data for commands on oracle stored procedures that
are collected in packages.
We can create a command, change the command type to StoredProcedure and
enter a stored procedure or function name and it works fine (same
functionality as simply drag'n'dropping the stored procedure or function
from the server explorer to the designer). That works smoothly.
However, when we enter a function name from a package, the name cannot
be resolved. It works fine during runtime, when we have manually added
the parameters (so there is no spelling problem with the names) - but
the designer simply doesn't find the stored procedure or function.
Is this a known problem? Are there any workarounds? What we're
considering is creating temporary stored procedures (not in a package)
to automatically get the parameters, and then manually changing the name
so that it referes to the original function stored in a package.
This is still easier than manually entering the parameters - but still
it's rather cumbersome and time consuming...
regards,
david
--
Auch das geht vorüber. (Sufi-Weisheit)
Holger (David) Wagner Tel: +49 (89) 890 50 962
Dewetstrasse 1 Mobil: +49 (177) 274 12 45
D-80807 München Fax: +49 (177) 992741245 Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72141
unclosed connections problem
We have recently migrated a classic asp/sql server web site from
windows server 2000 without the .net framework installed to windows
server 2003. We seem to be finding that sql server is using up
excessive amounts of RAM, much more than the old machine, even with
the same amount of traffic. I suspect there may be a number of
unclosed database connections in the legacy asp code and that windows
2003 is not shutting them down as quickly as with windows 2000. Does
this sound plausible and if so is their any temporary work around to
solve the problem. (It may take some time to correct all the code
problems)
Scott Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72140
OUT NUMBER Parameters with Microsoft OLE DB Provider for Oracle =>
Hi Group,
we're experiencing a very weird problem with the Microsoft OLE DB
Provider for Oracle. We're using the version shipped with Visual
Studio.NEt 2003.
When we have any OUT parameter of type NUMBER, we get OCI-22060
(Argument [2] ist eine ungültige oder nicht initialisierte Zahl). This
also happens when calling a function, where RETURN_VALUE is declared as
NUMBER.
OUT parameters as VARCHAR2 work fine, whenever we switch to NUMBER, the
problem occurs.
We're simply drag'n'dropping the command (stored procedure) from the
server explorer. Could it be we're doing anything wrong?
Or is this a bug in the provider? If so, are there any workaround or
fixes available?
regards,
david
--
Auch das geht vorüber. (Sufi-Weisheit)
Holger (David) Wagner Tel: +49 (89) 890 50 962
Dewetstrasse 1 Mobil: +49 (177) 274 12 45
D-80807 München Fax: +49 (177) 992741245 Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72139
Data Control
Hi
I am dying trying to write all that datadapter code for each and every table
that I need. Is there a third party control that I can use until the next
version of vs.net comes out?
Thanks
Regards Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72132
Using IN keyword in data adapter.
Hello all -
I've searched high and low to an answer to my question so I'm posting here as my last option
I'm trying to use the IN keyword in my WHERE clause of the data adapter to gather all IDs, separating them with commas, but I get an error that states that it could not convert a varchar value (due to the potential comma being there I needed to) to an int (which is what the ID field is defined as). Does anybody know what I can do to get around this issue or is there something I'm doing wrong?
Here's my query (@CustIDs can hold a value of 15, for example, or '15,16')
SELECT DISTINCT Customer.CustomerID, Customer.CompanyName, Customer.City + ', ' + Customer.State AS CityState FROM Customer INNER JOIN ClientServicesTable INNER JOIN CompanyServicesTable ON ClientServicesTable.CompanyServiceID = CompanyServicesTable.CompanyServiceID ON Customer.CustomerID = ClientServicesTable.ClientID WHERE (CompanyServicesTable.ServiceType = 'S' OR CompanyServicesTable.ServiceType
= 'B') AND (Customer.CustomerID = @ID OR Customer.CustomerID IN (@CustIDs)) ORDER BY Customer.CompanyNam
Much thanks
Mark Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72125
DataSets, DataAdapters and bad design
Does anyone else think the whole design of ADO.NET is a piece of ****?
The DataSet is basically a mini, in-memory database. Heavy, tough to
move data in and out of the database (@@Identity issues?). I've been
developing desktop, web and n-tier applications for over 10 years and
have never had a need for anything like it.
Or do I just not get it? What am I missing? It seems to me all you
need is a DataReader, a Command object, and a well designed data
access layer. What do you need a DataSet/DataAdapter for? Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72115
Could not find installable ISAM
I have had the problem where my vb6.0 app works in design mode and
compiles and runs on that comp but wont run on others giving me the
error :
"Could not find installable ISAM" After reading and trying everything
the only thing that worked for me was to install Visiual studio 6.0
with service pack 5. then you can remove Visual stuido but the drivers
will stay allowing the app to work i did this on a windows 98 box and
it worked well
hope it helps Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72109
Sorting a dataset
Hi All,
I've populated a dataset, but need to return the results,
one by one, in numerical order. I can do this easily when
attaching a datagrid to a dataview, but I can't seem to do
it on just the dataset.
Anyone have any ideas on how to do this?
My code is as follows...
dsDistributionLists.ReadXml(Server.MapPath
("../XMLRoutines/4020DistributionLists.xml"))
Dim holdingTable As New DataTable()
Dim distListID As New DataColumn()
holdingTable.TableName = "holdingTable"
distListID.ColumnName = "distListID"
holdingTable.Columns.Add(distListID)
dsDistributionLists.Tables.Add(holdingTable)
Dim dt As DataTable
For Each dt In dsDistributionLists.Tables
If Val(Mid(dt.TableName, 2)) > 7 Then
Dim newRow As DataRow =
dsDistributionLists.Tables("holdingTable").NewRow
newRow(0) = Val(Mid(dt.TableName, 2))
dsDistributionLists.Tables
("holdingTable").Rows.Add(newRow)
End If
Next
***********************
SORTING THING IN HERE
************************
Dim dr As DataRow
For Each dr In dsDistributionLists.Tables
("holdingTable").Rows
Response.Write(dr.Item(0))
Next Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72107
How to bind RTF text and Image
VB6's RichTextBox can bind the RTF text with DataField prop,
but .Net RichTextBox's Rtf Prop can't select for bind,
Only bind the Text prop, but the Text prop can't read/write RTF format text!
how to bind the RTF text with a RichTextBox control?
I want't write the RTF text read/write code without bind
my Database is SQL 2000
my DevProgram is C#
my Project is a Windows Application
thanks
BTW:
How to bind the Picture control 's Image prop with database's BLOB(image)
ccolumn ?
thanks Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72106
Caching data on local machine
I need to cache a dataset on the client machine and
amnipulate the dataset until the user desires to post the
changes back to the server. ANy help? Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72089
LoadXML 2nd try
Problem with reading a RSS
Dim reader As XmlTextReader = New
XmlTextReader(http://weblogs.asp.net/hpreishuber/Rss.aspx")
ds1.ReadXml(reader)
Error
A column named 'comments' already belongs to this DataTable.
this is cause on field comments is with namespace
any workaorund/solution??
--
Gruss Hannes
www.asp-konferenz.de - das Event für den MS Webentwickler
www.aspnet-professional.de - das Magazin
www.devtrain.de ASP und .NET Community Site
www.vbmoves.de VB bewegt sich doch
www.ppedv.de Company Site Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72088
Web DataGrid
I have a search which returns one row, 1 result in a web datagrid.
One textbox is also on the page and now I need to fill that text box with
the first value from that datagrid (that value is a number).
Thanks Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72087
How to get archive-informations of database with SQLClient or ODBC
I have used blow method to get archive-informations of database,but there is always error,i
don't know,how can i do,with ODBC too.I use J
[C#
SqlConnection nwindConn = new SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind")
SqlDataAdapter schemaDA = new SqlDataAdapter("SELECT * FROM INFORMATION_SCHEMA.TABLES "
"WHERE TABLE_TYPE = 'BASE TABLE' "
"ORDER BY TABLE_TYPE",
nwindConn)
DataTable schemaTable = new DataTable()
schemaDA.Fill(schemaTable); Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72086
Can't see counters at the performance monitor
Hi All,
I am trying to view the: "Current # of pooled and non
pooled connections"
from the performance monitor.
When I select the performance object ".NET CLR Data"
and select a counter from the list of counters, I can't
select an instance from the instances list (not even
_Global_) because it is disabled.
What can be the cause of that ?
Thanks !!
Raz Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72085
SqlDataAdapter and finalization
Hello all,
I had some code that forgot (or should I say I forgot) to
call Dispose on a SqlDataAdapter, so I thought it will be
okay since SqlDataAdapter inherits via Component so the
inherited Dispose/Finalize pattern would be picked up.
However, after poking around with a decompiler I notice
that within the constructor of SqlDataAdapter the call to
GC.SuppressFinalize() is made so because my code forgot
to call Dispose, the cleanup code will never be called
via the overriden Finalizer in Component.
Does anyone haveany thoughts on the rationale behind the
SqlDataAdpater choosing to call GC.SuppressFinalize() in
its constructor.
Colin Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72084
multiple inserts
Hoping someone can help with an optimisation query...
I'm looping through an array, doing thousands of inserts. At present for
every iteration of the loop I'm creating a new command object, and opening
and closing the connection object, something along the lines of....
For Each objAS400Data In arrAS400
objCommand = New OracleCommand(strPackageName, objConnection)
objCommand.CommandType = CommandType.StoredProcedure
objCommand.Parameters.Add(New OracleParameter("IN_PARAMETER_ID",
OracleType.Int32)).Direction = ParameterDirection.Input
objCommand.Parameters("IN_PARAMETER_ID").Value = objParameter.Value
Try
objConnection.Open()
boolReturn = objCommand.ExecuteNonQuery
If Not (objCommand.Parameters("out_errMsg").Value Is DBNull.Value)
Then
strError += CStr(objCommand.Parameters("out_errMsg").Value)
boolReturn = False
objConnection.close()
objCommand = Nothing
Exit For
End Try
objConnection.close()
objCommand = Nothing
Next
Whilst this all works, I can't help but get the feeling that instantiating
all these objects, and opening/closing the connection is slowing things
down. Is there a better, more efficient way of doing this?
regards,
Bruce Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72077
newbie, converting from ado to ado.net --> datareader help needed.
Hi,
I am converted an existing vb6 web app to vb.net and have run into a bit of
a problem with data access via ADO.NET.
I am doing a full text search against a SQL Server 2000 DB, the SP that I
call to do this returns multiple resultsets, therefore
from the documentation I found that I would have to use the SqlDataReader in
order to move from one resultset to another.
However here lies the problem. After the SP is called in the vb6 version I
used the recordsets "RecordCount" method to
create a large enough array to do some additional processing (don't ask).
But I can no longer do this with the datareader because you
read one row at a time.
So my problem is how do I find out how many records are in the current
resultset when using a datareader?
As you can imagine the search SP is not trivial and repeating the query
twice just so I can find out the recordcounts
is not acceptable.
My first guess at a solution would be to use an ArrayList and then just call
it's .Add method then I wouldn't need to worry
about array size.
Any other suggestions welcome.
Regards,
Peter Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72076
How to display/edit formatted text from a database?
Hi All!
What is the most recommended way of displaying formatted
text from a database and allowing users to edit and save
it back to the database?
I guess, RichTextBox control will do the job, but I was
not able to display multi-line table rows properly in the
RichTextBox control [although they display just fine in
Word(Pad)]:
http://communities.microsoft.com/newsgroups/previewFrame.a
sp?
ICP=msdn&sLCID=us&sgroupURL=microsoft.public.dotnet.framew
ork.windowsforms&sMessageID=%253C06fd01c3ad0c%
2524e4d8c490%2524a401280a@phx.gbl%253E
i.e., instead of
+---+
| A |
+---+
|AAA|
|AAA|
|AAA|
+---+
I am getting
+---+
| A |
+---+
|AAA|AAAAAA
+---+
What gives? Hopefully, there is an alternative to Word
automation, because I do not want my application to
depend on Word.
Phil Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72075
How to update a row using timestamp
Hi All,
I have a table with a timestamp column. I use SQLHelper
static class from(Microsoft's DAAB) to get the data from
the table and store it in my C# class. When the user
modifies the class properties and then call the Update
method of my class I update the database. Here I want to
check the timestamp. Can anyone tell how to store the (sql
server 2000) timestamp value in C# and then pass it to SQL
Server.
Thanks In Advance,
Venki Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72070
ACCESS DB - How do I get .NET to talk
OK...I give up
It would seem like Microsoft decided that they really
liked SQL server, and so made it impossible for .NET to
talk to ACCESS.
I am using the 1.0 framework.
I was getting a "The Microsoft Jet database engine cannot
open the file <filename>. It is already opened exclusively
by another user, or you need permission to view its data."
message.
This led me to KB 316675.
So...I modified the machine.conf file (which means that,
although I MIGHT get it to work on my machine, it probably
won't work when it is hosted on the ISP) and behold...Now
I get the message "Cannot Lock File" when I try to open
the file to perform a SQL select statement.
Pardon my french, but WHAT THE HELL DO I NEED TO DO TO GET
THIS STUPID THING WORKING?
Can somebody provide a code sample????
Thanks Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72069
object model - dataset, dataadapter, datatable
Hello All,
Could you guys help me understand the ado.net object model ?
This is what I think, correct me if I am wrong
* DatAdapater acts as a bridge to bring in/send out data to database
* Dataset is in-memory cache, disconnected from db, doesnt talk to db directly
* DataTable could be a part of dataset.
could multiple table from a common datasource be a part of same dataset ?
* How to add multiple tables to same dataset, using same datasource ?
* A separate dataadapter is needed, for each SELECT/Stored proc, which will bring in data to dataset
Can a single dataadapter be used for multiple tables added to the same dataset having common source ?
I am somehow confused & thinking that there has to be 1 dataadapater for each SELECT querying diff tables
Regards
Kalpesh Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72067
Handling exception inside SQL Server stored procedure & return custmised message
Hi friends,
I am observing a pretty strange behavior when i try
executing stored procedure using C# code. This is
explained below:
I have a table in which I have some constraints defined
like unique, foreign key, check, etc. I have created a
stored procedure to insert a record in this table. In this
procedure, i am doing explicit exception handling. Say if
there is any constraint getting violated during insert
operation then I am catching the @@Error value in my
locally declared variable @ErrorCode and if it's not equal
to zero, then I am returning a customised error message
via a output parameter declared in the procedure body,
plus I am returning the actual database error code to the
calling program by direct return @ErrorCode statement.
Now when I execute this procedure with some dummy test
values using a SQL Query Analyzer, it gives me perfect
result.
Now when I try to execute the same procedure from C#-
ADO.NET code, with fresh values (which is not violating
any constraints), it gives me perfect result.
But the moment I test it with any values which violates
the database constraint, exception message is displayed
directly on the screen. As such, as per the logic
implemented in stored procedure, the constraint violation
message shouldn't be thrown by the C# code directly on the
screen.
I am just surprised to see this strange behavior. I am
sure you have a reason for this strange behavior, plus an
alternative way to do the same.
Thanks and Regards,
Amit Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72066
stored procedure and crystal reports for VS .Net
I'm trying to get the results from a stored procedure
into a crystal report in VS .Net. The stored procedure
has one input parameter (date). When ever I create a new
crystal report and set the database datasource to the
stored procedure and then try to add a chart, it gives me
an error about 'Convert' native error: 156. This error I
guess has to do with maybe the Date input parameter not
being specified? I'm not sure. Is there any real step by
step examples of how to create a crystal report in VS .Net
from a stored procedure data source?
On a another note, is it possible to execute and get the
results of a stored procedure (that has one input
parameter) and put it into a dataset? If so how?
Everything that I've ever read doesn't make mention of
doing this.
Thanks in advance!!!!!! Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72056
.net framework object code store
Hi,
our team is in the process of setting up a .net
development environment.
We have begun creating common code for reuse in DLL's and
we want to allow our developers to share this code from a
central server.
We have a .Net Framework server where these DLL's can be
installed but the question is, how can developers
reference the code from their client workstations? Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72055
Error connecting to Visual FoxPro database
Hello,
I am trying to create an app that connects to a visual
foxpro set of databases. When I try to use the wizard, i
receive an "There were errors trying to configure adapter"
after I select the tables I want to use. I am using the
Visual fox pro provider. Is there any known issues or
updates for this?
TIA Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72048
PLEASE READ CAREFULLY
MAKE MONEY FAST AND EASY HURRY!!!! Make Money Fast A little while back, I was browsing these newsgroups, just like you are now, and came across an article similar to this that said you could make thousands of dollars within weeks with only an initial investment of $6.00! So I thought," Yeah, right, this must be a scam", but like most
of us, but I was curious, so I kept reading. Anyway, it said that you send $1.00 to each of the 6 names and address stated in the article. You then place your own name and address in the bottom of the list at #6, and post the article in at least 200 newsgroups. (There are thousands) No catch, that was it. The main difference between this system and others is that you have a mailing list of 6 instead of 5... This means that your average gain will be app. 15 times higher!!! So after thinking it over, and talking to a few people first, I thought about trying it. I figured what have I got to lose except 6 stamps and $6.00, right? Like most of us I was a little skeptical and a little worried about the legal aspects of it all. So I checked it out with the U.S. Post Office (1-800-725-2161) and they confirmed that it is indeed legal! Then I invested the measly $6.00.............plus postage Well GUESS WHAT!!... Within 7 days, I started getting money in the mail! I was shocked! I still figured it would end soon, and didn't give it another thought. But the money just kept coming in. In my first week, I made about $20.00 to $30.00 dollars. By the end of the second week I had made a total of over $1,000.00!!!!!! In the third week I had over $10,000.00 and it's still growing. This is now my fourth week and I have made a total of just over $42,000.00 and it's still coming in rapidly....... It's certainly worth $6.00, and 6 stamps, I spent more than that on the lottery!! Let me tell you how this works and most importantly, why it works.... also, make sure you print a copy of this article NOW, so you can get the information off of it as you need it. The process is very simple and consists of 3 easy steps
STEP 1
Get 6 separate pieces of paper and write the following on each piece of paper "PLEASE PUT ME ON YOUR MAILING LIST." Now get 6 US$1.00 bills (or equivalent in your local currency) and place ONE inside EACH of the 6 pieces of paper so the bill will not be seen through the envelope to prevent thievery. Next, place one paper in each of the 6 envelopes and seal them. You should now have 6 sealed envelopes, each with a piece of paper stating the above phrase, your name and address, and a $1.00 bill. What you are doing is creating a service by this. THIS IS ABSOLUTELY LEGAL! Mail the 6 envelopes to the following
Addresses:
#1) J Alex Biley 69 Manningham St. Parkville, Vic 3052; Australi
#2) Suranga Sampath 237/a Bell St. Coburg, Vic 3058; Australi
#3) Greg Davidson 1370 South Madison Ave. Clearwater, Fl 3375
#4) J. Schlundt 190 Brookline St. Newton Ma 0245
#5) D. Hale Jr. 407 Edgewood Ave. Pittsburgh, Pa 1521
#6) Nimai Jaekley; 3311 Landon Dr. West Unit A; Bullhead City, A
8642
STEP 2
Now take the #1 name off the list that you see above, move the other names up (6 becomes 5, 5 becomes 4, etc...) and add YOUR Name as number 6 on the list. (Use your 'delete" key to remove name #1 and move all other names up. Then change numbers and add your name as #6)
STEP 3
Change anything you need to, but try to keep this article as close to original as possible. Now, post your amended article to at least 200 newsgroups. (I think there is close to 24,000 groups) All you need is 200, but remember, the more you post, the more money you make! Don't know HOW to post in the newsgroups? Well do exactly the following: THAT'S IT! All you have to do is jump to different newsgroups and post away, after you get the hang of it, it will take about 30 seconds for each newsgroup! **REMEMBER, THE MORE NEWSGROUPS YOU POST IN, THE MORE MONEY YOU WILL MAKE!! BUT YOU HAVE TO POST A MINIMUM OF 200** That's it! You will begin receiving money from around the world within days! You may eventually want to rent a P.O. Box due to the large amount of mail you receive. If you wish to stay anonymous, you can invent a name to use, as long as the postman will deliver it. **JUST MAKE SURE ALL THE ADDRESSES ARE CORRECT** Now the WHY part: Out of 200 postings, say I receive only 5 replies (a very low example). So then I made $5.00 with my name at #6 on the letter. Now, each of the 5 persons who just sent me $1.00 make the MINIMUM 200 postings, each with my name at #5 and only 5 persons respond to each of the original 5,that is another $25.00 for me, now those 25 each make 200 MINIMUM posts with my name at #4 and only 5 replies each, I will bring in an additional $125.00! Now, those 125 persons turn around and post the MINIMUM 200 with my name at #3 and only receive 5 replies each, I will make an additional $626.00! OK, now here is the fun part, each of those 625 persons post a MINIMUM 200 letters with my name at #2 and they each only receive 5 replies, that just made me $3,125.00!!! Those 3,125 persons will all deliver this message to 200 newsgroups with my name at #1 and if still 5 persons per 200 newsgroups react I will receive $15,625.00! With an original investment of only $6.00! AMAZING! And as I said 5 responses is actually VERY LOW! Average is probable 20 to 30! So lets put those figures at just 15 responses per person.
Here is what you will make:
at #6 $15.00 at #5 $225.00 at #4 $3,375.00 at #3 $50,625.00 at #2 $759,375.00 at #1 $11,390,625.00
When your name is no longer on the list, you just take the latest posting in the newsgroups, and send out another $6.00 to names on the list, putting your name at number 6 again. And start posting again. The thing to remember is, do you realize that thousands of people all over the world are joining the internet and reading these articles everyday, JUST LIKE YOU are now!! So can you afford $6.00 and see if it really works?? I think so... People have said, "what if the plan is played out and no one sends you the money? So what! What are the chances of that happening when there are tons of new honest users and new honest people who are joining the internet and newsgroups everyday and are willing to give it a try? Estimates are at 20,000 to 50,000 new users, everyday, with thousands of those joining the actual internet. Remember, play FAIRLY and HONESTLY and this will work. You just have to be honest. Make sure you print this article out RIGHT NOW, also. Try to keep a list of everyone that sends you money and always keep an eye on the newsgroups to make sure everyone is playing fairly. Remember, HONESTY IS THE BEST POLICY. You don't need to cheat the basic idea to make the money!! GOOD LUCK to all and please play fairly and reap the huge rewards from this, which is tons of extra CASH. TRUST ME IT DOES WORK! I am sure this will work out, try it and see. Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72035
calling a dataAdapter Update in DataTable.DataRowChanged Event
At some part of my application I want to hide the idea of a cache
(dataset) from my user, so went the user deletes a row using the data
bound UI, which deletes the row from the corresponding data table, I
want to make a call to commit the changes to database as well, so what
I did is I registered an event handle for the DataRowChanged Event and
tried to call DataSet.GetChanges. The problem is DataSet.GetChanges
return null. Is is because the DataSet is still in edit mode when the
DataRowChange event fires? So how can I commit data at the same time
as it is deleted from the dataset apart from putting a separate
'commit' button?
thx in adavance Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72030
Behind the scenes -- how is a DataTable implemented?
When one gets a row from a database (ie, a DataTable), the row contains a
typed value in each column. How is this typically implemented behind scenes.
I want to build this functionality myself. The reason I want to do this is
because I need an in-memory table without any of the overhead of a DataSet
or DataTable.
Thanks! Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72027
sp results into dataset
I'm having problems with creating a crystal reoport from
a stored procedure in VS .Net. When trying to add a chart
onto the report I get an error about 'Convert' native
error: 156. There is one input parameter on the stored
procedure (which is a date) could this be causing my
problem? Any help would be great.
Thanks in advance Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72026
Stop deleting a Row in the Changing event within a DataGrid
Hi!
I wan't to prevent a user to delete some Rows showed in a DataGrid.
I registered for the DataTable.RowDeleting event and tried to throw an
exception when deleting occours but is forbidden(as proposed in the msdn).
Problem: Nobody catches the error, so an application Exception gets shown to
the user. How can I catch the exception or prevent deleting a row in an
other way?
Thanks in advance
Benedikt Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72022
XML fix to MSDN Survey Sample - datarelation.nested??
Dear all,
Does anyone have a fix / working solution to the "bug" in the MSDN Survey
Sample?
Setting the nested property of the datarelation to true throws "A column
named 'Answer' already belongs to this DataTable: cannot set a nested table
name to the same name" in the AdjustQuestionPrimaryKey sub which is
according to the documentation (1.1.1) of the framework. The issue seem to
be with the XML...
My question is: have anyone a workaround/fix to this issue?
Thanks /BS Tag: How to bind PictureBox.Image to database image or bin column? Tag: 72018
XML to MSAccess (OleDb)
It's a breeze to take an MSAccess table to XML, but how to you do the
reverse?
Given an XML file created from a DataSet using the WriteXML method,
including the Schema, how would you then read that XML file into a dataset
and then write the dataset to an Access Database table?
Reading into a dataset is easy: DS.ReadXML(filename), BUT once I have the
dataset, what's the best way to get it back out to a database Table?
Thanks
Eric Robishaw Tag: How to bind PictureBox.Image to database image or bin column? Tag: 71988
Windows Forms semi-connected data-access best practice
I have looked around and have not found a best practice or pattern regarding
the use of data in a semi-connected multi-user windows form application.
What I have is this, a Windows Forms Client-Server application which ties in
to Microsoft SQL Server 2000. Currently the application acquires data on
clients from the database when it loads so that the end user can work on
said data. When changes are made they are made to the dataset to track
changes and properly manage new record creation. When the user exits, or
clicks save, changes are submitted using a variety of DataAdapters to
properly hierarchally update the data.
I believe though that although this has worked for single-user systems, this
is not the best practice for a multi-user system as data can become
inconsistent as changes are made by each application.
Would it be better to:
* Transmit transacted changes immediately to the database once the DataSet
can perform its constraint checks, rather than wait until the user clicks
"Save"
* Find or put together a means to constantly check for updates to actively
changing and highly used tables (such as clients) and freshen the data as
soon as is possible.
I would rather this application be as connected as possible to the database
server, and that updates be as real-time as possible. I have seen "some"
examples of a semi-connected application using a web-service and performing
some type of polling for connectivity however I do not wish to expose the
business logic as a web service at this time. None of the examples explain
how to manage a consistent state for real-time or pseudo-real-time data.
--
Ron A. Buckton, MCP
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
President
Chronicles Design
Url: http://www.chroniclesdesign.com
begin 666 Ron A. Buckton.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..D)U8VMT;VX[4F]N.T$N#0I&
M3CI2;VX@02X@0G5C:W1O;@T*3U)'.D-H<F]N:6-L97,@1&5S:6=N#0I4251,
M13I396YI;W(@+DYE="!3;VQU=&EO;G,@1&5V96QO<&5R+"!-0U -"D%$4CM7
M3U)+.CL[.U!I='1S8G5R9V@[4$$[,34R,S<[55-!#0I,04)%3#M73U)+.T5.
M0T]$24Y'/5%53U1%1"U04DE.5$%"3$4Z4&ET='-B=7)G:"P@4$$@,34R,S<]
M,$0],$%54T$-"E@M5T%"+4=%3D1%4CHR#0I54DP[2$]-13IH='1P.B\O=W=W
M+F-H<F]N:6-L97,N;W)G#0I54DP[5T]22SIH='1P.B\O=W=W+F-H<F]N:6-L
M97-D97-I9VXN8V]M#0I%34%)3#M04D5&.TE.5$523D54.G)B=6-K=&]N0&-H
M<F]N:6-L97-D97-I9VXN8V]M#0I2158Z,C P,S$Q,3E4,C$R,#(R6@T*14Y$
(.E9#05)$#0H`
`
end Tag: How to bind PictureBox.Image to database image or bin column? Tag: 71987
End Of File
Scenario: I have a SqlDataAdapter that I used to populate
a dataset.
oAdapter = New SqlDataAdapter(oCmd)
oDataSet = New DataSet()
oAdapter.Fill(oDataSet)
I then use the dataset to populate a datagrid.
dgFilings.DataSource = oDataSet
dgFilings.DataBind()
Problem: I don't want to populate the datagrid if there
were no records return from the query. So how do i check
if the dataset or the DataAdapter is empty or not?
In classic asp this would be done with the recordset
method eof().
thanks for your help,
aymer
aymerb[@].yahoo.com Tag: How to bind PictureBox.Image to database image or bin column? Tag: 71974
System.Data.Odbc
I am trying to work through some non-specific provider work and can't seem
to get the System.Data.Odbc provider. According to the MSDN documentation,
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataodbc.asp,
this namespace is supported in version 1.1 of the framework. I have 1.1
installed and the namespace is nowhere to be found. Any help would be
greatly appreciated.
Thanks,
Steve Bering Tag: How to bind PictureBox.Image to database image or bin column? Tag: 71973
*very* basic question about design of ado.net
Sorry in advance for my ignorance. Any help would sure be
appreciated. I'm writing a fairly simple application with VB.Net and
am obviously a bit of a newbie. This application will be used by 1, 2
or at most 3 people concurrently and I'm using Access 2003 for my data
source. We are not dealing with a large amount of data (5 or 6
tables, for a total of maybe 3,000 records - one table having the
majority of that). This application is using a fairly simple form,
but upon leaving certain text boxes, I want to fill in some data. For
instance, I might have one field that is for a competition number -
when I leave it, I want to populate a description. The next field
might be a competitor number and when I leave it, I want to populate a
field with the competitor name.
Enough of the background - I created a module to open my connection
and a function within that to handle my DataReader. In that module I
have:
Imports System.Data
Imports System.data.oledb
Imports System.Data.sqlclient
Module Main
Public strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=f:\mydatabase.mdb"
Public cn As New OleDbConnection(strConn)
Function ExecuteReader(ByVal sSQLString As String) As
OleDb.OleDbDataReader
Dim dr As OleDbDataReader
Dim cmd As OleDbCommand = New OleDbCommand(sSQLString, cn)
Try
If cn.State = ConnectionState.Closed Then cn.Open()
dr = cmd.ExecuteReader()
cmd.Dispose()
Catch ex As OleDbException
MsgBox(ex.Message, MsgBoxStyle.Exclamation)
End Try
Return dr
End Function
End Module
And that's pretty much it so far. In my main code I have:
Private Sub txtCompNum_Leave(ByVal sender As Object, ByVal e As
System.EventArgs) Handles txtCompNum.LostFocus
Dim dr As OleDbDataReader
dr = ExecuteReader("SELECT * FROM competition where compnum =
" & "'" & txtCompNum.Text & "'")
While dr.Read
txtDance.Text = dr.GetString(2)
End While
dr.Close()
End Sub
Private Sub txtCompetitor_Leave(ByVal sender As Object, ByVal e As
System.EventArgs) Handles txtCompetitor.Leave
Dim dr As OleDbDataReader
dr = ExecuteReader("SELECT * FROM dancer where cardnum = " &
txtCompetitor.Text)
While dr.Read
txtName.Text = dr.GetString(3) & ", " & dr.GetString(4)
End While
dr.Close()
cn.Close()
End Sub
These seem to work well and fast. But there are a few questions:
1. Is there a "right" way to structure creating the different
components necessary to populate my form and if so, is mine along the
right lines so far?
2. Should I use "Leave" or "Lost_Focus" for my text boxes? I used to
use "Lost_Focus" with VB6, but was wondering if there was a difference
or if one was preferred.
3. If the two datareaders above only return one record, is there some
other reader I should use to improve performance?
Any other suggestions would sure be appreciated. I'm a bit
wet-behind-the-ears so I'd love some help.
Thanks!
Steve Tag: How to bind PictureBox.Image to database image or bin column? Tag: 71970
ADO.NET Bug re: Autoincrement Columns "Value ... is already present" VS2003 v7.1.3088 .NET v 1.1.4322 SQL Server 2000
Hi,
I am getting these "Value is already present" errors occasionally on
my autoincrement columns. I am not doing anything special here, just
using the code that is generated by the Visual Studio designer. I
have tried autoincrement seeds on the table of both 1 and 100, but it
doesn't make any difference. Most of the time, it works, but every
once in a while, I get this problem... usually when the table is
"young" but not necessarily on the first inserts.
I am 99% certain that SQL Server is not the source of the fault.
The fault, I believe, is with the SQL generated by Visual Studio
and/or the manner in which ADO.NET handles the merging of the INSERT
results into the original table. If you look at the SQL statement
generated by Visual Studio, you will see that it SELECTS the results
of the insert. I believe that Visual Studio is immediately attempting
to merge the results into the source dataset, so if there are still
rows in the dataset waiting to be inserted and the IDENTITY result of
the first insert happens to coinicide with the "Fake" ADO.NET identity
in one of the pending insert rows, then ADO.NET throws an exception.
This would be a bug in ADO.NET, in my opinion.
I do not want to have to customize the INSERT statements for all of my
SQL commands. This would be a lot of work, and also essentially
renders the Visual Studio designer useless.
My question is: Is there a known workaround for this problem? I have
seen this suggested:
http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&safe=off&selm=KQ5HdGMFDHA.2580%40cpmsftngxa06.phx.gbl
...but you would have to remember to repeat this step every time you
regenerated the dataset, not good.
The only other idea is temporarily turning off constraints during the
insert... would it work?
See code examples below... names have been changed to protect the
identities of the innocent. FYI, the dataset is being generated by a
client app, the data updates are done by an EnterpriseServices
component (COM+). Otherwise, this is 100% plain-jane Visual Studio
generated code.
>>>>> Visual Studio's generated SQL statement <<<<<<<
Me.SqlInsertCommand2.CommandText = "INSERT INTO X(Y_Id, Z_Id) VALUES
(@Y_Id, @Z_Id); SELECT X_Id, Y_Id, Z_Id, FROM X WHERE (X_Id =
@@IDENTITY)"
>>>>> ERROR MESSAGE <<<<<<<<
Column 'X_Id' is constrained to be unique. Value '115' is already
present.
>>>>> DATASET SOURCE <<<<<<<<
...
<xs:element name="X_Id" msdata:ReadOnly="true"
msdata:AutoIncrement="true" type="xs:int" />
...
>>>>> TABLE SOURCE <<<<<<
CREATE TABLE [X] (
[X_Id] [int] IDENTITY (100, 1) NOT NULL ,
[Z_Id] [int] NOT NULL ,
[Y_Id] [int] NOT NULL ,
...
CONSTRAINT [PK_X] PRIMARY KEY NONCLUSTERED
(
[X_Id]
) ON [PRIMARY] ,
CONSTRAINT [FK_X_Z_Y] FOREIGN KEY
(
[Z_Id],
[Y_Id]
) REFERENCES [X_Y] (
[Z_Id],
[Y_Id]
) ON DELETE CASCADE
) ON [PRIMARY] Tag: How to bind PictureBox.Image to database image or bin column? Tag: 71966
HELP PLEASE "DataBinding could not find a row in the list that is suitable for all bindings"
Hi all, i have this error
"DataBinding could not find a row in the list that is suitable for all
bindings"
and this happens when i press my button to cancel using this
"Me.BindingManager.CancelCurrentEdit()"
i have in my datatable 4 string fields , one autonumber ( key ) and 1 date
field, when i press the add button using
Me.BindingManager.Addnew() and i press imediatly the
Me.BindingManager.CancelCurrentEdit() it throws the error ..
one note: i don´t have any row in my datatable. datatable.rows.count = 0
can anyone assist me .. ?
thks
JSB Tag: How to bind PictureBox.Image to database image or bin column? Tag: 71965
Handling of a ConstraintException
Hi.
I got so much help out of the dotnet Groups, so I thought I'd share a little
wisdom I found out.
Forgive me if the solution I present is already well known (honestly, it is
stupid simple) - But I found only questions like mine asked in the header,
and no answers.
Brief description of the problem:
You load your tables using a dataadapter into your dataset. Tables are
master/child, the dataset enforces the relation.
Somehow, one of the masters got deleted - and the children are stranded.
When enforcing the constraint, you get the exception.
You want to find out, which child rows cause the trouble. The exception does
not deliver this data in one of it's properties.
Brief description of my solution:
The data has been loaded fine already, so you can do the following (in the
catch ex as ConstraintException-block):
For each dr as DataRow in ChildTable
if dr.GetParent is Nothing then dr.delete
Next
DataAdapter.Update(ChildTable)
Dataset.EnforceConstraint = True
Now the rows causing the trouble are gone, and the changes are put back to
the database. In my solution, deleting the rows was the best idea - you
might need to do something else, but once you know the rows, you can handle
them as you like!
After Enforcing the constraint yourself, your Dataset is ready to go, as if
nothing ever happened to it!
Bye, Ralf Tag: How to bind PictureBox.Image to database image or bin column? Tag: 71956
How to bind PictureBox.Image to database image or bin column?
--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
"jiatiejun" <jiatiejun@126.com> wrote in message
news:uy8NSo8rDHA.572@TK2MSFTNGP11.phx.gbl...
> How to bind PictureBox.Image to database image or bin column?
>
> thanks
>
>