all groups > vb.net data > november 2006
SQL Client CommandTimeout being ignored
Posted by jwgoerlich NO[at]SPAM gmail.com at 11/28/2006 1:21:11 PM
Hello group,
I have a simple Vb.net application that reads from a SQL 2005 database.
Sometimes when I execute a query and fill a data table, a "Timeout
expired" exception is thrown.
The strange thing is that I have set the CommandTimeout to 10000. This
should be more than enough time, given... more >>
Read and write database
Posted by fniles at 11/28/2006 9:36:34 AM
When using VB6 and ADO, if I only do a Read, I will open a recordset with
Forward Only cursor and Read Only lock, thus it will be faster than a non
Read recordset.
In VB.NET, when only need to do a Read, is it correct that I want to use
OLEDBDataReader (SQLDataReader for SQL Server), when wh... more >>
Retrieve records from table that match current record in another table?
Posted by mike11d11 at 11/22/2006 2:12:43 PM
I'm working with a dataset table WorkList that has all of the details
for a persons accounts displayed in detailed view as individual text
boxes for each field. The problem I have is trying to take another
table Memos that can hold multiple note lines for each particular
account. some how I ne... more >>
Dataconection and multiple forms
Posted by Andy at 11/18/2006 3:33:40 PM
Hi
I'm currently working on an application that so was has only used one form,
and all connectioninfo to my database is within this. But I've I plan to
implement multiple forms, is it best to move the variables regarding the
database connection over to a module in my solution?
/A.
... more >>
Excel: Numerics are read as Null
Posted by Kjell Weding at 11/17/2006 1:03:28 PM
Software: VB.NET 2.0 and Excel 2003
I have an Excel sheet with 140 records. 135 of the records have alphanumeric
data in fields.item(2) (see code below). 5 of the 140 cells in this coloumn
is however numeric.
When I read the records, the alphanumeric fileds is read OK, but the 5
records ... more >>
passing parameter to class from application
Posted by Smile at 11/17/2006 2:51:21 AM
Hi there,
I have a question, please give me some idea. Thanks in advance!
Solution1
|
|---DBLogic (class library)
| |
| |-dblogic (class) which defines ConnString, functions to create
DataTable by sqlstr
|
|
|---DBObjects (class library)
| |
... more >>
HELP!!! System.Data.OleDb.OleDbException: Cannot update the cursor, since it is read-only
Posted by sales NO[at]SPAM advantagewebaccess.com at 11/15/2006 9:21:14 AM
I am trying to add users to a database via asp.net into a foxpro table,
i get the following error:
Source Error:
Line 204: myCommand.Connection.Open()
Line 205: Try
Line 206: myCommand.ExecuteNonQuery()
Line 207: ' Message.InnerHtml = "<b>Record Updated</b><br>"
Line... more >>
datagridView in windows form 2.0 creating problem.
Posted by sathya at 11/13/2006 8:57:33 PM
i am adding geeting values from popup and putting that selected value
to last row (new row) of datagridview.but when i get value from popup
the new row is not formed.So when ever i move out from this record
without savving the record the values of the record get vanish.
but when i enter the va... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Performance problems, saving 5 values in a second
Posted by Christer S at 11/10/2006 3:23:45 PM
I got this error message occasionally, sometimes is says that it couldn't
close connection because its execusing.
I call this sub below every 200 millisecond(the applivcation recives measure
data from a PLC), and the errors occurce irregularly, somtimes 20 minutes
between them and some times ... more >>
how to create a table programmatically in excel?
Posted by Britt at 11/9/2006 10:00:14 PM
Hi,
I want to create a table programmatically in excel. How can o do this
("create table ....")??
And then, how to put it in specific cells in the worksheet, and possibly
put it into sheet2 of the same worksheet?
Thanks for gelp
Britt
... more >>
Any RTF Lib out there?
Posted by Leon_Amirreza at 11/9/2006 12:00:00 AM
I need a good RTF Parser (Reader / Writer) Library in C/C++/C# for some text
processing purposes?
any Free or Commodity Libs I can use?
Please give some Web Site Address
... more >>
How to Get the ITextDocument Interface of a .Net RichTextBox?
Posted by Leon_Amirreza at 11/9/2006 12:00:00 AM
Is there Any way I can get the ITextDocument Interface of a .Net
RichTextBox?
Please post some Sample Code that extracts this interface from RichTextBox?
... more >>
KNOW THE SIZE OF A FIELD
Posted by Raul at 11/8/2006 1:33:03 AM
In visual basic 6
xxx.recordset.fields(1). size and in the fields of type string it indicated
you the maximum that allowed
In. net opposing net anything resemblance.
thank you
... more >>
I'm not able to filter dataset with the dataset.tables.select
Posted by mike11d11 at 11/5/2006 7:38:14 PM
I cant seem to filter down my dataset table by criteria in expression.
Can someone tell me why I still have the same amount of rows after I
use this filter select option.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Me.WorkListTa... more >>
bind the data in textbox with recordset
Posted by asad at 11/3/2006 9:08:00 PM
hi everyone!i am trying to bind the data in textbox with recordset such as vb6 can do it as textbox1.datasource= rs
but in vb.net there is problem in datasource.
plz help me to solve this problem
my email address is mustakeel@gmail.com... more >>
Datasource question
Posted by Andy.I at 11/2/2006 12:00:00 AM
Hi
just begun playing around with VB and SQL programming, and have a question.
When I'm making a data source in my project I want to set up a SQL server
connection. But, I see that I have 2 choices, Microsoft SQL Server and
Microsoft SQL Server Database file. What are the differences between... more >>
|