Ranx

Bowling for Columbine

The Year of the Cat - Al [B]Stewart[/B]

Are you trying to add the values from "Selected" Rows? If so, try [CODE] For each r as DataGridViewRow in DataGRidView1.SelectedRows CurrentCellValue = r.Cells(1).Value If CurrentCellValue = "" Then CurrentCellValue = 0 CumulativeSummer += Convert.ToInt32(CurrentCellValue) Next[/CODE]

CAn you change the datasource in the SelectedIndexChanged or SelectedIndexChanged events of the combo box?

[CODE] & "'WHERE EmployeeID=" & txtEmpID.Text[/CODE] try [CODE] & "'WHERE EmployeeID='" & txtEmpID.Text & "'"[/CODE] if EmployeeID is a text field. also try putting a spce between "'" and "where"

Can you not just add a datarelation to your dataset between your customer table and your orders table and navigate it that way?

You can use the DriveListBox and the DirListBox *oops, thinking VB6

Use the .[URL="http://msdn.microsoft.com/en-us/library/system.data.datatable.select.aspx"]Select method[/URL] and set the resulting array of Datarows to be the datasource of your grid

Have you got "Show All Files" clicked on the toolbar?

It appears you are not setting the parameter?

Not sure exactly, but i sort of see the code should read something like below. I haven't tested it but it looks like you are modding by i instead of 2, so try that I haven't tested it [CODE] ' from your line 26 If number1 < number2 Then For …

Can you pass it Nothing and test for it? e.g. [CODE]Public Class Form1 Private myCoolClass As New testClass Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click, Button2.Click, Button3.Click 'etc myCoolClass.retrieveRec(Sender) End Sub End Class Public Class testClass Public Sub retrieveRec(ByVal Sender As System.Object) If Not Sender …

[URL="http://vb.net-informations.com/dataset/vb.net-ado.net-dataset-tutorial.htm"]http://vb.net-informations.com/dataset/vb.net-ado.net-dataset-tutorial.htm[/URL] This link may be helpful.

Hoping someone out there can help. I have a fairly simple piece of code for viewing files [code] System.Diagnostics.Process.Start(tFileInfo.FullName) [/Code] Basically passes the path of a file to the process and let Windows deal with how to open it. Have also tried [code] Dim myProcess As New System.Diagnostics.Process With myProcess …

[QUOTE=lipton150786;1302792]I want to read content of pdf file when window openfiledialog appear.I use VB 2005 at winform. anybody know please help me!!!( show code[/QUOTE] Not exactly sure what you're after, but if you have pdf files associated with an app on the target machine, try [code]System.Diagnostics.Process.Start(filename)[/code]

lend

Crop Core Pert Ecstasy

I use a dataview for conditional combos. Without knowing your table structure, I can only give you an overview. I hope it helps [CODE] Dim dv as Dataview = New Dataview(DT) ' DT is the datatable returned by your sp with all the data in it dv.Sort = "SortField" dv.RowFilter …

you can deconstruct the old string starting from the back and create a new string. just roughly, untested. e.g. [code] for x = 0 to oldstring .length -1 Newstring &= oldstring.substring(x,1) next [/code] or something along those lines

Hi, i'm hoping someone can help with a slightly odd problem i have. I have a piece of code that can create a folder on a sharepoint site from one machine, but not another. [CODE] If Not System.IO.Directory.Exists(strTargetLocation) Then System.IO.Directory.CreateDirectory(strTargetLocation) End If[/CODE] Originally it was because WebDAV was not running …

Actually, if you are going to do it that way, instead of "-1" it should be "+2" to get the number after the "+" sign. The "start" argument of the Mid function is 1-based while the indexof property of a string is 0-based. [code] stemp.Substring(stemp.IndexOf("+") + 1, stemp.Length - stemp.IndexOf("+") …

Something like [Code] Private Sub Broker1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Broker1.TextChanged Me.AcctLabel1.Visible = (Broker1.text.length>0) End Sub [/Code] that way they will hide when you delete the text

[QUOTE=gianrocks;1094076]anyone?[/QUOTE] have you tried storing the path as UNC? i.e. instead of C:\MYFOLDER try \\machinename\drive\MYFOLDER

Does the table have a primary key?

Have you tried using the "Split" method? you can read each line into a string variable and then split it by using the space as the delimiter.

You'll need to select your results INTO the output parameters. Your current sp will return a dataSET, not individual results. [code=SQL] ALTER PROCEDURE dbo.RBTestSP1 (@Number1 Int OUTPUT, @Number2 Int OUTPUT, @Date DateTime OUTPUT) AS SELECT top 1 Number1 into @number1, Number2 into @number2, Date into @Date from RBTest order by …

I think the only way you can do it is via a select case statement and hard code your form names in there, i.e. [code=VB.Net] Select Case strName Case "frm1" dim frm as new frm1 Case "frm1" dim frm as new frm2 end select frm.showdialog() [/code] This is not as …

It's not good practice, but if must, you can direct the execution flow by calling "Start_Click" from with "Retry_Click" i.e. replace [code] Sub Start_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Start.Click Start: Dim ...... End Sub Public Sub Retry_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Retry.Click …

Hi there, I had a similar requirement, and got the answer i needed from this place here. [url]http://www.startvbdotnet.com/controls/rtb.aspx[/url] Hope it's cool to link to this site

VB doesn't use SQL, it is a component of the underlying datasource. Google "Transact-SQL" or "T-SQL" and you database engine name and you should get more replies tha you can handle

I'm not sure what you are trying to do, but can you do a comparison in the "Changed" event of the textboxes?

Do you need to edit the stored values? Or could you use a calculated field in your datatable? i.e. [code=VB.Net] mtblDocs.Columns.Add("Overflow", GetType(Double)) ' Capacity is trailer capacity ' CubicM is the number of Cubic metres required mtblDocs.Columns("Overflow").Expression = "CubicM-Capacity" [/code]