I'm using VB.NET and MSSQL 2005 to create an application. I was told I should rather use SQLite as I want my application to be a standalone one with embedded database. Can someone please provide me with a step to step tutorial on how to create a standalone application with an embedded database?
View 2 RepliesI have experience in C++ programming, but never created gui with it so learning vb.net for some quick gui development. and i want to learn vb.net. I can't install visual basic express on computer cause i'm on shared computer and such huge install is not possible on that computer. So i picked up sharpdevelop. After searching most of the tutorial, i found out that most of tutorial written for visual studio IDE for vb and vb.net. I'm trying to learn vb.net in depth from command line to gui programs. Any good recommendation of tutorials, book ? I searched google but very few results so far. I'm looking for good learning tutorials that can help learn with sharpdevelop.any suggestion for tutorial and books that mentions sharpdevelop in their tutorial/guide ?
View 2 RepliesIs there anyone can post a simple code using vb,that start building a simple games ?
View 2 RepliesTrying to make a simple browser with some simple addon's. What Ive done is setup a menu(forum) for the user to enter their email providers web address and it will save it in a xml file. When they click on the email link, it should load the email xml iformation and place that info in the tb_html.text and navigate. I keep getting a null exception and im not sure what going on here. Here is the code:
Browsers:
Private Sub btn_Email_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_Email.Click
'Load Action
Dim SavedEmailObj As Storage
[code].....
I'm wondering if someone can point me towards a good article/tutorial explaining how to use the MVVM pattern in an WPF Application that uses WCF web services. My WPF client calls a service reference to get data objects that contain data from the database but from everything I've seen and read so far about MVVM I am still not clear on how to use MVVM to work with the data objects I am retrieving from the WCF services.
View 1 RepliesI have a SQLite database and I am tyring to query the max value in the RecordID field. This query works when I run it in SQLite but I can not get the VB to return the value, what have I done wrong?
Dim getMaxRecID As String = "SELECT MAX(RecordID) FROM String"
Using cmd1 As New SQLiteCommand(getMaxRecID, pConn)
cmd1.CommandType = CommandType.Text
Dim IDresults As Integer
[code]....
The connection is correctly opening the db, and shows it as open as well. No error, just IDresults returns 0 everytime.
I'm working through the MVC Music Store in Visual Basic ([URL]), trying to convert things as I go. I'm heving trouble with some of the lambda expressions in the Views, however. Specifically, on page 53 when the Album editor template is used, I am not seeing my editor template when I use the following code:
[Code]...
storing values into a database from a ComboBox?
ComboBox 1
=========
Contains Pre-Determined List of Leagues
[code]....
Is propogated with the contents from the database depending on what was chosen in ComboBox 1 and 2.For Example:If a person picked the "Premier League" and "Manchester United", ComboBox 3 would display the members of the Manchester United team. The user could then select a single member of that team and save him as their choice.
VB.NET tutorial for beginners especially for database,
View 4 RepliesCan someone direct me to a waveout example? All I keep finding in searchers is C# language.Just trying to play a .wav file.
View 13 RepliesI have a class named TestClass
[code]...
Form the main form, I call the class. Here is my code:
[code]...
When I call tg.Count from main form, the main form will become not responding. How to prevent my form from not responding. The user can access other menu rather than waiting for the result.
Depending on what i know, SQLite is supported in WP7.1, but i cant even import System.Data.SQLite to the project should i download it as a dll specially for windows phone or am i missing something?!
View 1 RepliesI am writing an app that uses both an SQLite and MySql database. The reason for this before you ask is that it means I can store a local copy of the data onto my user' own machines when they are offline, and then update them to a central server when they are next online.
The problem I have is that when using datasets (on tables created in identical fashion) the itemarray of the mysql database has 9 extra totally blank fields...where as the SQLite itemarray has only the values for the items.
here is a snippet of the code:
CODE:
ultimately I am getting an index size mismatch error but with both tables having the same number of fields this is confusing.
I'm trying to Collect Bids and Distribute the average from a Column I'm getting an InvalidCast Exception: Specified cast is not valid. on the TotalSum +=
Dim sql As String = "SELECT " & Column & " FROM " & Table & " ;"
Dim dt As DataTable = SQLiteDatabase.GetDataTable(sql)
Column = Column.Replace("[", "")
Column = Column.Replace("]", "")
For Each row As DataRow In dt.Rows
[Code]...
i am deleting from an sqlite database using the ids of the records like this the dirID is an array of the IDs Dim i As Integer = 0
[Code]...
the problem is that it dosen't alwasy delete from the database, and its not throwing any errors. Could there be a better way of deleting
I have records from server that I want to copy, so I used datareader to select all, during selection the insert also process. [Code] What is the exact sql statement to insert only if record doesn't exist in my current table? I used some of this code, but a filter was defined: like x. What if I just want to insert records that doesn't exist in the table I want. [Code]
View 1 RepliesI have this records in the table:
username, password, rights, allowance
admin, asdf, admin, 20
john, qwer, user, 10
peter, zxcv, user, 10
I want to select one record at a time
I used:
for i as integer = 1 to sqliteDataReader.FieldCount
dim ss as string = "select * from xtable where recno()=" & Ctr(i)
...
Next
But it doesn't get 1 record at a time.
I have an StackOverflowException in one of my DB functions that I don't know how to deal with. I have a SQLite database with one table "tblEmployees" that holds records for each employees (several thousand posts) and usually this function runs without any problem.
But sometimes after the the function is called a thousand times it breaks with an StackOverflowException at the line "ReturnTable.Load(reader)" with the message: An unhandled exception of type 'System.StackOverflowException' occurred in System.Data.SQLite.dll
If I restart the application it has no problem to continue with the exact same post it last crashed on. I can also make the exactly same DB-call from SQLite Admin at the crash time without no problems.
Here is the code:
[Code]...
When crashes, the reader has "Property evaluation failed." in all values.I assume there is some problem with allocated memory that isn't released correctly, but can't figure out what object it's all about. The DB-connection opens when the DB-class object is created and closes on main form Dispose.
Should I maybe dispose the mycommand object every time in a finally block? But wouldn't that result in a closed DB-connection?
I'm a newbie in programming and visual basic 2008 language.I'm learning to use sqlite database in visual basic 2008, and I got the following tutorial code. The code is working correctly and my question is: what is the meaning of that ! mark in the code. Please point to me where to get more information as I wish to learn more about that. I have Windows Sdk v6.1 installed.
[Code]...
I'm constantly trying to improve my coding abilities. I'm trying to learn the ropes on using .NET Sockets but everything I'm finding it pretty cheesy and doesn't really go over the details of what each piece of the code is about.Can anyone point me to a great tutorial or site where I can get started?
View 2 RepliesI'm looking to get into some of the more advanced features of resharper tamplates. I know just enough to be dangerous by looking at some of the existing templates.
View 1 RepliesI have a very particular application I have developed. I want to create a second appideally in visual basic, that provides a tutorial/ guide on how to use my original app step by step.I imagine PowerPoint slide style images embedded in a simple window with forward & back controls.I have experience in java, C & VB. Ideally the app needs be be kept simple and written in VB. Can anyone recommend a starting point, or if any tutorials for such exist? I've had a search and nothing stands out.
View 1 RepliesAs a measure of emergency I need to prepare a very simple ActiveX object to be used in Excel sheet and VBA.I'm not a hardcore programmer myself but I'm able to put together a code in VBA to get things done. I have no experience compiling ActiveX dll's in VB though.Could anyone point me to a simple tutorial on the web where I could learn steps how to do it in VB? (project type, setting up methods for the control, parameters for compiling the dll so it's recognized as an ActiveX.. etc)The ActiveX object will be very simple - it's a stopwatch:
1. displaying elapsing time, I have it done already in VB as a windows ap.
2. As an object it will be taking only 3 types of methods: start, stop, reset
3. it has to be a proper ActiveX, so I can use "insert ActiveX" in Excel to add it to the sheet and the code.
I guess I have to start with creating a 'class library' project, haven't I ?
find tutorial on vb.net using sql server as database? using code's
View 1 RepliesCan i get any best tutorial/Book/site to learn ADO.Net
View 1 Replieshow can i make a ddos program does someone have a tutorial on this?
View 2 RepliesWhere can i find some good user control tutorial's for beginners?
View 11 RepliesI am looking for a tutorial for making reports with Visual Studio 2008. I have a VB.Net app using hard coded MySQL statements and variables from different parts of the program, mostly the server as I have the same app with options to connect to different servers with the same back end structure (different data unique). As far as i know I can not use data sets (I think thats the name for them) as that would mean one program for one location.
View 4 RepliesI am rather familiar with the ins and outs of VB.NET and Database Selects, Updates and Inserts. Not so good with Transactions. (Oracle, MSSQL)
for example, take a Billing System for a hardware store.I create a 'New Order' and select the Cash Customer I start adding items to this order. 1 Rake 1 Shovel Where do I store this information (temporarily) until the user hits 'SAVE'. Maybe the customer decides they don't want the items. Too expensive. I just EXIT. nothign to do.
Or - I open an existing order and make a bunch of changes. Where do I put these changes until the user hits SAVE. I am sure transactions might have something to do with this - or temporary somethings??? I just don't know and need some guidance.
I need a simple embedded database for a relatively small database size (< 100MB, but in most cases < 20MB) and maximum 1-2 concurrent users/connections on average. It must be able to protect/encrypt it's data with a login.
View 4 Replies