20,285 Topics
 | |
| | hi guys, i have the following code: "select sum(( receiptDetails.retailprice - receiptDetails.purchaseprice)* receiptDetails.itemcount ) + ((customerReceiptDetails.retailPrice -customerReceiptDetails.purchasePrice)* customerReceiptDetails.itemCount) As Total from receiptDetails,customerReceiptDetails " am trying to get the gross profit from the two tables: receiptDetails and customerReceiptDetails. the query works well if both tables have values. i tried to use …  |
| | Hi everyone. I want to make a update option for my app. I have a idea how to do this but doesnt sound very logic. This is how it is: The files are located at a drive. When download the update it download on the some folder and overwrite the … |
| | hi guys I was wondering whether it is possible to load items to the data grid view without having to do it in the form load event. if so, please assist in discussing a few techniques. thanks |
| | ** # i try to insert 10 record under the field year and actual data but only the first text from text1 is entering inside # ** provider = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source =" dataFile = "db7exmpl.accdb" connString = provider & dataFile myConnection.ConnectionString = connString myConnection.Open() Dim str As String 'str = …  |
| | Hi, I have a string like 32/355ab//3456 from which I need to extract the three separate numbers 32, 355 and 3456. The string pattern may vary. I can use Split by (say) / to separate strings. How can I extract groups of numbers from a 'mixed' string like above. The … |
 | Hi How to plot chart from data in the middle of Datagridview ? I tried this code below , [from this table](http://i.imgur.com/1GzQITe.png) , it plot [nicely like this](http://i.imgur.com/NH2aTio.png) , but but when [this data increase](http://i.imgur.com/CSMfEGJ.png) , I [do not want this kind of chart](http://i.imgur.com/wUx89fP.png) ..... Chart1.Series(0).Points.Clear() Chart1.Series(0).BorderWidth = 5 Chart1.Series(0).Points.AddXY(DataGridView1.Rows(0).Cells(1).Value, … |
 | Hi, Im trying to use a multi column combobox from this thread [Here](http://www.codeproject.com/Articles/8619/Flat-MultiColumn-Combobox-with-Autocomplete) Just wondering if there's a way to show Column header from its datasource (sql) Can't find a property to do this Thanks |
| | I searched through nearly every article in the forum as well as other groups but I'm stumped on a solution. I have a ComboBox filled with values from a DB. I would like autocomplete to show results from the entire string not just the beginning of the string. Autocomplete queries … |
| | I am trying to calculate a cable bill for a residential and business customer can someone point me in the right direction for my logic?For residential customers it is 4.50 processing fee,30 basic service fee and 5 per channel. For business customers processing fee = 16.50 basicservice fee is 80 …  |
| | i want to use y axes as datetime and x axes as interger. i used zedgraph control. i used the following code Imports ZedGraph Public Class Form6 Dim frames As Integer Dim time1 As TimeSpan() Public Sub New(ByVal no_frame As Integer, ByVal time() As TimeSpan) InitializeComponent() frames = no_frame time1 …  |
| | Hi, There are 50+ textboxes and comboboxes on my form and I created a label to store the tag of each textbox or combobox as it is focused. This is portion of what I had currently. Private Sub cmbCGWPBCl1t_GotFocus() Forms!Main!lblMessage.Caption = Me!cmbCGWPBCl1t.Tag End Sub Private Sub txtSUHal_GotFocus() Forms!Main!lblMessage.Caption = Me!txtSUHal.Tag … |
| | Dim x As Integer Dim y(100) As TimeSpan For x = 1 To frames y(x) = time1(x) list.Add(x, y(x)) Next x what is the solution for this ? is there any other graph or bar chart control in vb.net ? if yes then how to use bar chart in vb.net …  |
| | Hi everyone I am fairly new to programming VB. Net I have a program I have written to calculate the totals of snowfall for an each month and make it a yearly total for snow fall. Here is the code I currently have. Public Class Form1 Private Sub Button1_Click(sender As … |
| | Hi I have code in VBA i want to convert it to VB.NET the code Dim lastrow As Integer Dim curRow As Integer Dim newrow As Integer lastrow = exWS2.Cells.Rows.End(XlDirection.xlDown).Row exWS2.Cells(8, 6).Value = "Max" exWS2.Cells(8, 7).Value = "=Max(B2:B" & lastrow & ")" newrow = 8 For curRow = 2 To … |
| | Hi, All Like to know how to create a TCP/IP listener for my cloud based mysql server. Am very much new to this process. Actually i have a GPS Tracker with GPRS service. Its sending coordinates values to the predefined IP address and Port. How to get this data and …  |
 | =======Download The Full Solution Below======== This will be my last VB.Net soure as I've made the move to C#. For a recent job application I was given the technical test to create a horse race simulator which would calculate the odds of a runner winning a race of up to … |
| | I have this gigantic query that returns certain data from my MSSQL Database (working perfectly- Courtesy of djjeavons). I want to sort and arrange this data in order. I want if the user selects a range of dates from the form (ex. November 1, 2014 - November 9, 2014), the … |
| | I managed to disable %, $, #, | in my application using the script below: 101 ACCELERATORS LANGUAGE LANG_KOREAN, 0x1 { VK_F4, 40002, NOINVERT, ALT, VIRTKEY VK_RETURN, 40001, NOINVERT, ALT, VIRTKEY "%", 104 "#", 104 "$", 104 "|", 104 VK_NUMPAD0, 104, NOINVERT, ALT, VIRTKEY VK_NUMPAD1, 104, NOINVERT, ALT, VIRTKEY VK_NUMPAD2, … |
| | Hello... Im having a problem with "like operator" on SQL database Im using this code to search on database Dim DV As New DataView(dbDataSet) DV.RowFilter = String.Format("ID Like '%{0}%'", TextBox1.Text) DataGridView1.DataSource = DV and at textbox1 I type 2 in data grid view show all people who have number 2 … |
| | Hi guys, I have a form called frmSales, with two textboxes and a list box. what I want to do is to fill the listview with product description from txtDescription and product from txtPrice when I click the add to cart button. the listview should also be able to add … |
| | Hi , how to add numbers in specific count of rows in Datagridview like in this[Click Here](http://i.imgur.com/IZJ39Wq.png) picture. I already run this code to sum all collumn in my Datagridview. But I need to sum the 1+2+4 in collumn TEST1 without erasing the other data. Private Sub Button1_Click(sender As Object, …  |
| | Hello, first of all I am new to vb.net so sorry if my question is stupid... :( I have text files that are something like this: "#...... "#...... 1.2 2.5 3.4 5.6 4.8 8.9 . . . Now I would like to add to the first column of the datagridview … |
| | Hi, after creating a software with SQL database (my other pc is the data server) this shown up " String or binary data would be truncated. The statement has been terminated " what to do? sometimes it imports the data sometimes it does not... |
 | Hi i want to add items from multiple listviews to other Listview (Main Listview)when i click the same button each time select diffrent item from diffrent listview how can i do this with VB.net best regards |
| | Good day guys I need help for adding 2 column in datagridview my project is : the import and the varibles are : Imports Excel = Microsoft.Office.Interop.Excel Imports Microsoft.Office.Interop.Excel Imports Microsoft.Office.Interop Imports System.Runtime.InteropServices Public Class Form2 Friend xlApp As New Excel.Application Friend xlWorkBook As Excel.Workbook Friend xlWorkSheet As Excel.Worksheet Friend … |
| | Hi, how to plot a chart from imported excel in Datagridview? I tried the tutorial from [HERE](https://www.daniweb.com/software-development/csharp/code/492766/display-excel-data-in-a-datagridview), but I do not know how to plot the chart. Previously, I used MS.Access for my Datagridview, then I manage to choose the Datasource. But, for this case, I imported an excel and … |
| | Hello !! I use vb.net with excel I have a buttom "get the name of the column from worksheet" with a combobox thi is the code of the button: Private Sub Button7_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button7.Click Dim Excols As New Dictionary(Of Integer, String) Form2.xlWorkSheet = … |
| | hello guys I have a data grid view with the following rows customerID, customerName, credit, debt. how do I implement filtering based on the customerID. I want to basically perform a search and display the results. thanks. |
 | Hi Group, I attempting to save a file to a specific folder that is begins with the hotels property number. Currently I've manually listed the properties complete folder name in a text file. This is proving to be a management problem that needs to be fixed. The code I'm using … |
 | This snippet demonstrates how you can add VBA code to an Excel file at run time. **Prerequisites** In this snippet I am using Microsoft Excel 2013 with the Microsoft Excel 15.0 object library. Before you can use this code, you will have to change a setting within Microsoft Excel to … |
The End.