I'm trying to use the .NextResult() method of a DataReader but I get an error that no data is present.
The 1st query returns a value but the 2nd query is the problem.
Dim strSqlStatement As String = "Select Count(*) As TotalRows " & _
"From Parents " & _
"Where (FatherName = @SearchValue " & _
[Code]......
I imported a website made in visual studio express 2008 to visual studio express 2010. When I run the home page I get the following error:"It is an error to use a section registered asallowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS."
View 2 Repliesjust created a classlibrary project named CreatingDll and i did this
Public Class Class1
Public Function getComboTable() As DataTable
Dim dt As New DataTable
[code]....
I want method which can check if microsoft office word spell checker is present. If version less than 2007 are there I check if ""C:Program FilesCommon FilesMicrosoftSharedProofMSSPELL3.DLL" this dll is present, but for officewe don't find this dllat this location. I'm looking for a method which will check for spell checker of the various version of Offices.
View 5 RepliesIt seems like when there is only one row at the data grid view with a data source pointing to a data table, it's row state for the data table doesn't change when editing. It remained "unchanged" reguardless to how many columns I had entered. However,after editing, when you click on a different row or click on any of the column headers to change their sorting, the row's state from the data table then gets changed to "modified". I'm not sure why the data table's row states gets changed only when you do those things instead of finishing editing itself. Couldn't the data grid view be able to change the data table's row states when you finished editing a cell?
View 5 RepliesPrivate Sub setView()
With lvwLogs
.AllowColumnReorder = True
.FullRowSelect = True
.GridLines = True
[code]...
I am getting the same compile error for the forms with setview. I am thinking it concerns with listview. It highlights the public sub setview().
I am trying to read all selected items from a listbox in Visual Basic.
Dim x As Integer
Dim testValue As String
testValue = "20"
[code]....
is the code I am trying. But When I run the code, I am getting "Compile error : Method or data member not found" I guess I am missing some references to use "ListBox.Items" method right?What is the required references/library.
The application that I am working on is a Service Desk App. I have a form there that uses a DropDownList that contains employees names coming from the Active Directory. Any employee can make a request and save it. Problem arises when an employee leaves the company and consequently his account is deleted from the Active Directory. When some other employee searches the DB to finds a relevant Service Ticket that could be of his use, when tries to open it an error is thrown that indicates that the name does not exist in the DropDownList items.
UPDATE:I am adding some code so that it can be more clear.
<asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1"
DataKeyNames="ITRequestId">
<EditItemTemplate>
[code]....
I'm working on a ASP.NET website project using VB.NET as backend code. I was looking for a way to show the header/footer of a gridview even if no data is present. I'd like to use this solution as it looks pretty clean (although it's written in C#): link I have converted the code using an online tool, resulting in: [URL] This however shows an error on line 77: "Events cannot be declared with a delegate type that has a return type"
View 1 Repliesi gave input text file. now i should copy the contents of the text file.need code.
View 3 RepliesIn a nutshell...I have developed a site in ASP.Net and VB.Net which allows a user to create an order and submit it to a SQL Server backend database.
When the order is placed...an xml file is also produced, showing the items that have been ordered...which is then loaded in to a program to update stock quantities.
The code I have is as follows:
Public Sub butSubmitOrder_Click(sender As Object, e As EventArgs) Handles butSubmitOrder.Click
Dim sqlConn As New SqlConnection
[Code].....
I am not sure why this code doesn't work. I have follow according to the table field data and it I am still unable to get the SQL Datareader to work. I have checked the tables and all datafields, everything is correct. But I still am unable to read data from the database.
Dim connectionString = ConfigurationManager.ConnectionStrings("CleanOneConnectionString").ConnectionString
Dim myConn As New SqlConnection(connectionString)
myConn.Open()
Dim cmd = "Select * from [Member] where Email = @Email"
Dim myCmd As New SqlCommand(cmd, myConn)
[Code] .....
I did this code to iterate through the data present in the DataTable:
Imports System.Data.OleDb
Public Class Form1
Dim con As New OleDbConnection
[Code]....
But this code always gives the last value of a particular row as its output.
I want to specify a particular column and a particular row of the DataTable and fetch the corresponding result:How to do this?
i am using visual studio 2005 check my code and let me know what i am doing wrong
[Code]...
Can you maybe tell me what is wrong with this code?I get an error on the line were the writing is in red.
db.OpenConnection()
strSQL = "SELECT * FROM ChaletBookings WHERE BookingNo = '" & strBookingNo & "'"
dr = db.getData(strSQL)
[code].....
When I run my application the following code prompts an error. Ideally, I want to populate the TxtOracleNo with a value read from another table on my form based on certain conditions i.e., prac_no, prac_eid and pay_method is the same in both tables then populate the Oracle No on TxtOracleNo text box.
The error given is
"Invalid attempt to read when no data is present"
The function is shown below
Private Sub Oracleview()
'Open the database.
'Delete any existing record
Dim cmd As New SqlCommand
Dim conn As SqlConnection = GetDbConnection()
[Code] .....
I checked that data in the database and it is available in both tables. Probably, the problem is where I call the function. Presently, I call it on loadform.
What I'm trying to do is to write a generic rss reader that I plug in any URL into without worry if the feed has all the common properties. For instance in my example below I'm looking for pubDate, however if no pubDate exists in the xml I'd like to return the current Date. I cannot seem to get the syntax right though.
Dim xmldoc As New XDocument
xmldoc = XDocument.Load(url)
Dim feeds = From feed In xmldoc.Descendants("item") Select New With { _
[code].....
Why does my the declaration of my string in the code result in the following error? Is there a workaround?
Code:
<script runat="server">
Protected Sub form1_Load(sender As Object, e As System.EventArgs)
Dim x As String = "</script>"
[code]....
Error: Statement cannot appear within a method body. End of method assumed.
Note: The following page did not fix my issue and instead resulted in the string </script> being output in my page. ( VB.NET hates </script> tag in string literal )
Here is the code for the button click event;
Protected Sub CompetenciesButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles CompetenciesButton.Click
Dim con As String = WebConfigurationManager.ConnectionStrings("foo").ToString()
[code].....
I have a number of controls (Device1, Device2, etc.) that all inherit from BaseDeviceControl. In the DragEnter event handler I am trying to test for the correct type by using the BaseDevvceControl like this....
[Code]....
I was asked by a client to create a tool that would let a user add/modify/delete/read content from a database. The content can be read from TextBoxes.
My question is, what is the best way to manage GUI locks/unlocks for the different states of the program. IE: If I'm in a "insert" mode, some GUI elements should be enabled, and some not. If I'm in the "read-only" mode, a bunch of them should be disabled... etc.
i want to which way is better when concentration is on processing speed. i want to call a method that compute some data that method is on another form in my windows form application then what you prefer is better way 1) to call that method in another form and use returned value or create similar method in form where it is required.i want to make it's processing fast.
View 3 RepliesI have a bit strange problem in my application. I have more binding sources then one in my different forms. All of them work great when editing, deleting the data except one. But this one is a bit different from others. I'm using it only for updating and deleting. You can't add new records using it. And also its dataset doesn't contains any Insert commands in it. That's the difference.Now problem is:
After deleted the rows (using BindingSource.RemoveCurrent), it doesn't mark rows as deleted. I call BindingSource.Count method after deleted rows, it sill counts deleted rows. So it seems it doesn't update the dataset. But it is. Dataset.HasChanges returns true.
In my career I have seen literally dozens of ways that people choose to handle implementing state and country data (as in NY or USA). I've seen enumerations, multi-dimensional arrays, data driven classes from XML docs or databases, and good old-fashioned strings.
So, I'm wondering, what do people consider the "best way" to handle this very common implementation? I know that most of the answers will be based primarily on opinion and preference; but, I'm curious to hear arguments as a recent discussion for an app I'm working on has resulted in a small debate.
I am having with what appears to be a ASP.NET page life cycle issue. I currently have a user control embedded into my page. Now depending on the options chosen from the menu item list, the page can be in one of three states represented by a PageStates Enum within the control. The page on selecting the menu item merely updates the a property exposed from the control
Initial State (nothing congifurable)
Editing (this uses a dropdown extender and makes a gridview within it visible)
Adding (this uses another dropdown extender and makes the same the gridview visible however with different properties)
PROBLEMS
The page will only get itself into the correct 'state' if the menu item is selected twice Controls are visible on the gridview when they shouldn't be The page 'state' seems to lag one state behind
I think the main problem I having with this is that the grid view has check boxes drawn if the page is Adding mode, however you would need to select the Adding menu item option twice to get it into this state and I believe it is because I am setting the page state when the menu item is selected however the grid rows are already created at this point ( I am dynamically creating the check boxes in the grid view within the RowCreated event
I have two listboxes: lstStates and lstOuput
I have cut and paste the fifty states on one box in the order in which they entered the union. I have two buttons, one to alphabetize the states and one to reverse alphabetize the list. Here is the code for alphabetizing the list:
Private Sub btnAlpha_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAlpha.Click
lstOutput.Sorted = True
[Code].....
How can I put the list in reverse abc order without using an array? I've tried a variation of the above code, but it did not work?
I have a CheckedListBox populated with specific records from an Sql table . I want to update each record in the table, only if the checkbox checkedState = True, so far I can update all or none. This unworkable code will hopefully give an idea of what I need to do.
[Code]....
I need to display info about each of the 50 states when selected in my program. I have one combobox with all the states as items inside, one button that you click to get the info and one listview for displaying the info. Here is my code so far:
Imports System.Text.RegularExpressions
Public Class Form1
Private Function getinfo(ByVal state As String)
[Code]....
I did a MDI Winforms application and noticed behaviour that I have a question for. If one of the forms is opened with a Maximized Window State and another form is opened with a Normal Window State, the form Window State that used to be Maximized is changed to Normal. Can several windows be open in a MDI form with different window states at the same?
View 1 RepliesI'm working on a project where I need to trigger an event when a switch is closed. It is my understanding that it is possible to use the control lines on a serial port and read whether the switch is closed or not. I've found a schematic of how to connect the switches to the pins, but I have not been able to find any example code on how you can read the state of the switches.
View 2 Replies