VS 2010 Public Dataset Or Table To Store Permissions Locally?
Dec 7, 2011
In my vb.net winforms application using Visual Studio 2010, I'm trying to work something out and my brain just isn't working today. I'm rewriting this application to make it more efficient and trying to minimize the sql calls.
Currently it works like this.User logs in to the app, it loads the main form, where the user can open up different forms to access different client data. Each time a record is loaded in one of these new forms it also loads that specific users permissions from a Sql Server 2005 table.
What I want to do is when my main form loads after the user logs in, is load a public dataset or datatable, or any other suggestion, storing that users permissions so I can access them locally without hitting the sql server every time the user opens a client record.
I am currently developing an application that will require each end user to specify a rather large set of tabular data specific to his/her own preferences. Each time the user starts the application, it will load this set of data.
what is the best way to store this data locally on the end user's local machine? Should I use XML, Access mdb, flat text files?
I'm using System.Management.ManagementScope to connect to a remote computer and install an MSI package. This works great if the MSI is located on the remote computer, but it fails if I try to use a network location to run the MSI from. The UNC path is correct because if I manually type it from the remote computer it runs fine. There must be a limitation (security I'm thinking) that prevents things from running via WMI if the exe isn't local to the remote machine.My last hope will be to copy the MSI from the network location, store it locally on the remote computer, then run it - but I'd really rather not have to do that.
I use a dbDataAdapter to populate a DataTable from an unlinked oracle database.I have a dbDataAdapter that I want to insert rows into an SQL Server table using SQLCommandBuilder.I have been trying all day to update the DataTable that references the SQL Server table with the data from the Oracle DataTable so that I can insert the rows.
I inherited a program that retrieves 3 datasets from our vendors' web services, converts it to a table and then merges the 3 tables before exporting into xml from the resulting combined table. The problem I am having is that when web services returns an empty dataset the program crashes in the attempt to create a table from the empty dataset.How do I modify this code to either create an empty table or recognize the empty dataset and skip around that particular table creation, merge and removal? There is always data in at least one of the datasets.
foreach (Branch branch in branches) { Console.WriteLine("Opening connection..."); Vendor.ws_ordersSoapClient VendorClient = new VendorInterface.Vendor.ws_ordersSoapClient();
I have a query that brings back a result that I want to be able to use on all forms in my project. Is there a way to store this until the application is terminated?
For example,
I'd like to store the result of this:
Dim ssSQL As String = "SELECT ClaimNo, Custodian, Activity, Code, DateStamp FROM [Activities] WHERE " ssSQL &= "[ClaimNo] Like ('" & txtClaimNum.Text & "')"
I'm looking for the best way to locally save settings to an application.I want the settings to "attach" themselves to the executable of the application so that I can send the application to another PC and still have the settings.The purpose of this is for a server that is going to issue an executable to anyone who requests it, the server sends an executable with the callback settings hardcoded into the application (for example IP, port and other settings) so that the application can connect to the server.I can't hardcode the settings in the source code because the application is going to be issued by different servers which of course, will need a different connection setting.I also don't want the settings to be stored on a file or any other "external" resource since then, the settings could be changed which could open security holes to exploit the application.So what I want to do: I want an executable to have some settings attached which will be set by another application. How can I set the settings of one application with another? And how can I efficiently save the settings internally on an application and then copy the file to another PC while still having the settings?
Can you please explain me and/or show some good tutorials how to do it?It seems pretty complicated because visual studio usually does it all for you and that made me stupid and not to do anything about it.Things I don't know to do in code but I know VS does it for me:
[Code]...
I'm sure there is a good tutorial somewhere on the internet. I'm okay with doing it with designer, but now when I have a situation where I can't use MDI container but tabcontrol.Other solution would be to make a MDI container out of tabcontrol. Is it posible or only other form can be MDI container.
I am writing a program for a class and it needs to read/write to an Access 2007 database. Right now I am referring to it's absolute path when I use it in connection strings, something like:
Dim conn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:UsersMeDocumentsVisual StudioProjectsProject1Database.accdb")
This is going to be a problem when I turn it in obviously, because the professor isn't going to have the same path. So I want to somehow include it into my project and then refer to it with a relative path or something so that it will work on his machine. When I imported it through the Data Sources it had an option at the end to copy the database into the project which I agreed to. It put the Database where all of the source files are on my computer, so I tried using Application.StartupPath(
I have an application with a number of forms that basically access the same data (or subsets of it)Can the data adapter, connection object etc be opened in a module so that all the forms have access to them to avoid writing the same code in each form?I had a go at doing this but they seemed not visible to the form?
I have a large form that is set up from master-detail datasets in Visual Studio 2008.I havene master table with a large amount of detail tables. Several of the detail tables also have detail tables linked.Now I need to add a master table that sits on top of my existing master table making it a detail table.
I have a project which contains a large number of lookup tables, and I have all of these lookup tables represented in a single typed DataSet, which contains TableAdapters for each lookup. I've designed an editor for these lookup tables, which should allow editing of one of these at a time. My front-end is written in VB and WinForms, the back-end is a SOAP web service; I can successfully pass the changes to the DataSet back to the web service, but can't find a way to use a TableAdapter to update the single table that has been changed.
What I'm trying to do is instantiate the appropriate TableAdapter for the updated DataTable by sending the name of the table back to the web service along with the DataSet, then referring to the TableAdapter with a dynamic name. The normal way to instantiate a TableAdapter is this:
Dim ta As New dsLookupsTableAdapters.tlkpMyTableTableAdapter
What I'd like to do is this, but of course it doesn't work:
strTableName = "tlkpMyTable" Dim ta As New dsLookupsTableAdapters(strTableName & "TableAdapter")
Is there any way to achieve this, or am I taking the wrong approach altogether? My other alternative is to write separate code for each table, which I'd prefer to avoid!
How can I update local dataset with mysql database without making duplicates. Assuming I set some column in mysql as primary key, which has unique string.
adapter.fill will just add duplicates, but adapter.clear before that is not an option.
So I want to update if the key column is the same with mysql data and if there is option for ignore adding new row.
I created a database (.mdf) file. I added data to it after running the program in debug mode. When I closed it and opened it up again, the data I got was stored and loaded again.I closed my whole Visual Basic Express program. When I opened it up again, all the data had disappeared.
Can you tell me what I am doing wrong with the program? I can't get queries to work either. It worked when I used the NOrthwind dataset this past weekend but it is not working when I use my own or empty dataset.
I have some concern about designing Datasets. I was told that it would be good to have a dataset for each table for maintenance purpose. Because frequent change in database tables is expected, having one dataset including every tables would be pain to make the corresponding change in the application.
Q. is it good approach to have a dataset for each table ( I would end up having 30~40 datasets for each db table using Stored procedure) ?
I have a separate project for commonly used datasets. each project include "dataset project" as a reference, and use it by including needed dataset into Forms, classes, etc.
Q. Does this approach makes the whole system to be slower? If I have a set of datasets as a separate project, it would be beneficial, since It will be easier to make a change (I only need to make modification in one place)
I am trying to change the permisions of the following registry key from within VB.net:- HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSLicensing Basically need to change users to full control. I need to change permissions for the "users" group.
My app needs a config file that can be written to by the user. I've got the Setup project to install it to [CommonAppDataFolder][Manufacturer]][Product] but that folder is then read only to normal users (which defeats the point really!).
I've read various articles on the internet on how to solve this, ranging from making the app a Full Trust ClickOnce app to running a separate app post install to change the permissions.
I have a dataset (WW1Dataset) with one data table(WW1).(database used in an access database) I'm trying to filter the dataset e.g a user wants to filter by a chosen surname (SurnameTextBox.text) so the datset is filtered to display only those records wherethe surname column in the dataset matches SurnameTextBox.text.
I can seem to find is vbs code for retrieving remote share permissions using WMI.I've tried to convert this code to run on vb.net but don't seem to be getting anywhere.should I try to convert the below code or are there other methods I can use to retrieve the permissions. I can easily get the list of remote shares using win32_share but not the permissions
I've search tons of .net pages and all I can seem to find is vbs code for retrieving remote share permissions using WMI.I've tried to convert this code to run on vb.net but don't seem to be getting anywhere.hould I try to convert the below code or are there other methods I can use to retrieve the permissions. I can easily get the list of remote shares using win32_share but not the
Just tried to create a new Data Source in VB 2010, apparently I don't have permission to connect to the 'Login.mdf' file I recently created in SQL 2008. Does anyone here have any knowledge of how to surpass this problem? I'm the Administrator of my PC and have full permissions and UAC is turned off so that shouldn't be the problem either
I've been struggling for hours now to get some working code to list the share permissions of a remote share. I've got WMI code which uses win32_share which lists the shares and path and it works great. I"m now trying to add in a routine to get the share permissions as well.
I've searched just about every site for some sample code and can only find some C# (I think) code.
my program read and writes into registry and has been working fine, until today when i tested it on a new server i got this error request for the permission of type system.security.permissions. registryPermissions, mscorlib,version=2.0.0.0. i checked the registry permission and made sure all allows are ticked.
I am coding a program that will allow the user to input 5 payrolls for Store 1, Store 2, and Store 3. The total of the 5 payrolls are then added together and shown in the respective Store's labels. A total label is also there to add up all the totals into one number. The numbers in the label must be in currency form. My problem is the numbers don't add correctly when I hit calculate. The first two numbers add together, but then after that the number just seems to subtract a random amount.
So far I have this --
Public Class Form1
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Me.Close() End Sub
