The obvious thing to do, is to write a base page, which all pages derive from, which checks the logged in member and if they do not have access, redirects. Then set what permissions are needed in the derived page, or create derived pages to then derive from, for each status you want to apply. Christian Graus Driven to the arms of OSX by Vista. "! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums. I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

Why do you need Linq to SQL for such a basic task ? This is what I feared, new tools are being forced like square pegs into round holes by people with no idea. And, this is a SQL question. A very basic one, at that. Christian Graus Driven to the arms of OSX by Vista. Please read this[^] if you don't like the answer I gave to your question. "! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

hahii wrote: Yes, I created the virtual folder. e.g my website is in the folder C:\project\NyWebSite Now I treated virtual folder in C:\Project and named it as test2. But when I go to window explorer C:\project my test2 is not there. So,. How can I publish it. I have no idea where I am doing wrong I don't understand what are your doing? If you have published your Web sites from VS, then Open IIS and Create the Virtual Directory and Give the Path Reference of your Published Folder, that all. Now you can access from you web site from Localhost or IP address. For more details, Please look into this article, Deploying Web Sites in IIS cheers, Abhijit CodeProject MVP Web Site:abhijitjana.net

database tables are not an authenticaion mechanism. You can store data that can be used by your authentication mechanism, but it isn't a mechanism per se. Your question, therefore, is larger than the scope of a forum reply. You would do well to find a tutorial on authentication in what ever OTHER technology (e.g. ASP.NET, WinForms, etc.) you are using and how to do that with SQL Server. Man who stand on hill with mouth open wait long time for roast duck to drop in

Just realised I'm in the ASP.NET forum - Why are you asking this here? It is a database question! Man who stand on hill with mouth open wait long time for roast duck to drop in

Use SQL Christian Graus Driven to the arms of OSX by Vista. Please read this[^] if you don't like the answer I gave to your question.

I think your design is missing a table. Typically this type of situation is implemented as follows: Users table (contains a list of valid users) Roles table (contains a list of valid roles) RoleMembership (this shows which users are associated with which roles) For example: Users: A,B,C Roles: R1, R2, R3 Role Membership A,R1 A,R2 B,R1 C,R1 C,R3

ASP.NET Membership Provider for MySQL does not come with VS 2005/2008 by default. Check the following links. It will help you to address your requirements. http://forums.mysql.com/read.php?38,63403,63403[^] Membership and Role providers for MySQL[^]

try this

Make sure u write code for DetailsView1_ItemUpdated in cs file .

//you have to create a DataClasses1.dbml and drag and drop ur tables and proceed //these are methods and you have to pass the values. public static void insert(int id, string name, string address, string department, string gender, int phone) { // DataClasses1.dbml name DataClasses1DataContext da = new DataClasses1DataContext(); //table name linq_padhu_emp data = new linq_padhu_emp { id = id, name = name, address = address, department = department, gender = gender, phone = phone }; da.linq_padhu_emps.InsertOnSubmit(data); da.SubmitChanges(); } public static void update(int id, string name, string address, string department, string gender, int phone) { DataClasses1DataContext up = new DataClasses1DataContext(); linq_padhu_emp updating = up.linq_padhu_emps.First(P => P.id == id); updating.name = name; updating.address = address; updating.department = department; updating.gender = gender; updating.phone = phone; up.SubmitChanges(); } public static void delete(int id) { DataClasses1DataContext del = new DataClasses1DataContext(); linq_padhu_emp deleting = del.linq_padhu_emps.First(P => P.id == id); del.linq_padhu_emps.DeleteOnSubmit(deleting); del.SubmitChanges(); } Padmanabhan

It is very easy to do. In such situations, any kind of entity framework will help you. e.g. Ado.net Entity Framework, n-hibernate. I am presenting a sample pseudo code for that in Ado.net Entity Framework A) Fetch operation public List<Employee> FetchRecord() { EmployeeInfoEntities objEmployeeInfoEntities = new EmployeeInfoEntities(); ObjectQuery<Employee> employeeQuery = objEmployeeInfoEntities.Employee; return employeeQuery.ToList(); } B) Insert operation public void AddEmployee(Employee e1) { try { EmployeeInfoEntities objEmployeeInfoEntities = new EmployeeInfoEntities(); objEmployeeInfoEntities.AddToEmployee(e1); objEmployeeInfoEntities.SaveChanges(); } catch (Exception e) { string msg = e.Message; } } c) Update Operation public void UpdateEmployee(Employee e1) { try { EmployeeInfoEntities objEmployeeInfoEntities = new EmployeeInfoEntities(); Employee e2=( from emp in objEmployeeInfoEntities.Employee where emp.EmployeeID == e1.EmployeeID select emp ).First(); e2.Name = e1.Name; e2.Title = e1.Title; e2.Gender = e1.Gender; objEmployeeInfoEntities.SaveChanges(); } catch (Exception e) { string msg = e.Message; } } D) Delete operation public void DeleteEmployee(Employee e1) { try { EmployeeInfoEntities objEmployeeInfoEntities = new EmployeeInfoEntities(); Employee e2 = ( from emp in objEmployeeInfoEntities.Employee where emp.EmployeeID == e1.EmployeeID select emp ).First(); objEmployeeInfoEntities.DeleteObject(e2); objEmployeeInfoEntities.SaveChanges(); } catch (Exception e) { string msg = e.Message; } }

//use like this var type = from p in entities.Customers select p; this.Gridview1.DataSource = type; this.GridView1.DataBind(); Padmanabhan

Here is the answer to your question Everything is correct except that you need to type cast to the particular Entity before you r binding the source to your grid. e.g. public List<Customers> FetchRecord() { return( from p in entities.Customers select p ) } this.Gridview1.DataSource = FetchRecord(); this.GridView1.DataBind(); Hope this helps :) Niladri Biswas

when you clicked the Node Get Parent Nodes of Selected Node and Show it on label. Example. TreeNode ParentNode= new TreeNode(); ParentNode=this.treeviewCtrl.SelectedNode.Parent string strFullNode=ParentNode.Text + ">>"+ this.treeviewCtrl.SelectedNode.Text

check this : [GridView all in one](<a href=)[^]"> Padmanabhan

then change DataBind; in DataBind(); In Word you can only store 2 bytes. That is why I use Writer.

The DataBind is a method call and the syntax should be: this.GridView2.DataBind();