20,279 Topics
 | |
 | 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 … |
The End.