DB/Reporting :: Program With Microsoft SQL
Jun 5, 2009
I've been programming for quite a while now and started learning about databases and decided to make a program with a database with it. I made a normal log-in system, but then I don't know how to add information into the database or take out.For Ex:Create account button:
- Creates a new string in the 'Accounts' table
- Then the user can login with that information
The main idea is, I want to be able to insert and delete data from a windows form (the log-in system). And check to see the information, like when users login. Please help, I've tried so many things and don't know how to do what I want with Microsoft SQL.
View 2 Replies
ADVERTISEMENT
Jan 1, 2009
I added a parameter to the rdlc called paramTitleThen I tried this as a demo
Code:
Dim params(0) As Microsoft.Reporting.WinForms.ReportParameter
[code]....
View 1 Replies
Mar 2, 2010
It looks like MS have removed support for nested Business Objects in their Report Viewer 2010 companant. We would like to upgrade our web app to make use of the new features, but need to maintain backwards compat for loads of legacy reports.1: We cant put anything in the GAC as we are on a hosted shared web server.2: We are in VB so dont seem to be able to use Aliases (i think a c# feature), so we cannot add the references in VS at all or we get a namespace conflict or reference already exists error.3: The report web componant dll is itself dependant on two other dlls that are also new (e.g. common.dll and processing.dll)4: The report compnant has to run in the main app domain at the moment using ExecuteReportInCurrentAppDomain) as when it accesses the business objects, they check security roles etc and this did not seem to work if the report viewer ran in a different app domain. This can probably be worked around.
View 1 Replies
Apr 1, 2010
Does Visual Basic 2010 have any reporting services, ie, Microsoft Report viewer?
View 6 Replies
Aug 24, 2011
I just upgraded from 2008 to 2010 Visual Studio. I attempted to open a 2008 VB project. I converted just fine, but now I can not open the main form. I get this error: microsoft.reporting.winforms.reportdatasource is not defined.
[Code]...
View 5 Replies
Jul 26, 2010
I've created a VB Console Application Project and am trying to instantiate a Report Viewer object. To my understanding I need to import Microsoft.Reporting.WinForms however Visual Studio does not recognize this name space. Is there some reference I need to add?
View 4 Replies
May 5, 2010
I am using .rdlc Microsoft Reporting reports. I have a form with one reportviewer on it. What I want to use is a combo box where they select the report and then click generate, and it shows a specific report. I have this code so far that changes the report:
[Code]...
View 2 Replies
Sep 20, 2010
I have a program where a lot of the required information for it is stored in text files. I simply read this information into large arrays. However, I don't think it's necessary to load all the information each time. Rather, it would be more efficient if I could simply search through a list of items to find the one I need and then use the data from it, or to find a similar name and use it elsewhere.
Would I be right in using a database? And is database programming done in SQL? I have a book on it telling me to use the SQL Server (IIRC), so I shouldn't be doing it in the VB.NET Express GUI?
Here's an example of what I would do:
Hex = 03 00 => dex number 003
Search in file Pokemon Dex Numbers
003 returns Bulbasaur
Check Bulbasaur base stats in the base stats file
etc
So basically I'm reusing a lot of information. I think a database would be best and it would all be internal right? I'm getting complaints about access denied to a text file (since it's stored in the program directory in the program files).
So to cap up the few questions I have:
-Databases are done in SQL and not inside the GUI?
-Databases would load internally?
-I could search a database without having to load it into like an array or something?
View 2 Replies
Oct 23, 2009
What does this mean? This just started I never had this error.
at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
[code]....
View 4 Replies
Dec 17, 2009
I have an VS2008 VB windows application. I am deploying it via Microsoft .MSI . The target machine parameter is set to x86. When I deploy it to an x64 running XP I receive the following "Microsoft.ACE.Oledb.12.0 Provider is not registered on the local machine". Am I missing something in my setup project to make sure it registers all my components?
View 1 Replies
Oct 12, 2009
How can i add SWF to microsoft VB 2008 Express editon, Sorry if i posted in the wrong place
View 1 Replies
Jan 23, 2011
I need Microsoft Visual Studio: Installer 1.1, where can I download it and why doesn't Microsoft still have it I know someone in IT has it. Then if it can't be downloaded from Microsoft why does this site [url]... still list it as being available for download. Doesn't anyone at Microsoft archive their old software just for the purpose of still having it around. If Bill Gates only knew what Microsoft has become since he drop out the scene he would be disgusted.
View 6 Replies
Feb 9, 2010
program I am writing needs Microsoft WinStock involved with it. Where do I find it and install it?
View 12 Replies
Sep 13, 2011
We have developed a tool using VB.net and in one screen, we have placed a button - 'Contact Us'.
The business intent of this button is to - send query regarding technical help to our team. Once the user clicks on the Contact Us button, microsoft outlook new mail page should open where the mail ids of our team should be populated by default, the user jus has to type the subject and the body and send across to us.
View 3 Replies
Aug 13, 2010
Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately.
Invalid Argument=Value of '10' is not valid for 'SelectedIndex'.
Parameter name: SelectedIndex.
View 1 Replies
Feb 11, 2010
How can make my form look like microsoft's series of program like word
View 34 Replies
Sep 19, 2011
It might be funny , but I'll ask anyway : is it allowed to create a program with VS2008 while at the same time it will use the Microsoft framework 4.0 ? I am asking because I use VS2008 while at the same time I have the impression that framework 4.0 is "lighter" than 3.5 .
View 7 Replies
Sep 17, 2009
I want to create a windows installer package using visual studio. It is my understanding that there was a simple way to do this in vb6, you could add an installer like you can add a new form.
How can I do this in vb.net? I downloaded and installed the Windows SDK from [url]... because it said somewhere that it could create installer packages and had tools to do so for .net
View 5 Replies
Mar 3, 2010
What is the best way to make a program that works with multiple versions of Microsoft office? I own office 2007, so my program uses the office 2007 com objects. When I try to use my application with office 2003, I get errors related to the com objects. Does Microsoft have com objects that are compatible with multiple versions of office?
View 2 Replies
Dec 28, 2008
These things look about the same to me. Is there any reason I should use one over the other?
View 5 Replies
Nov 27, 2010
What would be the best way to save configuration of a program? for example lets say you have a checkbox and does whatever and you check it and start the program and it should be check or unchecked depending on the setting used.
View 1 Replies
Oct 3, 2009
Connection between program and an remote SQL server. most of the hits were on VB6 and as you might see in the title I use VB.NET 2008, so let's begin:
[Code]...
View 6 Replies
Apr 5, 2009
I have a problem with my (aspx.vb, aspx) program. Since my vb program require more than a day to make some data analysis. however, the page always run a long period(one hours exactly) will be downed and become cant display the page. i am wondering is it related to dns error?
View 3 Replies
Oct 8, 2011
I'm currently doing a project that includes access 2010 My question will be what driver can I use for an access 2010 *.accdb type file? For a *.mdb it works perfectly well with
ConnString ="Driver={Microsoft Access Driver (*.mdb)};Dbq=" & Application.StartupPath & "\CITSDB.mdb;Uid=Admin;Pwd=123;"
But, when I changed the mbd to accdb:
ConnString ="Driver={Microsoft Access Driver (*.accdb)};Dbq=" & Application.StartupPath & "\CITSDB.accdb;Uid=Admin;Pwd=123;"
It resulted in errors:
ERROR[HY000][Microsoft][ODBC Microsoft Access Driver]Could not find file '(unknown)'.
ERROR[IM006][Microsoft][ODBC Driver Manager]SQLSetConnetAttr failed
ERROR[HY000][Microsoft][ODBC Microsoft Access Driver]Could not find file '(unknown)'
And then it shows me that my code for
If dsLogin.Tables(0).Rows.Count = 1 Then
IndexOutOfRangeException was unhandled
Cannot find table 0
I knew it must be the driver but I don't know what accdb driver I can use for the connstring.
View 3 Replies
Jul 20, 2008
how would I go about making the user access different local SQL databases. As in they use a GUI program to access / read / write data in a database but can also use that same GUI program to do the same to multiple database files.Is that sort of setup easy to integrate into a VB program? or does a VB program by nature only try to access one database? To integrate the open and close dialogs into a VB GUI in terms of different database files, is there much involved?
View 10 Replies
Dec 3, 2011
im trying to create this program for tarantula keepers record.im still halfway to its completion.I have MySQL installed on my pc and i used navicat to easily create my database and tables.I exported it as MSAccess file to my Projects folder.I used datagridview to display my data. it works fine on that part but when i close my program and reopen it, my data are not saved and no change has been made to my database.Here's some part of my code:
Dim dbdataadapter As New OleDb.OleDbDataAdapter
Dim sql As String
Dim dbprovider As String
Dim dbsource As String
[code]....
View 2 Replies
Sep 17, 2010
this would be my first post and usually I can figure these problems out, but I am stumped so badly right now, I am writing code to write into a .mdb file, my program uses two login forms, the first reads the data base, and sees if the user name and password is correct. I got that working, my second login form is used for creating an account. This is where I am getting stuck, I have followed and looked for tutorials and I found nothing, my DB is simple, its one table, and two input fields called "Userid" and "password" this is my code to write a new account into these fields
[Code]...
View 13 Replies
Feb 17, 2009
I'm writing a program in VB.Net and loading the info into a SQL database. Debugging it works fine on my machine that I am programming it on, it connects to the database and runs through all the info perfectly. However trying to get it to run on another machine it will not connect to the database. I realize the reason for this is the connection string, it's looking specifically at the file directory for the database. How do I change this so that it will function on any machine. The program is only intended to run on one machine at a time and not over the internet.
View 2 Replies
Aug 7, 2009
I have a database with one table.I'd like to populate an array with the values in the table so that I can work with the data.How do I copy the data from the table to the array?I am able to view the data with a DataGridView but can't find any info on extracting the data to an array or variable.
View 2 Replies
Dec 7, 2011
I have an error ERROR [22018] [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. and I've been trying to solve this but unfortunately I couldn't get the hack of this error. I'm a newbie in dotNet.
Public Sub LogInContinue(ByVal senter As Object, ByVal e As EventArgs)
Dim LibDS As DataSet = New DataSet
Dim LibDA As OdbcDataAdapter = New OdbcDataAdapter("SELECT * FROM tblUserAccount WHERE Uname='" & txtUserName.Text & "'", LibConn)
[code]......
View 2 Replies
