I have a dataview and want to update using a stored procdure. My Update procedure is as follows. When I have a watch on my variables (int & amt) it is reading empty string even though I pass values. Yes cell(1) is my ID coumn and cell(8) is my amt coulmn
Protected
Sub GrdResult_RowUpdating(ByVal
sender As
[code].....
I have written a web page which connects to a database and then display 3 values from a management reporting system using the database.
I am accessing a database using the following code:
<asp:SqlDataSource ID="SqlToVersion" runat="server"
ConnectionString="<%$ ConnectionStrings:WebImportOnServer %>"
SelectCommand="SELECT [VerNo], [PeriodName], [PeriodNo] FROM [atblVersion]"
[Code].....
but it is how to replace the question marks with valid code that takes the values from the bound fields that I am stuck with.
I'm building a TCP/IP server that sends small strings and updating my database, every time the client connect i get this Exception:
unable to read data from the transport connection: an existing connection was forcibly closed by the remote host. The client successfully able to connect to the server and everything working fine even though this Exception raise, but if i send 3-8 request in the same second the database do get updates in all of them but the server failing to send "OK" response to the client in about 3-4 of those requests, the line i get the error is this: bytesRead = mClient.GetStream.Read(readBuffer, 0, BYTES_TO_READ)
I am getting following exception:
[Code]....
I am trying to send messages from my application to a yahoo account and I am getting the following error:failure sending mail..Unable to read data from the transport connection: net_io_connectionclosed.Is this because of the LAN and work or something else/ [code]after the line mailobj.send executes it stalls for a while and then the application ends.I checked all the parameters and they seem correct
View 4 RepliesCurrently I have a problem with updating my database with values in my Data Grid View.
On my form I have a "Populate" button and "Submit Details" button.
The "Populate" button fills my Data Grid with numerous lines of data.
On the click event for "Submit Details" I want this data to be inserted into a table in my DataBase by looping through each record.
For Each dgi As DataGridView In DataGridView1.Rows
Dim productCode As String = DirectCast(dgi.FindControl("product"), Label).Text
Dim description As String = DirectCast(dgi.FindControl("description"), Label).Text
Dim quantity As String = DirectCast(dgi.FindControl("order_qty"), Label).Text
[cODE].....
I have two forms and I am running a sql query to provide a set of variables in my first form that I need to pass to my second form. Here is the code that I have:[code]to form 2 which then shows the data retrieved from a sql query in the load event to a datagrid view.
View 19 RepliesI am almost there but for some reason I don't find the answer to my issue. Here it goes. In my application I have a form which displays a data grid view with some info I get through XML from a web server. The data grid view have as first column a Check Box colum. The second column have the information I get into a variable (from cells), one by one, to pass it to the sub with the XML command.
What I want to do is to be able to select all the rows and send the cell info of the second row (only for the selected rows) to my sub which will execute once then send the second cell info and execute the sub and so on until all the loop is complete. Currently my code works only if I delete one row at a time (sending the XML code will delete the info in the web server and update the datagridview which in return will remove the item).
[Code]...
I am using vb.net with phpMyAdmin MySql database. While running the piece of code below, the program hangs in the for loop before the variables are assigned values from the data table(dt)...
'Check for appraisal period-----------------------------------------------------------------------
Dim sqlCheckDate As String = "SELECT * FROM tblappraisalsetting where appSetID=(select max(appSetID) from tblappraisalsetting);"
[CODE]................
I am building a chat client/server. And I can connect and chat just fine, but when a user disconnects, the server does not recognize this and acts weird, often spamming the last message that was sent by the user..Also, it's like the client does not disconnect from the server even when I close the client app. Once I exit the program, VB acts like it is still debugging. Once the server is shut down however, I get this error:
IOException was unhandled:Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
serverStream.Read(inStream, 0, buffSize)I don't know how to make my client and server accept the fact that a client has disconnected...
I have to do an application using VB.Net .The application must be able to capture values from ms word data table and map them to ms excel sheet. For your information, i have over 6000 files ms word document, each of them contains 4 data tables using the same format .Then i have this code for read from data table 1 in document 1:
Dim
wb As
Excel.Workbook<br/>
[Code].....
I am developing a program where i will download and save an xml file from a url as abc.xml. I open the abc.xml in a datagridview with a dataset without problem.I am confused how can i read raw per raw the datagridview and assign the data in a database table? i am using vb 2008 + msde2005 express.I show the whole content of the xml file in the datagridview with the following [code]I dont know how to create a loop where i can read the datagridview line by line save data in variables (ex.strings) and save it in a databese table?
View 6 RepliesI have a simple scraper. It works on some websites, but on some there is this Error:
Quote:
IOException was unhandled Unable to read data from the transport connection: The connection was closed
It is occuring at "Dim htmlresults As String = Urlcontents.ReadToEnd()".
'Create the HttpWebRequest object
Dim req As HttpWebRequest = WebRequest.Create(URL)
'Set the timeout to 1 second (or 1,000 milliseconds)
req.Timeout = 10000
[code]....
I have one test class which having few variables declared in the header of the class where it will be accessed for all the subroutines and functions in the class. Here's the sample of my declaration:
Private m_dblMaxPwrLimit As Double
Private m_dblMaxPower As Double
Private m_intHalfPwrIndex As Short
Private m_intMaxPwrIndex As Short
After that, I have one Private Function which need to access some of the variables declare in above. Part of my function is show as below:
Private Function GetPmaxIndex(ByVal Serial As Short) As Boolean
Dim i As Short
Dim Total As Short
[code]....
The problem is when I step into the line of m_dblMaxPower and m_intMaxPwrIndex, I can't see the value of these variables which is suppose I can see it as in VB6. Additionally, when I put Add Watch for these variables, it showed 'unable to evaluate expression'. I guess it is not being used and I think something is wrong with my declaration but I do not how should I declare it corretly because as for VB6, we can declare all the variables in the header of the class and we can use it for all the subroutine/function within the class.
I am building an application that has several forms to it and on my first form, I declare 2 variables that I will need to pass to at least 2 of the other forms. I call them
Public payPeriodStartDate, payPeriodEndDate As Date
on form2, I am needing to pass those variables to a datagridview to present to users. I have the following query that I'm trying to run from that form but I'm given an error that SQL is unable to parse the query:
Code:
SELECT Employeenumber, Exceptiondate, Starttime, Endtime, Duration, Code, Approvedby
FROM Exceptions
where [Exceptions].exceptiondate between '" & payperiodStartDate & "' and '" & payPeriodEndDate"
The datagrid is bound to the form and I'm using SQL 2000.
So there I was working on a project. I was putting the finishing touches on the GUI and clicked on the Image list I had added. VB froze up a moment, and when it came back I was on a code view of the form showing the properties I had just set up in the GUI. Suddenly, I can in no way view the form. I get a View code option, but no View designer. If I close out the project and open another, there it is "View Designer" right where I expect it. But in the project I was working on, it is just plain gone.
Is there something I am missing here? Can I recover my project?
If I run it in the debuger the whole form shows perfectly, I just can't get to it to edit it.
The following code worked with 2.0 Framework, now with NPGSQL 2.0.11 and framework 4.0, this is erroring out despite Pooling=False for the connection. The underlying logic is that add nodes to treeview; for each node added, immediately get subnodes and populate...
vb
Private Sub LoadRequirements(ByVal parnode As TreeNode)
Try
Dim CMd1 As NpgsqlCommand
CMd1 = New NpgsqlCommand
[code]....
i have datagridview populated with stock code, name and description.And i have docked my datagridview to the bottom. so whenever the form is resized, the bottom section will be occupied completely with the datagridview.But i want to display one extra empty column and multiple empty rows to completely fill in the datagridview.The extra empty column width will be adjusted to the right end side of datagridview.And the no of empty rows will be generated based on how many is required to fill up to the bottomSo that i can create datagridview with full column and row even though some columns or rows are empty.
View 1 RepliesI have a DEM file(Digital Elevattion Model File) and I am trying to open the file,where we have Latitude and Longitude values inside the DEM file.And, Now I have opened the file using Filestream and Read the file using BinaryReader.But, I am having a trobule in getting the values of Latitude and Longitude.I am getting Byte values randomly as 1,202,31,271 etc.But, we dont have latitude and longitude values more than 180,and also I am not getting 16 bit UInt values.For example, the values should be like Latitude 20.00416666666667 and Longitude 39.99583333333333.So,read the correct Byte values of the DEM file.The code I have used till now is:
Dim fs As FileStream = New FileStream("C:UsersadminDesktopHeader and DEM fileE020N40.DEM", FileMode.Open, FileAccess.Read)
Dim rd As New BinaryReader(fs)
Dim convertDB As UInt16
For i = 0 To rd.BaseStream.Length
[code]....
I made a very simple web browser with three forms last night, saved the project and came to re-open it this morning only to find that form1 and form2 cannot be edited in anything but code mode now.Very confused. Am using Visual Basic Express 2008 on Windows 7 x64.
View 2 RepliesHi, I am inheriting the telerik radcombo control however I am unable to view any items that i add to the combo list.
View 3 RepliesI am working on a Thesis Software. Right now I am stuck and don't know what to do. My software needs to write xml files (Figured it out) and also READ XML Files then use the values inside the XML files as data by assigning the values to variables and such for the software. In essence we are using XML Files as a type of flat file database.
One of my XML files has the following structure:
<User> <Student ID="1">
<FirstName> </FirstName>
<LastName> </LastName>
<StudentNumber> </StudentNumber>
</Student> </User>
I need to be able to read the xml file and get the values inside FirstName and put it into a variable that I can use through the system(like show the firstname in a label) and the same with LastName and StudentNumber. I would like to note that there will only be one student. This particular XML file is for a Student Profile.
Also I would like to note that the location of the will depend on the programs start up location:
System.AppDomain.CurrentDomain.BaseDirectory() & "StudentProfile.xml"
I want to use the Linkshare helper in the Microsoft.Web.Helpers dll. I added the reference to my project but if attempt to use it in the vbhtml file Visual studio underlines it with a blue squiggly and tells me it is inaccessible blah blah. I even added references to those webmatrix dlls as described here[url]...
View 2 RepliesOK, I am trying to create a "payroll" program and I want to be able to have end users add information to a file and have the program read that file
View 3 RepliesI would I have a program that I use in the computer in my network, but for every user I need to edit the source to this user, thus the user cannot edit his information, just use the program how it was ... So, looking over the internet I found a "program" that may contains my solution... Its a Keylloger, I'm not meaning use this keylogger, no, but it has a a very interest feature: I use the main form to edit the information then after all it create a new program with the new information inside... I use my main program to create every userprofile then my program create a new program with the profile inside...
View 12 RepliesI have a text file that has a list of certain values and I need to read each one back to the correct variable.
View 2 RepliesI have a txt file and what to read it in a variable in vb.netSo for example :
txt file contains:
Name=Tom
Code=23423
[code]......
what if you created a pool of numbers: 1 - 21 and then chose a random selection from the pool? Something like the following:[code]This gets rid of those messy if statements and all of those loops.
View 1 Repliesi had a look at how to set values of variables from nummbers stored in external txt files the variables then needed to be added up so i used trial and error first
((XVAL) + (NEWVAL))
assuming that XVAL was set to 10 and NEWVAL was set to 20 i expected to get the answer of thirty but waqs presented with the new value of 10 20 VB.net pysicaly added the two values together but i wanted the mathematical product of the two which is ((10) + (20)) = 30
I'm passing a value to another form and later on use that value that is assigned to a variable.
Here is the code.
loadingPage.Show()
mode = "notime"
Dim ld As loadingPage
[Code]....
CurrentMode doesn't have a value. I don't know why. CurrentMode is a global variable.
