I want to modify an existing XML-File.
I used a DataSet to load the XML File with the ReadXml method.
I then displayed the relevant entries via the GetChildRows method.
I want to change/add/delete those ChildRows:
How can I accomplish this?
Below is the xml before edit
[code]....
I'm trying to call a dataset, modify a value, and then put it back into a dataset.
I think this is possible but I'm doing something wrong
attached is an image of the table and the code
[Code]....
Backgroud: I'm using NHibernate for my model layer, and I have a HTTP module taking care of instantiating the session at the beginning of each request and cleaning it up at the end of each request (i.e. Session Per Request). In this case, I have two object types:
ParentItem - an object with a bunch of properties and a collection of ChildItems. ChildItem - an object with properties including a DateTime (EffectiveDate) and an unenforced FK pointing to a completely different database. The ChildItem class contains a reference back to the parent as well (many-to-one) While the ParentItem has multiple ChildItems in its collection, I'm only generally interested in the latest ChildItem in the collection.
Desire: Want a databound control (GridView or ListView, I don't care which) that allows me to Add/Edit/Delete ParentItems from my datasource. I also want to have the ability to set a new "latest" ChildItem as part of the edit/update.
Issue: I can't seem to access the underlying DataItem from the GridView/ListView in the OnItemUpdating handler (which isn't unexpected, since the data is now in the viewstate). What I thought I could do would be to load a ParentItem from my session using the ID from the databound control, create a new ChildItem, add it to the ParentItem, and then save the ParentItem. Since NHibernate caches the data, the load should give me a copy from cache (no roundtrip to the DB) and I'd either be doing this before the ParentItem was saved back (thus no changes committed to ParentItem, just to ChildItem) or after (thus the cached version is still the same, and my new object will match the updated version). What I get when I do this (for ParentItemID=1):
a different object with the same identifier value was already associated with the session: 1, of entity:
NameSpace.ParentItem
on the line:
Session.SaveOrUpdate(parentItemInstance);
I need to modify a dataset column's value. I tried using the following code but it's returning "Input string not in correct format error".
for (int iCount = 0; iCount < dataset.Tables[0].Rows.Count; iCount++)
{
dataset.Tables[0].Rows[iCount][23] = "Test";
}
Till now I used to design RDLC file before and assigned typed dataset table columns.Report processing mode is local. But now my stored procedure returns different columns based on condition i.e columns are not fixed every time. Now I need to add that columns to typed dataset and dataset is assigned to RDLC file. So dataset and RDLC files are create dynamically based on stored procedure result set columns.
View 1 RepliesToday I am facing the problem with Typed DataSet using DataSet.XSd file, And How to fetch, Delete and Update the Database through Dataset.xsd file.
View 9 RepliesI would like to find a way to read a txt file (in my case delimited by €). I need to change the order of the columns and also add and remove some columns. My output file should be a txt file delmited by ;.
I tried Jet.OLEDB to read the file and put it into a datatable and then used a stringBuilder and streamwriter to get an output file in .txt format. However. This does not me since IŽ, reading the txt file from start to end and my output will be the same. It does not seem like I can have a custom sql statement when reading the file. The only query that works is
Dim da As New System.Data.OleDb.OleDbDataAdapter("Select * from 1.txt", TextConn)
How can I possible modify a txt file?
This is my code for now:
[Code]....
by looking at using the XmlDocument and creating elements and attributes and then inserting them into the document. Pretty soon this looked like a massive amount of work for all the elements I have to add.What are the repercussions of treating the config file as one big long text string and doing a replace at certain points to add my entries. Something like this...
private void InsertXMLElement()
{
StringBuilder webConfig = new StringBuilder();
// get the file into a stringbuilder for manipulation
using (var sr = new StreamReader("C:web.config"))
{
webConfig.Append(sr.ReadToEnd());
In SQL, I have:[Bands] 1 ---- * [BandsGenres] * ---- 1 [Genres]In my EF layer, it translates to:[Bands] * ---- * [Genres](BandsGenres is BandId and GenreId)My problem is, I can't seem to figure out how to delete just the selected relationships I need. Basically, I'm trying to update a list of type Genre for a band. A list of Guids is passed in and I'm able to get those using joins. However, the .Remove() method isn't removing the old genres and adding the new ones. I tried using .Attach(g) and .DeleteObject(g) but that removed the actual Genre (from Genres) instead of just the relationship.
[code]...
How can I delete/add or update my list of genre relationships for a band, given a list of genre IDs?
i have a problem executing an insert query. whenever i try to insert i have an exeption telling me it cant execute because a record needed in another table; where i select a value form that other table according a listbox, and then insert it into this table. here is a sample of my code:
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=|DataDirectory|emp2.mdb");
int a = 0;
conn.Open();
string sqlcmd = "select id from nationality where descreption = '" + DropDownList1.Text + "'";
OleDbCommand readNatCmd = new OleDbCommand(sqlcmd, conn);
OleDbDataReader readerNat = readNatCmd.ExecuteReader();
while (readerNat.Read())
{
a = readerNat.GetInt32(0);
}
readerNat.Close();
conn.Close();
string saveEmpcmd = @"insert into employee " + "(nationality) " + "values (@nationality)";
OleDbCommand objCmd = new OleDbCommand(saveEmpcmd, conn);
objCmd.Parameters.AddWithValue("@nationality", a);
conn.Open();
objCmd.ExecuteNonQuery();
conn.Close();
now, the form executes with no errors, but it catches an exeption caused by the ExecuteNonQuery funtion; here it is in details:
System.Data.OleDb.OleDbException: You cannot add or change a record because a related record is required in table 'nationality'. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Default2.Button1_Click(Object sender, EventArgs e) in c:Documents and SettingsAdministratorMy DocumentsVisual Studio 2005WebSitesempDefault2.aspx.cs:line 305
when i remove the relation between the tables, the exeption isnt catched anymore, but the value stored in the employee table is 0 how can i solve this?
I am doing some research on themes in asp.net. (Just Learning) is this a practical use of my time? Should I just use css files and if someone wants to modify anything let them use the css to do it? Are themes a waste of my time? I really want to create my app but give the end user the ability to customize the look and feel without jumping through hoops. Can someone push me in the right direction with pros, cons etc
View 3 RepliesI have a C# web application (VS 2005).
I need to open an existing text file and add data to each row.
I have been trying to overcome the well know issue of importing a csv file, nut ignoring the comma's within the quotes. Not every field has quotes, and not every record has comma's withing the quotes. After spending ages looking at various samples and arguments, Im still baffled. I have below a qiuck sample of a file ( we can not change the file at all ) , what i want to get out of it, and the the procedure i am currently working with. Can anyone show and explain how to modify my sub to get the desired results
"Smith, John", "125 My Street ","MY1 25Q", 135.00
"Jones,Fred","Flat 1, 139 Hight Street", "UB8 8UU",798.00
(0) Smith,John
(1) 125 My Street
(2) MY1 25Q
(3) 135.00
(0) Jones,Fred
(1) Flat 1, 139 Hight Street
(2) UB8 8UU
(3) 798.00
[Code]....
I want to add the new tables to dbml file dynamically from another database
View 2 RepliesI have some pages that reference javascript files.
The application exists locally in a Virtual Directory, i.e. http://localhost/MyVirtualDirectory/MyPage.aspx
so locally I reference the files as follows:
<script src="/MyVirtualDirectory/Scripts/MyScript.js" type="text/javascript"></script>
The production setup is different though. The application exists as its own web site in production, so I don't need to include the reference to the virtual directory. The problem with this is that I need to modify every file that contains a javascript reference so it looks like the following:
<script src="../Scripts/MyScript.js" type="text/javascript"></script>
I've tried referencing the files this way in my local setup but it doesn't work.
i am currently working on an asp.net mvc 2 web app using LinqToSQL. I would like to handle a scenario where a user comes form a country and for this i have set the users - countries db relationship and in my user model i have a CountryId property.
I would like to display the country name on my users display view, so i tried fetching the country name like this: User.Country.Name, but an exception occurs that i cannot access a disposed object. I understand that this is caused by the way i handle my users repository and service.
This the repository users code:
[Code]....
This is the service users code (the repository is not class level property, but a local one that gets dipsosed immediately after calling it):
[Code]....
So, how could i handle such a scenario, where i would like the Country model to be also fetched in order to use it later? Should i convert the repository model a class level proprty in order not to get disposed?
Is there some kind of simple database system that uses simple text or xml files for data storage? I just need some basic functionality like update,delete, insert, simple constraints and relations.For the project that I have now using SQL Server would be too heavyweight and I have never really liked it anyway.
View 6 RepliesI have been asked to modify an ASP.NET 3.5 web application. The solution file does not appear to be present on the web server, but there is a DLL. Is it possible to modify the solution by "reverse engineering" the DLL?
View 2 RepliesI am trying to modify an xml file from my aspx code. The file is in another directory from my project like in D:folderfile.xml When publishing my code and running it I am receiving an error as not to be able to access this directory, access in denied. Which user account shall I add to this folder in security option to be able to modify it. I tried adding IIS user but it does not seem to work.
View 2 RepliesI have a site and Web.sitemap file added to the root folder of the site.
I want to create a new page that allows the user to change the title and description of the SiteMapNodes in the Web.sitemap file. I have completed it partially, in the sense, I am able to iterate through the nodes in the sitemap file using the following code.
[Code]....
In my orginal post i asked the question to handle this within the .Net side.
I was trying to stay away from using SSIS package, and with help from another member, i was able to get the process to work with an excel spreadsheet.
But part of my project requires us to allow .csv files.. so my question is how can i modify the code i have now for the excel to work with a .csv file?
You can find the current code in my original post here:
[URL]
I not sure what the best solution is for the end result.. I was reading somewhere online that you can right the data from the file to a datalist or gridview so you can present the user with a view of what is being uploaded, then use that datacontrol to insert into SQL.
In my current code, im uploading the file, then using that file to do the insert. This works fine for .xls files.. but i need to accomplish the same thing for a .csv file.
I have json file Users.json and I want read json object from file and store in to database one by one. how to delete json object when it stored in database. when object not save in database then it not delete from file. Need to know about delete json object.
using (FileStream fs = new FileStream("user.json", FileMode.Open, FileAccess.Read))
using (StreamReader sr = new StreamReader(fs))
using (JsonTextReader reader = new JsonTextReader(sr))
[Code].....
Based on the the following article:
Upload and Download files from SQL Server Database in ASP.Net
I m using multiple sitemaps in my website. The providers are defined in web.config file as:
[Code]....
[Code]....
Now I m trying to modify one of my xml file in memory to dynamically populate querystring but when I use
Dim currentNode
As
SiteMapNode =
SiteMap.CurrentNode.Clone(True)
I get Null in my currentNode and I cant point to the node.
I am having to add button to file upload my form page, when user click the add button , file upload contol opened in pop up window with upload option,then browse file, when user click the upload button , the file name should be displayed in parent window and popup window should be closed , these all should be happen with out page refershing.
View 3 Replies