|
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..
|
|
|
|
|
|
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...  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>
<!-- DYNAMIC DEBUG COMPILATION
Set compilation debug="true" to insert debugging symbols (.pdb information)
into the compiled page. Because this creates a larger file that executes
more slowly, you should set this value to true only when debugging and to
false at all other times. For more information, refer to the documentation about
debugging ASP.NET files.
-->
<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>
<!-- CUSTOM ERROR MESSAGES
Set customErrors mode="On" or "RemoteOnly" to enable custom error messages, "Off" to disable.
Add <error> tags for each of the errors you want to handle.
"On" Always display custom (friendly) messages.
"Off" Always display detailed ASP.NET error information.
"RemoteOnly" Display custom (friendly) messages only to users not running
on the local Web server. This setting is recommended for security purposes, so
that you do not display application detail information to remote clients.
-->
<customErrors mode="RemoteOnly"/>
<!-- AUTHENTICATION
This section sets the authentication policies of the application. Possible modes are "Windows",
"Forms", "Passport" and "None"
"None" No authentication is performed.
"Windows" IIS performs authentication (Basic, Digest, or Integrated Windows) according to
its settings for the application. Anonymous access must be disabled in IIS.
"Forms" You provide a custom form (Web page) for users to enter their credentials, and then
you authenticate them in your application. A user credential token is stored in a cookie.
"Passport" Authentication is performed via a centralized authentication service provided
by Microsoft that offers a single logon and core profile services for member sites.
-->
<authentication mode="Windows"/>
<!-- AUTHORIZATION
This section sets the authorization policies of the application. You can allow or deny access
to application resources by user or role. Wildcards: "*" mean everyone, "?" means anonymous
(unauthenticated) users.
-->
<authorization>
<allow users="*"/> <!-- Allow all users -->
<!-- <allow users="[comma separated list of users]"
roles="[comma separated list of roles]"/>
<deny users="[comma separated list of users]"
roles="[comma separated list of roles]"/>
-->
</authorization>
<!-- APPLICATION-LEVEL TRACE LOGGING
Application-level tracing enables trace log output for every page within an application.
Set trace enabled="true" to enable application trace logging. If pageOutput="true", the
trace information will be displayed at the bottom of each page. Otherwise, you can view the
application trace log by browsing the "trace.axd" page from your web application
root.
-->
<trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true"/>
<!-- SESSION STATE SETTINGS
By default ASP.NET uses cookies to identify which requests belong to a particular session.
If cookies are not available, a session can be tracked by adding a session identifier to the URL.
To disable cookies, set sessionState cookieless="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
This section sets the globalization settings of the application.
-->
<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 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 )
|
|
|
|
|
|
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.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
