Web Development

Re: Datagrid in vb.net 2003

5-Jul-07 0:32

DataBase Management System

Datagrid in vb.net 2003

saravanaks4-Jul-07 0:32

saravanaks

4-Jul-07 0:32

how to display textbox and combobox in datagrid and when clicking particular column I want to display a cell value to another cell in the same row.

Please give me sample code

Saravanan

koolprasad20034-Jul-07 3:10

koolprasad2003

4-Jul-07 3:10

dear Saravanan,

post in VB.NET forum U will get answer soon,

don't cross post the fourum

regards,
koolprasad2003 Smile | :)

Be a good listener...Because Opprtunity knoughts softly...N-Joy

unable to compare in javascript [modified]

rahul.net114-Jul-07 0:03

4-Jul-07 0:03

Hi
i am unable to compare in javascript.when i am compare boolean result
it
dosenot display output.following is the code.

function stateChangeHandler()
{
if (xmlHttp.readyState == 4 || xmlHttp.readyState == 'complete')
{
var result = new Boolean();
result = xmlHttp.responseText;

if ( result==false )
{
alert("not available");
var label=document.getElementById('lblMessage');
label.innerHTML='NotAvilable';
}
else if( result==true )
{
alert("available");
document.getElementById('nameList').innerHTML ='Available';
}
}
}

in my above code in result i am getting response true/false.
i am getting response from my vb.net code.is it case sensetive
because in vb.net it got True and in javascript we comp with true
when i am run the code it dose not compare the result (true/false) value
with given condition.Can anyone tell me where i am going wrong?

Thanks.

-- modified at 6:12 Wednesday 4th July, 2007

Luay.Essa4-Jul-07 0:50

4-Jul-07 0:50

I did not understand your question very well, but as i know:
The vb.net is NOT case sensitive. So 'True' is the same as 'true' in vb.net.

Can you post the called vb.net function code ?

rahul.net114-Jul-07 1:23

4-Jul-07 1:23

Hi Luay.Essa
i know vb.net is not case sensitive.in my application i am
checking username is available in database or not using AJAX.if user name
is available then i am sending false through Response.Write.When i catch
the response in javascript like
var result = new String(xmlHttp.responseText);
then i compare if response is False then giving message in label that
not available if response is True then i am giving message Available.
when i try to compare
if (result=='False')
{//message here
}
but it is not comparing.if condition become true means result contain False in that case also it goes to else loop.
i cant understand why?Cany u tell me why it is happening?

Thanks.

Luay.Essa4-Jul-07 2:30

Re: unable to compare in javascript [modified]

4-Jul-07 2:30

My first advice to you is to write the following line:
alert( result );
just to be sure what is the content of 'result': is it 'True' as keyword or 'True' as string.

My second advice and for everyone who faces a bug in javascript: is to use firefox with FireBug extension which displays the javascript error and allows you to debug the javascript code.

rahul.net114-Jul-07 2:47

4-Jul-07 2:47

Hi Luay.Essa,
I already write it.In alert it displays True.How did i know it is
a keyword or string. i am sending it as follow in my vb.net function.
dim isAvailable as boolean
then when i got response that user name is available or not if already in database then
isAvailable=0
response.Write(isAvailable)

then i caught response in result and watch it in alert(result);
when i saw response then it shows (True/False) depending on output
and it also shows HTML code on page in alertbox.

I cant understand your second advice.i am using firefox browser.

Thanks.

My code is as follow...

I am sending my code with it.

My javascript as follow.

function OnChangedUsername()<br />
{<br />
if(document.Form1.newuserid.value == "")<br />
{<br />
//document.Form1.btnCheckAvailability.disabled = true;<br />
}<br />
else<br />
{<br />
//document.Form1.btnCheckAvailability.disabled = false;<br />
}<br />
}<br />
<br />
function OnCheckAvailability()<br />
{<br />
if(window.XMLHttpRequest)<br />
{<br />
oRequest = new XMLHttpRequest();<br />
}<br />
else if(window.ActiveXObject)<br />
{<br />
oRequest = new ActiveXObject("Microsoft.XMLHTTP");<br />
}<br />
<br />
//oRequest.open("POST", "Avablity.aspx?strUsername=" + document.Form1.newuserid.value, true);<br />
oRequest.open("POST", "ProcessRequest.aspx", true);<br />
oRequest.onreadystatechange = UpdateCheckAvailability;<br />
<br />
oRequest.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");<br />
//var name=document.Form1.newuserid.value;<br />
<br />
oRequest.send("strCmd=availability&strUsername=" + document.Form1.newuserid.value);<br />
}<br />
<br />
function UpdateCheckAvailability()<br />
{<br />
if(oRequest.readyState == 4)<br />
{<br />
if(oRequest.status == 200)<br />
{<br />
var msg= new Boolean();<br />
 //var msg = new String(oRequest.responseText);<br />
alert(oRequest.responseText);<br />
//var msg=oRequest.responseText<br />
var label=document.getElementById("lblMessage");<br />
if (oRequest.responseText=='False')<br />
{<br />
alert("not");<br />
 label.innerHTML = 'NotAvailable';<br />
 label.style.color='Red';<br />
 }<br />
 else if (oRequest.responseText=='True')<br />
 {<br />
 alert("available");<br />
 label.innerHTML = 'Available';<br />
 label.style.color='Green';<br />
 }<br />
//document.getElementById("Result").innerHTML = unescape(oRequest.responseText);<br />
//document.getElementById("Result").innerHTML = msg;<br />
}<br />
else<br />
{<br />
document.getElementById("Result").innerHTML = "Asychronous Error";<br />
//var msg=document.getElementById("lblMessage");<br />
 //msg.innerHTML = oRequest.responseText;<br />
}<br />
}<br />
}<br />

This is my Server side Code of ProcessRequest Page.

 Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<br />
        'Put user code to initialize the page here<br />
        i = Request.Form("strUsername")<br />
        'i = Request.QueryString("q")<br />
        j = Request.Form("strCmd")<br />
        'i = Request.QueryString("value")<br />
        If i = Nothing Then<br />
        Else<br />
            IsUsernameAvailable(i)<br />
        End If<br />
    End Sub<br />
<br />
Public Function IsUsernameAvailable(ByVal Username As String) As Boolean<br />
        Dim cn As SqlConnection<br />
        Dim cmd As SqlCommand<br />
        Dim dr As SqlDataReader<br />
        'Dim isAvailable As Boolean<br />
        Dim str As String<br />
        Dim flg As Byte<br />
        Try<br />
            cn = New SqlConnection("connection string.")<br />
            cn.Open()<br />
            str = "select count(*) from CheckUser where UserName='" & i & "'"<br />
            cmd = New SqlCommand(str, cn)<br />
            flg = cmd.ExecuteScalar<br />
            If flg = 1 Then<br />
                isAvailable = 0<br />
                Response.Write(isAvailable)<br />
                'Response.Write("NotAvailable")<br />
                'Response.End()<br />
            Else<br />
                'Response.Write("Available")<br />
                isAvailable = 1<br />
                Response.Write(isAvailable)<br />
                'Return True<br />
                'Response.End()<br />
            End If<br />
        Catch ex As Exception<br />
            Response.Write(ex.Message + ex.StackTrace)<br />
        Finally<br />
            cn.Close()<br />
        End Try<br />
    End Function<br />

-- modified at 8:54 Wednesday 4th July, 2007

Luay.Essa4-Jul-07 3:10

Re: unable to compare in javascript [modified]

4-Jul-07 3:10

Try this:
var msg= new Boolean(oRequest.responseText);
// or var msg= oRequest.responseText;
if (! msg)
{
alert("not");
label.innerHTML = 'NotAvailable';
label.style.color='Red';
}
else
{
alert("available");
label.innerHTML = 'Available';
label.style.color='Green';
}

As for my second advice, see this page: https://addons.mozilla.org/en-US/firefox/addon/1843

Download the extension and use it in FX. Its very helpful to find bugs in the
javascript errors

rahul.net114-Jul-07 3:16

4-Jul-07 3:16

Yes i got your second advice i download it.Can i debug in javascript if the
javascript is externally available.
means javascript is not in head tag is external javascript and we give its
source in page.
I tried it in both cases(name available or not) it goes in else loop?

Thanks.

-- modified at 9:27 Wednesday 4th July, 2007

Luay.Essa4-Jul-07 19:01

4-Jul-07 19:01

rahul.net11 wrote:
Can i debug in javascript if the
javascript is externally available.

Yes, you can do it even if the javascript code in separate file

WoutL4-Jul-07 2:26

WoutL

4-Jul-07 2:26

Can you put alert(result); in your script to check the value?

Wout Louwers

rahul.net114-Jul-07 2:53

4-Jul-07 2:53

Hi WoutL,
I already write it.In alert it displays True/False(depanding on
user name availability)
i am sending it as follow in my vb.net function.
dim isAvailable as boolean
then when i got response that user name is available or not if already in database then
isAvailable=0
response.Write(isAvailable)

then i caught response in result and watch it in alert(result);
when i saw response then it shows (True/False) depending on output
and it also shows HTML code on page.

I am sending my code with it.

My javascript as follow.

function OnChangedUsername()<br />
{<br />
if(document.Form1.newuserid.value == "")<br />
{<br />
//document.Form1.btnCheckAvailability.disabled = true;<br />
}<br />
else<br />
{<br />
//document.Form1.btnCheckAvailability.disabled = false;<br />
}<br />
}<br />
<br />
function OnCheckAvailability()<br />
{<br />
if(window.XMLHttpRequest)<br />
{<br />
oRequest = new XMLHttpRequest();<br />
}<br />
else if(window.ActiveXObject)<br />
{<br />
oRequest = new ActiveXObject("Microsoft.XMLHTTP");<br />
}<br />
<br />
//oRequest.open("POST", "Avablity.aspx?strUsername=" + document.Form1.newuserid.value, true);<br />
oRequest.open("POST", "ProcessRequest.aspx", true);<br />
oRequest.onreadystatechange = UpdateCheckAvailability;<br />
<br />
oRequest.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");<br />
//var name=document.Form1.newuserid.value;<br />
<br />
oRequest.send("strCmd=availability&strUsername=" + document.Form1.newuserid.value);<br />
}<br />
<br />
function UpdateCheckAvailability()<br />
{<br />
if(oRequest.readyState == 4)<br />
{<br />
if(oRequest.status == 200)<br />
{<br />
var msg= new Boolean();<br />
 //var msg = new String(oRequest.responseText);<br />
alert(oRequest.responseText);<br />
//var msg=oRequest.responseText<br />
var label=document.getElementById("lblMessage");<br />
if (oRequest.responseText=='False')<br />
{<br />
alert("not");<br />
 label.innerHTML = 'NotAvailable';<br />
 label.style.color='Red';<br />
 }<br />
 else if (oRequest.responseText=='True')<br />
 {<br />
 alert("available");<br />
 label.innerHTML = 'Available';<br />
 label.style.color='Green';<br />
 }<br />
//document.getElementById("Result").innerHTML = unescape(oRequest.responseText);<br />
//document.getElementById("Result").innerHTML = msg;<br />
}<br />
else<br />
{<br />
document.getElementById("Result").innerHTML = "Asychronous Error";<br />
//var msg=document.getElementById("lblMessage");<br />
 //msg.innerHTML = oRequest.responseText;<br />
}<br />
}<br />
}<br />

This is my Server side Code of ProcessRequest Page.

 Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<br />
        'Put user code to initialize the page here<br />
        i = Request.Form("strUsername")<br />
        'i = Request.QueryString("q")<br />
        j = Request.Form("strCmd")<br />
        'i = Request.QueryString("value")<br />
        If i = Nothing Then<br />
        Else<br />
            IsUsernameAvailable(i)<br />
        End If<br />
    End Sub<br />
<br />
Public Function IsUsernameAvailable(ByVal Username As String) As Boolean<br />
        Dim cn As SqlConnection<br />
        Dim cmd As SqlCommand<br />
        Dim dr As SqlDataReader<br />
        'Dim isAvailable As Boolean<br />
        Dim str As String<br />
        Dim flg As Byte<br />
        Try<br />
            cn = New SqlConnection("connection string.")<br />
            cn.Open()<br />
            str = "select count(*) from CheckUser where UserName='" & i & "'"<br />
            cmd = New SqlCommand(str, cn)<br />
            flg = cmd.ExecuteScalar<br />
            If flg = 1 Then<br />
                isAvailable = 0<br />
                Response.Write(isAvailable)<br />
                'Response.Write("NotAvailable")<br />
                'Response.End()<br />
            Else<br />
                'Response.Write("Available")<br />
                isAvailable = 1<br />
                Response.Write(isAvailable)<br />
                'Return True<br />
                'Response.End()<br />
            End If<br />
        Catch ex As Exception<br />
            Response.Write(ex.Message + ex.StackTrace)<br />
        Finally<br />
            cn.Close()<br />
        End Try<br />
    End Function<br />

Rahul.

Check if app exists and open from internet

WoutL4-Jul-07 3:29

WoutL

4-Jul-07 3:29

Try this:

<br />
var result = oRequest.responseText.toLowerCase();<br />
<br />
if(result == 'false')<br />
{<br />
   ...<br />
}<br />
else<br />
{<br />
   ...<br />
}<br />

Wout Louwers

Connection help

boyindie3-Jul-07 23:07

boyindie

3-Jul-07 23:07

Hi
Forum

I was looking for some advice for my applicaiton and best way to go about it.

I have defined users within a mysql database in a usersTable, and my asp deals with logging in and out of the system, but I obviously still need to make the asp connect to the database in a secure way, as at moment i have a simple connection string that is hardcoded into the system, i am sure there is a much more secure way of getting around this problem, any help would be much appreciated

many thanks
boy

Dimkov3-Jul-07 22:54

Dimkov

3-Jul-07 22:54

I have a stand alone application (messenger). I was asked to the messenger to have the fallowing possibility:
from a link with a phone number parameter to make a call in the application. If the messenger is not installed, to take the client to the official web site. If the product is installed to see if it is open. If it is open and the user is logged in to make the call.

My idea is the client to check the registry and see if the product is there, which solves the first part. If there are certain keys in the registry next step is from the processes to see if the product is active. If active somehow send instruction to call the function : CallNumber( phonenumber phnum)

Can you give me any leads on how to do all this, any other solution to the task?

The project is done in C++

Thank you very much

Dimkov Trajce

Michael Sync3-Jul-07 23:10

Michael Sync

3-Jul-07 23:10

you are posting in wrong section..

Dimkov3-Jul-07 23:18

Dimkov

3-Jul-07 23:18

To me the obvious solution is writing javaScript... but I am not sure of javaScript capabilities of reading from the registry.
This is why I put it on the web development forum

Michael Sync3-Jul-07 23:42

Michael Sync

3-Jul-07 23:42

You wanna use javascript in your C++ standalone application??