Right Up Using Ms Reporting In Vb 2010?
Jun 4, 2010Does anyone know were there is a right up using ms reporting in vb 2010. I don't use the server explorer for database its all in the code and I can't figure reporting out.
View 1 RepliesDoes anyone know were there is a right up using ms reporting in vb 2010. I don't use the server explorer for database its all in the code and I can't figure reporting out.
View 1 RepliesI'm new to Visual Basic. I came across a random number generator tutorial. Got it working fine and then I thought, Is there a way to get it to access a database Here's the thing
1. Generate the random number.
2. looks at the database and finds the corresponding id number.
3. Takes the field for that number and enters it into a text field in the program.
So for example the number generated is 32. Then the program looks at the database and looks for id number 32. then takes the text in line 32 and enters it into a textbox in the program.Now I have my database and the program. But just can't seam to figure out how to get the two connected like I want. I have looked and searched but have found nothing like it I am using Visual Basic 2010 and Access 2007.
What is the easiest method of storing data and retrieving it using VB? FYI, I have not used Access before. It will be a movie database that stores title genre, etc. I thought about using a text file but i think thats crude and ran across this site:
View 1 RepliesI use VB in Visual Studio 2008 Pro. I've created a few solutions using the Crystal Reports tools. I found them easy to work with & easy to do things, (export to different formats, refresh reports, write an automated service that ran & saved reports, etc...)Is CR in VB 2010? If so - which version of VS 2010 do you need to buy to get it?OR - is the reporting services in VS a suitable replacement? Is there a viewer / preview like the CR tools? Can you create a standalone app to refresh reports & export them to different formats? Which version of VS 2010 would I need to purchase to get these?At home - I use Win 7 media centre (a fantastic piece of software). Are there any development 'goodies' in Visual Basic 2010 for Win 7 Media Centre?
View 2 RepliesI keep getting this error "Syntax error in INSERT INTO statement." on this line "da.Update(ds, "Llenar")" when i try to update a microsoft access 2003 database with this app.
Code:
1.Imports System.Data
2.Public Class A�adir
3.Dim coneccion As New OleDb.OleDbConnection
[code]....
We are in very critical position. In our orgnizantion our development team using Visual Studion 2010 with sp1 and they are using MVC 3. When they try to insert table or create a new dataset, the visual studion 2010 simply restarted again and again. How to fix this issue. The below are the event log files for the above issue.
[Code]...
I want to do something like this:
Code:
'create a dataset and a table
Dim ds As New DataSet
[code].....
I have a form that when you click a button it begins a query. I want the user to know that they already started a query and they basically need to wait and not hit the button again. To do this I have a list box that has an lbResults.item.add() to it
Code:
Private Sub btnControlKSMS1117Query_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnControlKSMS1117Query.Click
[code]....
I've been using DevExpress and CrystalReports for previous .NET versions. I'm wondering if there are any native reporting controls for .NET 4.0, so I could do away with the 3rd party ones.
View 1 RepliesI need to programmatically add a row to a MS Database.How is this done?
View 2 RepliesI have a problem with my datagrid(I am noob sorry if its simple). The datagrid is binded to a data table. What i want do is when a product is added or an existing one changed then make that one the selected row in the datagrid. The SelectionMode of the DataGrid is set for the whole row.
Here is the code that i am currently using,[code...]
Now as you can see from my code i don't understand how the index can be wrong as the datagrid is binded to a datatable and the indexes would be the same, and i have the current row in the datatable and look for the index in the datatable and stored it as a Integer!
DB/Reporting :: How to run on another computer
View 7 RepliesWhenever I work with applications involving database I have this habit of declaring a global variable that holds reference to a Connection object and keeps it open throughout the lifetime of the application and closes and disposes it accordingly at program exit.I've been doing this since my VB6 days and still doing it now in dotNET. I've read a lot of articles regarding this practice and most of them states that it has great impact on connection pooling. Does this also mean something when my application connects to a database file (i.e. MS Access, flat text files)? Is it true that the DataAdapter and Command objects open and close the connection?
View 2 RepliesI don't actually know if I can use any XML file as a database that I can edit and make some changes to it using vb.net 2008 and save them. Because I'm working aboard a war ship and we have a central automatic system to control all the internal communication using standard telephones. to reprogram the extinctions we used to have a MS DOS program and it's so old and now it's totally lost and not found and after a long searching I have found a file that could maintain the extensions and reprogram the system but it's an XML file.
[Code]...
Basically I have a routine that validates an XML document, here is the code:
[Code]...
If you look at the XSD file you'll see that the element ID is supposed to mandatory in that I have set minoccurs to 1. However when I run the code this doesn't seem to be flagged as an error. Also I get 20 errors like Could not find schema information for the element Employees etc.
I am currently making an old school adventure game for a college project, it uses an Access database (dbGameStats) which has the primary key (gameStatsId) which is an auto number. The main form of the game holds the data bindings, dragged into text boxes, and the various screens of the game are shown over the top of the main form. So on the main form I have highscore and player name text boxes, bound to the corresponding database fields, when running the program, the user enters a name, the highscore field is altered as the game progresses and when the user exist the database is updated using this:
[Code]...
I want to create a report. I have already stored all the query results in their appropriate textboxes. Now that I have all the data I require, do I need to use report viewer?
I haven't connected my database using ADO.net or anything else. Just using code to connect and retrieve data.
Is it appropriate to create a Form and put this data there and arrange it there for printing purposes?
I drawn graphics in picture box that its content is report that i create by myself. then i want to print it.how I print it for more than one pages?
View 1 RepliesWe have a reporting system where in we are getting unexpected results:
1) The size of reports at different time of interval is different?
2) The reports are writen as pdf to a directory. When we have thousand of older unused pdf(which will not get merged) in the directory the Adobe Life Cycle(to murge the PDF) throws error.But when we clear the directory by deleting the old unused pdf, it works fine?
3) Some of the pdf that are rejected by Adobe life cycle may or may not be corrupted. Meaning they may or may not open up with Adobe Reader, manually.
VB2008: use a BindingSource on numerous textbox fields. The form loads ok and all of the binding is working fine. My problem is that I need to set certain form defaults based on the incoming data prior to showing the form. I cannot find a form event that fires after the data is bound, yet before it is displayed. I tried Form_Activated and several more. The bound fields are still showing zero-length strings. This wasn't a problem in VB6. Can anyone point me in the right direction?
View 1 RepliesI'm using Visual Basic 2008 Express Edition. What I have is an Access database that will have several tables. What I want to do is connect to the database, enter the name of a table in a text box and query that table. The code that I have now is: [Code] I'm not sure how to modify this code so that tablename = whatever I type in the text box.
View 5 RepliesI am using SQL server managment express. I have 4 databases in it and got a bug on my computer which I could not get rid of. I saved these to disk and reinstalled windows, I reinstalled SQL server and I am now trying to add my 4 databases. Can any one help me with this, I can add a new database but not an existing.
View 2 RepliesI have working on a project to add details to a database. I'm having trouble with the connection string, the code is as follows:
Code:
Public Function AddContactToDatabase(ByVal sFirstName As String, ByVal sLastName As String, ByVal sAddress1 As String, ByVal sAddress2 As String, ByVal sAddress3 As String, ByVal sAddress4 As String, ByVal dDOB As Date, ByVal sPhone As String)
[Code]......
I have Combobox "Combo5" with a string value selected by the user.
How would I assign that selected value to another variable that I want to use later on or how od I refer to a combobox value that is currently selected?
Im have one heard time trying to get data back from a SP on my SQL server.Here is what I have from looking all over the net to get it working.
Dim conn = New SqlConnection("Data Source=SQLsvr5;Initial Catalog=Orders;Persist Security Info=True;User ID=userx;Password=123123")
conn.Open()
Dim sqlcomm As New SqlCommand
sqlcomm.Connection = conn
[Code]...
[Code]....
Thought I should probably say im using Windows 7 and the 2010 beta Visual studio
Using VB 2008 Express /Using SQL Server Express/Database name is "StopData"/Computer name is "LAPTOP"?Here's what I have.
Code:
Imports System.Data.SqlClient
Public Class frmMain
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code].....
[code] I'm confused with the last line, because cnn.CreateCommand has not been assigned any value ( so it should be empty ). Why would you then assign this (cnn.createcommand) to cmdselect.
View 4 Repliesso i started a program yesterday and after a whole day of tinkering with codes i have realised that something was wrong with my old program and i have started again.
[Code]...
i have the sql code (exported from mysql) as
[Code]...
I have tried multiple times to get string str to = this but it never works? can someone look at it and tell me wat cud be wrong or even better and possibly convert it into the str 4 me or give me an easy way to do it?