this is my web.config - ASP.NET Discussion Boards

You can create any file you like with File.WriteAllText.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Hi dear,

i face a problem here,

use asp.net with c#....

conConnectionOTHER= new OdbcConnection(
"PWD=; SourceType=DBC;DSN=payroll;Collate=Machine;Deleted=Yes;BackgroundFetch=Yes;Exclusive=Yes;
SourceDB=C:\\payroll\\data\\myapp.dbc;Null=Yes;UID=");

=======================================================================================
//Success
conConnectionOTHER.Open();
OdbcCommand cmdGetHistory;
OdbcDataReader dtrGetHistory;
string strGetHistory="select * from sol where employeeid='000007'";
cmdGetHistory=new OdbcCommand(strGetHistory,conConnectionOTHER);
dtrGetHistory=cmdGetHistory.ExecuteReader();
DataGrid2.DataSource=dtrGetHistory;
DataGrid2.DataBind();
conConnectionOTHER.Close();
//end

Result is success, it can bind and show in data grid
======================================================================================

//Fail Here
conConnectionOTHER.Open();
OdbcCommand cmdUpdate;
string strUpdate="Update sol set type='LEA' where employeeid='000007'";
cmdUpdate=new OdbcCommand(strUpdate,conConnectionOTHER);
cmdUpdate.ExecuteNonQuery();
conConnectionOTHER.Close();

//end

Result is fail, cannot update record

Server Error in '/linkToPayroll' Application.
--------------------------------------------------------------------------------

ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.Odbc.OdbcException: ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor.

Source Error:

Line 37: string strUpdate="Update sol set type='LEA' where employeeid='000007'";
Line 38: cmdUpdate=new OdbcCommand(strUpdate,conConnectionOTHER);
Line 39: cmdUpdate.ExecuteNonQuery();
Line 40: conConnectionOTHER.Close();
Line 41:

Source File: c:\inetpub\wwwroot\linktopayroll\webform1.aspx.cs Line: 39

========================================================================================

Please need your guideline.......help
Thank you very much

from : eva

try running the query in query analyzer in sql server to see if it works

hi, i'm new in this. i've been doing a prgm using vb.net with asp.net and it's working when i run it in my local pc. but, when i deploy it to my server the database r pointing to my local pc. i've check my web config and my coding. but all are written to point to the server dbase. i know it's pointing to my local pc bcoz i rename my DB in the local pc. so when i run at the server, the prgm told me my table name is invalid eventhough the table r there at the server. but when i rename my DB at the local pc ti it's original name, the prgm shows all the data from my local DB. it can add data but to my local DB. help me pls.. this is my first time doing a prgm..

This is a re-post.

Shhhhh.....
http://craptasticnation.blogspot.com/[^]

To be fair, I told him he was in the wrong forum and it belonged here.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

yup, b4 this i'm in the wrong forum. and it's not him, it's her... Smile | :)

where to know the mistake if i try to debug and there's a massage say cannot debug bcoz windows authenthication is disable. but the prgm can run without debug and there's no problem with it.

<?xml version="1.0" encoding="utf-8"?>
<configuration>
<appSettings>
<add key="strConn" value="data source=MISKPI;User ID=sysadm;Password=sysadm;Initial Catalog=SPGALatihan;Persist Security Info=True;"/>
</appSettings>
<system.web>


<compilation defaultLanguage="vb" debug="true"><assemblies><add assembly="CrystalDecisions.CrystalReports.Engine, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/><add assembly="CrystalDecisions.ReportSource, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/><add assembly="CrystalDecisions.Shared, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/><add assembly="CrystalDecisions.Web, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/></assemblies></compilation>



<customErrors mode="RemoteOnly"/>


<authentication mode="Windows"/>


<authorization>
<allow users="*"/> 


</authorization>


<trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true"/>


<sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes" cookieless="false" timeout="20"/>


<globalization requestEncoding="utf-8" responseEncoding="utf-8"/>

</system.web>

</configuration>

zaimah wrote:
data source=MISKPI

To point to a machine on the network, you need a network path.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

sorry in advance if my next question is a stupid one Smile | :)

what do u mean by network path?

I think you're very lost, this is your first program you say ? Are you working in a class, or at home ? You're surely not getting paid ?

The path across your network to the SQL Server that is not on your machine.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

At my office. Actually i'm a new worker. My main job is to give a training to our customer how to use our companys system. but my leader ask me to do a web app to record all the calls from our customer so he can trace all the problem that our cistomer had. thank god i can make it n 2 month, but now the problem is only with connection to DB. rite now it can update and add data to my server DB but, i cannot display all the data in data grid bcoz it's only gonna display data from local DB. this is getting weird. and sorry to disturb u with this stupid question.

zaimah wrote:
but my leader ask me to do a web app to record all the calls from our customer so he can trace all the problem that our cistomer had.

OK, your work does not sound very fair.

zaimah wrote:
and sorry to disturb u with this stupid question.

Oh, I am glad to help you, don't worry about that. I am just trying to understand your situation.

A network path is like \\networkmachine\databasename. Just the db name is not going to find it, I don't think.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

another question is, i cannot debug my prgm bcoz it say the windows authentication r disable. why is this happening? when i run it without debug, there's no error come out from the prgm.

Put this in your web/config file
<compilation debug="true"> </compilation>

modified on Friday, May 16, 2008 3:45 AM

put what? pls explain more. TQ.

I will suggest you to give a look this google result[^]

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

For goodness sakes, buy a book. We're trying to help, but you're lacking even the basic skills to understand our answers.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

zaimah wrote:
put what? pls explain more. TQ.

This is silly, We are giving you basic answers,

I cant blieve so many people are giving programming tasks and have little knowledge of programming!

Hi,

Currently I am trying to create a drop down list which user could type in his/her desired words and the drop down list will filter accordingly and list down for the user. The item in the list is from the SqlDataSource which I use a stored procedure to call out the list of item to be populate in the drop down list. For example, the user type 'a', the words aeroplane, apple will be listed out but not ball, boy and when the user type 'ae', the word aeroplane will appear and not apple.

I found some solutions but it is not working, maybe some of you had already done this, so I would really appreciate that you could share your experience with me.

By the way, I am using C# ASP.NET.

Thanks

There's a control in the ASP.NET AJAX library that does this.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

the control name is Autocomplete Extender

Here you can see the demo to see it is the same you are looking for.

http://asp.net/AJAX/AjaxControlToolkit/Samples/AutoComplete/AutoComplete.aspx[^]

Thanks
Laddie

Kindly rate if the answer was helpful

Ok, I did saw those two ajax component, thanks for the confirmation that they can do what I'd been looking for, I shall try it. But the only thing is I not sure how to link the Autocomplete extender to a SqlDataSource, I dragged and drop the SqlDataSource but not sure the coding on how I link the Autocomplete to this SqlDataSource of mine. I read something about WebServices but not sure how I can use that to link the Autocomplete Extender with the SqlDataSource.

I am planning to join VB .Net Course.Which software should i buy VS2005 or VB.Net Standard edition.

which one is the best?.
Please guide me.
thanks,
avinash.

Give a look to this result...[^]

I Love T-SQL
"Don't torture yourself,let the life to do it for you."