How to see a database from the Administration tool ?

I'm new using ASP NET , after I created alocal application Visual Web Developer that connect to the remote server be able to see the dataonly shows up User ID, and Email, what can i do if I want to see the rest ofthe fielsas name, address and phone number??What do you suggest I should do? and How encrypt the data to avoid other people read it?

Thanks in advance.....

 

I dont understand.


Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET

 

I apologizefor not organized better myideas. This is the situation:


I created an aplication usingVisual Web Developer. I used the createuserwizard control and I realizedthat I needed to add more fielsin thetemplate so i customized it, the data just looked fine but when I placed my aplication in another server (SQL2005) and creating a local application that connect to the remote server to allows me to see the database thenI cansee through the Web Site Administration Tool only the User ID and Email of every user whohas registeredso my question is how canI do to be able to see the data for the rest of the fiels which I addded as names, address an phone numbers???


I hope I could have explained myself better than before......Thanks in advance....

 

I think you have not migrated the data over to your remote SQL 2005 database from your local SQL Express where you've created the additional fields. If your remote SQL 2005 database only contains membership data, you could use the Attach SQL tool in the control panel to attach the ASPNETDB.mdf file.

Aristotle

DiscountASP.NET
www.DiscountASP.NET

 

I did what you said but i recalled the file because last week I received this message:
Dear Customer,
The reason that the database has was not attached is because - '\App_Data\aspnetdb.mdf' does not exist on our server.Recall that once the database is dettached, you will need to ftp the mdf file to the DASP server.Once the upload completed, you will need to enter the path in the sql managements tools of the path of where the database resides


Then, I wanted to checkthe user data, thing that I could do through the Web Administration Tool but It only shows User ID/Email/Description. IfI want to check other user data like the one below what I need to do:


<asp:SqlDataSource ID="InsertExtraInfo" runat="server" ConnectionString="<%$ ConnectionStrings:LocalSqlServer %>"


InsertCommand="INSERT INTO [userAddress] ([UserId], [FirstName], [LastName], [Address], [City], [State], [zipCode], [Country], [Telephone], [Title], [University], [Specialty]) VALUES (@UserId, @FirstName, @LastName, @Address, @City, @State, @ZipCode, @Country, @Telephone, @Title, @University, @Specialty)"


ProviderName="<%$ ConnectionStrings:LocalSqlServer.ProviderName %>">


<InsertParameters>


<asp:ControlParameter Name="FirstName" Type="String" ControlID="FirstName" PropertyName="Text" />


<asp:ControlParameter Name="LastName" Type="String" ControlID="LastName" PropertyName="Text" />


<asp:ControlParameter Name="Address" Type="String" ControlID="Address" PropertyName="Text" />


<asp:ControlParameter Name="City" Type="String" ControlID="City" PropertyName="Text" />


<asp:ControlParameter Name="State" Type="String" ControlID="State" PropertyName="Text" />


<asp:ControlParameter Name="ZipCode" Type="String" ControlID="ZipCode" PropertyName="Text" />


<asp:ControlParameter Name="Country" Type="String" ControlID="Country" PropertyName="Text" />


<asp:ControlParameter Name="Telephone" Type="String" ControlID="Telephone" PropertyName="Text" />


<asp:ControlParameter Name="Title" Type="String" ControlID="Title" PropertyName="Text" />


<asp:ControlParameter Name="University" Type="String" ControlID="University" PropertyName="Text" />


<asp:ControlParameter Name="Specialty" Type="String" ControlID="Specialty" PropertyName="Text" />


</InsertParameters>


</asp:SqlDataSource>

 

I did what you said but i recalled the file because last week I received this message:
Dear Customer,
The reason that the database has was not attached is because - '\App_Data\aspnetdb.mdf' does not exist on our server.Recall that once the database is dettached, you will need to ftp the mdf file to the DASP server.Once the upload completed, you will need to enter the path in the sql managements tools of the path of where the database resides


Then, I wanted to checkthe user data, thing that I could do through the Web Administration Tool but It only shows User ID/Email/Description. IfI want to check other user data like the one below what I need to do:


<asp:SqlDataSource ID="InsertExtraInfo" runat="server" ConnectionString="<%$ ConnectionStrings:LocalSqlServer %>"


InsertCommand="INSERT INTO [userAddress] ([UserId], [FirstName], [LastName], [Address], [City], [State], [zipCode], [Country], [Telephone], [Title], [University], [Specialty]) VALUES (@UserId, @FirstName, @LastName, @Address, @City, @State, @ZipCode, @Country, @Telephone, @Title, @University, @Specialty)"


ProviderName="<%$ ConnectionStrings:LocalSqlServer.ProviderName %>">


<InsertParameters>


<asp:ControlParameter Name="FirstName" Type="String" ControlID="FirstName" PropertyName="Text" />


<asp:ControlParameter Name="LastName" Type="String" ControlID="LastName" PropertyName="Text" />


<asp:ControlParameter Name="Address" Type="String" ControlID="Address" PropertyName="Text" />


<asp:ControlParameter Name="City" Type="String" ControlID="City" PropertyName="Text" />


<asp:ControlParameter Name="State" Type="String" ControlID="State" PropertyName="Text" />


<asp:ControlParameter Name="ZipCode" Type="String" ControlID="ZipCode" PropertyName="Text" />


<asp:ControlParameter Name="Country" Type="String" ControlID="Country" PropertyName="Text" />


<asp:ControlParameter Name="Telephone" Type="String" ControlID="Telephone" PropertyName="Text" />


<asp:ControlParameter Name="Title" Type="String" ControlID="Title" PropertyName="Text" />


<asp:ControlParameter Name="University" Type="String" ControlID="University" PropertyName="Text" />


<asp:ControlParameter Name="Specialty" Type="String" ControlID="Specialty" PropertyName="Text" />


</InsertParameters>


</asp:SqlDataSource>

 

If all your data is in the same database, why not just use SQL Server Management Studio to create a SELECT statement and retrieve all the fields. I'm not sure you can customize the Web Administration tool to see custom fields, since I've never tried it.


dan