Hello all, I was wondering if I could get some questions answered about how cupons work in the work place. I have an idea which involves creating a very flexible cupon service, but would require knowing the rudiments of how cupons work. The main question I have is how is tax calculated on a ware as it is sold under a cupon service. I believe that would be the only thing I would have to stringently mandate as far as the cupon goes, since the institution wishes to clear the merchendise from the floor. The service would involve some C# …

Member Avatar
Member Avatar
+0 forum 1

hi I have datagridview which i want to add on several forms. Number of columons and all ather functionality remains the same. to avoid creating size, columns, column names each time, i am trying to create class control for datagridview which will give me by default number of columns and size once i add the datagrid to form. i have tried this . **But it shows ten columns instead of five** . attached picture Public Class ClsDgvJournal Inherits DataGridView Public Sub New() Width = 500 Height = 200 Dim Col1 = New DataGridViewTextBoxColumn With {.HeaderText = "AAA", .Name = "A", …

Member Avatar
Member Avatar
+0 forum 11

Hello, i got a table in Excel (or exported to CSV). There are 3 columns (1. column = specification / 2. columns = value1 / 3. column = value2). On my vb.net form i got a textbox, 2 labels and a button. If i write in in the textbox "5" it should search in the Excel or CSV-File in columns A (specification" the "5" and then it should show the both values in this row in label1 and label2. I tried much things but i can only read and show the complete row in only one label and only from …

Member Avatar
Member Avatar
+0 forum 2

Hi, I have checked all the prior forum questions on this topic, but none of the options seem to be working for me. I am creating an output file that goes into a specific folder for getting MP3 file information. When I run inside of Visual Studio Community 15, it works great ... no errors. When I take the EXE and create a new folder for the actual application and run by itself is when I get the error. I have tried turning on the UAC to Admin rights, with no luck. Here is my code Private Sub cmdCreateFile_Click(sender As …

Member Avatar
Member Avatar
+0 forum 5

Hi All Brothers I am working on ERP system and i need one help I wrote code for Datagrid auto complete. this code is working perfect but it only showing one Column record from database what i need is i want first column is to autocomplete as i did and it should fill related columns automatically linked with first column. please guide me with Codes many Thanks My Code Dim strConn As String Dim da As SqlDataAdapter Dim conn As SqlConnection Dim ds As New DataSet strConn = ("Server= DESKTOP-QN6F623; Database = stock_in;Integrated Security = false;User ID=dis;Password=0m3rP@ss") conn = New …

Member Avatar
Member Avatar
+0 forum 3

Hi guys, i'm having a difficulty to set the path in vb.net.i put the code in the module and every time i run the code it throws error "Could not find file 'C:\Users\Abdueie\Desktop\BMS\Bridge Asset Management\Bridge Asset Management\bin\Debug\Adigrat.accdb'." here's the code Public conn As OleDbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source= .\\Adigrat.accdb;Persist Security Info=False")

Member Avatar
Member Avatar
+2 forum 10

pls can iny one help me , i want to display table from database or datagridview to template word for exmlple i have table "items" with 3 champ id_items,name_items,price_items

Member Avatar
Member Avatar
+0 forum 1

Hello, I want to have a manual IP-input-box like windows. ![tcpip_properties.gif](/attachments/large/4/1b3cb2d2b7b2be11e2b4abcef8d6fcc5.gif) I tried by MaskedTextBox but the problem is, the 3 pionts are sliding when i insert some numbers and i can insert letters and numbers higher then 255 (higher is not allowed in IP´s). I hope anyone helps me, maybe with some codesnips!?! :) best regards josh

Member Avatar
Member Avatar
+0 forum 6

Getting error when showing data in list view, please help me..... Error :* Cannot add or insert the item '10-07-2018' in more than one place. You must first remove it from its current location or clone it. Parameter name: item* I use Vb.net 2010 visual basic sql server 2008 r2 stored procedure one listview I want this type of structure (example) id date item_name qty. amount 1 1/1/2019 a 2 10 B 1 12 x 14 100 zz 4 52 2 4/1/2019 M 5 80 N 4 50 But when I showing to the data 1st item show on list …

Member Avatar
Member Avatar
+0 forum 4

I would like to create a Microsoft Access database and integrate it into my VB.net application. I am also hoping to distribute this application to others. My concern though is whether or not users who download my application will also need Microsoft Access in order for the database (and app) to work properly. Will the app still be able to create, modify and delete records if the users themselves don't have Access? Should i be looking into a different database software?

Member Avatar
Member Avatar
+0 forum 1

i have a mssql datagridviewer. i only need when user load the form..they must get empty datagrid...data only show when they search any item or add item....i worked on search and add but i am confused on load event ....please help with code

Member Avatar
Member Avatar
+0 forum 1

I have a text file with the following contents: Andrew Law 32 6'1 123 Pounds Tom Harris 19 5'5 180 Pounds Randy Poffo 45 5'3 141 Pounds Now on my form i have a listbox and four labels. What i would like to do is have the listbox show only the names of the people in the text file (Andrew Law, Tom Harris, Randy Poffo) and when the user clicks the persons name in the listbox i would like each of the labels to show the corresponding details for that person (one label showing age, one showing their height and …

Member Avatar
Member Avatar
+0 forum 2

I have a worksheet of about 388 items that each item is exported into a template worksheet that is created to itemize each item. It creates the worksheets but I can't get it to stop looping at the line of code in bold comments icons. The line that it stops at is to name the worksheet from the column "A" of the list of 388. I have shorten the list to work on the code. So when I'm done I would have workbook of 388 worksheets from the template made. The template worksheet name is "wbs_template" (hidden). I have attached …

Member Avatar
Member Avatar
+0 forum 11

Dear all I am working on a project for my customer . I wrote code to search items from sql using vb.net Now my code working fine.....when I search data using itemid it show me data in all related textboxes but not in datagrid here my code Dim connection As New SqlConnection("Server= DESKTOP-QN6F623; Database = dbo_main; Integrated Security = true") Dim command As New SqlCommand("select * from items where itemnumber=@itemnumber", connection) command.Parameters.Add("@itemnumber", SqlDbType.Int).Value = ItemnumberTextBox.Text Dim adapter As New SqlDataAdapter(command) Dim table As New DataTable() adapter.Fill(table) ItemnameTextBox.Text = "" If table.Rows.Count() > 0 Then ' return only 1 row ItemnameTextBox.Text …

Member Avatar
Member Avatar
+0 forum 1

Greetings, I'm kinda new to ASP.NET so I'm unsure as to how to proceed with accomplishing this task. I have a webpage that contains a GridView and controls associated to that such as Add, Issue Equipment, Edit, Delete. What I'm trying to do is when I click on a cell on the gridview the row will be selected then when I click Edit, the modal popup for editting will display with the values and details of that gridview item that Ive selected. How do I pass that gridview item and its values to that Edit modal popup? I use a …

Member Avatar
Member Avatar
+0 forum 2

Hi, I Have below table I want all rows with all coloumn from below table where ActCode is 1162828 and sum of DocAmount for DocNo. i.e where the docNo is repeated i want only one row with sum of amount of all repeated rows. ** "Select *, Sum (DocAmount) from TblPurLedTranData whre TblPurLedtranData.ActCode='" & 1162828 & "' Groupby DocNo " ** PosDate DocDate DocNo DocAmount DueDate Status Period DocType FinYear Chan ActCode 10/10/2018 12/10/2018 369896     36980      11/11/2018 INV      5         PUST       2018       PUST       1243684    10/10/2018 12/12/2018 665        36000      11/01/2019 INV …

Member Avatar
Member Avatar
+0 forum 4

[B][COLOR="Green"]Hi Guys :).. I hope you fine :), I need the best and easist way for printing the form ,nested of PrintForm tool coz it is very bad :angry:,it prints the form [U][COLOR="Red"]like screen shot :angry:[/COLOR][/U] ,what I want print entire form on A4 ... Any suggestions ? :( Thanks for your help :)[/COLOR][/B]

Member Avatar
Member Avatar
+1 forum 4

Hello all, I am relatively new to Visual Basic and have managed to muttle my way through creating a 2013 Word document that has some ActiveX controls. The final control I put in place is a Command Button that, when clicked, it sends the form off to an email. That is all working great, however, I would like to have a pop-up message that displays after the button is clicked, letting the form sender know the form has actually been sent. I have put the code I used for this Command Button below. Any help would be much appreciated. Private …

Member Avatar
Member Avatar
+0 forum 9

Hi guys, This is my first post and so glad to start sharing the knowledge. I am using Mysql database with VB.NET and I have this code : Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim str As String = "Server=localhost;Port=3306;Database=testdb;Uid=root;Pwd=password" Using con As New MySqlConnection(str) Dim query As String = "select * from testdata where rfid_tag='" & TextBox3.Text & "' and Date_serve<= '" & Date.Now.ToString("yyyy-MM-dd ") & "' and Start_Time<= '" & Date.Now.ToString("HH:mm:ss ") & "' and End_Time>= '" & Date.Now.ToString("HH:mm:ss ") & "' or amount_serve='' " Dim cm As New MySqlCommand(query, con) con.Open() Dim rd …

Member Avatar
Member Avatar
+1 forum 2

Hello, I am have been struggling with this and need some help. I am reading and excel sheet and getting the data and trying to search sql server to get the record. IN excel the length is 12 characters and in sql its 30. I am trying a like query and never getting any results. But if I do it in sql I return a value. ** VB.NET code** > > Dim strSearchText As String strSearchText = TextBox2.Text Dim sqlquery As String = "Select * from Housedat where (PROPID LIKE '%" & TextBox2.Text & "%')" SQL.ExecQuery(sqlquery) If SQL.RecordCount < 1 …

Member Avatar
Member Avatar
+0 forum 2

I am traying to filter Datagrid view based on user type in TbxGlCode (TextBox) Initialy Datatable is populated from SQL table to TempTable (DataTable) getting error at **runtime** at below line Dim Rows As DataRow() = TempTable.[Select]("Code like '%" & VerCode & "%'") Exception Unhandled **System.Data.EvaluateException: 'Cannot perform 'Like' operation on System.Int32 and System.String** How to filter datatable with** Like ** option *My Code* Dim TempTable As DataTable Private Sub FrmGLCodeList_Load(sender As Object, e As EventArgs) Handles MyBase.Load ' Dim TempTable As DataTable 'Create New Table Instance TempTable = New DataTable TempTable.Columns.Add("Code", GetType(Integer)) TempTable.Columns.Add("Name", GetType(String)) 'Adding Rows to TempTable from …

Member Avatar
Member Avatar
+0 forum 5

I create a project on vb.net 2010 and SQL server 2008r2 I showing a report in listview report am show fine and error free. But now I want to add a sub total column every end of the category. How it is possible please help me sir Please see the attachment picture https://ibb.co/tZ86Hvb https://ibb.co/V22d4Sk I try many coding, but not work, because i have no more knowledge about this. And search on google but many example are on Datagridview, but I used Listview please help me sir.......

Member Avatar
Member Avatar
+0 forum 1

hi, i am trying to read from a text file and store the data in an array but i don't know how to get started with my code. can someone please get me started here. i have start with the code for locating the file, but i am having difficulty reading the file. Dim strFileName As String OpenAnswerFile.ShowDialog() strFileName = OpenAnswerFile.FileName MessageBox.Show(strFileName) 'message box showing the file path

Member Avatar
Member Avatar
+0 forum 13

i'm trying to make price lable printer and i was able to print a single page for a single id, but my problem is when i'm trying to print more that one id i was not able to make it work, i'm still learning but i was hoping that someone can give me idea how to make it work Imports MySql.Data.MySqlClient Public Module thisModule 'Info for the Price Lable Public NameV As String Public IdV As String Public DiscV As String Public ArDiscV As String Public PriceV As String Public SalesPriceV As String End Module Public Class Form1 Dim connection …

Member Avatar
Member Avatar
+1 forum 3

I need to Retrieve the values from a XML file i have seen many example but none of them is like the XML I have. My XML look like this <component> <section> <code code="31011" codeSystemName="Codifica Interna Laboratorio" displayName="Etanolo (urine)"> <!--TRASCODIFICA ANALISI NON DISPONIBILE--> </code> <text> <paragraph> </paragraph> <table> <thead> <tr> <th>Esame</th> <th>Esito</th> <th>Abnormal Flag</th> <th>Unita di misura</th> <th>Range di riferimento</th> <th>Metodo</th> </tr> </thead> <tbody> <tr> <td>Etanolo (urine)</td> <td>&lt; 0,01 g/l</td> <td></td> <td></td> <td>fino a 0,35</td> <td /> </tr> </tbody> </table> <footnote></footnote> <paragraph> </paragraph> <!--Inizio Microbiologia sezione humane readable--> <!--Fine Microbiologia sezione humane readable--> </text> <entry typeCode="DRIV"> <!-- INIZIO MONO RISULTATO …

Member Avatar
Member Avatar
+0 forum 2

Im Stuck With Something, Iv Been Searching, And Searching And I Canot Find Any Information On How To Make SQL Database Show The Samething For Everyone, When Updated Of Coarse... I Can Make The DataTable And Put It On A Form But I Cannot Make It To Where I Add Something And It Update For People That Have Different computers... Please Help!!!!

Member Avatar
Member Avatar
+1 forum 3

I create a project encrypt and decrypt data in vb.net how to use this code as a function please help it is work only on a textbox i want to send a string value then return encrypt value and when i send encrypt value then send me decrypt value. [Click Here](https://www.daniweb.com/programming/software-development/threads/375789/encrypt-decrypt-vb-net) **What I have tried:** `Private arLetterChars() As Char = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz1234567890 "` `Private arEncryptedChars() As Char = "******************************************************"` **' encrypt.** Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click, Button4.Click With TextBox1 For Each myTextBoxChar As Char In .Text '// loop thru TextBox, one char. at a …

Member Avatar
Member Avatar
+0 forum 1

Hi! We are a 4 member group for our thesis and we already have submitted 5 topic proposals yet nothing was accepted...and here are the topics: enrollment system, gadgets on track, employment resource system, subdivision technical entry pass Now, I need a help for new ideas that can be developed through visual studio and it can be a web-based or window-based projects. Hope you can help me Thanks in advance!

Member Avatar
Member Avatar
+0 forum 36

Hi all I have a script to update the value from datagridview to database I do use a button insert ToolStripButton but not working hope people to help thank ! Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load conn = New SqlConnection("") conn.Open() Dim query As [String] = "SELECT * FROM dtaEmployees" da = New SqlDataAdapter(query, conn) Dim cb As New SqlCommandBuilder(da) dt = New DataTable() da.Fill(dt) C1FlexGrid1.DataSource = dt conn.Close() End Sub Private Sub ToolStrip1_ItemClicked(ByVal sender As System.Object, ByVal e As System.Windows.Forms.ToolStripItemClickedEventArgs) Handles ToolStrip1.ItemClicked Select Case e.ClickedItem.Name Case "ToolStripButton1" '---> button insert da.Update(dt) End Select …

Member Avatar
Member Avatar
+0 forum 7

showing Error "Failure sending mail." please help me i used port 587 because maximum example 587 used this port how i can know the my mail port or it is right error in this line SMTP.Send(Mail) massage is:- Just "Failure sending mail." ------------------ Imports System.Net.Mail Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim Mail As New MailMessage Mail.Subject = "test email" Mail.To.Add("abcd@gmail.com") Mail.From = New MailAddress("abcd@gmail.com") Mail.Body = "test mail test mail 123456789 hi" Dim SMTP As New SmtpClient("smtp.gmail.com") SMTP.EnableSsl = True SMTP.Credentials = New System.Net.NetworkCredential("abcd@gmail.com", "***********************") SMTP.Port = 587 SMTP.Send(Mail) End …

Member Avatar
Member Avatar
+0 forum 1

The End.