I am using Sql Server 2005 and Vb Studios 2010 on a .net Framework of 4.0. I am trying to get the exact number of rows from a database and populate a datatable then have a label show the number of rows.
Dim comm2 = db.selectcommand(db.conn, "*", "Tablename", " columnname = '" & Session(sessionvariable) & "' AND columnname = 'Unread '")
Dim sqlda2 As New SqlDataAdapter(comm2)
[Code]....
I am using VB2008. I use the following code snippet within my code:
[Code]...
This is running on an XP SP3 system (no Vista). The browser being used is IE7. Everything is fully patched. Normally, the code works just fine. The users using this program *always* have lots of open IE windows. This normally returns the correct number of IE sessions that are open. (I then cycle through the windows to find the IE session with a particular URL.)
[Code]...
So I'm writing a query as follows:
Dim assSummary = From a In db.Assignments
Join ur In db.UserRegions
On a.Origin.ID Equals ur.Region.ID
[code]....
In the controller I can return the data easily as follows:
For Each c In assSummary
MsgBox(c.Description & " " & c.AssCount)
Next
If I pass the object through to the view using Viewdata("assSummary") = assSummary, how do I display the data? Every method I've tried results in messages about 'VB$AnonymousType_7(Of Integer,String) and I don't know how to retrieve the data from the anonymous type.
I am attempting to read the results from a SQL query into a List(Of) and I can see the List.count while adding items to the List increments, however in another part of my code when I am attempting to read the List the List.Count returns 0. My List is as follows:
[Code]...
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.
View 1 RepliesI 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.
[Code]...
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.
View 3 Repliesdesigning 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"
View 14 RepliesThis is what I have, but It doesn't work with strings for some reason (only text files):
[Code]...
I am looking for a way to count words in VB My full code is as follows Public Class lblTranslator
[Code]...
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?
this its a very silly problem i have with CheckBoxList control, i dont know if its just me or what but the whole idea of the control its just great but the implementation its very confusing.
im trying to eval something like this
if CheckBoxList.Items.Item(CheckBoxList.Items.Count-1).Checked=true then.....
or something like
CheckBoxList.CheckedItems.Item(CheckBoxList.Items.Count-1) = Checked then...
the problem its that i dont know how does the checkboxlist works but it just sucks that they had to make it so confuising....
i've handled lots and lots of collection controls and they all work in a similar and simple
I have some code which gets child items for a menu via the GetChildren function which takes a list of menuData: Dim builtMenu As New List(Of MenuData)(_rawData.FindAll(Function(item) item.GroupingID = 0))
For Each menuData As MenuData In builtMenu
If menuData.Children IsNot Nothing Then
menuData.Children.AddRange(GetChildren(menuData))
End If
Next
If I check if menudata.children isnot nothing, it always is nothing because the GetChildren function is yet to run (providing the child items, which do exist). If I remove this check and just have this code:
Dim builtMenu As New List(Of MenuData)(_rawData.FindAll(Function(item) item.GroupingID = 0))
For Each menuData As MenuData In builtMenu
menuData.Children.AddRange(GetChildren(menuData))
Next
Then I am presented with a Object reference not set to an instance of an object error on menuData.Children.AddRange(GetChildren(menuData))
I have a fair bit of experience with VB.NET and C# (In this case I chose VB.NET, blame my laziness), but I do most of my professional work using PHP. I have no experience what so ever in using any database with VB.NET let alone MySQL.Just FYI, at the moment I am only trying to Query the database to gather the information required to activate. The Activation wizard and algorithm building (which is finished anyway), and everything else will come soon. I chose the MySQL database because I have experience with it, and it seems the best option for remote usage.The whole idea already works in PHP, I'm just have major issues moving it accross into VB.NET (Using the MySQL Connector.NET);I understand the basics, and all I need to know how to do is Count Rows and gain access to the other information in a row based on provoided information (in PHP, through mysql_ result)
So, here goes nothing, this is the Query code I am using in PHP to complete the job I want to do in VB.NET. [code] As you can see, I basically need to get the PHP code into VB.NET to fit into the 'btnQueryDB.Click' Command in VB.NET. By Equivalent, the Product ID in VB.NET will come from 'txtPID' and similar, Serial Number will come from txtSNUM. Once counted to be 1, the Activation Code and Status will be fed into 2 other text boxes in the form. (acCode, and acStatus).
i have a datatable with column "prices" and i displeay the column values in a listbox and i sum all the values in this column and i display the sum in a label.text but when i delete one row in de listbox the sum returns a zero value.[code]
View 2 RepliesCould someone point me why the IndexOf returns always zero in the following text?
Dim Str as string = "<p><img class=floatLeft width="330"src="http://www.com"></p><p>"
Dim Idx as integer = Str.IndexOf("<p>")
Is there any other way, of getting the index?
[Code]...
I always get {} as answer. What's wrong?
I'm trying to create a function that would return a PDF document. Something like this:
Function GetPDF(ByVal DirectoryPath as String) as PDF
Return DirectoryPath
End Function
I've got my text files read into an array.Which was step 1 .My code so far is:
Note: textSKU is just a text box. No event handler associated.
Private Sub BtnSeacrch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnSeacrch.Click
Dim objCA As New System.IO.StreamReader(ofdCA.FileName)
System.IO.StreamReader(ofdWarehouse.FileName)[code]....
The message box is mostly just to test to see if it's finding the line. And the problem is it's returning -136.Which I'm pretty sure can't be a value in the array ( actually very sure, as I tested it just to be sure, and it says it's out of bounds).I know it's in the array, as when I change returnvalueCA to a...7 for example, it outputs the correct line from the .csv file.
Edit: Index was outside the bounds of the array. is what the debugger says, as it's trying to output the value of SKUSheet(-136)
I have to cut down the amount of code in my blackjack program so im trying to use a function however the function always returns a value of 0 I have tried putting in "return cardvalue" but it still comes out as 0 I dont know where I went wrong or if the code im using can even be used as a function.
Function Values(ByVal deal() As Integer, ByVal counter As Integer, ByVal cardvalue As Integer) As Integer
If deal(counter) = 1 Or deal(counter) = 2 Or deal(counter) = 3 Or deal(counter) = 4 Then
[Code]....
as a workaround for the Locale bug in Office Interop I wanted to use VSTO but if I call
app.ActiveWorkbook.GetVstoObject()
then it returns nothing. I'm working from a .NET 2.0 Visual Basic Application project. This is not an add in or a special VSTO project. I have added the required Imports and References.
Dim app As New Excel.Application
app.Caption = "Rapport"
app.Visible = True
app.Workbooks.Add()
Dim tmp As Object = app.ActiveWorkbook.VBProject
Dim book As Workbook = app.ActiveWorkbook.GetVstoObject() 'Returns Nothing
This is a school project and it needs to be finished by the end of next week
have a look at this code Dim colors() As KnownColor = CType(System.Enum.GetValues(GetType(KnownColor)), KnownColor()) Since CType is a function that returns DataType ,But here as in the code it seems that CType() is returning array having values that is assigned to color() array. How this is happening?
View 3 RepliesI've been having a problem with Math.Log in a function I'm trying to write. When working with variables, it always returns 0. Here's the line I'm trying to run:
Quote:
mb = txtMb.Text
k = txtK.Text
t = txtT.Text
[Code].....
Recently (I have no idea when) App.Path in VB6 started to return a URI rather than an absolute path for the location. Instead of returning something like "C:program filesmyapplication it has begun returning "\sacoc$program filesmyapplication"Has anyone else noticed this?
It breaks a whole crap-load of my code.It seems like MS, in their infinite wisdom, have decided there is some security breach with the way it was returned before - just guessing.
I want to get the row count of my datagridview. I currently use this code below. But the RowCount value is &H7. I have 7 rows displayed in the datagridview. The code below seems to work, but I don't understand what &H7 means. Does it have something to do with Hexadecimals?
' tell user if no results are available to update
If dgv.RowCount < 1 Then
MsgBox("There are no results available to set Ready.", MsgBoxStyle.Information)
Return "Failed"
[code]....
I set the culture to Hungarian language, and Chr() seems to be broken.
System.Threading.Thread.CurrentThread.CurrentCulture = "hu-US"
System.Threading.Thread.CurrentThread.CurrentUICulture = "hu-US"
Chr(254)
This returns "ţ" when it should be "þ" However, Asc("ţ") returns 116. This: Asc(Chr(254)) returns 116.Why would Asc() and Chr() be different?I checked and the 'wide' functions do work correctly: ascw(chrw(254)) = 254
On the publish tab of My Project the correct current version is there, 1.1.0.0 and in Programs and Features under Control Panel it shows 1.1.0.0 but when I reference Application.ProductVersion I get 1.0.0.0.
View 2 RepliesIm trying to make a web service in VB.net is their a way that i can return the results that i get from LINQ. ie "return objreturnLINQResults" I have tryed to set my Public Function GetAlarmsByGUIS(ByVal DeptGUID As String, ByVal IdNumber As String) As Linq.DataContext . i just keep getting errors.
Public Function GetAlarmsByGUIS(ByVal DeptGUID As String, ByVal IdNumber As String) As Linq.DataContext
Dim lqAlarms As New linqAlarmDumpDataContext
[Code].....
I have a WPF application that uses a third-party library to perform a specific task; this library, in one of its methods, executes the statement Assembly.GetEntryAssembly(). If I run the WPF application on debug (by running a .Net exe for testing) the library works properly and Assembly.GetEntryAssembly() returns a reference to the assembly of the executable, but in production I have a different situation that causes me some problems.
[Code]....
I get #Error in reportviewer when I use the following expression:
=IIf(Fields!PaymentNumber.Value>0,
IPmt(Fields!Annual_Interest_Rate.Value/1200,
Fields!Payment.Value,
Fields!No_of_Monthly_Payments.Value,
Fields!Total_Amount_Financed.Value),0)
When I remove the IPmt() function and use some static value instead, it works. Is there a way to find out the exact error ?