|
We have sql server with the name production1 (IPID:100.102.33.33) ,from asp.net iam able to connect properly ,yesterday we changed the ip Id of this system(production1) from that time if iam trying to connect from asp.net code it is giving error sqlserver does not exists access denied.
Iam able to connect in query analyzer for the same sql server by using same userid,password.
Iam able to connect in vb.net for the same sql server with same connection string which iam using in asp.net
Iam unable to connect in asp.net error sqlserver does not exists access denied.
Please help me is there any problem with asp user or what?
Thanks
|
|
|
|
|
Hai,
add the user ASPNET to the database you are using.
select the user from the list not by typing...
the user must be in the list of local users list or add the production webserver aspnet user to the database, if iis and database are in different machine.
this will work..
lot of links is available in google, try the appropriate one for you,
cheers
asithangae
|
|
|
|
|
Hello friends...I use 2 datalists say dtlist1 and dtlist2 and two pagers say pager1 and pager2 for each of them resp..and onpageload dtlist2 is displayed by default. When user clicks on a button dtlist1 is displayed...and after clicking on the pager for that datalist1 ..It shows second datalist i.e. dtlist2 ....becoz on page load dtlist2 is to displayed..To avoid such confict in pager..i decide to use datagrid which has its own pager..Then the problem occurs to show datagrid horizontally...Do anyone have any solution.....
|
|
|
|
|
Hi CP
Suppose that I have a url in s string, how can I get the site name i.e
Dim strURL as string = http://www.codeproject.com/script/comments/forums.asp?forumid=1640 "".
Then how can I extract the string " www.codeproject.com ", for sure we can do it with string manipulation, but is there another way ??
thank you all
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
Try using System.Uri. It's properties break up a url into segments which allow you to get any info you want out of the url w/o using string manipulation or writing your own regex.
|
|
|
|
|
thank you
but can i ask you what this line of code returns ??
Request.Url.GetLeftPart(UriPartial.Authority)
on my machine it returns http://localhost ,but what it will return
when i publish my application ??
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
From VS 2005 Documentation for System.Uri.GetLeftPart Method:
http://www.contoso.com/index.htm?date=today
returns "http://www.contoso.com"
http://www.contoso.com/index.htm#main
returns "http://www.contoso.com"
mailto:user@contoso.com?subject=uri
returns "mailto:user@contoso.com"
nntp://news.contoso.com/123456@contoso.com
returns "nntp://news.contoso.com"
news:123456@contoso.com
returns "news:123456@contoso.com"
file://server/filename.ext
returns "file://server"
|
|
|
|
|
Hi
i found this one
String URL ="http://www.codeproject.com/script/comments/forums.asp?forumid=1640";
HttpRequest req = new HttpRequest("", URL, "");
string str= req.Url.Authority;
<l>Thanks and Regards
Sandeep
|
|
|
|
|
thank you Mark J. Miller and Sandeep
that was very helpful 
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
can anyone give example for session and application state
|
|
|
|
|
Hi
Which type of example you are asking for
Session["sandeep"] = "SomeValue";
Application["Akhare"] = "Throughout Application";
you can use this way
Session is used for perticular period(session only)after then it lost its value
where as application can retain the values even though session is lost i.e through out your application. Google it for more Info
<l>Thanks and Regards
Sandeep
|
|
|
|
|
Hi, I created a master page with a contentplacementHolder, then I created a .aspx page that displays a google map. I want the div control that holds the map to be bound with the contentplacementHolder in the master page
Here's the link:
http://localhost:1157/KemetProjectRuntime/KemetProject.aspx
I don't know how can I do that, the code is so complicated.
|
|
|
|
|
hi
I am not getting Why have you given the link of your application From Internet it is not accesible by others ? 
<l>Thanks and Regards
Sandeep
|
|
|
|
|
Only Contents can be "bound" to ContentplaceHolders. Put one around your div, and that's it:
<asp:Content ID="Content1" runat="server" ContentPlaceHolderID="DependsOnMasterPage">
<div>
...
</div>
</asp:Content>
|
|
|
|
|
Nada Adel wrote: http://localhost:1157/KemetProjectRuntime/KemetProject.aspx
BWAAAHAHAHAHAAHA
|
|
|
|
|
I am new to this field can anybody help please.
I want to set a particular column in datagrid to maxlength.
eg. I have a description column I want to set this column to a particular length and have to see details(full length ) in details view.
|
|
|
|
|
you can use the datagrid column style like this.
Dim s As Unit
s.Pixel(12)
DataGrid1.Columns(1).HeaderStyle.Width = s
Sathesh Pandian
|
|
|
|
|
Thanks,
but I am working with ASP.Net/C#
can u explain what kind of datatype is unit
|
|
|
|
|
hi
U can try like
<asp:TemplateColumn HeaderText="Description">
<HeaderStyle Width="25%"></HeaderStyle>
<ItemTemplate>
<asp:Label id="lblDescription" runat="server" Text= '<%# DataBinder.Eval(Container, "DataItem.Description") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
Here in "DataItem.Description"-- Description is the fieldname as in table.Use what fieldname what u want to display.
"Width = 25%" means that that coulumn takes 25% of your grid's width..
Try this .Hope this helps U
~Vsree
|
|
|
|
|
Thanks.
I had given like this but it is not working.Description column has become empty. no values there
<br />
</asp:TemplateField><br />
<asp:BoundField DataField="OUTCOME" HeaderText="OUTCOME" SortExpression="OUTCOME" /><br />
<asp:TemplateField HeaderText="DESCRIPTION" SortExpression="DESCRIPTION"><br />
<HeaderStyle Width ="25%" /><br />
<EditItemTemplate><br />
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("DESCRIPTION") %>'></asp:TextBox><br />
</EditItemTemplate><br />
<ItemTemplate><br />
<asp:Label ID="Label1" runat="server" Text='<% DataBinder.Eval(Container,"DESCRIPTION") %>'></asp:Label><br />
</ItemTemplate><br />
</asp:TemplateField><br />
|
|
|
|
|
how do i add a UK map to a web form in asp.net 2.0.?. where can i get a map of UK with all the places in UK?., please help me in writing code to consider a place that is selected using the map?..
|
|
|
|
|
Depending upon the type of map file .........
might be Image control is usefull if the map file is compatible with it
<l>Thanks and Regards
Sandeep
|
|
|
|
|
Respected Gurus
I have two text boxes which retrieves the values of a financial year.
eg.2006-2007.
User will manually enter 2006 in first one and on LOST FOCUS of it second should fill with 2007.
Can any one give some javascript code to do it.
I m using...
function Getvalue()
{
var from;
var to;
from=document.all['txtFinYearFrom'];
to=from+1;
document.all['txtFinYearTo'].value=to;
document.Form1.submit();
}
HTML--------
<asp:textbox id="txtFinYearFrom" runat="server">
<asp:textbox id="txtFinYearTo" runat="server">
In Page load of my codebehind file--------------
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As ystem.EventArgs) Handles MyBase.Load
Me.txtFinYearTo.Attributes.Add("onfocus", "Getvalue();")
txtFinYearTo.Text = Request.Form("txtFinYearTo")
End Sub
After running it i get NaN in the desired textbox instead of 2007(2006+1).
Any Help.
|
|
|
|
|
use parseInt while adding
to=parseInt(From.value)+1
Nana
|
|
|
|
|
Now i m getting error....
function Getvalue()
{
var from;
int to;
from=document.all['txtFinYearFrom'];
//from=document.getElementById("txtFinYearFrom");
//to=parseint(from.value)+1;
to=(from.value)+1;
document.all['txtFinYearTo'].value=to;
document.Form1.submit();
}
wht to do?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
