View Complete Post
The XML files will be uploaded by third party to a common location which can be access by us. Now, I need to read the XML file when ever the files are uploaded by the third party user(our system should automatically check when ever files uploaded).then i will read the data in XML file and update the status to my DB.what method i can follow to do this process. I should automatically read the files when ever they uploaded.i need the easy soultion for this.please suggest me.thanks in advance.
I have update statement.
UPDATE SPECT SET SRE = CLSS.NEWSIDFROM SPECTINNER JOINstudent (NOLOCK) ON student.ID = SPECT.IDINNER JOIN CLSS ON CLSS.GID = SPECT.GIDON CLSS.GID = student.GIDWHERE student.PID = '20201'AND CLSS.PID = '20201'AND SRE IS NOT NULL
However, student.PID and ClSS.PID need dynamically reach through from table CLSS to get each row of PID.
Here my table CLSS
Rowid Username PID gid nit sid NEWSID7 cc 20201 00 1 AA XX8 cc 20201 02 1 SS AA9 dd 11000 0N &n
I creat a WindowsFormsApplication that its name is Taxi_agancy
I attached a database file that its name is Taxi_Agency.mdf to my project from server explorer in Visual Studio . ( I add conection to data connections and select Microsoft SQL Server Database File) and in Database file name I enter my database file .
I created a stup project for it . When I install my application in another computer and I try to add some data to my Database from application interface I recieve this error :
Unhandled exception has occurred in your application . if you click countinue the application will ignore this error and attempt to continue . if you click quit the application will close immediatly .
Failed to update database "c:\program files\default company name\setup\Taxi_agency.mdf" because the database is read-only.
Download the code and a fully working example application from http://rapidrepository.codeplex.com/
I want to add multiple rows of a gridview if the data for multiple fields are same.
Idea for this is that a user may search a record with some parameter e.g. Sector, plot.
For example 15 records being displayed in gridview.
There should be checkbox before every row and if user wants to update Plot and Flat No that is same for 10 rows out of 15 so he will check the rows and update.
For this a dialog box should appear asking for the parameter i.e. Plot and Flat or something else next time may be it will be City or country. Moreover, there is already an Edit button to update records, when user click it another page open for the record to be updated and whatever he wants to update, it updates.
Hope everone understand the scenario.
I don't want to disturb the already provided Edit functionality and want to provide same record to be updated.
Any idea in this regard would be appreciated.
Very bizzare, any suggestions?
With a separate script tag in the <body> with my JQuery script, this works
I've a problem with my Visual Studio.
On the 13th of August 2010 i installed a Windows update on my vista sp2 pc. For this date my Visual Studio 2008 sp 1 always has closed itself by opening an aspx-page in designer view. There is no error message just closing the window. I restored a backup of my windows from the time before updating it and it helped, i could open aspx pages in the design view till the update has been installed again automatically after rebooting the pc. I can't disable windows updates, cause it's my pc at work and safety is very important. I hope you could help me out of this disaster.
I use visual studio 2008 but It's only use net frame work 2.0, Can I update and use net frame work 3.5 for Visual Studio 2008 ? Please help me !
my aspx page works in VWD, and everything works on the server EXCEPT update and delete sql functions. any ideas?
I am not able to read xml file with XDocument if its Descendants has Attribute like:-
<?xml version="1.0" encoding="utf-8" standalone="yes"?><root> <row ID="1" xmlns="http://www.opentravela.org/OTA/2003/05"> <var country_name="Caribbean and Rest of the world" city_name="Kingston" flight_category="Economy Class" via="Atlanta" flight_departure="London Heathrow" airline_logo="Delta" adult_fare="Delta" child_fare="660" infant_fare="561" date1="132" date2="2010-08-15" /> </row>
I don't know what to do ?
Looking for some help..
Can someone please tell me (sample code) how to read this XML into a SQL DB? Should I use LINQ to XML? Does anyone have any sample code? I am working in VB.NET
<?xml version="1.0" encoding="utf-8"?>
<ReadOrderResponseType xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">