20,278 Topics
| |
hey guys i need to know some of the techniques on how to shorten a very long query for example Dim SqlStatement As String = "INSERT INTO tblcenterlane(DESCRIPTION, UNIT, BEG, OT_KITCHEN, OT_F&B, OT_F.O., OT_S&M, OT_H.K., ADMIN, DEL, PULLOUT, SPOILAGE, ENDING, UNIT_COST, AMOUNT, VARIANCE, REMARKS, DEPARTMENT, DATE, DATE_DURATION_FROM, DATE_DURATION_TO, SUPPLIER_ID, CATEGORY) … | |
Hello, In my multithreaded applications, on occassion the error Que Is Empty occurs when trying to clear the que. Is there any way to prevent this from happening or catch it without causing the program to lock up? Below is the code that throws the exception. ` Private Sub Callback(ByVal … | |
Hi, I just wanna ask what's the problem with my code in retrieving image from database into a picturebox. Private Sub ShowDetails() Try Dim cn As New OleDb.OleDbConnection Dim cmd As OleDb.OleDbCommand Dim dr As OleDb.OleDbDataReader cn.ConnectionString = mstrConnection cn.Open() cmd = cn.CreateCommand() cmd.CommandText = "SELECT myimage FROM employees WHERE … | |
First posting here, but I've gotten a lot of help from this site. Here is my problem. I'm trying to automate some procedures for my production line. I have a word document that I have created a string from. What I'd like to is search the document for somestring after … | |
Right guys, I'm really new to this but I'm getting along ok, but I've hit a block. I need to be able to know how to search a text file in VB for a particular line and then display it. the files I'm trying to use are set up as: … | |
Hello, I am creating a toolstrip and then adding a toolstripcombobox to it. My code so far is as follows: Dim tsMenu As New ToolStrip tsMenu.Name = "tsMenu" tsMenu.Dock = DockStyle.Top tsMenu.Visible = True Dim tsComboBox As New ToolStripComboBox tsComboBox.Name = "tsComboBox" tsComboBox.Visible = True tsComboBox.Items.Add("Item 1") tsComboBox.Items.Add("Item 2") tsMenu.Items.Add(tsComboBox) … | |
I got an error with my codes? Is anybody can help me ? The Error list said Identifier Expected? the error pertains on the last Underscore in my code but i dont know how to solve the error, Hope can someone will give an Idea to make it right :) … | |
Hello! I need a help from my code in filtering the male/female regular/contractual employees. Scenario: I have 4 checkboxes the 'cbox' for contractual, 'rbox' for regular, 'mbox' for male and 'fbox' for female. What I wanted to happen is when I check 'mbox' it will display male employees in as … | |
Hello everyone, I'm attempting to log into Hotmail using Web Requests, but I'm having a little trouble. It seems I can log in fine, but when I try to access Hotmail, it takes back to a login page with puts me in a constant loop. The important code can be … | |
how do i detect the current position in vlc video-playback in vb.net? Basically as the clip is playing, I want in a label for it to say "02:58/21:35" relating to the current clip being played. So I'll need to somehow figure out how to detect current position and end position. … | |
guys i need ur help i want to insert data directly into the sql table using c# here is my code all that i have been able to do is get the values from the table not insert them i tried to do it this way but apprently there is … | |
| Hello people, here is a question related to sharing of databse between two applications. I am developing an application which has two parts: 1) Client Side. (Student) 2) Server Side. (Faculty, teacher) What I want to accomplish is that if a teacher creates question paper the student should be able … |
Hello to everyone I am a begginer in VB6. My project consist just on a form and a web object, the problem is that I want to dissable the sound that make the application when I click on links. Can someone help me?! Plese write the code here because I … | |
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 … |
The End.