ASP.NET

siddisagar11-Mar-07 23:15

11-Mar-07 23:15

Hi Harini,

Thanks for Quick Reply.I followed all steps that u mentioned above.
1.I didnot get any server names in the left list.
2.i given \\10.185.80.205 then it opened printers and faxes page.same message i got when i gave 'machine-name' in start-->run
3. i have given my system IPAddress in leftlist then it is visible in SqlServer tree.
4.In codebehind when i gave Data Source =ipaddress of my machine then also
i did not display any records from database.

Pls suggest me again ..Thank inAdvance.

Harini N K11-Mar-07 22:19

11-Mar-07 22:19

Hi
Then there is some mistake in your code behind ... post your code ...I will check it up.

Harini

siddisagar12-Mar-07 0:07

12-Mar-07 0:07

Hi ,I think problem with Data source only .Pls check my code.

Imports System.Data.SqlClient

Public Class DataGrid
Inherits System.Web.UI.Page

Dim conObj As New SqlConnection
Dim adpObj As New SqlDataAdapter
Dim dsObj As DataSet

Page_Load()
-----------

Try
conObj = New SqlConnection("Data Source=10.187.80.208;
user id=sa;password=sa;Database=Shopping")
conObj.Open()
adpObj = New SqlDataAdapter("SELECT * FROM Login", conObj)
adpObj.Fill(dsObj, "Login")
DataGrid1.DataSource = dsObj.Tables("Login")
DataGrid1.DataBind()
Catch ex As Exception
Response.Write(ex.ToString())
End Try
i am getting this following error.i tried Data Source=B4B-2F-323-CK26
" Login failed for user 'B4B-2F-323-CK26\ASPNET'".

imp point is when open servermanager 'B4B-2F-323-CK26' this is showing server name .Pls suggest me

Harini N K11-Mar-07 23:47

11-Mar-07 23:47

Hi
So Datasource is correct but what about Login name and password.

Try register again with login name and password (select SQL Account Login from the wizard).

Harini

siddisagar12-Mar-07 1:50

12-Mar-07 1:50

Hi Harini,

Fnally , I am getting message that server already Exists.So tell me How to Delete Existing one .Then I will register with SQl Account info afterwards.

Waiting for your Kind and valuable Reply.

Thank you.

Harini N K12-Mar-07 4:52

12-Mar-07 4:52

Hi

No need to delete the existing one. Right Click -> Edit SQL Server Registration. Change to SQL Logon instead of Windows Authentication.

Harini

siddisagar12-Mar-07 18:52

12-Mar-07 18:52

Yes Harini ,

Finally my problem solved.Thanks for so many replies and keep sending answers for Questions.

Thank you very much....

Harini N K12-Mar-07 19:07

Gride View Templete problem

12-Mar-07 19:07

That is great ... Sure will do

Harini

plz solve my problem

senthil_rajesh_kavin11-Mar-07 18:33

senthil_rajesh_kavin

11-Mar-07 18:33

hai,

I have a software in CD which contains .dll and an .exe of a software.I copied that software folder and put inside of a asp.net application and create a link to execute the software.but it didn't work.plz give me the solution.

Example:
---------

<Run the Software>
it gives the error that .dll files are needed to execute.

I made a folder and put both .dll and .exe in that,but error created.
please give the alternate solutions to execute the software through the Link in .net.

Re: plz solve my problem

N a v a n e e t h11-Mar-07 20:14

N a v a n e e t h

11-Mar-07 20:14

is that exe created using .net ? Try registering dll using regsvr32

Cheers
Navaneeth!!

www.w3hearts.com

nikhil123411-Mar-07 18:25

nikhil1234

11-Mar-07 18:25

when i am binding gird in page load it showing default values for check boxes in templet field means what ever at design time those but if i bind in button click then this is not happpned why is it so..

Re: Gride View Templete problem

N a v a n e e t h11-Mar-07 21:13

N a v a n e e t h

11-Mar-07 21:13

nikhil1234 wrote:
hat ever at design time those but if i bind in button click then this is not happpned why is it so..

When button is clicked page will post back and will execute all the contents in the page load. So try to call the binding function in pageload like this

if(!isPostBack)
{
//call bind function
}

Cheers
Navaneeth!!

www.w3hearts.com

Free ASP .NET shipping cart

szmulder11-Mar-07 14:16

szmulder

11-Mar-07 14:16

Install this software and you got yourself an online shop to sell ANYTHING!

..and run a professional internet business that will work for you 24/7,

so you have the freedom to quit your job and do things you really want to do with your time.

* Tiny size, only 2.0MB

* Automatic shipping fee calculation

* Unlimited number of items and categories

* Order and Accounts Manager

* Customize timeZone Support

* Customize Stock State Support

* Batch update Product price, desc, stock state

* News Manager

* AJAX support

Please Visit http://www.nzmk.com[^] to find out more!

Running on ASP .NET 2.0 & SQL 2000/2005

Cannot Update

blitz2bleach11-Mar-07 11:33

blitz2bleach

11-Mar-07 11:33

hello there,i know its not the righ place to ask some query,im cannot access my database in a query pane..i made a database where the username column has value and the password has none for e.g Username:93838383 and password:?..i just want to update the password column inputed by the user

I make the query in th stord procedure but th error said: Incomplete SET clause..unable to parse query text
i just want someone to check out the query and pls tell me what wrong or incomplete to my query

UPDATE UserTable
SET ((UserTable.[password] = [@password])
WHERE ((UserTable.username = [@username])

another thing is whenever the user visit the site,when the user type the password,it could not be updated anymore..unless i just want to use "select clause" because password column have now values...

here is the query

SELECT COUNT(*) AS Num_of_User
FROM UserTable
WHERE (((UserTable.username)=[@username]) AND ((UserTable.pasword)=[@password]));

error:unable to parse query text
it is correct query for accessing the values from the database?
im using a visual web developer IDE
thanx for helping

Re: Cannot Update

Guffa11-Mar-07 16:34

Guffa

11-Mar-07 16:34

blitz2bleach wrote:
I make the query in th stord procedure but th error said: Incomplete SET clause..unable to parse query text

Count your parentheses.

Also, don't you want to specify the parameters @password and @username instead of the fields [@password] and [@username]?

blitz2bleach wrote:
error:unable to parse query text

Same here, don't you want to specify the parameters @username and @password instead of the fields [@username] and [@password]?

Check the spelling of the field pasword / password.

---
single minded; short sighted; long gone;

how to execute an .exe file in asp.net application?

senthil_rajesh_kavin11-Mar-07 8:49

senthil_rajesh_kavin

11-Mar-07 8:49

ASP.NET mouse event

CodeBoi11-Mar-07 8:05

CodeBoi

11-Mar-07 8:05

I'm working with Visual Studio Express 2005 and ASP.NET.
I want to handle mouseevent (like mouse move) over a panel or image object, is it possible?

badgrs11-Mar-07 14:07

badgrs

11-Mar-07 14:07

onmouseover and onmouseout (google em)

CodeBoi11-Mar-07 23:36

CodeBoi

11-Mar-07 23:36

Really, i've tried to find, but nothing about ASP.NET, all about C# for Windows using System.Window.Form ( i'm looking for the web )

N a v a n e e t h11-Mar-07 20:22

N a v a n e e t h

11-Mar-07 20:22

using javascript you can

Cheers
Navaneeth!!

www.w3hearts.com