Removing Unwanted Reports Stored In Database

Oct 7, 2010

I have developed a VB .net application which uses SQL CE as its database engine. It works great so far. I recently added a section to remove unwanted reports which are stored in the database. The app correctly pulls ReportIDs from the table, which the user can select. The program will then delete the records based on the ReportID from the database. I know this records because, for testing purposes, message boxes inform the user of how many records where collected.

Dim SQLDeleteData As String = "DELETE FROM ReportData WHERE (TableID = @ID)"
Dim Con As New SqlCeConnection(DataBaseCon)
Dim DeleteData As New SqlCeCommand(SQLDeleteData, Con)
Dim ReportDelete As Integer = -1
DeleteData.Parameters.Add("@ID", SqlDbType.Int).Value = CInt(ListView1.SelectedItems(0).Text)
noOfDeleted = DeleteData.ExecuteNonQuery
MsgBox("Records Data Deleted " & noOfDeleted)

When the form refreshes to show the user the possible ReportID's, the list no longer contains the recently deleted ReportID. Now this is where I am getting confused. When I go through the server explorer and look at the database there, in the appropriate tables the data still exists. Through the server explorer new query builder, I can still create a select statement to allow me to view the data I just deleted. Does the server explorer create some type of local cache that replicates the database in someway? Are there really two copies of the database somewhere?

View 2 Replies


ADVERTISEMENT

.net - What Stored Procedure Is Crystal Reports Using To Connect To Database

Nov 25, 2010

I'm trying to make alterations to an existing Crystal Report form in a VB.net project I've inherited, and it's my first time using Crystal Reports. For clarity, I'm using Crystal Reports under Visual Studio 2010, not the standalone Crystal Reports.I've had a good go at looking through all the functions and variables listed in the CR Designer, and can't find what stored procedure is being used to call for data.

View 1 Replies

VS 2005 Removing Unwanted Characters From A Collection When Using .split?

Jul 30, 2009

I am using a collection to store data from a text file which I am letting the user load and I am using the .split to split and sort the data into alphabetical order and remove repeating words.However, I am having a problem removing unwanted characters from the final array. For Example, "This is the text file that I want sorted. It is random text not yet sorted"

View 6 Replies

Removing A Listbox Item When It Stored In An Array?

Jan 7, 2011

Basically, the user can type in a name and a job description into two different txt boxes and then click add. It then adds the name to the listbox and stores it in a string list (Public strList As New List(Of String)) it also stores the job description in a string list as well (Public strListDescription As New List(Of String))Then when you select an item in the list box it knows what data to bring up in the txt boxes using an array with these lists:

Code:
Private Sub lstMyCourt_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lstMyCourt.SelectedIndexChanged
Dim i As Integer

[code].....

View 2 Replies

VS 2010 - Removing Temp Document Stored In Array?

Nov 28, 2011

In my desktop, I have folder containing some word document files. I want the filenames of the documents in that folder. So, I used:
Dim strFiles() As String = IO.Directory.GetFiles("X:Documents and SettingsXXXDesktopvvvvv", "*.doc")
All filenames are stored in that array. But it would also include the temp document that Word generates. I am somewhat confused on how to remove this from array. I only need full filenames of the actual documents, which excludes the temp document.

View 12 Replies

DB/Reporting :: Crystal Reports Using A Stored Procedure

Mar 19, 2009

We connecting a stored procedure in a crystal report.

In the query analyzer we can call the SP with: execute test 'example'

If we run the crystal report we get the possibillity to fill in the parameter for this SP. The report looks fine but how can we send this parameter in the crystal report script??

View 3 Replies

Use SQL Server 2000 To Generate Reports Using Stored Procedures?

Nov 9, 2010

I have installed Crystal Reports and am using it in Visual Studio 2005. how i can use SQL Server 2000 to generate reports using Stored Procedures.

View 2 Replies

Using Result From A Stored Procedure With Parameters As Value For Gauge Chart - Crystal Reports In Asp.net Application

Jun 8, 2012

I have a stored procedure that takes in 2 parameters and returns an integer value. I would like this value to be the value for a gauge chart on the page. The 2 parameters will change depending on the attributes of the selected item. Is there a simple way to pass the one value from the stored procedure to the chart to display? This will be embedded in an asp.net application (vb) - so depending on the previously selected item, the values for the parameters and result will change.

View 1 Replies

Database (access Database) Should Be Stored On A Web Based Server?

Aug 10, 2010

I have developed some software(vb.net) that records fees paid by the students. The purpose is that the database should be stored in a server, which can be accessed from any stations linked with it.This is working fine with a network of 10 computers. I need to publish it over the net so people could do this job logging in over internet. Database (access database) should be stored on a web based server.

View 1 Replies

VS 2005 Removing Entry From Database?

Jul 14, 2009

I write the following

Imports System.Data
Imports System.Data.OleDb
Public Class Form1
Dim con As OleDbConnection
Dim cmd As OleDbCommand

[Code]...

View 9 Replies

Uses Crystal Reports And Sql Database?

Dec 30, 2009

I have a program that uses crystal reports and sql database. When I right click and try to click report in my program on my formreportviewer I get this error.

Conversion to "" to type integer is not valid.I have been looking for days. How can I find where this error is happening??

View 8 Replies

Create Reports From An Access Database?

May 26, 2009

Is there a way to create reports from an access database using visual basic 2008 express?

View 4 Replies

Making And Printing Reports From Database

Jul 7, 2009

I am new to vbExpress. I am working in vb express with MsAccess as database. I have a form with ListView and some comboboxes,textboxes,buttons etc. Now I am at the stage of forming different reports from database and then printing them. Like I want to make a RECEIPT with CompanyName as header, date, time, Serial Number, ItemDescription, Quantity,Price, Amount,Mode of payment. Then I want to generate sales reports like daily sale, weekly sale, monthly sale. The things like that. Definitely I will use SQL statements to bring data from the tables according to the requirements of reports. My question is how I can make and display different reports from the databases and to print them in proper format.

View 1 Replies

Asp.net - Excel Reports To Database Sql Server 2005

Apr 20, 2011

I am being given excel sheet daily and want to upload them to an existing database with the exact same column names, i wanted to do this in sql server 2005, but then i thought it would be easier to just creat an asp.net program that could do this autmatically, that way the managers could do it them selves. would i use a bulk insert?

[Code]...

View 1 Replies

Creating Reports In Crystal Reports That Is Integrated Within Visual Studio 2008?

Aug 26, 2011

I am creating reports in Crystal Reports that is integrated within Visual Studio 2008, and I noticed that some of the features are disabled. One is the ability to link tables with a Right Outer Join or Full Outer Join. I also cannot "Show SQL Query" in Crystal Reports. Is this something I can enable or do I have to purchase or upgrade?

View 1 Replies

Database - Detect Trusted Connection In Crystal Reports ?

Mar 28, 2010

I have some Crystal Reports connecting to a Sql Server db that I would like to detect whether the connection is trusted or whether I need to supply the log on info (reports are not supplied by me so I can't control the connect method). If I just blindly supply login credentials, it won't connect if it is a trusted connection.The following does not work:

oRpt = oCR.OpenReport("C:MyReport.rpt")

if oRpt.Database.Tables(1).ConnectionProperties.Item("Integrated Security") = True then
'trusted connection[code]....

It gives the following error:Operator '=' is not defined for type 'IConnectionProperty' and type 'Boolean'.

I cannot find how create a construct in vb.net for IConnectionProperty. I can't find any documents from Crystal that explain it.I am using Crystal Reports XI - Developer

View 1 Replies

Make A Connection Using Crystal Reports To Access 07 Database?

Dec 15, 2011

I'm trying to use crystal reports in my database that i have made using vb 2010 and access 07, I'm trying to make a new crystal report in vb, have gone add new item, crystal report, etc but when i go to specify the new connection using the Microsoft office 12.0 access database engine )LE DB provider i keep getting a catastrophic failure error 0x8000fff?

View 2 Replies

VS 2010 Reports - CR9 Does Not Allow To Connect To The New MS Access Database (accdb)

Apr 26, 2012

I just purchased VS 2010 Professional. I was using 2010 Express and i used to use Crystal Reports 9 to create my reports. My problem is that CR9 does not allow me to connect to the new MS Access database (accdb). It only lets me connect to .mdb. I used to use .mdb but i have upgraded to MS Office 2010.

[Code]...

View 1 Replies

VS 2010 Reports - Printing - Preview Reports From A Datagrid?

Dec 9, 2010

Basically, I am looking for a method on how to preview reports from a datagrid or it can be from the access database which populates the data to the datagrid (then displays this in the datagridview) in vb.net vs 2010.I believe there are two methods using the ReportViewer or using Crystal Reports, but so far, I have no idea how to get them to work. The first idea would be favourable - using the data from a datagridview (which may of already been sorted, filter etc) and be able to produce a report on that.

View 1 Replies

Connect Crystal Reports To Oracle Database Using Program Code?

Apr 24, 2012

I'm using crystal reports 9, visual studio 2008, and oracle 9i in this project I'm doing. My crystal reports pull data from an oracle database, and are displayed on a CrystalReportViewer on a windows form. How would I make this connection using vb.net code?[code]...

View 1 Replies

Crystal Reports Deployment Causing Database Login Prompt?

Jul 27, 2009

I have deployed a Visual Studio executible module written in VB Net 3.5 SP 1 with Crystal Reports. When the user tries to view a report(s)they are prompted to login in to the data base that has been data sourced into the report module. The correct database was verified before the build was made. The developer is able to run the report in a run mode on the local machine where the VB project was created. In the properties section in the project the following check boxes pertaining to reports were checked on:

Crystal Reports Basic for Visual Studio 2008(x86, x64)
Microsoft Visual Studio 2008 Report Viewer

Notes: If the executible module is deployed to a machine that has Visual Studio 2008 installed, the Reports run fine without a database login prompt.If the executible module is deployed to a machine that does not have Visual Studio 2008 installed, the user is prompted for a login. The data base is a SQL server 2008 database.

View 14 Replies

Make Setup Of Project Then Crystal Reports Keeps Old Database Path

Jun 22, 2010

When i make Setup of my project then my crystal reports keeps old database path how can i resolve it please help me.

View 2 Replies

VS 2008 Setup Including Database - .net Framework And Crystal Reports

Oct 10, 2010

how to create a setup in vb.net that comes with a ms access database and the .net framework if it is not existing in the system.. and also a crystal report... and also i want my database go automatically to C:

View 9 Replies

[2005] Populate The Tree View From Database For Different Crystal Reports Name

Jan 28, 2009

I want to populate the tree view from database for diff crystal reports name in such a way that i have :

[Code]...

So when user clicks on the caption node and presses the button, corresponding report has to open.

View 2 Replies

What Is Stored In Database

Aug 10, 2009

I am working with Vb.net and have a form with a combo Box. On load the form is loaded with one of the following details depending on what is stored in the database; Cancelled, Processed and Failed. [code] Then I have an update button and when the user drops down the list he/she can select between Cancelled/Processed/Failed. I want to be able to grey out or disable Processed and Failed, so that when the user updates the field he/she can ONLY update with the Cancelled option ONLY.

View 7 Replies

Creating A Crystal Reports Project - Setup The Login To Database Function?

Jan 31, 2010

I am creating a visual basic project for class. It is all running as intended though I am not sure how to set up the login to database function. When you click the link for the specific report it should display the page. But I get a login to database page. I am just wondering how I set that up so that one can actually see the information. ie:

[Code]...

View 1 Replies

Error Connecting Password Protected Access Database To Crystal Reports

Apr 10, 2012

How do I open my Crystal Report in VB code (RPT files) on password-protected Access 2007 database? Ever since I protected my database with password, my Crystal Report generates an error.

View 3 Replies

Loading The Reports Fom Reports Folder Instead Of Debug?

Apr 28, 2011

i am developing an application in vb.net having crystal reportsi have stored all my reports in a folder called report in my applicationbut initally when i executed i got a error msg like the report doesnot exixts in debug folderso i copied all the reports from report folder to debug folder & its workingany changes that i mke in report folder needs to be copied into the debug folder alsois it possible that the reports be executed from reports folder only & not from debug folder as everytime i need to make changes in the debug folderhow can i chnage the path to reports folder

View 1 Replies

Data Stored In The Database For A Login?

Apr 23, 2012

ive made changes to my data stored in the database for a login i.e. ive changed the password that is stored in the database however for my application to continue the previous password still has to be used does anybody know why and how to change this, this also is the case for new entry's in the database i.e. new users. I also had an update button that also no longer works i think this is because of the same problem. I think the problem is that its saving the data changes from the update to the data set and not the database its self can this be changed?

View 4 Replies

Database Loses The Stored Information?

May 7, 2011

I am working on login and registration page in vb express 2010. I have connected access 2007 database with my project and when I register as a user, it stores information to the database successfully and I can log in with that id as well. But when I close that project and reopen it, the same exact id won't work and the information in the database disappears.

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved