ADO.NET :: Transform This Sql Code Into Linq?
Nov 4, 2010i am new with linq and i wanna do something like this in linq:
[Code]....
how can i do this?
Similar Messages:
DataSource Controls :: Transform LINQ Dataset Into A Matrix For Export
Jun 1, 2010I've got a data table with columns in which include Item, Category and Value (and others, but those are the only relevant ones for this problem) that I access via LINQ in a C# ASP.Net MVC app. I want to transform these into a matrix and output that as a CSV file to pull into Excel as matrix with the items down the side, the categories across the top and the values in the row cells. However, I don't know how many, or what, categories there will be in this table, nor will there always be a record for each item/category combination.
I've written this by looping round, getting my "master category" list, then looking again for each item, filling in either blank or Value, depending on whether the item/category record exists, but as there are currently 27000 records in the table, this isn't as fast as I'd like. Is there a slicker and faster way I can do this, maybe via LINQ (firing into a quicker SQL statement so the DB server can do the leg-work), or will any method essentially come back to what I am doing?
How To Transform Form Tag Code Into A Page That Have A Master Page
Jul 10, 2010I have asp.net web page that have the following :
<form id="WebCaptureForm" name="WebCaptureForm" onsubmit="return checkform(this);" enctype="multipart/form-data" method=post
action="http://site/page.aspx?idn=1&tr=100d1165&action=savenew">
I want to make new page with master page that contain the same code but how can i make the above code in a web page that have a master page
C# - Transform URL Without Routing Or Rewrite?
Jan 13, 2010I am using ASP.NET 2.0 on IIS6 therefore I can't use system.web.routing. I've tried a few URL rewriters but none did what I wanted.I basically need to transform (read/parse then redirect) URL 1 into 2 with minimum IIS configuration because I don't have the full authority to reconfigure web servers (i.e. ISAP on IIS6 or install 3rd party extensions/libraries). And I can't transform URL into 3 because all the physical links will break. [URL]
View 3 Replies.net - Xslt To Transform Format Of Xml Document
Nov 19, 2010i have the xml in a structure such as this:
<RWFCriteria reportType="ProgramReview">
<item id="36" name="" value="9" type="Milestone" />
<item id="31" name="" value="9" type="Milestone" />
<item id="33" name="" value="11" type="Milestone" />
</RWFCriteria>
Transform Html Input With Special Characters?
Mar 22, 2010I would like to transform an html input to xml. But the input will have as part of its content an "&", e.g. Texas A&M. But calling XslCompliledTransform.Transform(htmldocument, xmlwriter) causes an xmlexception to be thrown.
View 4 RepliesProgrammatically Parse And Transform Webform Pages?
Aug 3, 2010I need to programmatically parse and transform ASP.NET webform pages. It's a requirement that I have =(.
Anyone know any tools or frameworks?
Update:
I just need to modify ASPX pages (not rendered HTML code).
There are no inline c# code.
Use Visual Studio Web.config Transform For Debugging?
Oct 13, 2010I want to use the web.config transformation that works fine for publish also for debugging.When i publish a web app, visual studio automatically transforms the web.config based on my currenc build configuration.How can i tell visual studio to do the same when i start debugging.On debug start it simply uses the default web.config without transformation.
View 5 RepliesVisual Studio :: Web.config Transform Is Not Working?
Apr 16, 2010I have easy to reproduce issue with web.config transform. Steps below are causing major grief.
Create new Web Application Project in VS 2010. Open web.debug.config, put following inside it
<?xml version="1.0"?>
<configuration xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform" xdt:Transform ="Replace">
<applicationSettings>
<MyProject.Properties.Settings>
<setting name="Username" serializeAs="String">
<value>username</value>
</setting>
</MyProject.Properties.Settings>
</applicationSettings>
</configuration>
Now deploy to file system on local hardrive. Open resulting web.config and see <value> setting has extrac carriag return and bunch of tabs in front of it..
Screenshots can be downloaded below.
[URL]
Configuration :: Transform Project Less Into Based - Steps To Execute Task?
Oct 27, 2010What are the steps to execute the task above? the reason I want to do that now is because the web site is ready for deployment and
we would like to deliver it as a DLL. I've heard of [aspnet_merge.exe] but I want to ofuscate my code with a 3rd party tool; and this ofuscator tool only works with Project-based projects.
Forms Data Controls :: Transform Datatable To A Gridview With A Hyperlink Column?
Feb 10, 2011I want to transfer data from datatable to a gridview with a hyperlink column. But dont know how to do.
I attach my code as below, what i want to do is to output 2 columns in gridview, and the first column should be a hyperlink. However, now the first column still shows nothing.
Web page code:
[Code]....
C# code:
[Code]....
Panel Populated By Xslt Transform - Can't Access Controls Values In Postback
Sep 22, 2014I have a page with an panel on it that can contain a number of editable controls (textboxes, date pickers etc). This panel (and the controls) are populated dynamicaly by loading up an XSLT tranformation and applying it to an XML document (which represents the entity being edited) in the Pages Load event if !isPostBack.
Once the user has made changes they click a button and the form posts back. At that point I want to be able to go through the various controls in the panel, get the updated values and persist them back to a database. When I try to access the controls in the underlying buttons even theyre not there the panel is empty.
What I think is happening is that the page is being recreated at the start of the post back. When its recreated the XSLT transformation doesnt run because its a postback so the edit panel never gets repopulated. The controls therefore dont exist as far as my Button handler is concerned and it cant access their values.
My stopgap solution to this is that Im not checking isPostBack before repopulating the panel, so now the panel gets repopulated in the post back, the controls are there and Im able to query their values. The problem is that this involves another round trip to the database server to pick up the xslt and thats undesirable.So, first of all, have I understood the problem correctly?
I could save the trip to the db by storing the xslt (probably in the view state) but the whole idea of having to load up the control before checking its values feels sort of wrong and Im concerned that Im doing the wrong thing without realising. When I repopulate the control I am, of course, applying the XSLT to the XML document as it stood before the user made any edits. I would have expected querying the value of a control to return me the value before the user changes, but it actually seems to return me the value of the control as it was in the page when the user clicked the button. How can that be?
Visual Studio :: 2010 1 Click Deploy, Config Transform Options Not Visible?
Feb 18, 2011I have installed VS2010 ultimate and have read with interest about the new publish options, config transformations but none of them are available. I have tried creating different release versions and cannot see the option, also have no new options for publish, just look like the VS2008 ones.
Is there some service pack or pack that i need to install these or does it sound like a reinstall?
C# - Speeding Up LINQ To SQL Code?
Apr 1, 2011I am developing an ASP.NET where I need to display each purchase for every account in a GridView (so basically each purchase links to an account).
The problem is, we have over 6000 suppliers (granted, these can be filtered down to around 1000 which the customer will usually do), each of whom will have a few transactions. So you can imagine the time it takes to bind this data is very long - in fact, occasionally the SQL server times out. Sadly I cannot use paging, as all the data needs to be displayed in one page.
What I'm doing is similar to the code below (not at my machine so can't copy exactly)
IEnumerable<Account> accs = (from s in dc.Accounts select s);
foreach (Account acc in accs)
{
IEumerable<Purchases> purchs = (from s in dc.Purchases where s.AccountID == acc.ID select s);
double 30daysval;
[Code].....
Is there a faster way of doing this, perhaps using join's in LINQ or something? I know this may be a bit hopeless seeing as the data involved is huge, and that displaying a couple of thousands rows on a single page is fairly absurd, but that's what I've been told to do...
Convert Linq Code To Dotnet 2.0?
Mar 17, 2011string pdfpath = Server.MapPath("images");
string imagepath = Server.MapPath("Images");
using (Stream inputPdfStream = new FileStream(pdfpath + "\NLI_Filled_out.pdf", FileMode.Open, FileAccess.Read, FileShare.Read))
using (Stream inputImageStream = new FileStream(imagepath + "\sign2.gif", FileMode.Open, FileAccess.Read, FileShare.Read))
using (Stream outputPdfStream = new FileStream(pdfpath + "\NLI_Filled_output.pdf", FileMode.Create, FileAccess.Write, FileShare.None))
{
var reader = new PdfReader(inputPdfStream);
var stamper = new PdfStamper(reader, outputPdfStream);
var pdfContentByte = stamper.GetOverContent(3);
iTextSharp.text.Image image = iTextSharp.text.Image.GetInstance(inputImageStream);
image.ScalePercent(24f);
image.SetAbsolutePosition(100, 130);
pdfContentByte.AddImage(image);
stamper.Close();
}
I have the above code in 3.5 using linq..i want to convert it into dotnet 2.0..
ADO.NET :: LINQ Insert Code Not Executing?
Jan 19, 2011deleted old code
View 3 RepliesDataSource Controls :: LINQ DataContext From Code Behind?
Jan 21, 2010I have a linq DataSource and a Grid in my htnl and I want to access the DataContext from code behind. Now in the past when I do evrything in code behind I just use...
DataContextName db = new DataContextName();
and I have my reference.
Now I can still do that and it works fine it just seems odd to be making a second class object when there is one that is made from the linq DataSource in the html. But I can't figure out how to get a reference to the DataContext that is created from my html code.
DataSource Controls :: Convert Code Of SQL To Linq?
May 14, 2010I would like to ask the programmers to help me in C# with LINQ to SQL.
I have this code conn.Open();
SqlDataReader dr = DB.ExecSpReader("select AttachmentName from AttachmentTable where TicketId=" + ticketID, param);
while (dr.Read())
{[code]....
and I need to convert it to LINQ SQL.
ADO.NET :: LINQ / Code Shows Only 10 In TextBox Where I Want To Display 1-2-3 ... -10?
Mar 29, 2011int[] numbers = { 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 };
var numPlusOne =
from n in numbers
select n + 1;
Console.WriteLine("Number+1");
foreach (var i in numPlusOne)
{
//Response.Write(i);
TextBox1.Text = i.ToString();
}
Above code Shows Only 10 in TextBox where I want to display 1-2-3....-10
C# - Optimize Code - Linq And Foreach Loop 15k Records?
Sep 6, 2010this is my code
[code]....
basically, the InstellingGegevens table gest filled in by some procedure from another server.
the thing i then need to do is check if there are new records in this table, and fill in the new ones in Instellingens.
this code runs for like 4 minutes on 15k records. how do I optimize it? or is the only way a Stored Procedure?
this code runs in a timer, running every 6h. IF a stored procedure is best, how to I use that in a timer?
[code]....
ADO.NET :: Make A Linq Query Dynamic In The Pseduo Code
Sep 9, 2010is it possible to make a Linq query dynamic in the following pseduo code (to show what I'm trying to do)
[Code]....
where a2 and a3 and a4 are being populated from user controls and only one will apply. So query is done by state, zip or by city, but not by more than one, so the other two would be null. So the operator is really "OR" but I haven't found anything on a "or" or "whereOr" operator.
MVC2 LINQ - Repository Pattern, Where Should The Pagination Code Go
Nov 2, 2010I'm working on adding an HtmlHelper for pagination, but I am unsure where the proper and/or most beneficial place to put certain parts of the pagination code from a performance and maintainability standpoint.
I am unsure if the Skip(), Take() and Count() portions of Linq to SQL data manipulation should live within the repository or the controller.
I am also unsure if their order and where they are used affects performance in any way.
If they live within the repository from my understanding this is how it would work:
1. I would pass the pageIndex and pageSize as arguments to the repository's method that grabs the data from the database.
2. Then grab the full data set from the database.
3. Then store the count of TotalItems of that full data set in a variable.
4. Then apply the Skip() and Take() so the data set retains only the page I need.
5. Display the partial data set as a single page in the view.
If they live in the controller from my understanding this is how it would work:
1. I would grab the full data set from the repository and store it into a variable inside of the controller.
2. Then get the count of TotalItems for the full data set.
3. Then apply the Skip() and Take() so the data set retains only the page I need.
4. Display the partial data set as a single page in the view.
Inside the controller (I realize I will incorrectly get the page count here and not TotalItems):
[code]....
Error - FormatException Was Unhandled By User Code In Linq?
Apr 7, 2010Look below this codes throw me : FormatException was unhandled by user code
Codes:
satis.KDV = Decimal.Parse((from o in genSatisctx.Urun where o.ID == UrunID select o.Kdv).ToString()); How can i rewrite linq query?
Rewriting This Linq Query To Move It From Code-behind To DAL As Reusable Object?
Apr 4, 2011I'm working to move my simple asp.net website to a three layer architecture. Currently I have Linq queries like the one below in my code-behind files. Basically this code snippet retrieves a collection of customer data from the database and then binds it to a grid control.
I'm wondering if someone can guide me on how to rewrite this in order to move it to my newly-created data access layer. I'm thinking I will turn it into a class (e.g. GetUserBoxesByStatus()) that can be reused throughout the site.
var boxes = from p in sbm.Packages
where p.UserID == CurrentUserId && p.StatusID > 1 && p.StatusID < 3
select new { p.PackageTag, p.PackageName, p.DateReceived, p.DateShipped }; [code]....
Some of the options that I've investigated but have not had success implementing are the following:
DataTable --- returning a DataTable seems like the best solution but it also appears to require a lot of potentially unecessarry code to define a table (isn't the data source already mapped in my Linq 2 Entities dbml?)
IEneuerable --- I think I could pass an IEnumerable list between the layers but after reading many tutorials about Linq I'm still a little lost DTO --- Conceptually I think I understand what a DTO is but I am not clear on how to begin implementing this approach POCO --- Again, the concept seems logical enough but I don't know how to put this into practice
how they would tackle this using one of the above or some other solution.
ADO.NET ::change LINQ To SQL Code In Data Access Layer Project?
Sep 2, 2010I am working on a project in which I have made changes to LINQ to SQL code in data access layer project.Initially the code was using Single() extension method, I have changed it to SingleOrDefault() was earlier method was throwing exception if no records found in db.
After making changes I ran the project but during debugging VS 2008 was showing that file is changed and do you want to reload the file box. When selected the file, the debugger was still executing the commented code (Single() method).I tried cleaning the entire solution and rebuilding it but it did not help. All the projects (Presentation, BL, DAL) are under single solution.