20,285 Topics
![]() | |
Can anyone check my search code? What seems to be the problem? **ERROR: **Object variable or with block variable not set. Dim con As New SqlConnection(connectionString:="Data Source=APBIPHAP06; Initial Catalog=PMT; Integrated Security=SSPI") Dim ds As New DataSet() Dim da As New SqlDataAdapter() Dim query As String = "SELECT * FROM tblPM … | |
![]() | I want to add data to sql databse using vb.net form And I am new to programming :( I get an error message saying "Incorrect syntax near "deatails") Can somebody tell me the reason the following is the code I'm using Imports System.Data Imports System.Data.SqlClient Public Class Customer_Profile Dim con … ![]() |
Hello, anybody still active in here? Can you help us get some thesis/capstone title consisting of 2~3 system interconnected to each other, we're a 3 member group and already past 10 proposal but none of those has been accepted, we need 10 title proposal where they can pick 3 out … | |
Good evening, I'm having problems when trying to save a listbox in a .txt file, follow the code; IO.Directory.CreateDirectory("C:\Test") Dim Caminho As New IO.StreamWriter("C:\Test\Arquin.txt") Dim i As Integer For i = 0 To ListBox1.Items.Count - 1 Caminho.WriteLine(ListBox1.Items.Item(i)) Next Caminho.Close() The following error occurs: 'Item' is not a member of … | |
I am herewith develop an application but I have created a class which calls button events(i.e. enable or visible). I am actually created the button events class(classfrmLoad) for the way which buttons should be enabled and visible when each & every form loading. There are 6 buttons in the forms … | |
Group, In VB.net, I use the following to return the actual name of a folder where data is kept. Is there an equivalent in VBA? I sure hope so. It would solve some problems for me. foldernameGD = CStr(getFolderNameGD("O:\Revenue Management\Centralized Revenue Management Service\CRMS Hotels", propertyNo2 & "*")) In advance, thanks … | |
![]() | Hi There, here is a form from my VS2013C Project  As you can see, there are 9 labels that need filling. My Question is, can I load the dataset with 9 different select statements from the same Table, and then fill the 9 labels with the correct data.? … ![]() |
I have one filter devexpress filter control. I want to convert IN operator into Like condition. Current Result - Column_Name In ('10.00', '10.10') Or Column_Name In ('10.20', '10.15') Expected Result Column_Name like '%10.00%' Or Column_Name like '%10.10%' Or Column_Name like '%10.20%' Or Column_Name like '%10.15%' Can some one help on … | |
Hi Dw. How can I tell if a file contains any file within it? I mean suppose I have a picture and I want to check if its a pure picture or there is a file hidden inside, this question comes after I read this post but it was number … | |
Hi all, I am having issue with my datagrid view. I plcaed some code in the 'SelectionChanged' event of the control. What the code does is it assigns items based on index to textbox items. This exception is raised when ever I click on the column header of the data … | |
![]() | Hi eveyone, I have a few labels in a panel and found this bit of code... Private Sub Button6_Click(sender As Object, e As EventArgs) Handles Button6.Click Dim RndGen As New Random For Each ctrl As Control In Panel1.Controls Dim lbl As Label = TryCast(ctrl, Label) If lbl IsNot Nothing Then … ![]() |
![]() | Hello Everyone, This time i am not asking for any help :-) I am showing anybody ,who wants to know how to add a $ sign into any item/subitem in Listview. Did try to add colour,BUT, there is a BUG in VS. you can code for differant colours in subitems,BUT … ![]() |
Hi all, I'm brand new to daniweb and fairly new to vb.net and am trying to get my head wrapped around looping through an XML file to create toolstrip buttons in VS 2013 vb.net. i have searched all over google and youtube and now im totally confused. I'd like to … | |
is it necessary to close, dispose or otherwise close an XML document after loading it as an Xelement? example: Dim xmldoc As XElement = XElement.Load(xPath) im transitioning from using streamreader and ini files into using XML and im not sure if I need to worry about freeing up resources etc.. … | |
![]() | HI again, I would like to know how i would use a loop for the following code, thanks for read this. LV1.Columns.Add(ds.Tables(0).Columns(0).ColumnName, 25) LV1.Columns.Add(ds.Tables(0).Columns(1).ColumnName, 75) LV1.Columns.Add(ds.Tables(0).Columns(2).ColumnName, 75) LV1.Columns.Add(ds.Tables(0).Columns(3).ColumnName) LV1.Columns.Add(ds.Tables(0).Columns(4).ColumnName) LV1.Columns.Add(ds.Tables(0).Columns(5).ColumnName, 75) LV1.Columns.Add(ds.Tables(0).Columns(6).ColumnName, 75) LV1.Columns.Add(ds.Tables(0).Columns(7).ColumnName, 75) LV1.Columns.Add(ds.Tables(0).Columns(8).ColumnName, 75) LVitem.Text = dt.Rows(0).Item(0).ToString LVitem.SubItems.Add(dt.Rows(0).Item(1).ToString) LVitem.SubItems.Add(dt.Rows(0).Item(2).ToString) LVitem.SubItems.Add(dt.Rows(0).Item(3).ToString) LVitem.SubItems.Add(dt.Rows(0).Item(4).ToString) LVitem.SubItems.Add(dt.Rows(0).Item(5).ToString) LVitem.SubItems.Add(dt.Rows(0).Item(6).ToString) LVitem.SubItems.Add(dt.Rows(0).Item(7).ToString) LVitem.SubItems.Add(dt.Rows(0).Item(8).ToString) i was … ![]() |
I am trying to sum a field in my MS Access database that I long ago stored as a string. I was using dbCommand.CommandText = "SELECT SUM(SubTotal) FROM Glasses WHERE OrderDate >= #" & SearchDateStart & "# AND OrderDate <= #" & SearchDateEnd & "#" and this would work for … | |
please i need urgent help on how save a form as pdf in vb10, all the code and seeing are c# and i dont understand them. i meean, if i run a program i will press save on the form that i am an save it as pdf to my … | |
Can you help me to add Next and Previous Buttons to this code please: Imports System.Data.SqlClient Public Class Form1 Dim id As Integer = 0 Dim idindex = 0 Dim command As SqlCommand Dim adapter As SqlDataAdapter Dim builder As SqlCommandBuilder Dim ds As DataSet Dim table As DataTable Dim … | |
i have done a project is a web browser uses a sql server 2008 as a back end so i want make setup file for that project to work in a computer that has'nt sql server , in onother word i want bind my database with the project and make … | |
I got some issues with Syntax error for my insert statement. I can read access database without any issues. I tried to put in all data as simple string but still not working. Executing in Access works fine though. Please help. cmd.CommandText = "INSERT INTO POSITION (positionID,stockSymbol,stockName,cashTransaction,lastUpdate,initialQuantity,initialValue,currentQuantity,currentValue,positionStatus) VALUES ('2','2','2','2','2','2','2','2','2','2')" cmd.ExecuteNonQuery() | |
Hi I have below code to save pdf file in sql. but getting error **"Cannot Bulk Load. The File "D:\xyz.pdf" does not exist."** Private Sub ButBouncePdfAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButBouncePdfAdd.Click Try If TxtRefNo.Text <> "" Then OpenFileDialog1.InitialDirectory = "d:\" OpenFileDialog1.Title = "Select PDF File" OpenFileDialog1.Filter … | |
Hello Daniweb Community, I'm wanting to slice a square image into 9 pieces like below  the code I'm currently using is this Private Function CropBitmap(ByRef bmp As Bitmap, ByVal cropX As Integer, ByVal cropY As Integer, ByVal cropWidth As Integer, ByVal cropHeight As Integer) As Bitmap Dim rect … | |
Hi, I've been working on a project when suddenly an error occured when I clicked a control and shows a error picture on the control. I'ved attached a picture for reference. I continued working ignoring the error which led me to my previous problem which is still unsolved [Unusual behavious … | |
Hello once again! I have searched in vain for a solution to this issue however, any threads that I've seen online were regarding copying a specific state of a dynamic image and were unresolved...or were more like what I was looking for and it was unresolved. My current form uses … | |
Hi all, I am trying to add a textbox in a child form as a node in a TreeView on a parent form. Any suggestions for implementing this bit of functionality? Thanks for any suggestions | |
In the good old days of VB6 I used to use this technique to communnicate between programmes, without using external files. In fact I could even set off the textbox interupt in the running programme so as it could do something once triggered. This being said, I can't get it … | |
I'm currently writing a trivia game for someone in VB.net (will follow similar pattern to TriviaCrack). My question is, what is the best way to contain the questions to have them display in a multiple choice fashion on the screen and their sequence to be randomized? Right now, I am … | |
Hi, I have two computers (Desktop and laptop), The desktop is my office computer and I have been using it for my application development(Visual basic). I have Visual studio 2013 and SQL Server 2014 installed on both computers. I exported the database from my desktop computer to the laptop and … | |
Hi, I think this is a simple problem maybe on settings, I dont know but when I select a control in any form , even the form itself it doesn't look selected. What i mean is usual behaviour should show like square or dots around the control when we select … | |
Hi there I'm creating an invoice generator program, first the user must enter the number of products to diplay on a pdf file, below are my codes. My proble is, this if statement does not run as expected Private Sub Add_New_Order_Item_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load … |
The End.