DataSource Controls :: Rewrite Linq2SQL Code?
Feb 1, 2011I am not familiar much with linqtoSQL and I need a better way to write this code:
[Code]....
[Code]....
I am not familiar much with linqtoSQL and I need a better way to write this code:
[Code]....
[Code]....
I'm got 2 model objects. Category and CategoryItem. I try to add a CategoryItem to Category in my Controller but It wont save to database, and I know why because I don't know how to call the submitChanges on the add while using repository, I dont got the DBContext right there is you know what I mean?.. here I will show you with code.
[Code]....
im developing a silverlight project using silverlight 3, vs2008 and linq2sql. when projects starts, im storing all the data from database into some static list variables. so when ever i need data, im reading it from those static list variables. all i want to know is, is it good to store data in static list variables and use it when ever necessary or is it good to get data directly from DataClassesDataContext object like db.mytable. which is the rite and fastest way or retrieving data. i mean which will use less connections to database?
View 2 RepliesIn our ASP.NET web application, we use our own class to act as a rewrite module. It takes all requests to the server, acting as a bootstrapper.
To access an image on our web application, the browser requests domain.com/ResourceItem.aspx?Id=74
Does not having a proper URI mean the server will never respond with 304 NOT MODIFIED?
how to get the 304 response, so the browser doesn't have to download each image every refresh?
Can the select command of a SqlDataSource be given by code in the code behind file. Also by calling the SqlDataSource.Select can the select statement be executed?
View 3 RepliesI want to bind an ObjectDataSource to a property in my asp page and I want to do it in the page's aspx code, not in code-behind. I've already done it in code-behind, as follows:
[Code]....
I'd prefer to get rid of the ugly code-behind and just do this in mark-up. Something like
[Code]....
This gives me a run-time error: Cannot create an object of type 'System.Object' from its string representation 'SelectedBook' for the 'DataSource' property.Is there a way of doing this declaratively and not in code-behind? Further, what if what I want is to actually use a child property of the property in question? For example, if my Book object has a ReaderComments collection, can I databind to it decaratively in the aspx mark-up?
I need to pass the control parameter to Sql Datasource in code behind,
<asp:ControlParameter ControlID="DDL_RType" Name="rtype" PropertyName="SelectedValue"
I'm wondering about if there is a difference (in performance) when I use:
User usr = (from u in Adapter.User
where u.Login == login
select u).FirstOrDefault();
or
User usr = Adapter.getUserByLogin(login); //stored procedure
Don't know if this is possible, but i have a site with categories, when you click a category i want it to redirect to the same page, but with a querystring parameter of the category id. The page will then load a lightbox to open the images with the correct category id. That is my basic thought. if any1 has a better ide, i'll gladly listen. Dont worry about the linq2sql parts, that i am sure how to do.
View 1 RepliesI'm building a music voting application, similar to stack overflow almost.I have 3 tables, Charts, ChartItems, Votes.I'm trying to bring back a list of chartitems, which link to a single chart, with the number of votes for each chart item counted.This is what I am trying currently
var firstList = from chartItem in db.ChartItems
join vote in db.Votes on chartItem.ixChartId equals vote.ixChartId into j1
where chartItem.ixChartId == id[code]...
The problem is once I have performed the grouping, I can't get any of the other properties I need from the join to populate the model. For example each ChartItem should have a title, id etc...I have created a ViewModel to hold all the properties that I need, called ChartItemWithVotes(includes all entity values + int totalVotes)In the end I am looking for this
Chart Name
Votes Name
20 - ChartItemname
15 - ChartItemname
12 - ChartITemName
Im using LINQ2SQL and i have an object called Article. Its has 2 properties FinishText and SwedishText. The idea is to let the user choose language. Swedish is default.
I bind the objects to a listView and there is a label that takes the swedish language. When the user presses the Finish flag button i want the objects to reload and the finish text to show instead of the swedish. The problem is that the text label is bound to the SwedishText property in the mark up like this:
<%#DataBinder.Eval(Container.DataItem, "SwedishText")%>
I can think of some ways to solve this, and i have one that doesnt work that well. My question is, what would be a good way to solve this? Im not so experienced so i know that there are lots of you out there that know how to do this much better.
Another problem i dont like my solution to is when i have an object that has a association with my Article object, like ArticleCategory. The ArticleCategoryId of my Article is, lets say 31, which is corresponds to the category "Movies". I dont want to display the category id but rather the name of the category itself (Movies).
So this is what i do:
<%#GetCategoryNameFromId(DataBinder.Eval(Container.DataItem, "Article_Id"))%>
I call a method that recreates the artice object and from there creates the ArticleCategory and gets the name from it. Its a horrible solution cause it involves lots of trips to the Database. Especially since i do similar things with other properties.
Just wanted to hear what is a proper and good way to deal with these common but for me new tasks.
I've got a sitemap in db with all current url, but some urls has changed so I added a column for old urls so I can redirect if old urls are requested and redirect to the new url.
How can I go about resolving this.
I would like to use 301 status.
UrlRewrite?
This is my table structure :
ItemNo SubIteMNo Process
001 001 A
001 001/Z B
02 002 C
003 003 D
004 004 E
I have 2 connection strings in my web.config file, and I would like to select which one to use, from code.Currently I have this:
asp:SqlDataSource
ID="SqlDataSourceDelegateServices"
runat="server"
[code]...
I am using the SQLDataReader to execute a Stored Procedure that accepts two parameters (BuildingTID and Department) to return the appropritae Value in my case The Director of the Department. My problem is I get the following error when I run the code that I added below for review. Let me also add that the user is selecting the values that I am using for the stored procedure from 2 DropDownLists. I am getting it when I try to assign the value that is in the Department DropDown
list to the first parameter.
Dim myParm As SqlParameter = getDirectorsCMD.Parameters.Add("@BuildingTID", SqlDbType.Int, 15).Value = (ddlDepartment.SelectedValue)
Also obviously there are more issues with my code than just the error because the datareader records property is false meaning I am not returning a row
i need to get my listview there are made on a LinqDataSource to update the db before it running my code i have made in my update botton. how do i force the update to happen ind c# ? my code in my update botton looks like this
protected void UpdateButton_Click(object sender, EventArgs e)
getting the Parameters declared in an sql function in the C# code. We can actually get the parameters from a Stored Procedure by giving SqlCommandBuilder.DeriveParameters
Similarly is there any way to get the Parameters from the SQL Function.
I converted code from VB that works to c# to insert a record in an SQL daTA BASE.
The VB code is as follows:
Insert a new record into Contact
Dim connectionString As String = ConfigurationManager.ConnectionStrings("aspnetdbConnectionString").ConnectionString
Dim insertSql As String = "INSERT INTO Contact(UserId, Notes) VALUES(@UserId, @Notes)"
Using myConnection As New SqlConnection(connectionString)
[Code]....
I have a web project that sends out a customized email after certain user events (like a status change). I also have an SSIS package on the database that pulls in data from one database and updates another database with that data. I want to be able to compare the data and if a particular field's data for that record is different between the two databases is different, I want to be able to use the dll I created for the web app to send the appropriate email.
View 2 RepliesIf I have a Linqdatasource that isn't connected to a a bound control on my page how do I use the data source to read data in the code behind. ie
var query = (from x in linqdatasource select x)
What I actually want to do is create a data array (myArray) within the code, read all of the data from the linqdatasource (selecting 1 field to form tableDataArray), then compare the two arrays and then write (insert) those into in myArray that are not already in the datasource to the datasource (ie execute an insert back on the datasource).
ive an access database with a table, in this table there is only one data column and one counter column (id, pet) i want to draw random a record. Reading on the web i came with this SQL solution: "SELECT TOP 1 tab_pets.pet FROM tab_pets ORDER BY Rnd(id)" and it works perfectly.
The problem is while using this statement in my code behind (in a class) as it draw always the same record, hence generates the same random each time. I though that the access Rnd() function would be handled by the access driver and not by my application, how can i resolve this?
I 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.
I'm making a page with a DropDownList (called ddlSupp) that contains several suppliers, and I populate it with an SqlDataSource, all in front code.
In another part of the page I make a CheckBoxList, and populate it again with an SqlDataSource. The select command of the SqlDataSource is a procedure call to my MySQL database. However, what the CheckBoxList gets populated with depends on who is selected in ddlSupp. How do I make a variable in front code that will take the value from ddlSupp and populate my checkbox accordingly?
Here is my code:
[Code]....
I get a MySQL error at (<%$ddlSupp.SelectedValue %>) so I know the wrong value is being passed into the query. How can I fix this?
I 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.
I have an ObjectDataSource and I want to configure it from code behind , I want to set the InsertMethod , Selectmethod from Code Behind and set it to my Business Layer files
View 1 Replies