ASP.NET

17-Feb-08 21:31

Hi,

I want to read and write the records from the databse(Client side)
and then these records get inserted into the table that is at server side.

I want to create script or any file format(Excel,XML) so that server database can read and then write the records into the server table.

format and records will remain same.

How Can I do this?

Thanks

sjs4u

N a v a n e e t h17-Feb-08 21:47

N a v a n e e t h

17-Feb-08 21:47

ASP.NET can't read data from client database since ASP.NET executes at the server. You can use DTS to transfer data from one server to other, but it has nothing to do with ASP.NET. SQL forum would be appropriate.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

sjs4u17-Feb-08 21:56

17-Feb-08 21:56

Ok.

Will it possible to write structure of client database and then use
it at the server.

and then by using the ASP.Net Program it can be read and then write at the server side.

or some any solution for this problem.

Thanks
sjs4u

Christian Graus17-Feb-08 22:08

17-Feb-08 22:08

you can write a component that embeds in a webpage, but even then, I doubt it can read the client side DB. Even if it had a valid connection string. Really, your best bet is to provide a client side application that takes the connection string, reads the database, and sends the data via a webservice. ASP.NET isn't going to cut it.

Christian Graus - Microsoft MVP - C++

"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 )

sjs4u17-Feb-08 22:13

17-Feb-08 22:13

Thanks For the Information.

But again it is possible to read and write database structure(also contains records) and run it at the client side using the ASP.Net Application.

If yes then How can it be?

Thanks,

sjs4u

Christian Graus17-Feb-08 22:17

17-Feb-08 22:17

I'm speechless.

Yes, you can do it, easily. That's why two people have told you it can't be done, we're trying to keep all the good stuff for ourselves.

sjs4u17-Feb-08 22:32

17-Feb-08 22:32

I have to read the records and the write it into the XML or Excel file.

Then with the Help of the above file I want to fetch the records and stored it into the database. I dont want to write directly to the database.

The Records writes in a such a way that structure of the database would not change.

How can it be possible.

Thanks,
sjs4u

Christian Graus17-Feb-08 22:39

17-Feb-08 22:39

Please don't ask if you're going to ignore the answers you're given.

message box after saving the information

N a v a n e e t h17-Feb-08 22:35

N a v a n e e t h

17-Feb-08 22:35

sjs4u wrote:
Will it possible to write structure of client database and then use
it at the server.

and then by using the ASP.Net Program it can be read and then write at the server side.

You can't automate this process. You can take the structure of database manually, supply that through an upload control to ASP.NET and execute it on the server. ASP.NET can't read the file you created at client side automatically. But don't go for such kind of solutions since it's not the right way to do this.

If you are trying transfer data from client DB to server DB, DTS will do a fair job.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Sonia Gupta17-Feb-08 21:24

Sonia Gupta

17-Feb-08 21:24

After successfully saving the information into the database , how should i invoke the message box with a button ok and a caption , record is successfully saved.

Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.

Re: message box after saving the information [modified]

N a v a n e e t h17-Feb-08 21:44

N a v a n e e t h

17-Feb-08 21:44

Use ClientScriptManager.RegisterStartupScript()

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

sumit703417-Feb-08 21:54

sumit7034

17-Feb-08 21:54

try this......
dim x as integer
dim cmd as SqlCommand
..........
your code for insert......
..........

x=cmd.ExecuteNonQuery();
if(x>0)

MsgBox("Record inserted", MsgBoxStyle.OkOnly, "Your title")

end if

by the way r u from MAIT

modified on Monday, February 18, 2008 4:03 AM

Christian Graus17-Feb-08 22:07

17-Feb-08 22:07

This is the ASP.NET forum. That won't work, because the msgbox ( apart from being a VB6 hack that you should not use ) appears on the server, not the client. This code will kill a website, the page will hang and the server won't be able to process any other requests.

Venkatesh Mookkan17-Feb-08 22:08

Venkatesh Mookkan

17-Feb-08 22:08

sumit7034 wrote:
MsgBox("Record inserted", MsgBoxStyle.OkOnly, "Your title")

Is not supported in Web world (ASP.NET, actually IIS). DO NOT recommend others to use it.

[Venkatesh Mookkan]
My: Website | Yahoo Group | Blog Spot

Paddy Boyd17-Feb-08 22:08

Paddy Boyd

17-Feb-08 22:08

That will give you a nice server side message box.

Christian Graus17-Feb-08 22:10

Viewstate Error in web server

17-Feb-08 22:10

To expand on Navaneeth's (correct) answer, you need to save the data and then you'll need to post back to the same page, and insert script so when the page reloads, it shows a message box with alert("your data saved"), or whatever. But, if you're doing a postback, you may as well just write it on the page, instead of the nastiness of a message box. If you use AJAX, then you can wait for the response and use javascript to show the message box after the AJAX call has saved the data.

Deepak the Cool17-Feb-08 21:04

Deepak the Cool

17-Feb-08 21:04

Hello Everyone,

I am developing a website and one of webpage generate the following error

" Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster."

I already disabled my page Viewstate, and ViewstateMAC for faster page rendering.

Hope you'll give me some suggestions.

Deepak

Smile a Lots,Its Costs Nothing

Re: Viewstate Error in web server

Christian Graus17-Feb-08 21:54