- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 6
- Posts with Upvotes
- 5
- Upvoting Members
- 4
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
I started coding at the age of 17 as a hobbie, I enjoyed it so much that I decided to go and study it part time while I'm working.When my studies were done my company apponted me into the optimisation department were it is my responsibility to design…
- Interests
- Work and Coding takes up most of my time.
20 Posted Topics
 | First create a "insert" command. [code] Dim dbInsert As New OleDb.OleDbCommand dbInsert.CommandType = CommandType.Text dbInsert.Connection = con [/code] Then create the parameters for your insert function. [code] dbInsert.Parameters.Add(dbInsert.CreateParameter).ParameterName = "JobId" dbInsert.Parameters.Add(dbInsert.CreateParameter).ParameterName = "ElecId" dbInsert.Parameters.Add(dbInsert.CreateParameter).ParameterName = "CustId" dbInsert.Parameters.Add(dbInsert.CreateParameter).ParameterName = "Price" dbInsert.Parameters.Add(dbInsert.CreateParameter).ParameterName = "Date" dbInsert.Parameters.Add(dbInsert.CreateParameter).ParameterName = "Time" dbInsert.Parameters.Add(dbInsert.CreateParameter).ParameterName = "Paid" dbInsert.CommandText = … |
| | Hi I would like to know if anybody could help me insert records into a MS access database with VB.net, I'm actually a c# programmer and I have never worked with databases before, I got as far as connecting but as soon as I want to add a record I … |
| | There is a simple way to do this but there is a access security issue. Since most of your processes run from the windows system folder the access will be denied as soon as you try to get the path, but here is the code anyways to add all the … |
| | How do I find the number of USB ports available, and what their references are. Example there are 6 USB ports on my motherboard what code would I use to find their reference like, port 1 is called 0 and port 2 is called 1. I want a user to …  |
 | That is because your Form1 is your applications main form. Rather just hide form1 [CODE] Me.Hide() [/CODE] Hope this helps. |
| | Hi First I must inform you that MS Access only supports Windows Bitmap (.bmp) and Device Independent Bitmap (.dib) images. and Second . . . . . . Well here you go :twisted: [CODE] Dim DatabaseConnection As New OleDbConnection Dim DatabaseCommand As OleDbCommand DatabaseConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\YourDBFile.mdb;User Id=YourUsername;Password=YourPassword;" DatabaseConnection.Open() DatabaseCommand … |
| | What you need to do is clear your dataset and refill it using your adapter, this will insure that the new/changed records/info are displayed rather than the original records/info. [CODE] 'dbAdapter is my adapter 'dbDataset is my dataset 'dbTable is my table object 'dbConnect is my Database Connection Dim sql … |
| | Please see the following thread I have a whole post there that explains saving data to your database. [url]http://www.daniweb.com/software-development/vbnet/threads/347379[/url] Note: If you want to reply, reply to the current thread and not the old one. Hope it helps. |
| | Re: video chat bot a Chat bot with video, that would be awesome!!! But I don't think that would be a easy task in vb.net. I would suggest using .gif files that represent emotions regarding what answer is given by your bot. Most of the Chat bots I've seen are Console applications that doesn't … |
| | Hello With all the SDKs' I worked with over the years it should be as easy as using the the COM component that you receive with the SDK. Here is a Microsoft site with detailed info on your SDK. [url]http://www.nextup.com/sapi5doc/Getting_Started.htm[/url] PS. Multi language text to speech will probably be no … |
| | Before using the following code insure that all your variables are declared. I'm only supplying the actual code that deletes the record from your database. [CODE] dbAdapter = New OleDb.OleDbDataAdapter(sql, dbConnect.ConnectionString) dbAdapter.Fill(dbDataset, "TableNameHere") dbTable = dbDataset.Tables("TableNameHere") Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click For Each …  |
| | First declare your forms in your main form public class. [CODE] Dim showForm2 As New Form2 Dim showForm3 As New Form3 [/CODE] Then in your button click event set your if statements to show which form you need. [CODE] If RadioButton1.Checked = True Then showForm2.Show() End If If RadioButton2.Checked = … |
| | Re: TabControl I tested the code and as far as I can tell it does what you want it to do. [CODE] Private Sub TabControl1_DrawItem(ByVal sender As Object, ByVal e As System.Windows.Forms.DrawItemEventArgs) Handles TabControl1.DrawItem 'Firstly we'll define some parameters. Dim CurrentTab As TabPage = TabControl1.TabPages(e.Index) Dim ItemRect As Rectangle = TabControl1.GetTabRect(e.Index) Dim … |
| | Rather than going the root of "cleaning" the sheet just get the info that is needed, which is possible without cleaning the sheet if you use some crafty coding. Since you know where all the info is on the sheet create the variables you'll need (preferable all strings) allocate their … |
 | You’ll definitely need a SDK and an encoder package, Visual studios or any other coding platform for that matter doesn’t have these required components from the get-go. If you are using Visual studios I would suggest using Microsoft certified products. So I would suggest the following "Microsoft Expression Encoder 4 … |
| | Remember the "Imports" at the start of your code. [code=vb] Imports Excel = Microsoft.Office.Interop.Excel [/code] The code you published does not seem like the easiest way or even the standard to do what you want to do. Try the following. [code=vb] Dim excelOutputFile As String = "C:\MyExcelDir\MyExcelFile.xls" If Not Directory.Exists("C:\MyExcelDir\") … |
| | Hi I hope this helps, First setup your database commands. [CODE]Dim dbInsert As New OleDb.OleDbCommand Dim dbConnect As New OleDb.OleDbConnection[/CODE] Setup your parameters and values that needs to go to the database. "NameSurname" "EmpNum" "Job" is Your Column names in the table and the textboxes are their values. [CODE]dbInsert.Parameters.Add(dbInsert.CreateParameter).ParameterName = … |
| | Here is a little tutorial. [CODE]Imports System.Data.OleDb[/CODE] First setup your Database connection. Put the next bit of code in your Form's Public class [CODE]Dim dbInsert As New OleDb.OleDbCommand Dim dbConnect As New OleDb.OleDbConnection[/CODE] Put the next bit of code in your Form Load Private Sub [CODE]Try dbConnect.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source … |
| | Hi Check out this thread, I solved a similar problem but I used a Dataset filled from my actual access database. the diffrence between our apps are that you want to verify access via userName and Password and mine just reads the CurrentUser.ToString to verify access. [url]http://www.daniweb.com/forums/thread305822.html[/url] Hope it helps. |
| | Hi everyone Could someone please help me, I need to loop through all the records in a column in my access database, Currently my program only views the first record in the column and does not go any further, I tried a While loop but I get a NullException error … |
The End.