473,695 Members | 2,360 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

There is already an open datareader with this command which must be closed first

Hi again,

sorry for posting two questions so close together but im working on a
school project which is due in soon and running into some difficulties
implementing the database parts. I have the code below which when
executed generates the following error message: 'There is already an
open datareader with this command which must be closed first'
Private Sub MainMenu_Load(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load
'Declare new connection variable
Dim cnn As SqlConnection
'Declare string to hold SQL reservation query
Dim sqlreservation As String
'Declare command to execute query
Dim cmdMain As SqlCommand
'Declare data reader to hold query results
Dim dr As SqlDataReader
'Declare insteger as loop counter
Dim i As Integer = 0
'Declare string to hold topic of reserved cutting
Dim topic As String
'Declare array to hold cutting ids
Dim cids() As String
'Declare arraylist to temporarily hold ids
Dim list As ArrayList = New ArrayList()

'Place container 100 pixels from top of screen
MenuContainer.T op = Me.Height - (Me.Height - 100)
'Place container in horizontal centre of screen
MenuContainer.L eft = Me.Width / 2 - (MenuContainer. Width / 2)

'Instantiate the conection object
cnn = New SqlConnection

'Try block to catch errors
Try
'Set connections connection string property to global cnn
varialbe
cnn.ConnectionS tring = My.Settings.cnn

'Try to open connection
cnn.Open()
Catch ex As Exception
'Deal with exceptions if any occur by showing a message box
with exception details
MsgBox("An error occurred whilst trying to connect to your
SQL Server" + Environment.New Line + ex.Message, MsgBoxStyle.Exc lamation
+ MsgBoxStyle.OkO nly, "Cutting Library")
'Stop exucting rest of this code
Exit Sub
End Try

'Set up query to find if any reservations for this user exist
sqlreservation = "SELECT CuttingID FROM CuttingReservat ion
WHERE StudentID = '1000'"

'Instantiate command
cmdMain = New SqlCommand

'Set up try block to catch errors
Try
'Set connection for command to use
cmdMain.Connect ion = cnn

'Set comand text
cmdMain.Command Text = sqlreservation

'Execute command and store results in data reader
dr = cmdMain.Execute Reader()

'Add contents of data reader to array list
While dr.Read()
list.Add(dr.Get Value(0).ToStri ng())
End While

'Resize the array and copy the arraylist's contents to
array
ReDim cids(list.Count - 1)
list.CopyTo(cid s)

Catch ex As Exception
'Display error message to user ecxplaining error
MsgBox("An error occurred whilst querrying the database. "
+ ex.Message, MsgBoxStyle.Exc lamation + MsgBoxStyle.OkO nly, "Cutting
Library")
'stop further executiong of code
Exit Sub
End Try

Try
'Iterate through all ids in array
For Each id As String In cids
'Set sqlreservation query to find status of each
cutting
sqlreservation = "SELECT Topic FROM Cutting WHERE
CuttingID = '" + id + "' AND Status = 'True'"

'Set command text to new query
cmdMain.Command Text = sqlreservation

'Set connection property
cmdMain.Connect ion = cnn

'execute query and catch results in datareader
dr = cmdMain.Execute Reader()

While dr.Read()
'display message box telling user cutting is
avaialble
MsgBox(dr(0).To String())
MsgBox("The following reserved cutting is now
available: " + dr.GetValue(0). ToString(), MsgBoxStyle.Inf ormation +
MsgBoxStyle.OkO nly, "Cutting Library")
End While
Next
Catch ex As Exception
MsgBox("failed " + ex.Message)
End Try
End Sub

Sorry for the large amount of code but without posting it all its
probably hard to get any idea as to what im doing

Thanks in advance

James

Jan 22 '07 #1
10 6100
You do know it's a no-no (imo) to post homework questions on newgroups
right? If we give you the answers now, what will you do when you get
stumped during a job?

Irregardless, I'll still help you out on this one. You're error message
tell's you exactly what needs to happen - you need to close the
datareader! So pull up the object browser (F2 I believe) and search for
SqlDataReader and browse through the available methods. One should
stick out as a way to "Close" the datareader..... .

Also, before posting you should always check out the provided help and
the object browser. Then I would recommend searching msdn.com and then
the archives of this newsgroup at
http://groups.google.com/group/micro.../topics?lnk=sg.
Most of the time a similar question has been asked/answered.

Thanks,

Seth Rowe
jimmy wrote:
Hi again,

sorry for posting two questions so close together but im working on a
school project which is due in soon and running into some difficulties
implementing the database parts. I have the code below which when
executed generates the following error message: 'There is already an
open datareader with this command which must be closed first'
Private Sub MainMenu_Load(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load
'Declare new connection variable
Dim cnn As SqlConnection
'Declare string to hold SQL reservation query
Dim sqlreservation As String
'Declare command to execute query
Dim cmdMain As SqlCommand
'Declare data reader to hold query results
Dim dr As SqlDataReader
'Declare insteger as loop counter
Dim i As Integer = 0
'Declare string to hold topic of reserved cutting
Dim topic As String
'Declare array to hold cutting ids
Dim cids() As String
'Declare arraylist to temporarily hold ids
Dim list As ArrayList = New ArrayList()

'Place container 100 pixels from top of screen
MenuContainer.T op = Me.Height - (Me.Height - 100)
'Place container in horizontal centre of screen
MenuContainer.L eft = Me.Width / 2 - (MenuContainer. Width / 2)

'Instantiate the conection object
cnn = New SqlConnection

'Try block to catch errors
Try
'Set connections connection string property to global cnn
varialbe
cnn.ConnectionS tring = My.Settings.cnn

'Try to open connection
cnn.Open()
Catch ex As Exception
'Deal with exceptions if any occur by showing a message box
with exception details
MsgBox("An error occurred whilst trying to connect to your
SQL Server" + Environment.New Line + ex.Message, MsgBoxStyle.Exc lamation
+ MsgBoxStyle.OkO nly, "Cutting Library")
'Stop exucting rest of this code
Exit Sub
End Try

'Set up query to find if any reservations for this user exist
sqlreservation = "SELECT CuttingID FROM CuttingReservat ion
WHERE StudentID = '1000'"

'Instantiate command
cmdMain = New SqlCommand

'Set up try block to catch errors
Try
'Set connection for command to use
cmdMain.Connect ion = cnn

'Set comand text
cmdMain.Command Text = sqlreservation

'Execute command and store results in data reader
dr = cmdMain.Execute Reader()

'Add contents of data reader to array list
While dr.Read()
list.Add(dr.Get Value(0).ToStri ng())
End While

'Resize the array and copy the arraylist's contents to
array
ReDim cids(list.Count - 1)
list.CopyTo(cid s)

Catch ex As Exception
'Display error message to user ecxplaining error
MsgBox("An error occurred whilst querrying the database. "
+ ex.Message, MsgBoxStyle.Exc lamation + MsgBoxStyle.OkO nly, "Cutting
Library")
'stop further executiong of code
Exit Sub
End Try

Try
'Iterate through all ids in array
For Each id As String In cids
'Set sqlreservation query to find status of each
cutting
sqlreservation = "SELECT Topic FROM Cutting WHERE
CuttingID = '" + id + "' AND Status = 'True'"

'Set command text to new query
cmdMain.Command Text = sqlreservation

'Set connection property
cmdMain.Connect ion = cnn

'execute query and catch results in datareader
dr = cmdMain.Execute Reader()

While dr.Read()
'display message box telling user cutting is
avaialble
MsgBox(dr(0).To String())
MsgBox("The following reserved cutting is now
available: " + dr.GetValue(0). ToString(), MsgBoxStyle.Inf ormation +
MsgBoxStyle.OkO nly, "Cutting Library")
End While
Next
Catch ex As Exception
MsgBox("failed " + ex.Message)
End Try
End Sub

Sorry for the large amount of code but without posting it all its
probably hard to get any idea as to what im doing

Thanks in advance

James
Jan 22 '07 #2
I have tried the dataReader.clos e method however i stil get the error!
where abouts would you recommend placing this? i've tried putting it
after the first time i used it. is this correct? I have also tried
using a new dataReader and command object and it still gives me the
same error message. Can the dataReader be reused once it is closed?

And about the homework thing, its part of a much larger project, which
i am allowed to receive external help for (as long as i say where from)
and also if i find out where i'm going wrong now when i get a job later
and i encounter the same error i should know what to do! thats just my
opinion on the matter though!

Thanks

james

Jan 22 '07 #3

jimmy wrote:
Hi again,

sorry for posting two questions so close together but im working on a
school project which is due in soon and running into some difficulties
implementing the database parts. I have the code below which when
executed generates the following error message: 'There is already an
open datareader with this command which must be closed first'
Private Sub MainMenu_Load(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load
'Declare new connection variable
Dim cnn As SqlConnection
'Declare string to hold SQL reservation query
Dim sqlreservation As String
'Declare command to execute query
Dim cmdMain As SqlCommand
'Declare data reader to hold query results
Dim dr As SqlDataReader
'Declare insteger as loop counter
Dim i As Integer = 0
'Declare string to hold topic of reserved cutting
Dim topic As String
'Declare array to hold cutting ids
Dim cids() As String
'Declare arraylist to temporarily hold ids
Dim list As ArrayList = New ArrayList()

'Place container 100 pixels from top of screen
MenuContainer.T op = Me.Height - (Me.Height - 100)
'Place container in horizontal centre of screen
MenuContainer.L eft = Me.Width / 2 - (MenuContainer. Width / 2)

'Instantiate the conection object
cnn = New SqlConnection

'Try block to catch errors
Try
'Set connections connection string property to global cnn
varialbe
cnn.ConnectionS tring = My.Settings.cnn

'Try to open connection
cnn.Open()
Catch ex As Exception
'Deal with exceptions if any occur by showing a message box
with exception details
MsgBox("An error occurred whilst trying to connect to your
SQL Server" + Environment.New Line + ex.Message, MsgBoxStyle.Exc lamation
+ MsgBoxStyle.OkO nly, "Cutting Library")
'Stop exucting rest of this code
Exit Sub
End Try

'Set up query to find if any reservations for this user exist
sqlreservation = "SELECT CuttingID FROM CuttingReservat ion
WHERE StudentID = '1000'"

'Instantiate command
cmdMain = New SqlCommand

'Set up try block to catch errors
Try
'Set connection for command to use
cmdMain.Connect ion = cnn

'Set comand text
cmdMain.Command Text = sqlreservation

'Execute command and store results in data reader
dr = cmdMain.Execute Reader()

'Add contents of data reader to array list
While dr.Read()
list.Add(dr.Get Value(0).ToStri ng())
End While

'Resize the array and copy the arraylist's contents to
array
ReDim cids(list.Count - 1)
list.CopyTo(cid s)

Catch ex As Exception
'Display error message to user ecxplaining error
MsgBox("An error occurred whilst querrying the database. "
+ ex.Message, MsgBoxStyle.Exc lamation + MsgBoxStyle.OkO nly, "Cutting
Library")
'stop further executiong of code
Exit Sub
End Try
dr.Close
>
Try
'Iterate through all ids in array
For Each id As String In cids
'Set sqlreservation query to find status of each
cutting
sqlreservation = "SELECT Topic FROM Cutting WHERE
CuttingID = '" + id + "' AND Status = 'True'"

'Set command text to new query
cmdMain.Command Text = sqlreservation

'Set connection property
cmdMain.Connect ion = cnn

'execute query and catch results in datareader
dr = cmdMain.Execute Reader()

While dr.Read()
'display message box telling user cutting is
avaialble
MsgBox(dr(0).To String())
MsgBox("The following reserved cutting is now
available: " + dr.GetValue(0). ToString(), MsgBoxStyle.Inf ormation +
MsgBoxStyle.OkO nly, "Cutting Library")
End While
Next
Catch ex As Exception
MsgBox("failed " + ex.Message)
End Try
End Sub

Sorry for the large amount of code but without posting it all its
probably hard to get any idea as to what im doing

Thanks in advance

James
Jan 22 '07 #4
Well, think about the message for a moment. It seems to be indicating that
you already have an open DataReader, right? That's because you do. You are
using dr to refer to one DataReader and then you are using it again to refer
to another and you haven't closed it in between. While many error messages
don't really provide clear information about what the problem is, this isn't
one of them.

Also, I have to say that if your teacher is teaching you to write code like
you've shown, I'd ask for my money back for the course! A couple of
pointers...

Avoid "Exit Sub" statements when possible (and in your code it is very
possible) as they are considered by many to be a nasty way of controlling
program flow. Try...Catch statements can help here. Instead of using
bunches of them, just use one and you won't need those ugly Exit Subs
anymore.

Although the plus sign (+) is acceptable as a concatenation charictor, VB
distinguishes concatenation from mathmatical addition by providing two
different operators, the plus sign for mathematical addition and the
ampersand for string concatenation.

Next, in your comments, you refer to using a DataReader to "store" the
results of your query. DataReaders do not store anything, they allow you to
have a connected look at the original data that matches your query criteria.

You've also attempted to use your connection (con.Open()) before
instantiating it (con = New SQLConnection) - that will never work.

You've certainly got the commenting thing down! But don't just write
comments because you are supposed to, write them in a way that will help you
understand the code (and others as well). You really don't need to comment
*every* line of code. That will just make more clutter and take much more
time. Instead of declaring all your variables at the beginning of your
code, I (and others) prefer to declare variables in the general proximity of
where they will be needed. This becomes significant when you get to writing
routines that are hundreds of lines of code long. Also, be aware of your
capitalization. Just because VB isn't case-sensitive doesn't mean we don't
care about it. Be consistent is the main thing. In general, it is common
to use Camel Case (cameCase) on private variables and Pascal Case
(PascalCase) on public variables. So, instead of: your code, how about
this:

Private Sub MainMenu_Load(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load

'ADO.NET variable declarations
Dim con As SqlConnection 'gets me connected to SQL
Dim cmdMain As SqlCommand 'executes a query against a SQL DB
Dim dr As SqlDataReader 'used to iterate over query results

Try
'Instantiate the conection object
cnn = New SqlConnection '<--- You had this after you were attempting
to open the connection!

'Set connection's connection string property to global cnn varialbe
con.ConnectionS tring = My.Settings.con

cnn.Open()

'Set up & store query to find if any reservations for this user exist
Dim sqlReservation As String = "SELECT CuttingID FROM
CuttingReservat ion WHERE StudentID = '1000'"

'Instantiate & configure command
cmdMain = New SqlCommand
cmdMain.Connect ion = con
cmdMain.Command Text = sqlReservation

'Execute command and return DataReader to iterate over results
dr = cmdMain.Execute Reader()

'Copy contents of DataReader to ArrayList
Dim list As ArrayList = New ArrayList()
While dr.Read()
list.Add(dr.Get Value(0).ToStri ng())
End While

dr.Close() '<--- This is what you didn't have in your code

'Declare string to hold topic of reserved cutting
Dim topic As String

'Declare String array to hold cutting id's
Dim cids() As String

'Resize the array and copy the arraylist's contents to array
ReDim cids(list.Count - 1)
list.CopyTo(cid s)

'Get ready to query the database again
'Never a good idea to re-use commands and data readers..it just causes
problems!
'Good idea to re-use connections though.
Dim cmdCuttingStatu s As New SqlCommand 'executes a query against a
SQL DB
cmdCuttingStatu s.connection = con
Dim dr2 As SqlDataReader 'used to iterate over query results
Dim sqlQueryText As String

'Iterate through all ids in array
For Each id As String In cids

'Set sqlQueryText to query that finds status of each cutting
sqlQueryText = "SELECT Topic FROM Cutting WHERE CuttingID = '" &
id & "' AND Status = 'True'"

'Execute command with new query and access results via a
DataReader
dr2 = cmdMain.Execute Reader()

While dr.Read()
'display message box telling user cutting is avaialble
MsgBox(dr(0).To String())
MsgBox("The following reserved cutting is now available: " &
dr.GetValue(0). ToString(), MsgBoxStyle.Inf ormation & MsgBoxStyle.OkO nly,
"Cutting Library")
End While
Next

'Configure menu container
'Place container 100 pixels from top of screen
MenuContainer.T op = Me.Height - (Me.Height - 100)

'Place container in horizontal centre of screen
MenuContainer.L eft = Me.Width / 2 - (MenuContainer. Width / 2)
Catch ex As Exception
'Deal with exceptions if any occur by showing a message box with
exception details
MsgBox("An error occurred ..." & Environment.New Line & ex.Message,
MsgBoxStyle.Exc lamation & MsgBoxStyle.OkO nly, "Cutting Library")
End Try
End Sub


"jimmy" <ja************ **@tiscali.co.u kwrote in message
news:11******** *************@m 58g2000cwm.goog legroups.com...
Hi again,

sorry for posting two questions so close together but im working on a
school project which is due in soon and running into some difficulties
implementing the database parts. I have the code below which when
executed generates the following error message: 'There is already an
open datareader with this command which must be closed first'
Private Sub MainMenu_Load(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load
'Declare new connection variable
Dim cnn As SqlConnection
'Declare string to hold SQL reservation query
Dim sqlreservation As String
'Declare command to execute query
Dim cmdMain As SqlCommand
'Declare data reader to hold query results
Dim dr As SqlDataReader
'Declare insteger as loop counter
Dim i As Integer = 0
'Declare string to hold topic of reserved cutting
Dim topic As String
'Declare array to hold cutting ids
Dim cids() As String
'Declare arraylist to temporarily hold ids
Dim list As ArrayList = New ArrayList()

'Place container 100 pixels from top of screen
MenuContainer.T op = Me.Height - (Me.Height - 100)
'Place container in horizontal centre of screen
MenuContainer.L eft = Me.Width / 2 - (MenuContainer. Width / 2)

'Instantiate the conection object
cnn = New SqlConnection

'Try block to catch errors
Try
'Set connections connection string property to global cnn
varialbe
cnn.ConnectionS tring = My.Settings.cnn

'Try to open connection
cnn.Open()
Catch ex As Exception
'Deal with exceptions if any occur by showing a message box
with exception details
MsgBox("An error occurred whilst trying to connect to your
SQL Server" + Environment.New Line + ex.Message, MsgBoxStyle.Exc lamation
+ MsgBoxStyle.OkO nly, "Cutting Library")
'Stop exucting rest of this code
Exit Sub
End Try

'Set up query to find if any reservations for this user exist
sqlreservation = "SELECT CuttingID FROM CuttingReservat ion
WHERE StudentID = '1000'"

'Instantiate command
cmdMain = New SqlCommand

'Set up try block to catch errors
Try
'Set connection for command to use
cmdMain.Connect ion = cnn

'Set comand text
cmdMain.Command Text = sqlreservation

'Execute command and store results in data reader
dr = cmdMain.Execute Reader()

'Add contents of data reader to array list
While dr.Read()
list.Add(dr.Get Value(0).ToStri ng())
End While

'Resize the array and copy the arraylist's contents to
array
ReDim cids(list.Count - 1)
list.CopyTo(cid s)

Catch ex As Exception
'Display error message to user ecxplaining error
MsgBox("An error occurred whilst querrying the database. "
+ ex.Message, MsgBoxStyle.Exc lamation + MsgBoxStyle.OkO nly, "Cutting
Library")
'stop further executiong of code
Exit Sub
End Try

Try
'Iterate through all ids in array
For Each id As String In cids
'Set sqlreservation query to find status of each
cutting
sqlreservation = "SELECT Topic FROM Cutting WHERE
CuttingID = '" + id + "' AND Status = 'True'"

'Set command text to new query
cmdMain.Command Text = sqlreservation

'Set connection property
cmdMain.Connect ion = cnn

'execute query and catch results in datareader
dr = cmdMain.Execute Reader()

While dr.Read()
'display message box telling user cutting is
avaialble
MsgBox(dr(0).To String())
MsgBox("The following reserved cutting is now
available: " + dr.GetValue(0). ToString(), MsgBoxStyle.Inf ormation +
MsgBoxStyle.OkO nly, "Cutting Library")
End While
Next
Catch ex As Exception
MsgBox("failed " + ex.Message)
End Try
End Sub

Sorry for the large amount of code but without posting it all its
probably hard to get any idea as to what im doing

Thanks in advance

James

Jan 22 '07 #5
Thanks for the code, it isnt working at the moment however it looks
more promising than mine!

As for the way i write my code its probably because i am completely
self taught, the course i'm doing is a GCSE course and doesn't involve
any programming, however i chose to do a more advanced project to
challenge myself.

I use several Try...Catch blocks because i find it makes it easier when
added more detailed error catching at a later date, by adding handlers
for specific errors however i could probably do it with just one block,
it would just require a bit more thinking. I know the error message was
obvious but i had already tried closing the datareader i guess i just
did it in the wrong place.

Thanks anyway

Jan 22 '07 #6
"jimmy" <ja************ **@tiscali.co.u kschrieb
Hi again,

sorry for posting two questions so close together but im working on
a school project which is due in soon and running into some
difficulties implementing the database parts. I have the code below
which when executed generates the following error message: 'There is
already an open datareader with this command which must be closed
first'
As the message says, first close the reader by calling it's close method
before opening another Datareader.
Armin

Jan 22 '07 #7
Thanks, but i have solved the problem now. I tried closing the
datareaders and even used the code the Scott provided but it still gave
me the same error! Instead i just created a more advanced query to get
all the info in one go!
Thanks

James

Jan 22 '07 #8
Forgot to mention that the 2nd DataReader needs to be closed after you
finish using it and just before the End Try, you should add

Finally
con.close
End Try
"jimmy" <ja************ **@tiscali.co.u kwrote in message
news:11******** **************@ 51g2000cwl.goog legroups.com...
Thanks for the code, it isnt working at the moment however it looks
more promising than mine!

As for the way i write my code its probably because i am completely
self taught, the course i'm doing is a GCSE course and doesn't involve
any programming, however i chose to do a more advanced project to
challenge myself.

I use several Try...Catch blocks because i find it makes it easier when
added more detailed error catching at a later date, by adding handlers
for specific errors however i could probably do it with just one block,
it would just require a bit more thinking. I know the error message was
obvious but i had already tried closing the datareader i guess i just
did it in the wrong place.

Thanks anyway

Jan 22 '07 #9
You still need to close your DataReader and connection objects. And,
although I'm happy you got your code working, I would really consider making
the changes I suggested. I'm not surprised my code didn't work (as I was
writing it off the top of my head) to give you an idea of the direction to
go to. I know it's close though. You may want to work through it.
"jimmy" <ja************ **@tiscali.co.u kwrote in message
news:11******** **************@ 11g2000cwr.goog legroups.com...
Thanks, but i have solved the problem now. I tried closing the
datareaders and even used the code the Scott provided but it still gave
me the same error! Instead i just created a more advanced query to get
all the info in one go!
Thanks

James

Jan 22 '07 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2858
by: Grant | last post by:
Hi, I keep getting the following error message: InvalidOperationException: There is already an open DataReader associated with this Connection which must be closed first. I have read up about it and realise that you can only have one DataReader open on a Connection at a time, but don't know how to rewrite my code to work properly.
20
7205
by: fniles | last post by:
I am using VB.NET 2003, SQL 2000, and SqlDataReader. As I read data from tblA, I want to populate tblB. I use SQLDataReader for both tables. I do not use thread. When I ExecuteReader on tblB, I get the error "There is already an open DataReader associated with this Connection which must be closed first." How can I fix this error ? For each DataReader, do I want to open and close the connection (in this case adoCon) to avoid this error ?...
13
3409
by: Bart | last post by:
Hi, i get the error: "There is already an open DataReader associated with this Command which must be closed first" Thanks Bart ----------------------------------------- Imports System.Data.sqlclient
3
13191
by: BLUE | last post by:
I've a TransactionScope in which I select some data and I want to do some queries for each record retrieved with my select. I'm using a DataReader and for each record I do factory.CreateCommand() and then I execute the command, but I get the following exception message: " There is already an open DataReader associated with this Command which must be closed first. " Searching on google I've found I've to create another connection, but...
11
3158
by: =?Utf-8?B?QXNhZg==?= | last post by:
Hello, I have two Table Adapters that I am storing in a Cache using .NET 2.0 Web Service and the Database is SQL Server on Windows 2003 IIS6. Each of the two table adapters has its own Connection string. The reason that table adapters are in cache is because I would like to maintain the connection string that will not be closed for any Insert or Update as there are thousands of requests per minutes to the WS.
0
9132
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9004
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8864
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8838
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5842
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4351
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4592
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3024
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
1986
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.