20,285 Topics
 | |
 | 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) …  |
| | 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  |
| | 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 …  |
 | 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 …  |
| | 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 … |
| | 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 … |
| | 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 … |
| | [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 … |
| | 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 … |
| | 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 …  |
| | 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 … |
| | 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 …  |
| | I Need Help, I Cant Find Anything Online On How To Make A Application That Can Have The Option To Sign Up And Login And When Accounts Are Signed Up, Anyone With The Application Can Login With Acocunts From Other Computers, How Would I Do This Without Being On The … |
 | 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 … |
| | 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 … |
 | 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 … |
| | 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> … |
| | 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 … |
| | hi all , i have the Following CSV generated by a third party software, i need to be able to read the first row and see what month and year it is. what i would like to do is generate a MySQL Table using the "<monthyear>" so november2018 and place … |
| | 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 … |
 | 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 …  |
| | 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 … |
 | I have a Database named "Store" and tables are orders and firm. The firm table fields are firmname, firmcode. The fields orderno, orderdate orderqty, qtyrcvd and balqty are stroed in another table. When selecting three ComboBox values (fetched from another(invoice) table) ie firm name, orderno and orderdate respectively when clicking …  |
| | Hello! Good Day to All, I am working on Visual Studio 2015. I have two workstation computer systems, in both same operating system and Visual Studio is installed. When i Build the main project it succeeded, and no any problem and my project runs normally on both systems. Then i … |
| | How to change the color of a cell(back or fore color) of listview item according to item value with if condition. I do it but it is not work and show no error Please help me...... For k = 0 To ListView1.Items.Count - 1 If ListView1.Items(k).SubItems(6).Text > 100 Then ListView1.Items(k).SubItems(6).ForeColor … |
| | I have one data base named store and tables are order and firm fields are firmname,firmcode in firm table and orderno,orderdate orderqty,qtyrcvd and balqty are in another table. when selecting three combo box values (fetched from another table ) ie firm name , orderno and orderdate respectively when clicking a … |
| | I was so amazed at how easy it was to embed google maps into a vb app I decided to post a quick example to help anyone get started. This is a simple example. Google's api has all kinds of things to help customize your map. You can find out …  |
 | Hello How do I rectify this error, please: 'Argument not specified...'? I have 4 columns in a MS Access database: username, strEmail, hashed, and salted. In my form field (on the Webpage), I have Name (username) and Email (strEmail) which are text fields and correspond to username.Text and strEmail.Text in … |
| | vb.Net - Regular Expression Tester Every now and then I find another use for a regular expression. For those not familiar with regular expressions, they can be as cryptic to read as strings of Greek letters. Simply put, regular expressions are just patterns. If you've ever used the DOS command … |
| | Hi here is code snippet used temprarily on button to debug. This works but i wish to use the 2nd snippet. 1st snippet Dim connString As New SqlConnection connString.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings("sql2008r2_857000_dmcsqlConnectionString").ConnectionString Dim cmd As New SqlCommand("select TOP 1 no from members ORDER BY no DESC", connString) Dim reader As SqlDataReader … |
The End.