For a webbased application:- what should be code in expert veiw, for retrievin

For a webbased application:-
what should be code in expert veiw, for retrieving a
single column name "username" from a server and checking
whether exported "username" from datatable doesn't exist in
server.
suppose i have saved in excelsheet a username="gayatri" ,
which is exported, then checked for whether this
username "gayatri" exist in server database or not ? if
exist then allow to enter new username, which should be
again checked for in loop , or else come out of loop and
enter a distinct "username".

plz let me have this answer in my id
gayatrisahooin@hotmail.com

Question Posted / gayatri

1 Answers
2281 Views
I also Faced
E-Mail Answers

For a webbased application:- what should be code in expert veiw, for retrieving a single column ..

Answer / Pallavi Singh

To achieve this, you can use VBScript, ASP, and SQL to create a web application. Here's an example of how the code might look like:

```vbnet
Dim connStr, cmdStr, rs, username
Set conn = CreateObject("ADODB.Connection")
conn.Open "Your_Server_Connection_String"

username = Request.QueryString("username") ' Get the username from the request
set rs = CreateObject("ADODB.Recordset")
rs.Open "SELECT username FROM UsersTable", conn

Do While Not rs.EOF ' Loop until we find a unique username
If rs!username = username Then ' Check if the username already exists in the database
Response.Write "Username already exists, please enter a different one."
Exit Do ' Exit the loop and end the script
End If
rs.MoveNext ' Move to the next record
Loop

rs.Close ' Close the recordset
conn.Close ' Close the connection"

' Save the username in an Excel file for further processing if needed
' ...
"

Send email with code to gayatrisahooin@hotmail.com

Is This Answer Correct ?

0 Yes

0 No

Post New Answer