20,278 Topics
| |
How do you display the week ending date (Sunday) in VB10? When a form loads, I want to display the upcoming Sunday date in a label. In VB6 I used the following code and it worked fine. Private Sub Form_Load() ' Set Default "Week Ending" Date lblWkEndDate.Caption = (Date + … | |
Well, in my previous thread i needed help deleting arrays, for the codes i use its here: http://www.daniweb.com/software-development/vbnet/threads/426588/how-to-move-arrays-1-place-down- But now i need help saving the arrays, i can save all the arrays to ini file like this: Ini module: Option Strict On Module INIAccess #Region "API Calls" ' standard API … | |
I was going to check if a temp table exists and delete the it,since "the temptable already exists" arises if you want to perform another operation. Here's the code i used five statements but it says syntax error in drop table or drop index statement. Any help would be appreciated. … | |
Hi, I am new to VB.NET and am working on what is pretty much my first app. The app is based on a sql data source (created within Visual Studio) and basically is intended to show who is on-call when the app is loaded. So, i have some test data, … | |
I am trying to make a form in vb and connect that to database .First of all i created a databse and then opened new project and tried to connect that database to form. file new--->try____>project--->add new item---->Service based databse--dataset---->finish step2----->in databse explored right clicked on table and Add table … | |
Good afternoon. I am developing a gmail app for my personal consumption for now and it has a lot of bells and whistles including showing me the latest emails coming in, playing a sound and changing icon when there is new mail and a few other things. I am using … | |
All, What is the most efficient way of writing several lines of data to a *.txt file? Currently, I store the required text in memory then write it all to a user-specified text file at the end, similar to the following; Dim text As String = "" text = text … | |
I'm trying to set up a timer that counts up to ten and starts/resets when the left mouse button is clicked (anywhere on the screen even when the application is in the background). I'm struggling to find a code that suggests it is possible and now I am starting to … | |
how i can import data from access database to my database in sql server , with a check for ducplicate each time i move data i need the code in vb.net any help ? | |
[code] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click connetionString = ("server=192.9.200.82;database=eKalyan;user id=invite;password=invite") MessageBox.Show("connection established") sql = ("select newuniqueid,newteh_code,newpcate_cd,newplano, pen_nm,rel_cd,pen_fnm,ccate_cd,pan_code,pvillage,ppo_cd,spo_cd,start_qtr,last_qtr,bundle_typ,bundle_no,mo_srno,pen_amt,pen_comm,status,operatorcode from ekalyan.welpen") cnn = New SqlConnection(connetionString) Try cnn.Open() cmdd = New SqlCommand(sql, cnn) cmdd.ExecuteNonQuery() cnn.Close() MsgBox(" ExecuteNonQuery in SqlCommand executed !!") Catch ex As Exception MsgBox("cannot … | |
Hi guys, i just faced a problem when trying to execute the following query.I searched for the exception on the internet and found that using a reserved keyword might raise this issue,and using brackets may solve this problem.But i use brackets all the time in my sql statements but still … | |
Hi everyone, I'm new here and is in need of some help. I'm trying to complete my project, however I'm stuck at writing the data from the sql into the vb.net/asp.net gridview. Was never good at database to start with and I had never learnt how to query from VB.NET. … | |
I have a form with a lot of checkboxes on it. I want to be able to set all the checkbox properties to "checked" in my code. Here is what I would like to do: For Each ctl As Control In Me.Controls If TypeOf ctl Is CheckBox Then ctl.checked = … | |
i am using vb.net application with OleDb database. In a form i have Search,Add,Edit,Delete buttons for the data. Although search data is working but Add,Edit,Delete are not working. Here is my code. Imports System.Data.OleDb Public Class Form1 Dim CN As New OleDb.OleDbConnection Private Sub Form1_Load(ByVal sender As System.Object, ByVal e … | |
Can anyone help me to solve this problem? How to validate ?Thank you Home identification code (4 alphanumeric characters) – required Program should generate it using a random number generator | |
Hi, I've a project compiled for .net 3.5. In the project there is a form with a DataGridView. In CellPainting I'am adding row numbers in row header: private void dataGridView1_CellPainting(object sender, System.Windows.Forms.DataGridViewCellPaintingEventArgs e) { if (e.ColumnIndex == -1) { e.PaintBackground(e.ClipBounds, true); using (StringFormat st = new StringFormat()) { st.Alignment = … | |
hey all again in trying to add to make sure if my datagridview has some data in it or not before adding it to the database and here what i came up till now int i = POSDGV.Rows.Count; for (int j = 0; j < i; j++) { string strCol2 … | |
Hi guys, A problem came up when i tried to copy record from the temp. table to the main one.I was copying records to two main tables but one table is empty but the other works fine.Here's the code i used: projcode = TextBox4.Text projname = TextBox5.Text description = TextBox6.Text … | |
| |
I have a database with items which I want to populate to a listbox. The first image shows how its right now, and the second shows how I want the final result to look like. ![dd3aaa66fdb74cecb5cca11999b6b6dc](/attachments/small/3/dd3aaa66fdb74cecb5cca11999b6b6dc.png "align-left") ![2645978b29622fc539c0725c199c3e13](/attachments/small/3/2645978b29622fc539c0725c199c3e13.png "align-right") | |
Hi, I am new to VB programming. I am using Aceess 2010 database with VB 2010. I have one main table which stores information of company details. The details are broken down in seven different tables with codes to avoid data duplication and keep the main table less bulky. e.g. … | |
IF YES THEN WHERE IS THIS CONTROL AND HOW TO USE IT???? | |
I Have A DataTable In MSAccess TbJform and I want to Show the Columns of TbJform in ListView.................The Columns Are JformNo,JformDate,PartyName,Bags,Packing,Loose etc.............now what sholud i do to show the all the colmns in listview... | |
In my program I hav a datagridview who is showing som data based on a table call it table_1. I have a table_01 witch has a Primary-key called OrdreID. The Binding navigator is connected to this table. The table called table_1 has a forreign key called OrdreId and are related … | |
I'm writing a program where the settings of a spreadsheet-like field of textboxes are changed using two for loops, and I can't for the life of me figure out why it's not working.I have tried declaring the txt variable and name variable in different orders using different methods, but nothing … | |
I'm looking for some help with an issue I am having. I have multiple text files in a folder. The folder can have an "unlimited" amount of text files in it, although typically 2-150 files. http://gyazo.com/5f314d1ca374abf9f813914609dd931d (images for this + below) Each file then contains an "unlimited" (although typically 0-20 … | |
i have a vb.net form linked to database access-Table1 In the form three checkbox as HB,TC and 2 textbox-ID,Age I am using following code but is its not working. If Hbtxt.Checked Then cmd = New OleDbCommand("insert into Table1(ID,Age,Hb) values ('" & IDtxt.Text & "','" & Agetxt.Text & "','" & Hbtxt.Text … | |
Sorry i'm new in visual studio 2008. I have a database (MSaccess 2007) wherein the ole object is shown in a picturebox when i click a file on the list view. What is the code to preview the picturebox in a new form inside another picturebox when I click it? … | |
Hello..please, i want to pass a dictionary from a class to a datagridview on a form.. but each time i try to reference this class from the form, it keeps recreating new objects of my dictionary, thereby setting my dictionary to null. Please, what do i do? | |
I am working on a project to create a front end in vb 2010 for an access database. It is adding the records in vb but not saving them in the database; this is the code i have so far: `Inline Code Example Here`Public Class Form2 Private Sub Button1_Click(ByVal sender … |
The End.