Re: gridview editing - ASP.NET Discussion Boards

Re: gridview editing

Abhijit Jana8-Mar-09 21:43

Abhijit Jana

8-Mar-09 21:43

...then what is your problem ?

cheers,
Abhijit
CodeProject MVP

Re: gridview editing

prateekfgiet8-Mar-09 21:54

prateekfgiet

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

Re: gridview editing

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

Re: gridview editing

prateekfgiet8-Mar-09 22:13

prateekfgiet

8-Mar-09 22:13

how use trigger

Re: gridview editing

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

Re: gridview editing

prateekfgiet8-Mar-09 22:11

prateekfgiet

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

Re: gridview editing

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

Re: gridview editing

prateekfgiet8-Mar-09 22:09

prateekfgiet

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.

Re: Image is not displaying

Jack Li8-Mar-09 22:05

Jack Li

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.

Re: Image is not displaying

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

Jack Li

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.

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

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

Jack Li

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?

Re: Web config connection?

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

Jack Li

8-Mar-09 22:32

<br />
con = new SqlConnection(ConfigurationManager.ConnectionString["conn"].ConnectionString);<br />

This code contain two 'ConnectionString', So error appears does not contain a definition for 'ConnectionString'

it's right:

<br />
con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);<br />

Re: Web config connection?

gregor109-Mar-09 3:58

gregor10

9-Mar-09 3:58

very easy.
Don't use the ConnectionStrings.
Use ConfigurationManager.AppConfig["myconn1"] Smile | :)

Asynchronous Operation in UdpClient in ASP.Net

M. J. Jaya Chitra8-Mar-09 20:14

M. J. Jaya Chitra

8-Mar-09 20:14

Dear All,

I have a web application from which I need to send an UDP datagram.

When I send the data through Synchronous mode it is working fine.

When I use asynchronous operation it is throwing the below error:

"A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call) no address was supplied "

The code used is:
Asynchronous:

 senderOfMessage = new UdpClient();
 IPEndPoint remoteEndPoint = new IPEndPoint(IPAddress.Parse(serverIP), Convert.ToInt32(serverPort));

 byte[] message = ASCIIEncoding.ASCII.GetBytes("Test Message");

senderOfMessage.BeginSend(message, message.Length, new AsyncCallback(OnSend), remoteEndPoint);

Synchronous:

//senderOfMessage.Send(message, message.Length, remoteEndPoint);

Kindly help me to get rid of this issue.

Thanks a lot in advance.

Best Regards,
M. J. Jaya Chitra

Re: Asynchronous Operation in UdpClient in ASP.Net

N a v a n e e t h8-Mar-09 20:31

N a v a n e e t h

8-Mar-09 20:31

What are you trying to achieve by using UDP in a ASP.NET application?

Navaneeth

How to use google | Ask smart questions

Re: Asynchronous Operation in UdpClient in ASP.Net

M. J. Jaya Chitra8-Mar-09 20:39

M. J. Jaya Chitra

8-Mar-09 20:39

Dear Navaneeth,

I have to send a message to a windows service, the windows service in turn sends a message to another external application which is not developed in .Net.

For sending the message to external application it used the UDP, so the same UDP is used o receive the message from the web application too in the window service.

Best Regards,
M. J. Jaya Chitra

To read excel

Krishna Varadharajan8-Mar-09 20:06

Krishna Varadharajan

8-Mar-09 20:06

Hi,

I uploaded my excel file into a folder(server), now i want to read that file from the folder, than i have to insert that excel into a database with same filds,

I have done this but from local system i can able to read a file not from the uploaded folder.

So how to read a excel file from folder....
Below code is the one i have used from local system, the connections string

String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:/valuefirst.xls';Extended Properties=Excel 8.0"; (its working)

How to take this excel sheet from server folder.

Pls help me,

thanx

krishna

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.