|
This article[^] should help you with your problems.
You can change the membership database by running the aspnet_regsql.exe utility from the Visual Studio command prompt.
Part 6 of the article explains how to add custom properties to user profiles.
Hope this helps.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Thanks for your answer
Isn't there another method to change database?
I am using a webhost, so i don't have access to .exe files
|
|
|
|
|
Not as far as I know. If you don't want to use the standard ASPNETDB.mdf database that resides in the App_Data to store membership info, I believe this tool is your only option.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi can anyone give me some idea /architecture how to audit all the changes made by web application to sql server data.
I want to audit user logins, and what all transactions(database and also application level events) they do in each session and also the table, fields they access, modify, old value and new value.
Rahul
|
|
|
|
|
I answered this yesterday.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi yaa u replied yesterday.. thnx!
i need any architecture idea how i can do that auditing.
with triggers i'm not able to get user sessions, username to store events associated with them. I want to use triggers but was looking for some idea tht would simply auditing...
|
|
|
|
|
If you don't use triggers, then you have to use seperate procs that you call. If the procs you're calling now take the userId, then you can use triggers, and get the user Id from the call that was made.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
hi there ,
I need to know if an ASP.net project written with VB can send data to excel sheet and perform specific mathematical operations (but simple)and then save it in SQL database created using SQL provided by the.Net environment ?
your help is appreciated I really need to know
or at least one of those functionalities 
thanks
knowledgestudent
There is always something to learn
|
|
|
|
|
Read up on the Excel Object Library[^].
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
This will only work if Excel is running on the server, why not do your own math ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
How can I configure my website on IIS in which browsers access on my site by writing the alias.
Example:
Browsers write the site name http://Intranet and they have to redirect in virtual path example: http://myserver/Intranet/Default.aspx
Hope I was clear
Regards
I Love SQL
|
|
|
|
|
You need to setup a DNS server. If you are using Windows server 2003 or 2000 you will find this. XP won't support I guess.
|
|
|
|
|
Hi Friends,
I am using GridView. Therein , i am making edit, addnew,delete all the three functions.
Now i am using Validators for the TextBoxes.
I am putting Validators in FooterTemplate for Addnew TextBoxes and in EditTemplate for Edit TextBoxes.
The Validators work for once. That is if i click AddNew LinkButton it will give me the Error message, but once i use Edit or Update and then try it again. It doesnt work.
I think it is losing the ClientID of the textbox?
I am not sure, but i felt so. Because earlier i was using the Ajax ValidatorCallout, which was displaying me Javascript Error message in this situation that, ControlToValidate is null.
Yes i even tried simple JavaScript
Eg: var NewName
NewName = document.getElementById("ctl00_ContentPlaceHolder1_GVGuide_ctl05_txtNewName");
alert(NewName);
for above line it is not able to Get the Control, NewName is always NULL
and
$get('<%=txtNewPhone.ClientID %>').innerText;
this one above code gives me error txtNewPhone doesnt exist, which is inside the GridView.
I am really lost...
All i am trying to do is get a decent grid which can work with validators.
Any Suggestion or Help would be highly appreciated.
If you need to see my code in detail please let me know i will post it here.
Thanks
Cheers
Menon
|
|
|
|
|
hi,
the login page is not in our control but after successfully login from another vendors login page what are the pages to be displayed are under our control.
requirement1: when i open the pages which r under our control any body can find the url and if we copy and paste the url in a new browser then the page should not be displayed , in place it will redirect to login page again.
requirement2: when session is destroyed by the vendor who has the owner of this login page then we should display a message that session has expired in our pages.
Please if any body knows this problem help me
thanks and regards
bikash pattanayak
|
|
|
|
|
Store the user info in session variable.
On Page_Load event of each page check if session is not null.If it is null then redirect the user to the login page.
|
|
|
|
|
I am taking a average of a score and want to show it in a data grid, as a percentage value, below is a query, How do i represent this as a percentage value in a data grid.
right now i am getting it as a decimal value, ex(0.98,0.80)
select Manager_Name, avg (KC_Score) as score from dbo.KC
group by Manager_Name
Please advice....
NvN
|
|
|
|
|
Multiply your decimal value by 100. Hey presto, it's now a percentage!
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
the value is in decimal format ex-0.90,and i want to show it as 90%,
i don’t think Multiplying with 100 solves my issue.
NvN
|
|
|
|
|
0.90 * 100 = 90. Stick a % sign on the end and voila - you've got '90%'.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
hi all
i have page load usercontrol
Control cul = null;
switch (strParam)
{
case "viewcategoryproduct":
cul = LoadControl("admin/uc_CategoryPro.ascx");
break;
}
divbody.Controls.Add(cul);
But when i load usercontrol so the function page_load always run 2 time. I dont understand
And into my usercontrol have 2 dropdownlist
the fist dropdownlist have property is AutoPostBack="True" OnSelectedIndexChanged="ddlNews_SelectedIndexChanged"
the second dropdownlist will load data when ddlNews_SelectedIndexChanged
and button
but have problem
when i SelectedIndexChanged the fist dropdownlist so the second after load data
after that i click button but in CodeBehind it continue run to the event ddlNews_SelectedIndexChanged
????
some body tell me why
|
|
|
|
|
sir ,
I am faced problem that datasource does not support server side data pagging when using datareader with gridview.
thanks
|
|
|
|
|
I have a column in a report which displays an amount of currency. The currency is stored in sqlserver databse as 'Money' data type.
My problem is when I run the report it rounds off the value and does not disply to any decimal places. I want it to display the currency as 2 decimal places as this is how it is input and stored in the database.
anyone know how to do this?
macca
|
|
|
|
|
You haven't explained which reporting tool you are using. However the .NET syntax to format a number to 2dp would be something like mynum.ToString("N2").
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
I have enabled paging in my datgrid but when I click on page 2 I get the following Error message:
The GridView 'DateGrid' fired event PageIndexChanging which wasn't handled.
Anyone know what code I need to handle this?
Thanks,
macca
|
|
|
|
|
In your DataGrid1_PageIndexChanged event write:
this.DataGrid1.CurrentPageIndex = e.NewPageIndex;
this.BindDataGrid( );
Note:BindDataGrid is just to bind the grid with datasource.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
