I want to count the amount of records in my table where the distance column is greater or equal to the passed integer.I have:
Dim TenMilesCount = GetDistanceCount("10")
Public Function GetDistanceCount(ByVal Miles As Integer) As Integer
statcon = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:My
[code]....
Yet running the code gives me "An error occurred creating the form. See Exception.InnerException for details. The error is: No value given for one or more required parameters."
I was trying to make a client/server application. Server listens at a specific port for an incoming connection and if there is a connection it accepts is and asks for a password. If password is correct then they simply wait for some "string" from eachother. everything is fine if I send and get data in string format. there is no problem at all!
(By the way I am using simple usual TcpListener/TcpClient, Networkstream, Binaryreader/writer, etc...
I decided to add file transfer option. well for that i needed to transfer data in byte arrays. Because of this I decided to make all data traffic in byte arrays. So I converted strings to arrays and arrays to string in between. In case of file transfer, file chunks are being sent with a cap like "[cap]"<data chunk>. This was my idea. On the other side there is a sub looking what is coming and what does it mean by looking its cap. In case of file transport specific cap, cap will be removed and data is being added to previous ones...
My problem was, that my binaryreader: reader reads incoming data without any parameter:
message=reader.readstring
But in case of readbytes i have to put a parameter called count. Well I don't know how much bytes are going to come until I get them. In case of TcpClient I can get it with: Client.GetStream.length.
But how can I get the same result with TcpListener? (At the server)
Can I transfer chunks of file bytes in string format and convert them back to bytearrays without any loss or problem?
I am using a mysql database and I am trying to get the number of results. I should only have 1 result because this is for a username/password login. I tried this
If loginReader.HasRows Then 'do whatever here Else 'do something else here End If
The loginReader gets the results and does the ExecuteReader. The problem with this is that if I use a good username and password it works but if I put in a bad username and password it doesnt do either one of them. Any ideas on how to just count the number of results?
How can i declare a simple variable in a form that is the count of the amount of times a field appears in a database.Basically i want to count the amount of times the word "Saloon" appears in a column in my database (access 2007) and then assign that value to a variable.
The object is to have a user input a sentence and then count the number of s's and z's total are in the sentence. The counting must be done in a function procedure. Would this make use of the Index keyword?
I write the code below. I want to make short using linq count.
Dim query0 = From obj In dtAginglist _ Where (obj.Field(Of String)("CurrentStatus") = "Open" Or obj.Field(Of String)("CurrentStatus") = "Acknowledge") _
[Code]....
I try to use code below but it dosen't work with if source is datatable.
Dim orderCounts = From c In customers New With { _ c.CustomerID, Key .OrderCount = c.Orders.Count() }
I have the following search code which works fine. However, I have an additional task to do, which is create a count function for the Record found or Record not found. Presently what it does is it searches and if a record is found it displays at the tooltip "Record Found" if not it says "Record Not found". However, sometimes you have 2 or more records. Therefore, the tooltip should say the exact amount of records found.. For example, 3 Records Found or even 5 Records Found. Also if only one record is found it says "Record Found" but if more it should display " 2 Records Found".
Private Sub btnPerformSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPerformSearch.Click ' Declare local variables... Dim intPosition As Integer ' Determine the appropriate item selected and set the ' Sort property of the DataView object... [Code] .....
I am using VS2008 front end and MySql 5 database When I attempt to run this sproc I get the following error message:"Procedure or function 'Test_sp' cannot be found in database 'EVOLUTION'." Yet the Stored procedure is definitely there.I have tried changing the name of both the sproc and in the sub below but it makes no difference.This is the first time that I am trying to use a sproc and I can't get it right.All other communication to and from the database is fine.
Dim Cmd As New MySqlCommand("Test_sp", Datacon) Cmd.CommandType = CommandType.StoredProcedure Cmd.Parameters.Add("@Acl_Key", MySqlDbType.String).Value = "ABC" Cmd.Parameters.Add("@Acl_Desc", MySqlDbType.String).Value = "My Description"
I have the code below which does work, but I need to add further functionality to it. The functionality I want to add to it is the text I have commented in the code below.
Dim objSQLConnection As SqlConnection Dim objSQLCommand As SqlCommand Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)
[code]....
Before the if statement, I want to find out if the database already has records with the username in the strUser variable.
Is the following code using good practices? All I want to do is get a count of the number of rows which any given user has:
objSQLCommand = New SqlCommand("select count(id) as record_count from table1 where user = @strUser", objSQLConnection) objSQLCommand.Parameters.Add("@strUser", SqlDbType.VarChar, 3).Value = strUser objSQLCommand.Connection.Open() objSQLDataReader = objSQLCommand.ExecuteReader() objSQLDataReader.Read()
In one of my school assignments I am trying to count fields (that are strings) in a database and then publish them to the screen, however I can't seem to figure out how to count them.I've been trying to do something like this but I am having trouble with the bold part. I think the datatypes are the issue but if not this then what? What is a better way to try and do this?
Private Sub btnCalc_Click(sender As System.Object, e As System.EventArgs) Handles btnCalc.Click Dim numRep As Integer Dim numDem As Integer
There are 3 textboxes->textbox1,textbox2,textbox3 and 1 button.In textbox1 bname will be stored and in textbox2 aname is stored.Bname and aname are columns of databasetable.This are not unique.There are same bnames and anames records.What I am trying to do is:when the user clicks on button then the code should match textbox1 and textbox2 with the databasetable and get the count of rows that match this data. And print the count in the textbox3.If there is no similar bname and aname in the table then the count should show 0.I tried doing this but am pretty sure that its not right as its not working.
I have a DLL , written in VB.Net. This DLL has a below Function: Public Shared Function CreateApplication(ByVal aobj As Object) As Object When i Try to call this function by exe application with below routin i get "Parameters count mismach" Error. Public Function loadDllAndRunMethod(ByVal dllFilePath As String, ByVal className As String, ByVal methodName As String) As Object
I'm using VB.NET, and I'm trying to write a program for the company I work for, that interacts with a database designed for logging web site email submissions (After a user fills out a form for a item request or comment sheet, the email the form sends gets logged so we can more easily see which site gets spammed more, and we keep a record of the actual spam). My program mainly just makes the data easier to read. However, I want to add a feature so that a user can click a button, then an automatic query will take place so that all the preserved URLs in the database are tested, then a form will appear that states something along the lines of: These Sites Sent This Number of Emails
I would like to ask some questions related some functions i want to make in my program:
1. I am using this function in order to get a the item code from the database Long.Parse(myReader(0)).ToString("2200000000000") the result i get is: 2200000059091. The form that i want the resultset is 22 (fix value) + item code (6 characters right justified) + 00000 (fix value) 2205909100000 how should i change my code to obtain this result?
2. The programs every time it runs creates a text file which i also attached it plu1.txt, when i try to open it with notepad i see all the lines justified, on the other hand when i open the text file with Wordpad or ConTEXT the lines are not fixed, others are longer others are shorter? What should i change in my code in order to have every line fixed lenght... The code i am using is the following
Dim myReader As SqlDataReader = myCMD.ExecuteReader()
Dim fNextResult As Boolean = True
Using myWriter As IO.StreamWriter = New IO.StreamWriter("c:everest
[CODE]...
3. third and last question is that my program every time it ends show up a pop up menu which says "Text is created." Instead of this i would like to create a file lets say log.txt and every time the program runs, it will overwrite on the log.txt file a line like this: system date + Text is created + with X lines (where X are the lines of the text plu1.txt) ex. 26-10-2009 14:56 Text file created with 15 lines
I have added a column to a Datatable called CallsPerDay which is there to tell me how many telephone calls have been made on a particular day or days.Is there a datacolumn.expression which will allow me to Filter on the day, count the rows and then populate this added column with the result.
I have some reports that I use with the MS ReportViewer and I need to get a count of the physical pages (as opposed to logical page count) to use with a print dialog. I've implemented a workaround so the ReportViewer control displays the correct number of physical pages, but is there a way to get that value from the ReportViewer control? The only publicly accessible property gives the logical page count.
Basically, Is it possible to get a grids row count using jquery.if my grid has 20 rows in it not including the header or footer, i want to now the count of actual rows, this will tell my users how many tasks they have in their list.
designing a Windows based computer program that will allow a user to enter some number (n) and a choice of a count up or count down for that many numbers. So for example, the user enters 5 as their number and selects the count down option, the message box displayed would contain the message: "Here are your numbers: 5,4,3,2,1,0"
Declare some class level variables that will keep track of the sums for each column. For example:
[Code]....
During the RowDataBound event, retrieve the data from each column and add it to the appropriate sum. I'm not sure if you are developing an ASP.NET application or a Win-forms desktop application so I cannot help you any further at this point. What have you tried so far to solve the problem?
What will happen when 3 function calls same function at a time? I have 3 Function, f1,f2,f3.. Those function after completing their task will call finish() function. What will happen if Finish is Called morethan once..
