20,899 Topics
 | |
 | I want to get the data between today this the coding i used CrystalReportViewer1.SelectionFormula = "{sell.Date}= '" & DateTimePicker2.Value & "' BETWEEN {sell.Date}= '" & DateTimePicker1.Value & "'" I saved the data into data Dim date1 As Date = DateTimePicker1.Value.Date THE ERROR I got have attached as a picture I … |
| | *It's my first time here but the way I see things around here is good * I'm a newbie in VB2010 so please don't judge me too much... HERE is my codes for INSERTING DATA but the problem is I don't know how to use it for SEARCHING Imports System.Data.SqlClient …  |
| | Hello, I'm having a little issue issue with my picturebox controls. Normally my program works fine, but when I try to load a picture into any of my pictureboxes, the image won't load until I make sure the form is extended to show the picturebox and the form is ontop. … |
 | Private Sub Open_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Open.Click If (BookmarksList.SelectedIndex >= 0) Then WebBrowser.WebBrowser1.Navigate(BookmarksList.SelectedItems) End If End Sub This is the code I made for opening a Bookmark from List yet an error keeps on showing. Any help? WebBrowser is the main form's name. BookmarksList is … |
| | No mapping exists from object type System.Windows.Forms.DataGridViewRow to a known managed provider native type. Using conn As New SqlConnection(My.Settings.Smitty) Using cmd As New SqlCommand() With cmd .Connection = conn .CommandText = "Update Repairs set status = @status WHERE RepairNumber = @repairNumber" .Parameters.AddWithValue("@status", "Awaiting Part Installation") .Parameters.AddWithValue("@repairNumber", RepairInventoryDataGridView.Rows(4)) End With conn.Open() … |
 | Hi All, Quick one. I have a webservice which uses numbers in american format which need to be passed as datetime data types when webmethod is called. The issue is the times passed depend on when a button is pressed. Please ignore variables as this is from testbed project I … |
| | i have a datagridview with 2 columns on it. i add column 1 manually from Datagridview task (add columns), it should numeric value and came from user input. for column 2 (it's numeric value), on load event from database with this : Using conn As New MySqlConnection("connection string") conn.Open() Dim …  |
| | Hey fellas, Is there any method by which I can declare a Variable that can be used in multiple forms in VB.NET ? |
 | I just wanna ask what's wrong with my code it says syntax error on INSERT STATEMENT but I can't find the error @.@ Try Using conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & System.Environment.CurrentDirectory & "\employeedb.mdb;") conn.Open() Dim command As New OleDbCommand("INSERT INTO employees (first_name, last_name, MI, address, age, contact, status, department, … |
 | Hello, I have been working on a time clock program where the user can enter their time in and time out using two DateTimePickers, and it will tell them how many hours and minutes they worked. I was able to format the DateTimePicker to only show the hours and minutes. …  |
| | hi guys i am a student of b-tech i want a ppt for my mini project i.e. web browser using vb.net .If u Know the sites from which i can get it plzz tell..... |
| | I want to display the current web address for my custom web browser. Any help? Thanks in advance.  |
| | Upon playing with the graphics/random class - I have discovered something odd. Private Sub Me_Load(sender As Object, e As EventArgs) Handles Me.Load For i = 0 To 5000 DrawColor(GimmiRectangle) Next End Sub Private Sub DrawColor(ByVal rNew As Rectangle) Try Dim g As Graphics = Me.CreateGraphics g.DrawRectangle(New Pen(Color.FromArgb(New Random().Next(255), New Random().Next(255), … |
| | How To Create a playlist in vlc player by using vb.net code.  |
 | Hi, is there another way of hiding or formating column value in asterisk in select statement? im using the command replace SELECT REPLACE([Item].[Price],[Item].[Price], '**********') AS Price From Tablename it works fine, but is there anyway to do this? Instead of replacing/forcing the value to display asterisk, i just need if … |
| | I am populating datagridview with 9 columns through dataset. After this I add 4 comboboxes programatically. Now for the first time form loads, everything goes well. But if I change selected value in combobox from FORM,grid does not gets value and it shows error **"Column cannot be added because it …  |
| | I am making a visual basic project and using MS Sql database as datasource. Now my problem is if I will use the project's .exe file on any other machine which has MS Sql already installed, then will the application will start using the database on its own or do …  |
| | Hello Guys, I have a table having a column called Sr.No. And I Wish that everytime i make an entry into that table Sr.No should be auto Incremented. How Can I Achieve this Functionality ? Thanks |
| | I'm trying to create a program that determines if what i inputted is a Literal (String or a Char) My idea on how to create one is if i inputted a string (Starts with the usual ") so the first Index in my Array should be " or else it … |
| | I published my project in vs2010 and im trying to deploy it to other computers. I used this connection string that runs smoothly on my pc. This code tries to retrieve the servername and try to connect to database mysysDatabase. This forcely change the app.config. Private Sub btnOk_Click(ByVal sender As … |
| | Hello! I'm just going to repost my question here from stackoverflow. I am currently developing a file sharing application using asynchronous communication in VB.Net. I successfully coded a simple connection between the client and the server. But, I am currently having a bad time doing the disconnection sub routine for …  |
| | Maybe I am missing something, but is it the case that when you set a pictureboxes background to transparent, all it really does is set it to the same color as the forms background? What I am trying to do is draw an animation for the benefit of this, a … |
| | With a ComboBox there are multiple properties and events that interact. SelectedIndexChanged() DropDownStyle AutoCompleteMode AutoCOmpleteSource Now I have a static collection of Objects, that contain String Values as their names. I add those names in alphabetical order (and by way of the list creation numerical indicies as well) to the … |
| | Hello all! I have a huge headache over this issue so ill just get right into it, the clients just got new windows 7 pro machines, they were using windows xp machines with no issue with this custom vb app, heres the error that pops up when they try to …  |
| | Upon aiding a friend - I have decided to post the example used here. The following is a snippet that shows basic class inheritance. The source file as well as a test case can be found attached. You can test these classes with the following code: Dim cNew As New … |
 | Hey guys im trying to display diffirent tables on 1 datagridview (ofcourse its one at a time only) so far it works everytime i change the datatable using listview for selecting now the problem is how do i insert data on it but only using a single form....each table have … |
| | anyone can help me... I have developed vb.net deskstop application.I want to open popup in button click event but when popuup open in second time first display blank space after that popup contain dispay. my code is : Dim popup As New ToolStripDropDown() popup.Margin = Padding.Empty popup.Padding = Padding.Empty popup.Width … |
| | Hello Guys, Here is an interesting problem. I have the following code. But it seems like I am missing out something in the process of populating drop down menus with data from database. You guys have a look at it and please give your valuable suggestions. Private Sub Open_Exam() Dim …  |
| | As title show. I still not able to connect my ms.access login database . Please help me ~ Dim con As New OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\leong\Documents\Visual Studio 2010\Projects\WindowsApplication4\WindowsApplication4\coursework.accdb") ' Dim cmd As OleDbCommand = New OleDb.OleDbCommand("SELECT * FROM AdminUser WHERE Username ='" & Usernametxt.Text & "' AND Password ='" & Passwordtxt.Text & … |
| | hello people, I have the following piece of code. Private Sub SR_No() Dim con As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\VB Applications\PROJECT_1\PROJECT_1\examdb.mdf;Integrated Security=True;User Instance=True") Dim cmd As New SqlCommand("Select MAX(SR_No) from Stud_Master", con) con.Open() Dim dr As SqlDataReader = cmd.ExecuteReader() MessageBox.Show(sr) con.Close() End Sub I wish to fetch SR_No into a variable sr. … |
| | can you help me by giving me some codes or program about item analysis using visual basic??  |
| | A curious thing, is there a reason that you can't declare sender as a specific type? For instance, if you had a number of textboxes and you wanted each one to select all it's text when you click on it could you use : Public Sub TextBox_Click(ByVal sender As TextBox, … |
| | I'm trying to search on how to store the image in a local folder and save its path and filename in ms access using vb.net but a lot of topic makes it more confusing for me. I'm just a student and working on my baby thesis. I'm currently building an … |
| | I have this code: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim connection As New SqlClient.SqlConnection Dim command As New SqlClient.SqlCommand Dim adaptor As New SqlClient.SqlDataAdapter Dim dataset As New DataSet connection.ConnectionString = ("Data Source=.\SQLEXPRESS;AttachDbFilename=c:\users\korisnik\documents\visual studio 2010\Projects\WindowsApplication46\WindowsApplication46\Database2.mdf;Integrated Security=True;User Instance=True") command.CommandText = "SELECT * FROM [User] … |
 | I have an array of TextureBrush() which I call upon to fill a rectangle. However, I am coming up against an error: System.ArgumentNullException was unhandled HResult=-2147467261 Message=Value cannot be null. Parameter name: brush ParamName=brush Source=System.Drawing StackTrace: at System.Drawing.Graphics.FillRectangle(Brush brush, Int32 x, Int32 y, Int32 width, Int32 height) at System.Drawing.Graphics.FillRectangle(Brush brush, … |
| | Hi, I let say I use this code to retrieve date from database SELECT Table.Date FROM Table The format is 01/09/2013 (dd/mm/yyyy) How will i format this to get 09-Jan-2013 output then print this format to crystal report? I'm using dataset to connect data to crytal report I just noticed … |
| | this might sound dumb, but oh well i just want to ask what are the significance and important things to put in mind in deciding the form size of a project because i can't decide what dimensions i'll be using for the current project i'm working on. cheers,  |
| | Hi sirs/Madams I am using vs2008, i have a problem. In my application command Prompt is open but file is not open through cmd. My requirement is any commands are not entered in cmd. Commands are written in code, but i don't know how to slove it.Just open the cmd … |
| | Hey guys I have a problem. I am using mysql as my database. I want to get the 3 most repeated values into 1 textbox And my problem is how do i get them? here is the table: pen book book book pen pencil pencil paper i want to get … |
| | Well i have troubles sorting the xml whenever i created a new info so here are the codes Imports System.Xml Imports System.IO Imports System.Text Public Class Form1 Dim m_strdata As String(,) = New String(999, 4) {} Dim w As Integer = 0 Private Sub read() Dim m_xmlr As XmlTextReader 'Create … |
| | My application has two forms. Focus may be on either form. Keypresses on either Form1 or on Form2 need to processed by code in Form1.vb. How should I make this happen? Thank you retroMIDI2 |
| | |
| | Hello, I have problem in one of my program,it's almost a copycat of MS-World, that means it's using RichTextBox, I have Bold,Italic,Underline etc. buttons but when I save the file and open it, it's a basic text that you can get from Notepad. File Type: DTX Save Method: Writer (User-made … |
| | How to Highlight a sentence row by row? For example I made a simple notepad written in VB.net. Then, I'd like to hightlight a row by row automatically and manually. lets say I have a button named "auto" to highlight row downward automatically , and I have a button named … |
 | I am trying to save items from listview to database,but whenever I try to run my code, the message "Object reference not set to an instant of an object".Here is my code.............. Private Sub Button9_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button9.Click strsql = "Update tbl_tec_temp set tem_we_position … |
| | Greetings! I just want to ask on how to change a word to another word and change its color in a textbox. For example if I type the word "Yes" in the text box it will change to "NO" and change its color into red at the same time.  |
| | Hello i am doing a WOW launcher but i wanted to switch from vB.net to C# so i used this converter http://www.developerfusion.com/tools/convert/vb-to-csharp/?batchId=afeaecee-b774-436c-a04a-97009e64a2bb but i getting some errors http://pastebin.com/enQ1s414 My code http://pastebin.com/F9CnGyKp I hope you guys might help me :) btw do not care about that missing GUI things just that … |
| | Hi Everyone, I have one text box named txtYear.text and this text box will accept only Year Value i.e. 2011, 2012 and so on. Now i want to put a validation on the text box like, if user enters the value like 1,03,54 in text box then the system should … |
| | Need some help, when im uploading the form stops responding and the progress bar is not loading. someone can help me in this problem. Thank you so much for advance :) -> Heres my whole code Imports System Public Class Form1 Public filenameOnly As String Public FN As String Public … |
 | My PC has 3 drives C, D, E...when I insert the removable CD drive it should detect that the drive is the F:... it may vary for different systems...how can I find which will can be the CD drive... I had written the following code Try For Each drive In … |
The End.