20,285 Topics

Member Avatar for
Member Avatar for kayecng

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 …

Member Avatar for kayecng
0
261
Member Avatar for cudawella

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 …

Member Avatar for cudawella
0
8K
Member Avatar for OiAmbut

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 …

Member Avatar for Reverend Jim
0
67
Member Avatar for Juninho_1

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 …

Member Avatar for Reverend Jim
0
171
Member Avatar for vijaycare

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 …

Member Avatar for vijaycare
0
185
Member Avatar for Papa_Don

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 …

Member Avatar for Minimalist
0
321
Member Avatar for westsiderailway

Hi There, here is a form from my VS2013C Project ![Texting_Form.jpg](/attachments/large/4/0f3a409637419f1390baf300f584d929.jpg "align-center") 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.? …

Member Avatar for westsiderailway
0
181
Member Avatar for Nirav Vasoya

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 …

Member Avatar for Santanu.Das
0
137
Member Avatar for Mr.M

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 …

Member Avatar for Minimalist
0
267
Member Avatar for Nebil

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 …

Member Avatar for tarunap
0
243
Member Avatar for westsiderailway

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 …

Member Avatar for westsiderailway
0
260
Member Avatar for westsiderailway

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 …

Member Avatar for westsiderailway
0
463
Member Avatar for vapor162

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 …

Member Avatar for Reverend Jim
0
344
Member Avatar for vapor162

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.. …

Member Avatar for cgeier
0
2K
Member Avatar for westsiderailway

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 …

Member Avatar for westsiderailway
0
4K
Member Avatar for mikeybware

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 …

Member Avatar for kevoxo
0
230
Member Avatar for Abdullahi_1

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 …

Member Avatar for Lethugs
0
188
Member Avatar for Aref_1

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 …

Member Avatar for mikeybware
0
488
Member Avatar for scomx

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 …

Member Avatar for mikeybware
0
692
Member Avatar for John_88

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()

Member Avatar for Begginnerdev
0
333
Member Avatar for PM312

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 …

Member Avatar for Reverend Jim
0
582
Member Avatar for joshl_1995

Hello Daniweb Community, I'm wanting to slice a square image into 9 pieces like below ![Image_Grid_Expected.png](/attachments/small/3/92037daf6101645e42f7718c3f4ccf65.png "align-center") 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 …

Member Avatar for joshl_1995
0
1K
Member Avatar for Lethugs

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 …

Member Avatar for Lethugs
0
248
Member Avatar for weekendrockstar

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 …

Member Avatar for weekendrockstar
0
594
Member Avatar for AnandK

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

Member Avatar for Reverend Jim
0
63
Member Avatar for UKnod

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 …

Member Avatar for UKnod
0
284
Member Avatar for CaffeineCoder

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 …

Member Avatar for DaveAmour
0
191
Member Avatar for Mike_25

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 …

Member Avatar for Minimalist
0
221
Member Avatar for Lethugs

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 …

Member Avatar for Lethugs
0
300
Member Avatar for tshukela.george

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 …

Member Avatar for tshukela.george
0
290

The End.