ASP.NET

8-Mar-09 21:38

i wana do when edit button clicked the value of selected row is saved in table2 with remarks "before edit" and when click update button it update table1 and also make new entry in table2 with remarks "after edit"

prateek
prateekfgiet@gmail.com

modified on Monday, March 9, 2009 3:59 AM

Abhijit Jana8-Mar-09 21:43

Abhijit Jana

8-Mar-09 21:43

...then what is your problem ?

cheers,
Abhijit
CodeProject MVP

prateekfgiet8-Mar-09 21:54

8-Mar-09 21:54

i m able only make edit it will update the value of table which contain the material incoming detail,but anable to save before edit value and after edit value in second table(edit_val)
how cani do it

N a v a n e e t h8-Mar-09 21:59

N a v a n e e t h

8-Mar-09 21:59

prateekfgiet wrote:
,but anable to save before edit value and after edit value in second table(edit_val)

Is this an audit table? You can write a trigger on the first table and insert the data into edit_val table from this trigger. Hook this trigger for all required events(insert,update and delete).

BTW, you need a spell checker first.

Smile | :)

Navaneeth

How to use google | Ask smart questions

prateekfgiet8-Mar-09 22:13

8-Mar-09 22:13

how use trigger

Abhijit Jana8-Mar-09 22:08

Abhijit Jana

8-Mar-09 22:08

prateekfgiet wrote:
i m able only make edit it will update the value of table which contain the material incoming detai

Good.

prateekfgiet wrote:
but anable to save before edit value and after edit value in second table(edit_val)

What does it mean? I am still confused Confused | :confused:

. Sorry.

cheers,
Abhijit
CodeProject MVP

prateekfgiet8-Mar-09 22:11

8-Mar-09 22:11

i m working on inventory managment project here when raw material come in store it creats entry in table1 reciept no.,name ,quantity and all that.
user can see all the entry by gridview if user makes any mistake he can mend it,but when he click edit button it creats a new entry in table2 with remarks "value before edit" and when user click update button it again make new entry in table2 with remarks "value after edit" and backgroundcolor of that perticuler row should be changed

N a v a n e e t h8-Mar-09 21:55

N a v a n e e t h

8-Mar-09 21:55

Looks like you are new to CP. I recommend you to read the posting guidelines[^]. Read this[^] and learn to write quality questions. Now go and rephrase your question, so that we all can understand it.

Smile | :)

Navaneeth

How to use google | Ask smart questions

prateekfgiet8-Mar-09 22:09

Re: Image is not displaying

8-Mar-09 22:09

ya i m new in CP but i m trying to explain to u
well i m working on inventory managment project here when raw material come in store it creats entry in table one reciept no.,name ,quantity and all that.
user can see all the entry by gridview if user makes any mistake he can mend it,but when he click edit button it creats a new entry in secon table with remarks "value before edit" and when user click update button it again make new entry in table2 with remarks "value after edit" and backgroundcolor of that perticuler row should be changed

Image is not displaying

BalasubramanianK8-Mar-09 21:28

BalasubramanianK

8-Mar-09 21:28

Hi,

I can show my report (CR of VS 2005) well in my development machine (ASP.Net with C#). But after deploying in my sever, the toolbar images of the report is not displaying well. It show as red color (X) mark.

I googled and tried in different ways. But I could not solve it. I tried in four ways so far such as by pasting aspnet_client in my project folder, creating another virtual diretry in my prj and linking with aspnet_client, adding CR of VS2005 in pre-requisitis while building and finaly building with Merge module. But I never got help from the above mentioned 4 ways.

Anybody can help me? I'm being struck in this for more than 5 days.

Note: Report is generating well with toolbar images in my development machine in both of running the application and deploying the application.

Balasubramanian K.

Jack Li8-Mar-09 22:05

Re: Image is not displaying

8-Mar-09 22:05

can you paster code of the report (CR)? it's must request one data source, and (CR).rpt files must in one directory.

BalasubramanianK8-Mar-09 22:33

BalasubramanianK

8-Mar-09 22:33

In my report, I am using command. I've written some queries over there itself.

rptDocument = new ReportDocument();
rptDocument.Load(Server.MapPath("Reports/rptPendingCredit.rpt"));
crvPendingCredit.ReportSource = rptDocument;
crvPendingCredit.DataBind();

This followng is my code of my Crystal Report Viewer control

        <CR:CrystalReportViewer ID="crvPendingCredit" runat="server" AutoDataBind="true" />

Previously I added some more in my control.  But I removed again

<CR:CrystalReportViewer ID="crvPendingCredit" runat="server" AutoDataBind="true" HasCrystalLogo="False" EnableDatabaseLogonPrompt="false" EnableParameterPrompt="false"
            GroupTreeImagesFolderUrl="/aspnet_client/system_web/2_0_50727/CrystalReportWebFormViewer3/images/tree/" 
            ToolbarImagesFolderUrl="/aspnet_client/system_web/2_0_50727/CrystalReportWebFormViewer3/images/toolbar/" />

Balasubramanian K.

How to publish the aspx files which are in local machines?

meeram3958-Mar-09 21:09

meeram395

8-Mar-09 21:09

I have completed an aspx application, which I wanted to provide the url for testing from my system. Means, the testers need to access my local system for testing the application.

Since I'm getting the url as http://localhost:(routing number)/directory/Default.aspx, I cannot give this url to them as they cannot access it. I tried to put my IP Address and computer name also, but it fails.

I published the site, and then provide the link. But I am getting an xml parser error: not well formed. It was not happening locally when I run from my system. How to solve this? How to provide the url?

Can anybody please help?

Thanks

Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

Re: How to publish the aspx files which are in local machines?

Abhijit Jana8-Mar-09 21:48

Abhijit Jana

8-Mar-09 21:48

meeram395 wrote:
Since I'm getting the url as http://localhost:(routing number)/directory/Default.aspx, I cannot give this url to them as they cannot access it. I tried to put my IP Address and computer name also, but it fails.

I published the site, and then provide the link. But I am getting an xml parser error: not well formed. It was not happening locally when I run from my system. How to solve this? How to provide the url?

You have to create a Virtual Directory in IIS for your web application. After Deploying the web application it can be accessible in your network using IP address like
http://yourip/directory/default.aspx.

Step1: Install IIS in your system/ server.
Step 2 : Create Virtual Directory for that web application
Step3 : Set the default page,authentication mode and most importantly .Net framework version.

Read this article.[^]

cheers,
Abhijit
CodeProject MVP

Re: How to publish the aspx files which are in local machines?

Jack Li8-Mar-09 22:16

Re: How to publish the aspx files which are in local machines?

8-Mar-09 22:16

if you syste/server don't install iis or .Net framework, At first ,you must install it's.
The .Net framework version and you application version must samed.About application version,you will look for application directory web.config file.

meeram39510-Mar-09 7:22

meeram395

10-Mar-09 7:22

Thanks. It worked well. I performed all the above steps and it is working fine now.

Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

how to save excel file in database?

anujbanka17848-Mar-09 21:06

anujbanka1784

8-Mar-09 21:06

i want full file in database not only file name how can we do it.

Re: how to save excel file in database?

Jack Li8-Mar-09 22:24

Re: Web config connection?

8-Mar-09 22:24

you want export excel file from database, example application in this web,you'll search keyword of database to excel. I do it also.

Web config connection?

Karthick_gc8-Mar-09 20:54

Karthick_gc

8-Mar-09 20:54

Hi,
I write connection coding in Web config file.

The code is

<connectionstrings>
<add name="conn" connectionstring="Data Source=techdbserver;Initial Catalog=project;<br mode=" hold=" /> user name=sa;password=sa;<br mode=" providername="System.Data.SqlClient">

When i called it in the web form as

con = new SqlConnection(ConfigurationManager.ConnectionString["conn"].ConnectionString);

the following error appears.

'System.Configuration.ConfigurationManager' does not contain a definition for 'ConnectionString'

Can any one tell whats the error?

Padmanabh Ganorkar8-Mar-09 21:01

Padmanabh Ganorkar

8-Mar-09 21:01

Hi,

You have not posted the code you wrote in Web.config file.
Secondly Please note and correct the syntax for accessing the connection string from web config in C#

con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);

Thanks
Padmanabh

Re: Web config connection?

Jack Li8-Mar-09 22:32