Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
100% Quality Score
Upvotes Received
5
Posts with Upvotes
5
Upvoting Members
5
Downvotes Received
0
Posts with Downvotes
0
Downvoting Members
0
2 Commented Posts
0 Endorsements
Ranked #718
~34.4K People Reached
Favorite Tags
Member Avatar for Mike Askew

I am currently creating a product lookup system for a project of mine, however from reading around it has come to my attention that an OLEDB connection will not handle the SQL query below as it will not handle more than a simple "SELECT, FROM". Table: tbl_ProductInformation Field: Product_Name CurrentEntry …

Member Avatar for Carmelo_1
0
13K
Member Avatar for Clocker

Hi guys i am trying to save information in to my access database , i created new instance of an ADODB.Connection object and ADODB.Recordset object but visual studio 2005 is given me an error message that ADODB.connection and ADODB.Recordset are defined, please can any one help this is my code …

Member Avatar for chilaka2
0
5K
Member Avatar for markdean.expres

I would like to create a textbox (search engine) that can search for items in a database that contains text as that keyed in the textbox. I am already aware of this code: bindingsource.filter = "table Like '" & textbox & "%'" EX: what I want is that when I …

Member Avatar for markdean.expres
0
108
Member Avatar for mikejs

Hi I am using the following to get the system sound question but it doesn't populate ? [CODE] Public Class SystemSoundItem Dim sound As SystemSound, soundName As String End Class Public Property SoundToPlay As SystemSound Set(ByVal value As SystemSound) End Set Get SoundToPlay = SystemSounds.Question End Get End Property[/CODE]

Member Avatar for mikejs
0
245
Member Avatar for Saurabhvyas9

Hi Friends, This is the code i wrote in order to First open a csv file as excel, then find the required three columns, n then read data from them n save the data into another variables showing them in textbox. As about the csv file, it contains many columns …

Member Avatar for Deepak Shitole
0
1K
Member Avatar for cyberdaemon

Good day.. I'm having problem on how to store or create a table on my database using vb.net i'm having hard time to create a table on my existing dbase here my code; coould you tell me what's wrong!!! Dim ntable As OleDb.OleDbDataAdapter Dim mtable As New DataTable con.ConnectionString = …

Member Avatar for cyberdaemon
0
3K
Member Avatar for chocoprincess

the path is correct, and there is no error, but still, my database is empty... Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim myConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Along\Documents\Visual Studio 2008\Projects\LCRS\LCRS\Lcrsd.mdb;") Dim myCommand As OleDbCommand Dim mySQLString As String Try myConnection.Open() mySQLString = "INSERT INTO REKOD_PELAJAR …

Member Avatar for deepakmjoshi
0
109
Member Avatar for olegb

Can someone help...this used to be so easy in C++ and VB6 :) I am dynamically creating multiple instances of a fairly simple class, tracking them via the Collections class in vb.net. I loop through the collection if I need to get to a particular instance to set some property, …

Member Avatar for crapulency
0
1K
Member Avatar for ryan311

[CODE] ryan = "Select A.*, B.* from training as A, participant as B where B.partname = '" & TextBox1.Text & "' and A.traincode = 'B.traincode'" rs1.CursorLocation = ADODB.CursorLocationEnum.adUseClient rs1.Open(ryan, cn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic) Form11.ListView1.Items.Clear() Dim AddItem As ListViewItem Do While Not rs1.EOF AddItem = New ListViewItem(rs1.Fields!traincode.Value.ToString) AddItem.SubItems.Add(rs1.B.Fields!title.Value) AddItem.SubItems.Add(rs1.Fields!venue.Value) AddItem.SubItems.Add(rs1.Fields!sdate.Value & "-" …

Member Avatar for crapulency
0
152
Member Avatar for emaduddeen

Hi Everyone, Can you look at this code because I am sure I'm missing something. I am trying to reset a Dataset. I have a form that has 1 text box and has 2 queries that locate the data. One is by customer ID and the other is by customer …

Member Avatar for crapulency
0
213
Member Avatar for rairai979

Hello, I'm using SQLBulkCopy to import data from a text file. There is a lot of data involved and I would really rather not import it row by row. There seems to be a problem with fields containing both numbers and text. (for example, a phone number '555-1212'). All fields …

Member Avatar for rairai979
0
74
Member Avatar for jlego

Im not familiar with the correct terminology to use with this. I have a form that i need to use in two different projects, and the form can remain identical for each project. I have read that there are code bases in other ides, where i could make a shared …

Member Avatar for jlego
0
182
Member Avatar for Mike Bishop

I have an sql table called Stock with two fields called StockID and StockCode. I want the user to select the stockcode from a combo which in turn populates the stockid for that item into a lable on my form. I have already populated the stockcode into the combo but …

Member Avatar for crapulency
0
166
Member Avatar for ppenno1981

hi guys i have a little problem. I need to access a database using vb.net to create a shortest path solver using vb.net. Say for example the shortest route for a product being sent from london to moscow. I can acess the database but dont know how to sort the …

Member Avatar for crapulency
0
344
Member Avatar for radnam

Hello, I am developing a software which will connect to a SQL SERVER situated at Head Quarters over a VPN connection.But for times when VPN is disconnected I want my applications at the branches to connect to a local Sql Server installed at a local server. Now all the applications …

Member Avatar for crapulency
0
185
Member Avatar for zarulhamdi

hi..is it possible to run SQL query periodically in vb.net? my system should update database B if there is an anamolly happen in database A i just wanna run UPDATE query periodically every 5-10 minutes plz help me

Member Avatar for zarulhamdi
0
2K
Member Avatar for Captain_Jack

I'm creating my second application. I'm not very good at coding. If i make dump mistake please bare with me. I can't get this Progress bar to work, I tried few steps. I'm writing this application to copying the Host file to a folder in desktop for troubleshooting purpose at …

Member Avatar for mrclark
0
260
Member Avatar for edriso

I am new to vb. I am trying to get a value for a textbox from a database according to the selected item in combobox. but i had this ex.message Operator '&' in not defined for string "select*from ......" and type 'dtarowview' Could anyone please tell me what is wrong …

Member Avatar for Netcode
0
144
Member Avatar for eladreznik

issue has to do with the number of rows which I represent The first row in the dB is 0, so to prevent confusions I added 1 to the index so row 0 will be represented as row 1. The issue is that when I scroll down I “gain” a …

Member Avatar for eladreznik
0
87
Member Avatar for Sarama2030

hi guys! it's my first post on vb.net, it's just that u can't develop on windows 7 anymore using vb6, guess we'll just have to get used-huh. i'm developing this procedure using a timer object.the thing is the procedure is not in the timer's event procedure but i want it …

Member Avatar for crapulency
0
345
Member Avatar for emko

Hello, I need some help on making a loop for an Windows Form application. This application takes as input a salesperson gross amount, and determines how many of the salespeople earned salaries in each range ($200 - 299, 300 - 399, and so on). I have to use an array …

Member Avatar for emko
0
170
Member Avatar for Netcode

How can one search for multiple items at once and display the result in a datagrid? for example, i want to search for multiple mobile numbers (in sql server database)at once and display the found numbers and their corresponding names.

Member Avatar for zx1
-1
1K
Member Avatar for Chris Ewe

Hi, appreciate if you can spend few minutes to analyze the problem below and shed some lights. Thanks I would like to Sum up MTD Value and separate by employee ID. I've used SUM(MTD_Value) and Group By Employee_ID but is not work. Thanks [B][U]VB.NET Coding[/U][/B] [code] Dim connetionString As String …

Member Avatar for kvprajapati
0
101
Member Avatar for eladreznik

i am trying to create a nextrow button to work with a bound datagridview the problems i have: 1. the row moves down, but the first row is the one who has the focus (the little black triangle is staying to it's left. 2. i am trying to set a …

Member Avatar for eladreznik
0
91
Member Avatar for Skillzilog

"SELECT * FROM customer where customer_ID LIKE '%" & Trim(TextBox1.Text) & "%'" good day everyone, im having a problem with querrying i want to query from the field customer_ID,customer_Name,customer_MI,customerLname and textbox 1, 2, 3 and 4 i already tried select * from customer where customer id like textbox1.text or customer_name …

Member Avatar for crapulency
0
164
Member Avatar for uzn

This is the error when i try to execute my code "Procedure or function 'Get Customer data' expects parameter '@Name', which was not supplied." [CODE]objCommand.CommandType = CommandType.StoredProcedure objCommand.CommandText = "GetCustomerData" Dim ObjParam1 As New SqlParameter("@Name", SqlDbType.VarChar, 2000) ObjParam1.Value = ID.ToString() Dim da As New SqlDataAdapter(objCommand) Dim dt As New DataTable …

Member Avatar for crapulency
0
162
Member Avatar for dorothy.v

error message: No value given for one or more required parameters. that falls in dr = cmd.ExecuteReader need help Imports System.Data.OleDb Public Class Form1 Dim conn As OleDbConnection Dim cmd As OleDbCommand Dim strSQL As String Dim dr As OleDbDataReader ' Dim ctr As Integer Private Sub Form1_Load(ByVal sender As …

Member Avatar for AndreRet
0
197
Member Avatar for 12345pj

EDIT: Sorry, it is of course Skype4Com. I really appreciate any help I can get, I want to develop a Skype userinterface for dissabled people, it must be a downscaled version of Skype, an easier human interface focused on video connection. I hold a Bachelor degree in electronics Engineering with …

Member Avatar for 12345pj
0
706
Member Avatar for aram25

Hello All I'm new to VB and i need help on how to rename text file with textbox contents. I have a textbox and i would like to make it so once a button is clicked the text file is renamed according to the contents in the textbox. I am …

Member Avatar for aram25
0
632
Member Avatar for styopah

I know similar questions have been answered elsewhere, but they weren't much help to me. I've only been using .NET for about a week so go easy on me! I'm trying to insert data into an MS Access database. Here is my INSERT statement: [CODE] sCmdIns = "INSERT INTO Table1 …

Member Avatar for crapulency
0
83