Search the Community
Showing results for tags 'db'.
Found 4 results
-
Hi, As you all know, it is recommended to give folders, files, and the DB less obvious names for extra security. For the above, as well as for username and password associated with website access, I am thinking of giving each name a mix of letters and numbers of multiple languages, hoping to face no problems using charset=utf-8 in all pages, css, js, and DB. Do you consider this to be an acceptable approach or there could be drawbacks I am not aware of?
-
Hi. I'm new to the .NET framework. I ran into w3schools demo: http://www.w3schools.com/aspnet/webpages_login.aspI did everything like the demo and it was o.k until the register/login pages.when i try to register to the site, i receive this error: Exception Details: System.Data.SqlServerCe.SqlCeException: The column cannot contain null values. [ Column name = UserId,Table name = UserProfile ] Source Error: Line 25: if (user == null)Line 26: {Line 27: db.Execute("INSERT INTO UserProfile (Email) VALUES (@0)", email);Line 28: WebSecurity.CreateAccount(email, password, false);Line 29: Any help will be great ! !
-
hello again,just a fast question... if i have somfthing like a little bit over 500 Words in a DB... and i am outputtin them with a normal SELECT in the query, is there not somfthing i can do in the query so that it can only show like 100 words, and if more, then in the end of the word(s), there will be added this: (...) to look more nicer in the design, thanks in advance! ...
-
Hi all, Sorry tried to attach but the upload failed. Anyway I have the above code to connect to my Access database. Now my database has 3 tables: People, Address and Contact. Currently the only way I know to display all three tables is to have 3 vars, loops etc. I was wandering if there was a better way to display all 3 Access tables? PS, all 3 tables have an ID field which I only want to display once (ID is primary key in people and a foreign key in the other two). Any help would be much appreciated
