Errors With Loop - Log-in App That Has Username, Passwords & Account Type Stored In A SqlCe Database
Oct 23, 2009
Getting some errors with a loop. It's a log-in app that has username, passwords & account type stored in a SqlCe database. I would like it to sync with a larger database for updates that has not been made so i left it out but I have started to make a loop that would connect it to the larger DB and if connection failed would try a set number of times before stopping the program. I'm coding this project with Visual Studio 08 pro
Dim conndb As New SqlCeConnection("Data Source = |DataDirectory|\Mydb.sdf")
Dim x, y, z As Double
x = 1
y = x + 1
z = 5
[CODE]...
View 1 Replies
ADVERTISEMENT
Sep 27, 2009
I am trying to get use to this....I need to know how to type in a database for my usernames and passwords??? I am using visual basic 2008, which I think is visual.net? anyway...heres my code:
Code:
Public Class login
Private Sub login_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Hello.Hide()
[code]....
View 2 Replies
Nov 14, 2011
I can access the current Windows user, but I want to give an admin the ability to enter an alternate username and password for a different Windows Active Directory Account without having to logoff and log back in. Once the account is authenticated, I need to use it in a connection string to sql server. I know I could do this for a SQL Server login, but this is Windows Authentication only. It was installed with ClickOnce. Is there an .exe file on the user's machine?
View 2 Replies
Sep 15, 2009
I am trying to add a new record to a table, well first it checks if there is already a duplicate record in the table, and if not it makes one. If there is a duplicate, it tells the user.[code]
View 2 Replies
Nov 20, 2010
I have a SQL CE database (SDF) that I tried to edit with Database.net v3, but it is now not opening in Visual Basic Express 2010.[code]I've installed SQL Server Compact 4.0 ENU CTP1, but it is still not working.Is there any way to revert the version back? Or anything else I can do to fix this error?
View 4 Replies
Sep 14, 2009
I have used Access databases before so thought I'd try something different. My problem is that when I try to add a new record to one of the tables in the databasethe code runs through fine, but the data is not added into the table :S have probably missed something simple, but it's been a while since I did any projects using a database.Here's my code:
Imports System.Data.SqlServerCe
Public Class Form1
Dim con As SqlCeConnection = New SqlCeConnection("Data Source=C:UsersMattDocumentsVisual
[code].....
View 15 Replies
Oct 24, 2011
I am having some issues with an application written in VB.net.
As part of a routine, an sqlce database gets backed up before the routine then if an error occurred gets restored. I am using system.io methods copy and delete.
I have released all the objects (connections, commands, datareaders) asscociated with the sqlce database by disposing them if they are not nothing. I also do a GC.COLLECT however when my delete command runs, an error message says it is open by another process. The PROCEXP.exe process explorer tool says it is attached to 4 undefined processes. After a while in debug mode, these clear and I am able to delete the file. However this is not acceptable as my program cannot "wait around" until they are released! I was under the impression that object.dispose forced an immediate disposal rather than waiting for the garbage collector to clean up (if you were just to use object=nothing), but still there appears to be a finite time before these objects are released.
My question is, is there an alternative way of checking (programatically in vb) for what is holding open an sqlce database (or in fact any other file for that matter) then killing these processes?
View 1 Replies
Apr 6, 2009
I'm about to pull my hair out on this guys I do not know where I'm going wrong but basically I receive a web request response formatted in XML and I need to insert that data into an SQLCE database. I have tried using LINQ queries but there are no matching ID fields to Join or Group.
View 3 Replies
Aug 20, 2010
I want to access the Windows mobile SQLCE database from the desktop application when device is connected to my PC.
View 1 Replies
Mar 27, 2012
I have created a for loop the validates a user account. however whenever i hit the button that starts he code it won't let me allow user input. I have checked a forums and other sites and its bugging me. i know its small but i don't know what i need to be doing to get out of the loop
[Code]...
View 2 Replies
Sep 15, 2009
I've been messing around trying to get an INSERT statement to work, and because of this, it has created lots of records in my database that I dont need or want.
The problem is, when I open up the table by right clicking on it in the database explorer and selecting "Show table data", I click on the record I want to delete and the following error comes up in a message box[code]...
View 3 Replies
Jun 26, 2010
I recently made a small app for a friend and then made it a public app, in doing so I forgot that it connects to my MS SQL DB and checks for values. Someone used Red Gate .Net Reflector to get my password and destroy it all. I've contacted their ISP and they are looking into it, apparently this person has a static ip with them.So this is a lesson learned at a heavy price for me. How can I prevent this from happening again? How can I get away from the unsafe connection string they were able to use?
View 5 Replies
Feb 7, 2010
i'm oding a project which involves using a log in form, from which the username and passwords are compared to. However, at the moment, my code works, but not case sensitively!
Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogin.Click
Dim sql = "SELECT Username,Password FROM login WHERE Username = '" &
[Code].....
View 2 Replies
Feb 20, 2012
I am using vb.net (visual studio 2010) and have made a form application that uses a login screen. All that works but I am having trouble any firm way to encrypt the passwords in the database. The encryption doesn't have to be very high standard as its just for a college project. Whats the best way to encrypt the password into the database? Or just encrypt the password string, I can then sort out the database end myself.
View 2 Replies
Aug 7, 2009
I have sql server2000 encypted stored procedure. I can not modify them. Typicaly all the procedures manipulate row by row different tables using cursors etc. When the stored procedure is executed at the Query Analyser screen, I see error being thrown in between but the procedures continues till all the records have been processed. This behavior is acceptable to the client. I now need to automate the process using VB.net 2002 windows application. I call the procedure from vb.net but the program throws runtime error on the 1st occurance of a error in the stored procedure.
View 2 Replies
Jun 7, 2011
I have a storedproc accepts parameters in XMLtype as
CREATE OR REPLACE PROCEDURE GetDetails(
p_para IN XMLTYPE,
[code].....
View 1 Replies
Oct 20, 2009
Account Type for installing a windows service
View 1 Replies
Apr 13, 2012
I've just finished creating a basic login system which enables you to create an account and select either a "Student" or "Teacher" account.
Once the account is created it's stored in an Access 2007 database. The field the account type gets stored in is called AccountType. When users log in with their unique username and password I want the program to take them to a different form depending on whether they have a student or teacher account.
View 2 Replies
Sep 2, 2009
I use AES encryption in my vb.net 2008 windows forms apps to ....
1. Store user passwords in sql server express database in encrypted form
2. decrypt the encrypted Sql server express connection string password on the fly when connecting to SQl Server over a vpn or direct to web based sql server database
3. decrypt the encrypted ftp site password on the fly when my application connects to my ftp site to upload client's database backups
The issue I have is that the secret key for the encryption / decryption is hard coded within the encryption/decryption functions. So anybody who decompiled my application would be able to generate the same encryption, as they would have the encryption secret key How can you hide the encryption secret key so that if anybody decompiled my app they could not reproduce the decryption function
View 1 Replies
Oct 5, 2010
In .NET, integer data type is a value type(stack) and String is a reference type(heap). So If a class A has an integer, and a string type object in it, and a class B creates an object of class A, then how will this object of class A be stored in memory? In stack, or in a heap? This was asked in my Microsoft interview. Need to understand how I fared.
View 3 Replies
Feb 24, 2011
I have a login in system that i'm creating for a game. I have this code for checking to see if the username and password are correct in the text file.[code]I want to know how to make the for loop stop once the username and password have been found correctly.Also, where would I put a message box saying that the username or password are not correct if they don't match up or they're not in there at all?
View 3 Replies
Mar 20, 2011
I have several text boxes I need to validate. I am not understanding how to validate in Visual Basic 2008. So I deployed standard If Statements to handle bad data. I am having two problems.
Lets say the user entered wrong data, example, numbers; an error message is displayed. The text boxes cannot contain numbers, be left empty or contained characters, like !@#$. The problem is if the user enter text, and then entered a wrong data again the code does not work or display error message. How can I make the conditions so that they throw out error message even if the user had previously entered good data.
Another example: If the user enter good data in text box 1 and bad data in text box 2, the error message does not work.
Finally, how do I filter out characters to allow only text. Is there a way to use this code on multiple text boxes with out writing the entire code for each form control?
Here are the conditional statements.
Private Sub btnDataSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDataSubmit.Click
If IsNumeric(txtDataEntry.Text) Then
lblErrorDisplay.Text = "Invalid Name!"
lblErrorDisplay.BackColor = Color.Red
[Code] .....
View 12 Replies
Mar 3, 2010
I'm designing a PC-based app that has a little local database. I'm using VB.NET with SQL Server Compact Edition. The user will only ever have access to one database file, because it's all about storing a user specific data. However I'm thinking of the situation where there could be multiple users that access the PC, each with their own Windows account. So ideally I'd need separate database files for each User.
I'm not sure how to implement this. I was hoping to deploy the 'empty' database as a ClickOnce deployment, but I can't see how I can have a database per user doing this. Also I'm not sure where to store the database files anyway. perhaps in MyDocuments for each user? Or perhaps I need to stick to just one database, but add a 'User' column into every table, so it can hold data for every user. I didn't want to do this though - because I wanted to keep the nice separation between the data offered by physically separate files.
View 3 Replies
Oct 27, 2009
Im coding a very nice browser, it has a gui and has many addons. Im looking for how to make it so when you type in a username and password on a website it asks you if you would like it to remember them like mozzila.
View 8 Replies
Jan 14, 2011
I have code on log in form but it only get the latest data on username and password column on my database
Here is my code
Public Class Users
Dim MyLogIn As New myRecords
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
[CODE]...
This is my connection:
Imports MySql.Data
Imports MySql.Data.MySqlClient
Module myconnect
[CODE]...
This is my record:
Imports System
Imports System.Data
Imports MySql.Data
Imports MySql.Data.MySqlClient
[CODE]...
View 1 Replies
Nov 10, 2009
I got a value which is store in the array and i need to compare it. Which
if my user = 1,2,3,4,5,6 then ignore
if my user = 2,3,4,5,6 then i need to add in a ,1 which become 2,3,4,5,6,1
Here is my coding
user = dr("user_access")
dr.Close()
Dim splitX As String() = user.Split(","c)
For Each item As String In splitX
[Code] .....
Is there other way to compare the array or there is another better way to check?
View 1 Replies
Aug 10, 2011
I am trying to loop through a datatable, that will pass information to my stored procedure but it isn't working.even though it works when i manuelly
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim dv As New DataView
[code]......
View 2 Replies
Mar 29, 2010
Error14Option Strict On disallows implicit conversions from 'System.Windows.Forms.TextBox'to 'Microsoft.Office.Interop.Excel.TextBox'
View 18 Replies
Sep 12, 2010
Does anyone know how to run windows explorer with an admin account while logged in with a non admnistrative account? i want to be able to open up an admin share on a remote host with windows explorer instead of iexplorer. I tried some code I found on the net to impersonate but it didn't work.
View 2 Replies
Feb 11, 2011
I've written some code in VB.NET that exports data to Excel. The data is mostly numbers but text can occur as well. So I send it as String values to Excel. I get the error "Number stored as text".I checked the format of the cells that show the error and it is General and not Text.
how to avoid this error or prevent Excel from showing this error.
View 5 Replies
