|
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.
|
|
|
|
|
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
|
|
|
|
|
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 )
|
|
|
|
|
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
|
|
|
|
|
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.
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 )
|
|
|
|
|
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
|
|
|
|
|
Please don't ask if you're going to ignore the answers you're given.
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 )
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
Use ClientScriptManager.RegisterStartupScript()
|
|
|
|
|
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
|
|
|
|
|
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.
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 )
|
|
|
|
|
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.
|
|
|
|
|
That will give you a nice server side message box.
|
|
|
|
|
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.
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 )
|
|
|
|
|
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
|
|
|
|
|
Turn off the viewstate validation, it's a property in the page attribute at the top of the page.
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 )
|
|
|
|
|
Hi Everyone,
I got the answer and I post it here for the help of other programmer....
<pages enableEventValidation="false" viewStateEncryptionMode ="Never" />
Deepak
Smile a Lots,Its Costs Nothing
|
|
|
|
|
Hi using Reprot Viewer I show some datas in chart way,
In that i like to show the width of the ratio my own style,
How to do that,
Plz help me,
Thanks & Regards,
Mageshh,
please don't forget to vote on the post
|
|
|
|
|
hi
i wanna create a dynamic form builder using ASP.net, will be better if using metadata Tables "large tables".....
plz if there any one can help me and give me any hints or articles..... these forms will be used to enter data to the data base.....
with regards
Muhannad
|
|
|
|
|
For example
<add key="constr" value="user id=Parthi;data Source=TEST;password=user">
parthiban
|
|
|
|
|
What do you want to do ?
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 )
|
|
|
|
|
Dear Programmers,
I am using gridview in my project. I want to give users a facility so that they can move the rows of the gridview Up and Down. For Example If the press the Up Button on second row of the gridview then the data on Second Row will be shifted on First Row and the Data on First Row must be shifted on Second Row.
For this I have used Link Buttons and I am using VB.NET as language. Please Help me in this regard.
Thankyou.
Waiting for your reply. Please reply me as soon as possible.
|
|
|
|
|
You need to re-order the datasource and re-bind it to grid view.
|
|
|
|
|
You have to use DataTable to re-structure the rows, and again bind the formatted rows with GridView.
I have done the same in C#.Net. If needed you can modify it to VB.Net
Cheers,
Muthu.G
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
