| Author |
Topic |
|
Denil
Starting Member
14 Posts |
 Posted - 2006-10-15 : 03:09:39
|
| Hi all, i'm new here. plz help me solve this question. i want to know how the login component that already have at visual studio, link with the database i created? what i mean is..when an user1 had login to the page, then it will show user1 database at the page..i dunno how to link the database tat created automatically(asp.net configuration) with my own database created.. izit using stored procedure? can i have some example or guide how to do tat from you all?mayb this is a noob question..but can u all help me? thx... |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-10-15 : 20:04:41
|
| Plz noob izit mayb u tat no mor xpost thx...CODO ERGO SUM |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-15 : 21:43:11
|
Denil, Can you post your question in plain English ? I guess only Michael can understand what you said. 
KH |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-15 : 23:41:58
|
| is this a presentation question? you want the db name to be displayed when your apps connect to the db?-- to connect to the db, you must know the name?-- otherwise use "select db_name()"or do you want to know how the db name gets displayed by visual studio?--------------------keeping it simple... |
|
|
|
Denil
Starting Member
14 Posts |
Posted - 2006-10-16 : 03:56:44
|
| oh thanks jen for helping me here, i really don't know much about sql..because i just learn from some video. Actally i'm doing a project, the project is "online banking system". I don't know much on visual studio 2005 and sql. So maybe my question is abit weird..but plz help me here..what you know about db just explain abit to me. Sorry Michael if i make you angry ^^.Jen i just know when i build a login (ASP.NET configuration) in visual studio 2005 it will automatically create a sql db call ASPNETDB.MDF. Inside there got a bunch of table and stored procedure. Well, now i plan to create my banking db in this ASPNETB.MDF. So i have create all the table only. I already set the Primary and foreign key, but i dunno got set wrong or not.Now i want to link up the login db (that one automatically created when i configure ASP.NET configuration) with my banking db. How to do that? I want when my user key in his login name and password...then my db will know which user is this..and will directly link to my user db and show up the content inside.. thanks if someone can help me on this. i'm a student who doing a project in using sql and visual studio 2005 |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-16 : 04:01:05
|
| My suggestion is that you hire a skilled DBA for a year, if your only experience with SQL is from a 2 hour video.Especially for an online banking system!Peter LarssonHelsingborg, Sweden |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-16 : 04:12:27
|
quote:
Originally posted by Peso
My suggestion is that you hire a skilled DBA for a year, if your only experience with SQL is from a 2 hour video.Especially for an online banking system!Peter LarssonHelsingborg, Sweden
Note : quote:
"i'm a student who doing a project"
1. Get a book on Visual Studio or make use of the help file in Visual Studio and also SQL Server2. Search the web like http://asp.net/learn/default.aspx?tabid=63
KH |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-16 : 04:16:36
|
| quite a feat you want to pull there Denilif you're still learning, try to learn one area at a time...study asp or sql first, once you get the hang of both, then integrateotherwise, if you'll just follow the video, you'll be able to create the system but won't really understand how things are working (no offense intended)For asp, try to grasp the concept first, like showing static pages, etc... for sql, try to create databases, users, provide permissions, creating sql statements or queries, creating stored procedures, etcTo fast track your learning, if you're really keen on the video thingie, always check the source codes whenever you run something and trace what's the code doingHTH--------------------keeping it simple... |
|
|
|
Denil
Starting Member
14 Posts |
Posted - 2006-10-16 : 07:07:48
|
| Jen..really thanks for your help ^^ i already know how to create database,i also know how to create query and also aspx pages. sql Creating store procedures i also learn already.sql statement i also know, like select, delete, and others. maybe those i know is kind of basic. When i download some sample...it really look complicated..i not so understand how it works. it is because the code is complicated.now i really don't know what to do.. is that really cant guide me on linking the database i said? is not only the method of primary and foreign key.. maybe most of you really don't understand what i want..haha..sry all..khtan i want to tell u something..those video i learn is almost 20 hours..not 2 hours. it teach u step by step and also all the features. now my problem is dealing a harder part.. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-17 : 00:12:58
|
| it's vague what your question really is but here goes:are you talking about database connections from your asp page to the database server?-- check www.connectionstrings.com--------------------keeping it simple... |
|
|
|
Denil
Starting Member
14 Posts |
Posted - 2006-10-17 : 03:14:08
|
| thanks jen..sorry that i make u all dizzy because my question is vague..i try search more web for some guide 1st ^^ |
|
|
|
Denil
Starting Member
14 Posts |
Posted - 2006-10-17 : 03:50:52
|
| yes jen...i want to connect my page to database server. how to do that? i give an example.. now i have create two aspx page. 1 is login page (i drag the login from visual studio 2005 toolbox), and 1 more page show database of the user that have sign in successful. I have create "user information table" for an example.Inside this table got all user information like name, address, contact... Now what i want to do is..when the user key in login name and password...then the page will show the current user information. My problem is i dont know how the login menu there will determine which user is currently want to login and will show the data of the current user after logged in. How is the database connection string link between the login database and the "user information" database? the login database and some tables are created automatically after i setup the roles and create a user in ASP.NET Website Adminstration Tool. The only table i create myself is "user information", because i want to try when User A login then the next page will show User A information that have retrieve from "user information" table. I dont know how to do interconnection of the login database and my " user information" table.the "login database" have a bunch of table inside it (create automatically) like aspnet_applications tableaspnet_membershipaspnet_pathsaspnet_personalizationaspnet_profileaspnet_Rolesand many others.the only one i create is "user information" table..so u all get what i mean? i need help from u all..thanks alot.. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
|
|
|
how login link wit my database