I signed up for a free 30 of Azure. I logged in, created a database. I am able to connect (=Test Connectivity). But that's it. I don't see anyway to create tables, etc. Also how can I connect this db to vb.net (I am using vs.net 2010)?
View 3 Replies
I am using VS2008 and SQLite. I have created a database and several tables and am attempting to populate the tables with data from arrays.
The following code (example) works fine but stops after it inserts 30 to 50 records. I am running the VB code in debug mode and when it stops, I press pause to see where it is. It stops on "SQLcommand.ExecuteNonQuery()" and when I press continue (F5) it will insert another 30 to 50 records.
I do not get an error message. Is this a timeout issue? How do I keep the loop running to the end of the array?
Following is example code.
Dim
SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLiteCommand
CODE:.....................
I have used VB (versions 2 - 6) through many years; however, I am crash-course training myself into the VB2008 / VB2010 world kicking a screaming. I would like suggestions as to what SQL database access method should I focus more on in my learning process without making me feel that I'm a million years behind. I know I have WinForms where I can create a datasourse and drag / drop fields or tables on a form to create a grid (not really what I'm looking for).
My trouble isn't so much designing the form but in how I access the database. Theres XML, LINQ to SQL, ADO.NET, and many other methods. Not only do I need to grasp these methods quickly but I also need to know what type of projects I should create. What I mean is...I was thinking that I would design a WinForm app; however, I see that there are WPF apps and others to chose from. This is getting deep. I know it depends on the project that I'm working on. My plans are to write an app based off of either an SQL Express 2008 or SQL Server 2008 database. This first app will be standalone for now but may later become multi-user. I know I'm far behind on my learning curve coming from VB6. I have read a bit on VB2005 / 2008 / 2010. I own
both VB2008 and VB2010. I use VB2008 at work. I know ADO.NET is still alive but by what I read online, it's a dying method and is only kept for backward compatibility. XML and LINQ to SQL and other methods are all pretty new to me.
I want to split this up into 3 side by side tables but have been unsuccessful in any of my attempts. Currently it prints one large table. The reader.Read is performing a really simple query that pulls a few names from a table.
Dim htmlString As String = "<table>"
While reader.Read()
htmlString = htmlString + "<tr><td>" + reader(1) + " " + reader(4) + "</td></tr>"
End While
[code].....
Possible to create new tables in my database at runtime. What components will I have to use?
View 2 RepliesI have two forms receipt and payment. Both are having almost same fields.e.g. entryno, date , partyname, amount. Should I create two different tables for receipt and payment or keep data in single table with additional field 'TransactionType'
View 3 RepliesI am using Access DB.I want to create Temp Tables in My DB.What is the Syntax for Crate Temp tables in VB.NET??
View 5 RepliesIs it possible to create temporary tables in MS ACCESS using VB.NET?
View 3 RepliesI install Visual Studio 2008 Professional Edition and I don't see on the templates the Data Form Wizard...
how can I install the template?
I want to used to create windows forms from my tables.
I have an XML file that has a basic hierarchical structure about horse racing. It has a summary of the tracks, some data about each track, then a list of all the races at each track racing that day. So lets say there are 10 tracks, and for each track there are 8 races. This is a snapshot of the data....
HTML
-<Meetings xmlns="" Jurisdiction="VIC">
-<Summary MID="MR_20110801">
<VenueName>ECHUCA (VIC)</VenueName>
<Type>R</Type>
<Events>10</Events>
<Track>DEAD </Track>
[Code] ......
I have written the code to pull down the data into a data store, but I dont know the BEST way to put the data into a set of tables. My first thought was to traverse the nodes and add rows into tables but I figure there must be a native VB process that reads the xml and puts it into the the appropriate table. How to code up the process for getting the data into a set of tables that match the xml. So lets say I have a Summary table, I would like all the data about each track to go into that table. Then I would have a Races table and have the data for each race go into that. What I have done already is import the xml into Access to create the tables (which was a breeze!) and then link that data source to my project. So I have the tables already built.
Im trying to create a form in VB that allows the user to perform queries on a number of tables which are in access.
View 3 RepliesI am very familiar with VBA and have been using access and excel to create applications that connect using ADO and/or linked tables.I'm looking to start developing simple Windows applications for my company using Visual Basic, that will connect to Oracle and SQL Server Databases using ADO. What do I need to accomplish this? If I purchase Visual Studio 2008 Pro, will it come with VB? And do I need anything in addition to this in order to connect to SQL or Oracle databases using ADO method?
View 7 RepliesThis is the code I'm using:
Dim conn As MySqlConnection
conn = New MySQLConnection()
conn.ConnectionString = "server=domain.com; user id=user; password=password; database=dbname"
[Code].....
So how can I create the tables for the username and password field?
is it possible to create typed data set tables dynamically or modify columns and the data types of an existing table. what i'm trying to achieve is to read the sqlString from an external file and populate a typed dataset table in order to use it as a crystal report data source.
View 3 RepliesA suite of apps will be using various tables out of the same sql server database.Regardless of which app is being used, the database structure must stay current. (ie:contain all the tables/fields to run any/all of the apps)So, when the user starts any of the apps, it needs to check the database, for the existence of all the tables and fields it needs, then update if necessary.
View 1 RepliesI am a newbee at this but I have a general question about datasets.Most of the help I have read and the videos that I have watched when a dataset is created it is created for a given table.Take the northwinds database.When a dataset is created in vb2008 in the video it creates a dataset for the Customer table and a seperarte dataset for the Orders table and a serperate dataset for the OrderHdr/OrderDtl.Is it better to do it this way or is it better to create one dataset named NorthDataSet and have all of the tables defined in it?What are the pros and cons to doing it both ways.Is there something I can read to help me decide which way to go?I have a large project that is being changed from VB6 and ACCESS to VB2008 and Sql Server.The database has around 300 tables in it.
View 1 RepliesI have trying to create a database that uses object dependencies for five different related tables.
View 1 RepliesI have a requirement to create n Access 2007 database & some related tables from my application at runtime.
I used to be able to do this ages ago in VB5 but having difficulties doing it in VS (VB) 2010.
I've recently created a MVC 3 ASP.net application (using VB). I have also created forms validation by running aspnet_regsql. I used this to create the table in the same database as my application uses. I am trying to work out how to create a new model, with a FK from the Users table. Do I have to reverse engineer the validation tables to create models in my application? right now, the tables only exist on the SQL 2008 database, as they were created by running the aspnet_regsql command, and do not exists as models in my ASP.net solution. Here is the code I have now, for a model I would like to add a FK to (as a one-to-many relationship):
Imports System.Data.Entity
Imports System.ComponentModel
Imports System.ComponentModel.DataAnnotations
[Code]....
I need some expert help in achieving this task. I have an xml file which will be emailed to me everyday. I need to loop through the xml and create tables in a database based on the xml nodes and their attributes. looking at the following xml fragment for example: Code:
So based on the above xml, I would have to create a Shipment table as a Parent with fields like ShipmentIdentifier. Then I would have to create an Event table with the ShipmentID as a foreign key and fields like Source, Code. Basically a field for each node. Then if there are columns in the table that are new, I would have to modify the table and add the column. I only have to create tables where there are child nodes or where the nodes have attributes.
My project is about recipes. I want to automatically create table inside in mysql database when I hit the add button on my project through codes. First is when I input recipe name in the textbox1 then my input will be saved in the recipes table under recipe name column and also create a new table through codes on what i input in the textbox1
Example of my database in sql
texbox1 input will be save here
recipes - id, recipename
And then it will also automatically create a new table in mysql database, create newtable, with id, quantity ,unit, ingredients
Private Sub iadd()
Dim command As New MySqlCommand("insert into recipes (recipename) values ('" & TextBox1.Text & "')", connection)
Try
connection.Close()
connection.Open()
command.ExecuteNonQuery()
[Code] .....
i have a few questions about seting up a form.when you creat a new for open the dataset drag and drop the tables to form it creates a top menu bar with pages plus sign and x and save.now when you run the app you need to press the plus sign to add data in the database..is there a way to make it that you dont need to press the plus sign?
View 3 Repliesi need to create sql tables based on user needs lets say a guy needs a table of 4 rows 5 columns other user needs 3 rows 3 columns each with different types so how is the best way for letting them choose like they write in a text box ( this will be the value of rows)4 and another text bvox the count of columns and i have those 2( rows and columns needed) numbers i create the table as is.based on those. by default i create type as varchar max then later on we must fill the table using datagrid.
View 14 RepliesI've been into programming, I've landed a job with a local company, the entire project the gentleman is paying me to do is incredibly easy, with one hitch, the original project I'm converting is built using access databases, for efficiency, and easier online transfer, I'm wanting to switch to using an SQL database, I've got plenty of experience inserting, modifying, and controlling an access database, but where should I start to learn how to essentially set up, create tables, and modify data within an SQL database?
View 5 RepliesPlease anybody help about how to create two dynamic combo box. Like Country and province.. when I select country conutry Combo box then Province Combo box automatically show same country province.[code]
View 5 RepliesI have a class that add extra information about a column for linq2sql (see code below) right now, I have to explicitly tell what column I want that info on, how would you put that code with a loop on every column in every table from a dbml file? I was doing my test on a very very small DB, now I have to implement it on a much more bigger database and I really don't want to do it manually for every tables/columns it will take hours.
how it's being used:
Partial Class Contact ''contact is a table inside a dbml file.
Private _ContactIDColumn As ExtraColumnInfo
Private _ContactNameColumn As ExtraColumnInfo
Private _ContactEmailColumn As ExtraColumnInfo
[Code]....
have a datagridview containing 2 tables left joined, so that:table1 LEFT JOIN table 2 ON table1.id=table2.idI get an error whenever I try to edit my datagridview."invalidOperationException was unhandled by the user codeDynamic SQL generation is not supported against multiple base tables."The error points to this line:
da.FillSchema(dt, SchemaType.Mapped)
da.Update(dt) << This line
'da = dataadapter
[code].....
In my datagridview I was fill in using join tables (table1 = pr_employees, table2 = pr_employee_deduction). My problem now is during save button I want to update records from table2 only.[code]
View 3 RepliesWe are presently developing an application, let's call it APP1, which uses a SQL Database which have about 800 stored procedures, 600 tables, etc. APP1 was originally created in order to replace another application, APP0, from which we do not have source code but only SQL tables, Stored Procedures, views, etc. Previous programers of APP1 used some DB objects from this same database and added some other objects specific to APP1 because it becomes bigger than APP0. And we do not need APP0 anymore as APP1 does all what we want, and more.
So, now, we are thinking about a way to find out which objects are used by APP1 in order to remove objects which are ONLY used by APP0.What is the best approach to discover all objects used by APP1 without having to open every single class and form?
Once we will have a complete list of these objects, it will be easy to use a program we bought which detects all dependencies for all SQL Objects specified directly from SQL and remove objects which do not return from any dependencies. Any ideas of how I could get this list without having to go through all our program that have many, many, many classes and forms?
Note : I know, in a perfect world, all calls to PSs and tables should be in a DAL but in the case of the application we're presently working on ... this is not our case! Yippy! (sarcastic yippy) ;)
Note 2 : This application is not using any ORM. So all queries are directly using SqlCommand. So any call to any DB objects are in string format.
I have a 5 tables in my database and i want to access all my tables togather at a time.e.g.I have a code for one table i.e. rs.Open "select * from Group_info", con, adOpenDynamic, adLockBatchOptimistic. instead of Group_info table i want to access 5 tables also as Login_table,User_info table,group_name table etc. How i do that
View 11 Replies
