- Upvotes Received
- 5
- Posts with Upvotes
- 5
- Upvoting Members
- 5
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
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 … |
|
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 … |
|
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 … |
|
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] |
|
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 … |
|
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 = … |
|
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 … |
|
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, … |
|
[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 & "-" … |
|
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 … |
|
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 … |
|
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 … |
|
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 … |
|
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 … |
|
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 … |
|
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 |
|
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 … |
|
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 … |
|
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 … |
|
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 … |
|
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 … |
|
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. |
|
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 … |
|
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 … |
|
"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 … |
|
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 … |
|
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 … |
|
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 … |
|
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 … |
|
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 … |