|
|
hi friends
select distinct(cname),names,address,phone from post_add
this my code.here i used distinct in one column but it is showed the following output.
this the rusult
ijjklokjlCHR3
sara CHR1
sara CHR2
how to solve error
regards
saravanan
|
|
|
|
|
This may be helpfull to you. Make sure that there may be uniquekey(cname) in another table.
http://www.15seconds.com/Issue/011009.htm
|
|
|
|
|
Why did you post this in the ASP.NET forum. This is purely a SQL question. It should be posted in the SQL Forum.
|
|
|
|
|
Hai,
I have datas in a table,i fetched it through the dataset,now i want to convert it as .CSV format in Asp.net(c#).
or
How to Convert a XML file to .CSV format -Asp.net(c#)
Thanks
m.s.s.kumar
|
|
|
|
|
I am generating a textfile I would like to drop on the c:\. This web app is going to run in my domain. I am also trying to drop a bitmap file.
How so I get access to create these files?
thanks
|
|
|
|
|
hi as you guys should know the standard provider create database and table wit called
ASPNETDB.MDF(database)
aspnet_Membership(table)
i would like to change the names to
datadb(database)
membership(table)
is tis possible and if it can anyone outline the steps involve to do this pls
|
|
|
|
|
1. Create a database named datadb
2. From the Visual Studio Command Prompt run aspnet_regsql
3. Choose "Configure SQL Server for application services"
4. Select server and database
5. Add a connection string to the web.config file to this database
6. From the %SystemRoot%\Microsoft.NET\Framework\v2.0.50727\CONFIG directory open machine.config file
7. Copy-paste the membership part of the system.web section to your web.config's system.web section
8. Change the name of the provider and the connection string property to your previously added one. Set the defaultProvider property to the name you gave the provider. Example:
<membership defaultProvider="MyMembershipProvider">
<providers>
<add name="MyMembershipProvider" connectionStringName="MyConnectionString" ... />
</providers>
</membership>
This takes care of the first part (custom database name). For the second part you should simply rename the table in the database, then also change the name in the stored procedures created in the database. Hypothetically this should work, but I can't guarantee it will. I think it's worth a shot though.
|
|
|
|
|
when u say Visual Studio Command Prompt on step 2 do u mean the normal command prompt or a command prompt within Visual Studio
as i didnt know know visual studio got 1
mind telling me where =P
|
|
|
|
|
soo if my connectionstring is
<br />
<connectionStrings><br />
<add name="HASDBConnectionString1" connectionString="Data Source=kingster\SQLEXPRESS;Initial Catalog=datadb;Persist Security Info=True;User ID=sas;Password=password"<br />
providerName="System.Data.SqlClient" /><br />
</connectionStrings><br />
<br />
then my membership provider would be
<br />
<membership defaultProvider="MyMembershipProvider"><br />
<providers><br />
<add name="MyMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="HASDBConnectionString1" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression="" /><br />
</providers><br />
</membership><br />
because i tried this and it just created another db wit the name aspnetdb.mdf
i am guessing i went wrong somewhere
|
|
|
|
|
thx man i got it to work
it turns out that if i want the role manager data to be save in the other db i need to copy that over too =)
|
|
|
|
|
Hi everyone,
I am only new in ASP.Net, and I have a problem about GridView and DetaisView.
And I am using MSSQL2005 as my backend for ASP.Net, but why is it that the GridView doesn't show up if there's no records
Is there a way on how to show the empty GridView and DetailsView? I am stuck with it.
I hope you will quide me how to do it.
Thanks in advance
hifiger2004
|
|
|
|
|
hi all 
I have using the web extension with asp.net 2.0. problem is that if we leave the browser open and disconnect the internet connection following message dialog box appear:
Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 12007
in some other cases message show as follows:
Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 2
i guess this problem is occur when the timer having on the open browser page
thats Tick event fire.
please suggest how should handle this problem.
Regards,
Srinandan
|
|
|
|
|
hi,
i am also having the same problem...
were you able to fix it?
|
|
|
|
|
hi guys its me again
i already add the membership and role feature to my sql database named (hogdb)
and is now trying to use hogdb as my provider database instread of the default aspnetdb.
i already tried going to the tab website->asp configuration and tryed to select a different datastore for the provider but all my attempt fail
anyone know how i can change the datastore of my provider infomation such as aspnet_Roles
thx ur help is appriatated
|
|
|
|
|
Classic ASP Script to check domain name availabilty
|
|
|
|
|
Apply the selection of first row to all other rows while paging in gridview.
The scenario is simple. You have a GridView control which has paging enabled and you also have a checkbox column in the GridView which allows the user to (apply to all other rows similar to first row selection) select items or all the items using the "ChkAll" checkbox in the header of the GridView.
|
|
|
|
|
hello all
can you tell me how to refesh the webform?
Gayatri
|
|
|
|
|
Use Javascript:
window.location.reload(true);
---
single minded; short sighted; long gone;
|
|
|
|
|
i incorporate squishyTREE in my project it is ok but more or less.the problem is whenever we click on the parent node then child node is not displaying.my code is perfect so please tell me where i am wrong and how could i fix this error.
tbhattacharjee
|
|
|
|
|
Hi all, I have one question about textbox. I want to have a break to start new line in control textbox. If I directly write "aaaaa
aaa" in mdb ,it can show two lines correctly. but in the input form when I key the same sentence in text box I can not save it.the error shows
A potentially dangerous Request.Form value was detected from the client (Text1="aaaaa
aaa"). Thank you for every suggestion
K.MD
Kit MD
|
|
|
|
|
wrote: potentially dangerous Request.Form value was detected from the client
On the top of the ASPX page write validaterequest="false"
|
|
|
|
|
Hi all, I have one question about textbox. I want to have a break to start new line in control textbox. If I directly write "aaaaa
aaa" in mdb ,it can show two lines correctly. but in the input form when I key the same sentence in text box I can not save it.the error shows
A potentially dangerous Request.Form value was detected from the client (Text1="aaaaa
aaa"). Thank you for every suggestion
K.MD
|
|
|
|
|
Not getting your query ?
Are you trying to pass text box value to next page ?
Thanks and Regards
Sandeep
If you want something you never had,
do something you have never done!
|
|
|
|
|
hello
i have one security form in that form when i will click add button that time small addsecurity form will be open, in that form i want to take security name, code etc fields and ok button .
when i click on ok button that time record will add on sql database.
ok
pls reply me
Gayatri
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
