ASP.NET

SQL Server Does not exits or Access denied

20-Feb-07 3:18

Internal postback means ?
Sorry i didn't understand your question please can you elaborate it ?

<l>Thanks and Regards
Sandeep

Aswanikumarj20-Feb-07 3:02

Aswanikumarj

20-Feb-07 3:02

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

Re: SQL Server Does not exits or Access denied

asithangae20-Feb-07 19:27

asithangae

20-Feb-07 19:27

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

Pager1 conflicts with pager2

iamdking20-Feb-07 1:59

iamdking

20-Feb-07 1:59

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.....

url problem

Tamimi - Code20-Feb-07 1:23

Tamimi - Code

20-Feb-07 1:23

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

Mark J. Miller20-Feb-07 1:33

Mark J. Miller

20-Feb-07 1:33

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.

Tamimi - Code20-Feb-07 1:41

Tamimi - Code

20-Feb-07 1:41

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

Mark J. Miller20-Feb-07 1:48

Mark J. Miller

20-Feb-07 1:48

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"

Sandeep Akhare20-Feb-07 1:44

20-Feb-07 1:44

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

session and application state example

Tamimi - Code20-Feb-07 1:58

Tamimi - Code

20-Feb-07 1:58

thank you Mark J. Miller and Sandeep
that was very helpful Smile | :)

When you get mad...THINK twice that the only advice
Tamimi - Code

anujose20-Feb-07 1:17

anujose

20-Feb-07 1:17

can anyone give example for session and application state

Re: session and application state example

Sandeep Akhare20-Feb-07 1:26

Re: Master Pages question

20-Feb-07 1:26

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

Master Pages question

Nada Adel20-Feb-07 0:58

Nada Adel

20-Feb-07 0:58

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.

Sandeep Akhare20-Feb-07 1:21

Re: Master Pages question

20-Feb-07 1:21

hi I am not getting Why have you given the link of your application From Internet it is not accesible by others ? Confused | :confused:

<l>Thanks and Regards
Sandeep

szukuro20-Feb-07 1:59

szukuro

20-Feb-07 1:59

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>

Re: Master Pages question

ed^nrgc20-Feb-07 7:12

ed^nrgc

20-Feb-07 7:12

Nada Adel wrote:
http://localhost:1157/KemetProjectRuntime/KemetProject.aspx

BWAAAHAHAHAHAAHA

Datagrid

A kamath20-Feb-07 0:17

A kamath

20-Feb-07 0:17

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.

sathesh pandian20-Feb-07 0:50

sathesh pandian

20-Feb-07 0:50

you can use the datagrid column style like this.
Dim s As Unit

s.Pixel(12)

DataGrid1.Columns(1).HeaderStyle.Width = s

Sathesh Pandian

A kamath20-Feb-07 0:55

A kamath

20-Feb-07 0:55

Thanks,
but I am working with ASP.Net/C#
can u explain what kind of datatype is unit

Vsree20-Feb-07 18:32

Vsree

20-Feb-07 18:32

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 Smile | :)

~Vsree

adding a map to web form?

A kamath20-Feb-07 20:45

A kamath

20-Feb-07 20:45

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 />

shaik_aks19-Feb-07 23:52

shaik_aks

19-Feb-07 23:52

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?..

Re: adding a map to web form?

Sandeep Akhare20-Feb-07 0:02