DB/Reporting :: SqlMembershipProvider In Windowsforms?
Jul 28, 2008
i just recently completed a simple windows project with security authentication that used SqlMembershipProvider and SqlRolesProvider. btw, the application connects to the db via Sql Server authentication. that means all user uses the same connectionstring to access the db.are there loop holes? is these style the least desirable? is these "hackable"?how would this type of implementation would fare compared to windows-based authentication, passport authentication, or a webapp that used same approach above?
I have an MDI window with multiple child forms. The user can hide or display child windows by checking/unchecking in a View menu on the main form, calling on either the Show or Hide methods for that form. Each time I call the show method do I also have to specify myForm.MdiParent = Me, or do I only have to specify that once, ie does vb remember that the form will always be a child? Is there way of specifying this at design time?... it doesnt appear to be a form property any more (from vb6).If I have created a form at design time, is it more efficient to create an instance of that form using New, or simply show the form as it is by just loading it. What are the pros or cons, memory and speed wise? In my case I will never need more than one copy of that form to appear, I'm using VB2005.
I'm developing a "small" warehouse-management WebApplication for few users(5-10 parralel) but with a complex authorization system(checking if pages,menus,TabPanels, UserControls and even single controls are visible or enabled) and permanent and frequent access. Because i've only limited experiences with the ASP.Net MembershipProvider, i'm unsure what's the best approach for following goal:
I want to hold all users, roles and frequently used masterdata in the Cache(in a Dataset). Hence every readonly access should be faster and causes less traffic than always using the database. On updates,deletes and inserts i would update the cached dataset and also the database.
Can i use or extend the SqlMembershipProvider to achieve this goal and if possible how?
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
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.
I 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!
Whenever 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?
I 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.
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:
Does 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.
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?
We 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?
I'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.
I 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.
I 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)
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
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] 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.
so 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.
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?
