I have a DataView resulted from a query as below
Title
Return Type
The Inception
1
NFS
2
Tron Legacy
1
Documentary
3
Roadrash
2
I want to pass this object to a method which modifies it using linq query to return the Dataview object as below(without using loops anywhere in the code)
Title
Return Type
The Inception
Movie
NFS
Game
Tron Legacy
Movie
Documentary
Others
Roadrash
Game
Is there a straightforward way to create a dataset after querying a dataview? The query itself returns DataRowView objects, which I cannot get to work with CopyToDataTable().
The query looks like:
Dim dvQueryView As DataViewdvQueryView = (dataview object of large dataset)
detailTableQuery = From rowView
As DataRowView
In dvQueryView _
Order
By sSortOrder _
Select rowView _
Skip nQuerySkipRow _
Take nQueryCountRows
I only want a small selection of records from the large dataview and use those to create a smaller dataset. The large dataset stays in place while multiple views are created from it, and then from those views I want to create the smaller datasets.
I know how to deploy and retrieve a single element in LINQ, but how can I do to change all the properties in a list. In the line below, I can only modify a record, I would modify several.
_ListaAcaoMenuInfo.Where(p => p.Id_acao == id).FirstOrDefault().Id_menu = 0;
I have just started using LINQ with VS2008. I have added extra columns to my table, saved the changes, but class ClassName.Designer.CS didn't get updated. What do I have to do to updated the class? Do I have to do it manually, or is there a way to automatically synchronize tables and ClassName.Designer.CS?
View 2 RepliesI need to add two DataViews together to have one Dataview that can then be bound to a Repeater.
I am plugging into someone else's API so I can't change the way the data is retreived at the SQL Level.
So essentially I want to do this:
DataView dView1 = getActiveModules();
DataView dView2 = getInactiveModules();
ModuleView = dView1 + dView2;
rptModules.DataSource = ModuleView.Tables[0];
rptModules.DataBind();
The two schemas for the views are identical just retrieving active and inactive modules.
i m using a regex to not allow certain characters, the below code works fine for certain html tags but not for all for i dont want the user to enter html tags for eg if i enter <nitin/> it allows but i dont want this to happen for other html tags it does not allow
!@#$%^&*()+=[]\';,/{}|":<>? or
!@#$%^&*()+=[]\';,/{}|":<>/>?
I store a large structure holding my application's reference data in a variable I access through HttpContext.Application. Every once in a while this data needs to change. When I update it in place, is there a danger that incoming requests will see the data in an inconsistent state? Is there a need (and a way) to lock some or all of this structure? Finally, are there other approaches to this problem other than querying the database every time you need this (mostly static) data?
View 3 RepliesI am using a regex to detect forum tags within posts, such as "[quote]text[/quote]" and then replace them with HTML formatting. I posted a question Forum tags. What is the best way to implement them? about a problem with nested tags.
I need this regex modified
string regex = @"[([^=]+)[=x22']*(S*?)['x22]*](.+?)[/(1)]";
Right now this matches an opening and closing tag, with match groups for the tag name, the tag content, and an optional value like the value after the equals in this forum tag [url=www.google.com]click me[/url].
What I need is for the expression to match the opening tag OR the closing tag and have a match group containing the tag name (including the '/' for the closing tag). I then want to iterate through them sort of like this:
Dictionary<string, int> tagCollection = new Dictionary<string, int>();
inputString = Regex.Replace(inputString, @"expression I'm asking for here",
match =>
{
[Code]....
So now, each tag is appended with a number and I could use the original regex to perform the tag functions and properly handle nested tags as separate tags.
I am creating a Quartz.NET application in C#, and creating a bunch of administration webpages (C#/ASP.NET) so users can easily create jobs, set datamap fields and edit datamap fields.
I'm having some trouble editting jobs data maps though - any changes I make aren't saved at all. Is there anything I need to call after modifying the jobs data map?
What I want is to filter the dataview so I get top 10.
I googled it and found out that I had first to sort the dataview. Then add a column (int) to datatable. This column I then made a AutoIncrement on......
This works fine - I can see in the codebehind that it adds a column to the datatable that I called AutoInc.
Then make a RowFilter on the dataview - here it goes "wrong" for me.....
When using the line
datVie.RowFiler = "AutoInc < 11";
and bind it to a gridview I don't get a error - but it also don't show me any rows in the gridview...... If I comment the line out - I get all the rows in the dataview..
Can anyone see in my below code what is wrong?
[Code]....
When I have multiple entries with the same id in a list box the selected index is always the first instance of the item. How do I get around this without modifying the id of the items in my list box so they are unique?
View 2 Replies what I can replace the bold line with to get it working with EventArgs e? I copied this code from a button function with CommandEventArgs e.
protected void btnNextStep_Click(object sender, EventArgs e)
{
if (cboxShippingSelect.Checked == true)
[Code]....
I would like to store some meta-information about a given site instance that can (a) be managed by that site instance and (b) persist clobbering of Web.config file.The site will run in multiple environments (dev,testing,staging and production) and each environment can have different values for this metadata.
Note: All environments are running IIS 7.0+
The Root Web.config seems very appealing, as it is certainly outside of the website. Therefore, both files and databases can be changed while maintaining the metadata. I have seen how to modify the appSettings of the Web.config stored in the website, but is it possible to similarly modify the appSettings in the Root Web.config (Specifically within the proper directive)?
I have a Quartz.NET application where I need the administrators to be able to modify the job details - mostly information in each jobs datamap, but also things like the triggers - here is my code I'm using
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
JobDetail jobDetail = sched.GetJobDetail(hdnID.Value, hdnGroupID.Value);
jobDetail.JobDataMap["idname"] = txtName.Text;
jobDetail.JobDataMap["initialPath"] = TextBox1.Text;
jobDetail.JobDataMap["targetPath"] = TextBox2.Text;
[code]...
I have a formatted table in ReportViewer. When I want to export to Excel though - I do not want to export the formatted table - instead I want to output the original/raw/unmassaged data table in an excel file.
What's the best way to intercept the Export to Excel function and output data in a different format?
I use the FormView control quite a bit, but I wish I had more control over the default templates.
When I drag a FormView from the toolbox onto my page and point it to a DataSource control it prepopulates the ItemTemplate, EditItemTemplate and InsertItemTemplates, but it doesn't do it very well.
For example, the InsertItemTemplate looks like this by default:
<InsertItemTemplate>
id:
<asp:TextBox ID="IDTextBox" runat="server" Text='<%# Bind("id") %>' />
<br />
Name:
<asp:TextBox ID="NameTextBox" runat="server" Text='<%# Bind("Name") %>' />
...
</InsertItemTemplate>
But what I would prefer is a good old fashioned html table
<InsertItemTemplate>
<table>
<tr>
<td>
id:
</td>
<td>
<asp:TextBox ID="IDTextBox" runat="server" Text='<%# Bind("id") %>' />
</td>
<tr>
...
</table>
</insertItemTemplate>
I know I can use a DetailsView to get a table rendered out, but I end up modifying the form so much that I prefer to use the FormView. It's just that I would like Visual Studio to start me out a bit closer to where I want to end up.
I would imagine that there is a T4 template somewhere in the guts of VS that I might be able to modify to get this done.
I am using a combobox.
I'm retrieving the data from database to fill the combobox. The name of the combobox is kategorilist. I want to set a string value to datavaluefield of the combobox. Also I'm using datalist with paging in this page. Datalist is binding with the selected value of the combox everytime.
Like this;
li.Value = "urunlist.aspx?ktid=" + dr["KategoriID"] + "&Sinif=" + sinifsa.ToString();
But it doesn't work. It worked with html <select> tag but ajax combobox doesn't accept this value.
Here is my code:
private void KategoriAdlariniGetir(int sinifsa)
{
DataSet ds = new DataSet();
SqlConnection con = new SqlConnection(cnnstr);
[Code]....
I'm trying to modify the output of my GridView in the RowDataBound event handler, but it's not working - nothing happens.
My code:
Private Sub MyGridView_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs) Handles MyGridView.RowDataBound
e.Row.Attributes.Add("data-xkoordinat", 0)
End Sub
[Code]....
Is there anything here that would cause the rows not to be databound? I'm reloading via F5 or by selecting the address field in my browser and hitting Enter, so I don't think postbacks should be an issue.
I'm playing around and created a new Web Form project and trying to make way with the default template. I've created the pages I need but trying to leverage the existing membership pages and ASPNETDB. I'm having trouble grasping how the asp pages are connecting to the database(and thus make my own changes). I cannot see any SQL syntax in the aspx pages or the code behind? I can tell the project is making use of the stored procedures but where is the actual connection configured or the command that is being run, for example when the "create" button is pressed on the CreateUserWizard control. Looking at the createUserWizrd I cannot see any adapters it might be using?
Perhaps my mindset is trying to apply, tableadapter and datasets way of working to asp controls. All the information and tutorials I'm looking at, seem to bypass the connection to the database and somehow there controls are 'taking care' of the I/O to the database. So if I wanted to add an additional field to the createwizard process, what do I need to do? Alter the db and the stored procedure, then?
When i try to sort my table manually, i receive this error:DataTable must be set prior to using DataView.The code is:
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{
DataTable sourceTable = GridView1.DataSource as DataTable;
[code]...
I have a DataView which filters
inputView.RowFilter = "isnull(" + ID1 + ",'')<>'' and isnull(" + reason + ",0)=0";
after this filter i have to update "IsVerified" column of inputView to "1"
Is there something in LINQ to execute the following?
inputView.RowFilter.ForEach(x=>x.Field<IsVerified> =1);
I have a DataView which has been populated with a list of files from a database table. I want to iterate through the DataView to see if there are any files there of a particular type, and if so, do something with that record, and then remove it from the DataView.
I've coded this as follows, but there's something missing - I can iterate over an object and then remove an object from it, since that will affect the iterator.
DataView dv = new DataView();
dv = ds.Tables[3].DefaultView;
dlFiles.DataSource = dv;
dlFiles.DataBind();
for (int j = 0; j < dv.ToTable().Rows.Count; j++) {
if (dv.ToTable().Rows[j]["FilePath"].ToString().ToLower().Contains(".pdf")) {
//do something with this record and remove it from the dataview
}
}
As a note, dlFiles is a DataList used to display the the items in the DataView. The files removed are displayed differently, and so should not be referenced when iterating through the DataList.
I have an image (consider the image of a clock). I would like to change the position of the dials depending on values retrieved from database. (This will probably be done using a service which will run every minute or so.) I just want to know how I can change the image (i.e modify the existing image).This is for a dashboard screen. The images would be refreshed every minute to get the latest data.
View 3 RepliesI have two user controls (wishlist & shopping cart) The shopping cart & wishlist objects are both in sessions.Also both controls are sitting inside the masterpage and the wishlist has the ability to move an item to the shopping cart. Now how do i achieve this? Originally i thought i would expose a public method within shopping cart called "BindItems" which would rebind the datacontrol, however this is causing .NET's automatic postback validation to throw an exception.
Invalid postback or callback argument. Event validation is enabled using <pages enableEventValidation="true"/> in configuration or <%@ Page EnableEventValidation="true" %> in a page.For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them. If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation.I dont want to set EnableEventValidation to false either for security reasons.
I'd like to change some properties of ASP Form Elements via Javascript and I am having a very difficult time doing so. The element is defined as:
[Code]....
But Im not having any luck modifying it with Javascript like this:[Code]....
one thing I noticed is that (At least in VS2010 intellisense) the elemtn doesn't seem to have a disabled attribute like a standard HTML
[Code]....
