20,278 Topics
| |
Hello I have a vb.net application with MS access database. I want to run LAN in 3 pc by this application. So it possible or which SQL method shuold I adopt for LAN connectivity. I started to convert my database in SLQ express but I am not succeed . | |
Hi i am trying to display records in access database that have pictures saves binary data i have created typed dataset that populate the crystal report but the problem is the images do not display code is as below i have attached sample report Imports System.Data Imports System.Configuration Imports System.Data.OleDb … | |
Program runs without errors, unfortunately it will not calculate the days overdue. Any Suggestions? I have attached the code as a pdf, i have also done this as an IF, THEN, ELSE statement with the exact same results, but it will not let me upload it. Help! Private Sub calculateFees … | |
I have vb.net application with MDF-Sql database. I retrieves data from Table in MDF-Sql into datagridview by TableAdaptermanager/binding navifator. Although it displays data but when I want to save by this code, its not working.This code is working in vb.net with OleDb application but not here. Is there any another … | |
namespace gridStudent { public partial class Form2 : Form { public Form2(DataGridView dgvFromFom1) { foreach (DataGridViewColumn dc in dgvFromFom1.Columns) { dataGridView1.Columns.Add(dc.Name, dc.HeaderText); } foreach (DataGridViewRow dr in dgvFromFom1.Rows) { Object[] newRow = new object[dr.Cells.Count]; for (int i = 0; i < newRow.Length; i++) { newRow[i] = dr.Cells[i].Value; } dataGridView1.Rows.Add(newRow); } … | |
Imports System Imports System.IO Imports System.Text Imports System.Collections.Generic Class Program Public Shared Sub Main(ByVal args As String()) ' Set a variable to the My Documents path. Dim mydocpath As String = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) Dim sb As New StringBuilder() ' Enumerate the files in teh My Documents path, filtering for text files … | |
I need help in fixing this bug (Data type mismatch).Im using a datagrid to insert data to access database but get this error. I can update and delete during runtime but I cant insert data to database. Following is my code: Try conn = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Video Store\Video Store\DvDSystem.mdb") conn.Open() … | |
I am having the most horrendous time searching for this. I swear I have trawled the web 10 times over. All I need is to get the URL of the link that has been clicked on, and open it in a new form window that is maximised with a web … | |
Hy guys, . Please assist in advicing whch toolbox conncetion controls to add in my form. I want to connect to access 2007 using vb.net 2005 and im struggling. I have two textboxes(username and password) and two buttons(submit and cancel). When I click on the submit button it supposed to … | |
Hi guys pls help, Im trying to connect to access 2007 database in vb.net 2005 woth no luck.....im using a login form with two text boxes and two buttons, Im tring to log into the database using the below connection string....... (i only get the catch message box error)... Plz … | |
Hy guys, Please assist in advcicing which toolbox connection controls to add in my form. I want to connect to access 2007 using vb.net 2005 and im struggling. I have two textboxes(username and password) and two buttons(submit and cancel). When I click on the submit button it supposed to allow … | |
how to resize a image thtz lager than picturebox?? | |
Dim total As Integer For Each row As DataGridViewRow In DataGridView1.Rows total += row.Cells("Total").Value Next TextBox2.Text = total // the above was the code i used and it worked good,bt if i do it for another column it is showing an error (which is given below)// Private Sub Button1_Click(ByVal sender … | |
i want to insert text in textbox at specific location(i.e row 2 column 3).how can i do that ? i tried this but its not working `Me.RichTextBox1.Text = Me.RichTextBox1.Text.Insert(i, CChar(cb.Text))` | |
Ok here is the required feature: To send data gathered from a database inside a UserControl to the main form which houses the UserControl. Hierarchy at present: Mainform --FlowLayoutPanel ----UserControl The UserControls are generated on the fly by a client list in a database. This all works fine. When you … | |
Hello, am on a project and I want the user to search for a word in datagridview. Am using vb.net 8 with access 2010 I want where the text is to be highlighted | |
HI, This code is to draw a circle in the form with one button in vb.net. [code] Dim g as system.drawing.graphics g=me.creategraphics dim p as new system.drawing.pent(system.drawing.color.Blueviolet) g.drawellipse(p,150,100,30,60) end sub [/code] this is not working it is showing the error in the declaration of p any one can help me … | |
Sometimes you want to add a little functionality to an existing class but you don't want to go to the trouble of sub-classing. A technique that you can use is known as **Extending**. For example, I frequently use regular expressions when working with strings. Wouldn't it be nice if strings … | |
Good Evening Everyone, i am currently facing a problem. I want to append data to an excel file but before that i want to check for duplication records in the excel file before appending. For example, an employee want to check in to a company but he can only check … | |
good evening everyone... could anyone help me on this? With a "time value", eg. 08:00:00... i want to find the range that this value falls in using case statement... i am not good in using the time format... anyone can help? This is just an example: (the code is not … | |
Good Morning Everyone, i have a question.... i have 2 text boxes... for text box 1, i want user to enter integer in "hour hour" (24 hours format) for text box 2, i want user to enter integer in "mm" (24 hours format) there is also a label in between … | |
Hi all, i encounter an syntax error "Syntax Error in Insert Into" when i try to run this code... anyone can assist? Thanks! Dim sConnectionString As String sConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" & _ "Data Source=H:\Users\Desktop\EmployeeAway2.xlsx;Extended Properties=""Excel 12.0;HDR=YES;""" Dim objConn As New System.Data.OleDb.OleDbConnection(sConnectionString) objConn.Open() Dim objCmd As New System.Data.OleDb.OleDbCommand() objCmd.Connection = objConn … | |
Hi Everyone. I got a problem when I want to input data into my second row. whenever i try to insert data,the data always appeared in the row. here's my code... private void btnTambahStock_Click(object sender, EventArgs e) { int i = 0, j = 0, k = 0, l = … | |
Having a problem. Wrote program originally as VB Console using Sub procedures, had to change it to Function. It worked as sub procedures, but now as function it won't calculate correctly, I actually have two that are doing the same thing because of the procedure switch! Grr! Any suggestions? Sub … | |
I NEED TO WRITE A CODE IN VB.NET , THAT LET ME EXPORT DATA FROM ACCESS DATABASE ( THE TABLE ATTACHED AS IMAGE ) AND IMPORT IT INTO SQL SERVER 2008 R2 . **NB : TAKING INTO CONSIDERATION DUPLICATION ** Example : if you see in the image the access … | |
Hello, I have my VB 6.0 Application and make a Exe and I hosted it on my windows server 2000 it gives me error 'Could not access network location \\mynetworkpath'. earlier when there was Datepicker control was used then also there was error coming but I had registered MSCOMCTL2.dll and … | |
how i can compare the data of two datatables ( dt1 , dt2 ) and got the difference in a thrid one dt3 dt1 and dt2 Structure ID Date Time S1 S2 EmpID IN\OUT any help ? thank you | |
Hey, i'm recently new in this forum, so if i'm doing something wrong, please tell me! I have a problem that is driving me nuts! Here's the thing, i want to know if there is any way of remove checkboxes dynamically, with code. I know that there is a way … | |
Hi all, I had a little problem when deploying an application having crystal reports as a reporting tool on a client pc. It works so well in my dev pc even installed.Since i'm using Access 2007 i used Microsoft.ACE.OLEDB.12.0 provider. I haven't provided any password or username for the database.But … |
The End.