ASP.NET

Hasan Ali19-Apr-07 5:37

19-Apr-07 5:37

"Select WPITEM ||'-'|| WPITMSEG from table"

rama charan19-Apr-07 5:48

rama charan

19-Apr-07 5:48

hi..
i think u are not clear

Rama Charan Prasad

"Be happy and Keep smiling.Thats what u want be always.. Smile | :)

Hasan Ali19-Apr-07 7:26

19-Apr-07 7:26

Dim i As Integer = 0
For i = 0 To gv_mres.Rows.Count - 1
Dim myButton As Button = CType(gv_mres.Rows(i).Cells(1).Controls(0), Button)
Dim myButtonEdit As Button = CType(gv_mres.Rows(i).Cells(2).Controls(0), Button)
'Dim lit_ref_road As Literal = CType(gv_mres.Rows(i).Cells(8).Controls(0), Literal)
' ''Dim str As String = gv_mres.Rows(i).Cells(8).Text
Dim county As String = gv_mres.DataKeys(i)(2).ToString()
Dim muni As String = gv_mres.DataKeys(i)(3).ToString()
Dim rt As String = gv_mres.DataKeys(i)(4).ToString()
Dim rn As String = gv_mres.DataKeys(i)(5).ToString()
Dim rs As String = gv_mres.DataKeys(i)(6).ToString()
Dim mp As String = gv_mres.DataKeys(i)(11).ToString()
Dim myear As String = gv_mres.DataKeys(i)(8).ToString()
Dim offset As String = gv_mres.DataKeys(i)("MILEPOINT_OFFSET").ToString()
Dim logmile_dir As String = gv_mres.DataKeys(i)("LOGMILE_DIR").ToString()
Dim rt_suf_str As String = ""
If rs = "" Then
rt_suf_str = " ROUTE_SUFFIX IS Null "
Else
rt_suf_str = " ROUTE_SUFFIX ='" & rs & "' "
End If
If gv_mres.DataKeys(i)(9) = "M" Then
myButtonEdit.Visible = True
Else
myButtonEdit.Visible = False
End If
'''' Show/Hide Near Point Button'''
Try
If gv_mres.DataKeys(i)(10) <> 0 Then
myButton.Visible = False
Else
myButton.Visible = True
End If
Catch ex As Exception
myButton.Visible = True
End Try

Hasan Ali19-Apr-07 8:52

19-Apr-07 8:52

"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\App1\Your_Database_Name.mdb; User Id=admin; Password="

Hasan Ali19-Apr-07 8:54

19-Apr-07 8:54

connectionStrings
add name="MembershipConnectionString" connectionString="connectionString"/
/connectionStrings

Hasan Ali19-Apr-07 9:09

Restrict User to visit any middle page

19-Apr-07 9:09

Dim strConnString As String = ConfigurationManager.ConnectionStrings("LocalSqlServer").ConnectionString

chat window

saravanan0519-Apr-07 4:25

saravanan05

19-Apr-07 4:25

hi friends

how to creat chat window in asp,c#.net

can u help me

regards
saravanan

Re: chat window

steffw19-Apr-07 4:31

steffw

19-Apr-07 4:31

first of all you would need an place for the output and a place to type Smile | :)

You have a window now!

When i made my first chatbox i used some javascript(getting the text from te text file every 2 seconds, this with a XmlHttp object) and php (for placing the text you typed into a text file)

I'd made a function with some dutch words in it (cause i am), this one for getting the page, it works as follows: getPage('http://yourside/yourfile.txt,'divID to fill with result');

Now you only need a way to place the text in the text file, you can do this with an StreamWriter

<br />
var xmlHttp<br />
<br />
function GetXmlHttpObject()<br />
{<br />
    // XML object maken<br />
    var objXMLHttp=null<br />
    if (window.XMLHttpRequest) // FireFox<br />
    {<br />
        objXMLHttp=new XMLHttpRequest()<br />
    }<br />
    else if (window.ActiveXObject) // IE<br />
    {<br />
        objXMLHttp=new ActiveXObject("Microsoft.XMLHTTP")<br />
    }<br />
    return objXMLHttp<br />
}<br />
<br />
<br />
<br />
function getPage(str,doel)<br />
{<br />
    if (str.length==0)<br />
    {<br />
        document.getElementById(doel).innerHTML=""<br />
        return<br />
    }<br />
    xmlHttp=GetXmlHttpObject()<br />
    if (xmlHttp==null)<br />
    {<br />
        alert ("Browser does not support HTTP Request")<br />
        return<br />
    }<br />
    var url=str;<br />
    <br />
    xmlHttp.onreadystatechange = function stateChanged()<br />
    {<br />
        if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")<br />
        {<br />
            document.getElementById(doel).innerHTML=xmlHttp.responseText<br />
        }<br />
    }<br />
    xmlHttp.open("GET",url,true)<br />
    xmlHttp.send(null)<br />
}<br />

i hope i helped you, not sure if i did Smile | :)

Stef

meeram39519-Apr-07 4:18

meeram395

19-Apr-07 4:18

Hi,

Suppose if any user directly typed visit any middle page of application without going to login page or home page, how can I restrict that? How will I make sure that user should always visit the login page or home page if not logged in? Any help in this regard will be great.

Thanks

Meeram395

Re: Restrict User to visit any middle page

Tarakeshwar Reddy19-Apr-07 4:40

Tarakeshwar Reddy

19-Apr-07 4:40

It depends on what method you are using to store the Username/Password of the logged user. If your using sessions, you can check if the username/password session is empty in the page load and redirect him to the login/home page.

Pass string to error page

mail57235219-Apr-07 3:45

mail572352

19-Apr-07 3:45

Hi,

My code needs to send a string (error text) to an error page. What's the best way of doing it? The string might be quite long so I want to avoid just sending it as a parameter to the page though that's possible if the error string is short enough.

Re: Pass string to error page

Tarakeshwar Reddy19-Apr-07 3:55

Tarakeshwar Reddy

19-Apr-07 3:55

The best way is to send an error code which could be used by the error page to get the error description from some kind of key value pair storage

Re: Pass string to error page

mail57235219-Apr-07 13:37

mail572352

19-Apr-07 13:37

Thanks, I want to avoid an error code though because I want to display the actual exception detail if I get any and I can't guess as to what exceptions or detail I will get.

My solution is that I've used a session variable instead because I can create it when an exception occurs and clear it after I've displayed it.

Hyperlinks in datagrid!

nclauder19-Apr-07 3:27

nclauder

19-Apr-07 3:27

Hi all,
I have two datagrid, one has a list of allowed user of the second datagrid. The second datagrid is an inserting datagrid and it Function properly. Now where my problem is I need to be able to select a particular name and will be able to see whatever the Particular selected user has been inserting in the insert datagrid. So I made the names in Hyperlink and and this is the code I'm using but it's not to be working:
<ItemTemplate>
<asp:HyperLink id=HyperLink1 runat="server" NavigateUrl='../Dash_Board/DashBoard.aspx?Name=<%# DataBinder.Eval(Container.DataItem,"TeamBilling")%>'
Text='<%#DataBinder.Eval(Container.DataItem,"TeamBilling")%>'></asp:HyperLink>
</ItemTemplate>
When I press the Name nothing changing. Where could be the problem?
Thanks.

Re: Hyperlinks in datagrid!

kubben19-Apr-07 5:32

kubben

19-Apr-07 5:32

I would check your source when you have the page in your browser. Just go to view source. See what is actually in your navigateurl. I am guessing you actually want the code to look something like this:

NavigateUrl='<%# "../Dash_Board/DashBoard.aspx?Name="+DataBinder.Eval(Container.DataItem,"TeamBilling").ToString()%>'

Hope that helps.
Ben

Re: Hyperlinks in datagrid!

nclauder19-Apr-07 19:24

nclauder

19-Apr-07 19:24

Thanks Kubben,
It's close to that only that it does not selects What the selected person wrote in the insert Datagrid. other wise now in the view source the URL looks like this:
<a id="dgbilling__ctl2_HyperLink1" href="../Dash_Board/DashBoard.aspx?Name=Claude">Claude</a>
Thanks.

Export Excel Problem [modified]

Karthik Kommandi19-Apr-07 3:01

Karthik Kommandi

19-Apr-07 3:01

Hi All,
How can I Export data from dataset to Excel with print layout. when we see this Excel report in print view the page numbers should be appear in the format of [Page x of y].

Please also suggest me how can I add Header and Footer to that Excel report.
I am very pleased if anybody help me regarding this.

Thanks in advance

karthik

-- modified at 9:20 Thursday 19th April, 2007

Problem with DataReader and SQL Express

kallileo19-Apr-07 2:15

19-Apr-07 2:15

Sub Page_Load(ByVal Sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load

If Not Page.IsPostBack Then
Dim SQLconn As New SqlConnection("Server=(local)\SQLExpress;Initial Catalog=Test;Integrated Security=True")
SQLconn.Open()
Dim Query As String = "SELECT rawvalue FROM Device1 WHERE device = 'Channel1'"
Dim SelectCmd As New SqlCommand(Query, SQLconn)
Dim result As Boolean

SQLconn.Open()
Dim myDataReader As SqlDataReader
myDataReader = SelectCmd.ExecuteReader()
result = myDataReader.GetBoolean(0)
SQLconn.Close()

ChangeButton(result)
End If
End Sub

Sub ChangeButton(ByVal Status As Boolean)
If Status Then
OnOff.Text = "Press to Close"
Label1.Text = "ON"
Label1.BackColor = Drawing.Color.Green
Else
OnOff.Text = "Press To Open"
Label1.Text = "OFF"
Label1.BackColor = Drawing.Color.Red
End If
End Sub

I have this code to change some properties of a label and a button. The problem is that I get and error while debbugging this in Visual Web Developer.
The error is:
"The connection was not closed. The connection's current state is open."

The problem is in line 21 "SQLconn.Open()"

Stack Trace:

[InvalidOperationException: The connection was not closed. The connection's current state is open.]
System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +56
System.Data.SqlClient.SqlConnection.Open() +229
ASP.mapurls_p2_aspx.Page_Load(Object Sender, EventArgs e) in C:\Websites\Project\MapUrls\p2.aspx:21
System.Web.UI.Control.OnLoad(EventArgs e) +88
System.Web.UI.Control.LoadRecursive() +74
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3034

Thanks!

Paddy Boyd19-Apr-07 2:24

Paddy Boyd

19-Apr-07 2:24

You have two calls to Open().

kallileo19-Apr-07 2:55

19-Apr-07 2:55

Yes. Thank you.
I deleted "Handles MyBase.Load" and I don't get the error message now.

The problem now is that I don't get any values in my Button and Label controls.
I mean the Boolean value passes to ChangeButton procedure that should initialize the controls.

QLconn.Open()
Dim myDataReader As SqlDataReader
myDataReader = SelectCmd.ExecuteReader()
myDataReader.Read()
result = myDataReader.GetBoolean(0)
myDataReader.Close()
SQLconn.Close()

ChangeButton(result)

Sub ChangeButton(ByVal Status As Boolean)
If Status Then
OnOff.Text = "Press to Close"
Label1.Text = "ON"
Label1.BackColor = Drawing.Color.Green
Else
OnOff.Text = "Press To Open"
Label1.Text = "OFF"
Label1.BackColor = Drawing.Color.Red
End If
End Sub

Paddy Boyd19-Apr-07 3:03

Paddy Boyd

19-Apr-07 3:03

Why would you delete the handle from the event??

The only problem you had was that you were opening the connection twice...

kallileo19-Apr-07 3:09

19-Apr-07 3:09

Man. Thank you again!!!!!!
I'm so stupid and blind. I put the handle and it works perfect.

If you have the time can you please explain me why this handle is needed?

Paddy Boyd19-Apr-07 3:25

Paddy Boyd

19-Apr-07 3:25

You can name your page load sub to be whatever you like (as long as it has the right method signature). The handles keyword tells the system which function to fun on page load...

If you want some more info, read up on events within asp.net.

kallileo19-Apr-07 3:35