|
for eg.
in urs stored procedure use following
declare @temp int
set @temp = select count(*) from table
declare @@count int
set @count = 1
while(@temp >0)
Begin
Insert query
set @temp = @temp-1
End
|
|
|
|
|
I am getting the following error from an ASP Page:
System.Data.SqlClient.SqlException: Login failed for user 'AFFORDABLE02\ASPNET'
Now, I added AFFORDABLE02\ASPNET as a user to the database, Public...What am I missing?
This is the code that is causing the error:
dataSet11.Clear();
sqlDataAdapter1.Fill(dataSet11,"Customer");
Using MSDE
here is the connection string:
workstation id=AFFORDABLE02;packet size=4096;integrated security=SSPI;data source=AFFORDABLE02;persist security info=False;initial catalog=RentToOwn
Thanx in advance!
Jude
|
|
|
|
|
may be in urs connection string u r missing password.
|
|
|
|
|
The solution is :
U created the New User named "AFFORDABLE02"
but u dont give the permission.. so give permission.
So if u work on sqlserver then
click on "AFFORDABLE02" user
then click on "Permission" button
and select the tables for select,delete,insert,update...
your work is done...
Now Enjoy...
Dipan Patel.
|
|
|
|
|
Thanx for the response! I had the Affordable02 as a user but not Affordable02\ASPET...added that one and gave permission! Worked great!
While I have some fesh minds...how can you cotrol the size of a data grid?? I have tried setting the height properties, but that doesn't work. The problem is when there are just one or two returns from a select statement, the header and data regions are huge! But when more than 3 row are returned, it is normal size.
Thanx in advance
Jude
|
|
|
|
|
My.Computer.Network.UploadFile will copy a file from my local folder to a webserver but when I post the code to the webserver a problem occurs. It cannot find the source file. It seems like it is looking for the source file on the webserver instead of my local computer. When the UploadFile command runs on the webserver how do I get it to look for the source file on the local computer?
|
|
|
|
|
dptalt wrote: It seems like it is looking for the source file on the webserver instead of my local computer.
That is because in the context of running the website My.Computer IS the webserver.
I knew these stupid façade classes in the My namespace would be more trouble than they are worth! Badly named pieces of crap that just hide what is really going on spawning a Me, My, Fisher-Price generation of developers!
[Sorry, I just need to rant about something and the My namespace is a favourite of mine]
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
In .net how do you copying files from one computer to another going across the internet?
|
|
|
|
|
Hi
I have into my side one directory with name "web" and i want to link pages there but the problem is because my ("home") main web pages is into main directori.So when i click on some of my bottom i go to "web" directori but than i can't back to my home.Because give me that path web/home is not valid but i give Response.Redirect("default.aspx"); what i shout give there??
thanks
|
|
|
|
|
I have a server-side ImageButton:
<asp:ImageButton id="btnDoSomething" runat="server" StartContainer="maindirection" 0nClick="StartProcessButtonClick" AlternateText="Start process" ImageUrl="/public/buttonImage.jpg" />
(note I've changed the O in OnClick to a zero so this post displays correctly).
The button has the appropriate code-behind:
protected void StartProcessButtonClick(object sender, ImageClickEventArgs e)<br />
{<br />
if(sender is ImageButton)<br />
{<br />
}<br />
}<br />
This button works for 95% of the visitors to the site, but for a select few, it the server-side handler doesn't get called. It's absolutely consistent - it either works on a PC, or doesn't, but there's no logical pattern as to why it doesn't work.
Any ideas at all why the handler would get called for one client (running IE6 SP2) but not for another (same browser)??!!?!?
________________________
http://www.webreaper.net
-- modified at 12:04 Wednesday 3rd May, 2006
|
|
|
|
|
Do other server controls work on the machines where this doesn't?
Do the machines where it doesn't work have javascript disabled?
Current blacklist
svmilky - Extremely rude | FeRtoll - Rude personal emails | ironstrike1 - Rude & Obnoxious behaviour
|
|
|
|
|
Javascript is enabled, as are cookies, etc.
We have lots of other code running on that machine (we've got a development machine which the problem happens on, but all our other sites work on that machine).
It also comes and goes - I've had the problem on my development machine one day, and then a couple of hours later it stops happening and the site works correctly. It's most bizarre!
________________________
http://www.webreaper.net
|
|
|
|
|
if u have given AutoEventWireup="false" in the page directive then u have to give
Handles StartProcessButtonClick.Click
ie ..
protected void StartProcessButtonClick(object sender, ImageClickEventArgs e)Handles StartProcessButtonClick.Click
{
if(sender is ImageButton)
{
// blah
}
}
Other wise u have to make AutoEventWireup="true"
I am not sure whether this little information will solve your problem
|
|
|
|
|
I've tried changing the AutoEventWireup="true" but it doesn't make any difference, the event still fails to trigger. I wouldn't have thought a setting like that should affect it anyway (or, more to the point, if it was as simple as that, I wouldn't expect the code-behind call to trigger on any client at all, rather than working on some and not on others, as we're currently seeing).
Any other ideas?
________________________
http://www.webreaper.net
|
|
|
|
|
Bit of extra info: the odd thing is that we have 2 production servers running exactly the same code - one is used as a 'staging' server (i.e., sand-box pre-production site used for external client testing) and the other is the actual production site. Both are configured identically (one used to be the real production system before we migrated it to an alternate hosting environment).
The odd thing is that the IE client which exhibits the problem on the staging server, doesn't exhibit that behaviour on the production server. So you have the same binaries and presentation (.asXx) files on both servers, and yet the same IE client behaves differently depending on which server you use.
And yet my machine works perfectly when I run against either server.
It's a head-scratcher, alright...
________________________
http://www.webreaper.net
-- modified at 6:58 Thursday 4th May, 2006
|
|
|
|
|
|
I'm sorry, but what is a compiled date?
--------------------------------------------------------
My portfolio & development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
|
Hi all,
A problem has recently started to occur when building the MSI file for a
project I am working on.
Now, for some reason as soon as the setup proj tries to build the MSI file
the Windows Installer launches. I get "Please Wait While WIndows Configures
Visual Studio .NET Enterprise." Then another box pops up saying:
"Error 1706. No valid source could be found for product Visual Studio .NET
Enterprise Architect. Then Windows Installer cannot continue."
If this problem is sorted out i can continue installing this file in my server, so that it provides all the crystal report runtime files and i can start running my project in the server.
Hope i ll get help from ..
Thanks,
sarayu
|
|
|
|
|
Hi,
There is a page (Register.aspx) which contains a LoginView to Register a new user. If one is not logged into the system , then he can browse to this page and create a new user. BUT if I log in to the system as admin and then click on the Register.aspx, then nothing happens and the login view control does not get displayed.
Do you know why?
May be it is because this control only works if you are not logged in already?
Thanks
|
|
|
|
|
Hello,
Using the configuration I have created three roles i.e. (standard, supervisor, administrator)
1)How can I get these roles using code (vb.net or c#)?
2) How is it possible to see a list of all the users who have already creatred a login in the system using the Login control (p.s. using the asp.net configuration I can see the users but not sure how to display them on the web page and get a count of these standard users)
3)How is it possible to assign each standard user to an ID of a record in a database table? For example: user1 who is a standard user needs to be able to see areacode1,2,3
Something like the follwing where peter is a standard user and Ali is a supervisor. Notice that in this table I can not use the ID of the users because these users are created using the login control and there is no ID fo them, hence the name of the user.
ID username areaCodeID
1 "peter" 12
2 "Ali" 14
3 "Ali" 12
4 "Ali" 16
Thanks
|
|
|
|
|
Hello every one
i have a query related to calender control.
i have some radio buttons on click of which corresponding text boxes and buttons has to be enabled.and on click of the buttons,it opens a calender and populate the corresponding text box with the selected date.
its workin fine.
my problem is that i want to open the corresponding calendar just under the corresponding text box.
remember i have used only one calender.
actually it opens at the same place every time where it has been set at the design time.which creates confusion to the end user.
any solution regarding this will be highly appriciated.
thank u
ajay seth
|
|
|
|
|
the local site am developing enables a client to attach a word documents, to be downloaded later by other clients.
it would be better to use digital signature to increase security
how can i do this ???
or is there a tool that does that and can be used???
to be comprehensive:
its done through asking for your private key (no one knows it except u) before uploading the doc
and when downloading this doc the client is asked for the corresponding public key of the sender(the public key is distributed to all clients)
the private and public keys represents a pair given for each client
the main difficulty is in generating a private key and the corresponding public key.
-- modified at 8:15 Wednesday 3rd May, 2006
|
|
|
|
|
You could use digital certificates - each client is required to have a copy of a certificate installed on the machine they wish to use to access your site. The site could then verify their certificates and allow them to download the document as appropriate.
It saves complication with clients having to enter public key strings etc., but it does tie your clients to the machine(s) on which they have installed the cert.
|
|
|
|
|
I get the following error when visiting my newly published site:
It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.
the Source Error is the: authentication mode="Forms" line in the web.config file.
I have IIS 6.0
I have been googling a lot on this topic but all the answers i can find tell me that this error is due to the fact that the site is not created as a virtual directory. But mine is. I also have only one web.config file. I relly don't know what to do. My OS is MS Windows Server 2003 (for small business server) Would be greatful for any help!
/Robert
-- modified at 7:28 Wednesday 3rd May, 2006
|
|
|
|