[Code]....
i get the following error
Local sequence cannot be used in LINQ to SQL implementations of query operators except the Contains operator.
when trying to bind "full" to a datagrid or if i do
[Code]....
List<ThemeObject> themeList = (from theme in database.Themes
join image in database.DBImages on theme.imageID equals image.imageID
into resultSet
from item in resultSet
select new ThemeObject { Name = theme.Name, ImageID = item.imageID}).ToList();
dgvGridView.DataSource = themeList;
dgvGridView.DataBind();
The list object populates fine. The datagrid is setup with 2 columns. A textbox column for the "Name" which is bound to "Name" An image column which is bound to the "ImageID" field. When I execute the code I receive the following error on the DataBind() Could not determine a MetaTable. A MetaTable could not be determined for the data source '' and one could not be inferred from the request URL. Make sure that the table is mapped to the dats source, or that the data source is configured with a valid context type and table name, or that the request is part of a registered DynamicDataRoute. I'm not using any dynamicdataroutes as far as I can tell. Has anyone experienced this error before?
I don't think there's an easy way but thought I would ask. I'm currently retrieving a table from my db and binding it to a datagrid with the AutoGenerateColumns on. One of the columns is a date and it's displaying time although it's always 12:00:00. I'd like to display the short date format in the datagrid. Is there an easy way or do I have to manipulate each row or bind the columns individually?
View 1 RepliesI have a DataSet with multiple DataTables and I use an ObjectDataDataSource to bind my DataGrid to it. One of my tables is correctly displayed in the grid. My problem is, that the grid displays the wrong table.
My tables are related to each other - I make use of the "relation" objects in VS Studio 2010. My ObjectDataSource points to a class with a select method. The DataSet contains several DataTables (e.g. "Variables" and "Components").
[Code]....
How can I configure the DataSet to display the table "Variables" by default?
I do not even know where to begin when it comes to this I am continuing from this question: ttp://stackoverflow.com/questions/2664029/linq-to-sql-statement-issueWhere I searched multiple columns in a table and returned my values in a datagrid,Ive done basic formatting on the grid but am unable to decipher how I would go aboutgetting each row to link to another page?
using (TiamoDataContext context = new TiamoDataContext())
{
var search = from p in context.UserProfile1s
[code]...
i m binding data to Gridview using LinQ i need to sort the Gridview i have no idea how to sort cs i m using LinQ to Bind data with Gridview at Button Click.
View 2 RepliesI want to dynamically bind dataset values into datagrid's header datafield.
Is it possible? To be more clear, when you click on datagrid's (Collection) from properties window, you get selected columns created from Bound column. So in those columns I want to dynamically display dataset's table values in those columns.
i.e like ds.Tables[0].Rows[0][0].
Is it possible to do it in Datagrid ItemDataBound function like,
e.Item.Cells[1].Text = ds.Tables[0].Rows[0][0]
or something like this? I know the above code is wrong and wont work since I tried it out and while building it throwed error saying, Cannot implicitly convert type 'object' to 'string'.
OK So I know WHY I am having the error I am getting. I don't know HOW to fix it. Basically, if the user doesn't have a certain permission, I need to join another table. But .NET is so picky I can't just make two different queries in an IF statement and then use it outside of the if statement. I can think of some ugly work arounds for this, but I would rather not. I am fairly new to .NET I know just enough to be dangerous.
[code]....
I get the error: Unable to cast object of type
'System.Data.Linq.DataQuery1[VB$AnonymousType_111[System.Guid,System.String,System.String,System.String,System.String,System.Nullable1[System.DateTime],System.Nullable1[System.DateTime],System.Nullable1[System.Guid],System.Nullable1[System.DateTime],System.Nullable1[System.Guid],System.Nullable1[System.DateTime]]]' to type 'System.Collections.Generic.IEnumerable`1[Ten11CRMLib.Company]'.
because of this: Dim l As IEnumerable(Of Company) its not just IEnumerable of a Company, its got the source in it. I have to explicitly select source to use it in my datagrid. Can I make Dim l something that will make it stop complaining?
'm not sure if this is the right forum, but I couldnt find one for linq related questions.I have the following problem. I have four tables, One with users, one with projects, one with the users and the projects they are in (joinProjectTable) and on table where the users can fill in there worked hours for a certain project. These hours are filled in on a daily base. Now every month there is going to be created a report on the workedHours table so there is visible which user has entered how many hours for a certain project. On this report there is gonna be a billing for the company where for the hours are worked. This is the easy part, the hard part is the following.
companies also want to have a list of users that didn't entered any hours for that particular month for a particular project. So I have to write a linq query that would look in the joinprojecttable to see which users are joined to which projects, and than with that join it should look if that particular combination (user+project) is in anyway entered in the workedhourstable for that particular month. If not this has to be shown in the datagrid, for every user that isnt in the workedhourstable for that month. So it should be a certain NOT query, but I can't seem to figure it out.does anyone have any idea to accomplisch this in Linq2Sql? I'm using VB instead of C#.
I am trying to figure out how to bind my link results to a datasource so it can manage/update/edit/insert/delete without me having to do manual coding for all of it. Is this possible?What am I doing?I have used the LINQ to Active Directory to access our AD accounts. I need to make this a webpage frontend of basic search and managing functionality. I have it searching now and adding the results to a gridview but edit is not working now. I was looking online and I saw something about being able to bind linq results to a datasource and then using the datasource to manage all the information for me. Resources I am using:
BdsSoft.DirectoryServices.Linq[URL]
I am using ASP.Net MVC2 and LINQ to SQL. I am using DataAnnotations and model binding in conjunction with a Form/View and its working beautifully well. Loving that.. My view is an "Add new Employee" form that's adding a new "Employee" complex object. Every Employee also has a child complex object called an "Address".
I am using the bound Html helpers in the view, such as Html.TextBoxFor(model => model.NewEmployee.FirstName) for example. Working beautifully well, validating beautifully well both client and server and coming into the controller fully populated and ready to be saved! Exciting.. ModelState.IsValid returns true and I go to save the new Employee.
The Employee is created fine but the system also creates a blank/new Address record in my Addresses table even when the Address fields are blank! How can I prevent any Address from being created, in situations where I ONLY want to create a new Employee with no Address. An example is when the user supplies an existing Address, then I wish to simply set the new Employee's AddressID to that of an existing physical address (I hope that makes sense). But it could apply to any situation where you need to create a new complex object, but you don't wish for LINQ to create any of its child complex objects. I have tried setting NewEmployee.Address = null after it is received in the controller, but even after that, a blank/new Address is still created. Even if I try NewEmployee.Address = SomeExistingAddress, it does correctly link the Employee to the existing Address, but it STILL goes off and creates another redundant new/blank address record! Which is really weird..
I have a "Create New Employee" ASP.Net MVC form. My complex object is an Employee and an Employee has an Address, which is another Complex object. On my View/Form I collect all required values for both the Employee and the Address. I'm using the bound HTML helpers such as: Html.TextBoxFor(model => model.EmployeeAddress.StreetName)
AND
Html.TextBoxFor(model => model.NewEmployee.FirstName)
This is all working beautifully well. Model binding is working like a dream, both server side and client side validation using DataAnnotations is working beautifully well and I am nicely receiving my populated complex objects as expected in the Controller.. Now I'm trying to save.. The Employee should always be newly created, because its an "Add New Employee" form. But sometimes the Address is an existing Address and I don't want to insert another one. Rather, I just want to link the Employee to the existing AddressID of the one that already exists in the database.
So I wrote a nifty GetExistingOrCreateNewAddress(Address PostedAddress) method which works great so I end up with the correct Address to use and link to the about to be saved Employee object. This is all happening in the same DataContext, so no problems there..
BUT even when I link the about to be saved Employee object to an existing Address, on save a new/empty Address row is created in my Addresses table. Even though the newly created Employee does link correctly to the existing Address I told it to! Why is it so??? And how can I save the new Employee without LINQ automatically creating a blank Address for me. Because I'm explicitly specifying an existing Address it should be linked to instead!
[HttpPost]
public ActionResult CreateEmployee(EmployeeDetailsViewModel NewEmployeeDetails)
{
if (ModelState.IsValid)
{
EmployeeRepository ER = new EmployeeeRepository();
// Fetch or Create the appropriate Address object for what has been entered
Address ActualAddress = ER.GetExistingOrCreateNewAddress(NewEmployeeDetails.EnteredAddress);
// Link this Address to the "about to be saved" Employee
NewEmployeeDetails.Employee.Address = ActualAddress;
// Lock it in..
ER.SaveNewEmployee(NewEmployeeDetails.Employee);
I am receiving Object reference not set to an instance of an Object when binding Child dataGrid in the ItemCommandEvent of Parent dataGrid.
[code].....
I have a DataGrid bound to an ObjectDataSource, as you know once the DataSourceID on DataGrid is set, data binding happen automatically without any coding. But due to requests from end users, I need to prevent the data binding when the page is loaded the first time, i.e. data binding should only happen during PostBack. How do I do that?
View 3 Replieshow do I bind data from a column from a table to a dropdownlist collection?
View 7 RepliesI've added the Dynamic.cs file to my project and have set it's Build Action = Compile in order to get the System.Linq.Dynamic namespace.
However, when I try to use any of the new code I am getting an ambiguous call error; see below.
[Code]....
I am binding the data in a data table from two different datagrid
[Code]....
but i want to know that what exactlu datagrid.columns[number] returns (the value inside that column or the datatype or only the column collection ).My code is not working
List<business.clspluginsprp> objprp = new List<business.clspluginsprp>();
business.clsplugins obj = new business.clsplugins();
for (Int32 i = 0; i < k.Length; i++)
[code]...
I am using updatepanel in aspx with master page content, required validation control. IN that updatepanel I have one datagrid through that I am trying to insert a row. When I click that linkbutton then is shows error like "sys.webforms.pagerequestmanagerparsererrorexcepti on. Error code: 405" . I tried with another project this code works fine. How to overcome this. Some times error code 12031 also appear in prompt window. Error Received: The HTTP verb POST used to access path '/PMS/Marketing/' is not allowed. Stack Trace: at System.Web.DefaultHttpHandler.BeginProcessRequest( HttpContext context, AsyncCallback callback, Object state)
at System.Web.HttpApplication.CallHandlerExecutionSte p.System.Web.HttpApplication.IExecutionStep.Execut e() at System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean& completedSynchronously)
Source:System.Web
Origin: [URL]
Target Site:System.IAsyncResult BeginProcessRequest(System.Web.HttpContext, System.AsyncCallback, System.Object)
Exception Thrown @7/26/2010 10:11:21 PM
i am creating a datagrid, this is the first time, i am getting error like this. what should i have to do to rectify this.
[Code]....
I'm having an AJAX Tab Container with 4 tab panels. in my 4th tab panel I'm having 2 panels with 2 div layers.In 3rd panel i'm getting html paypal form code and putting that in session, Then binding the session value to div layer.After the button click was executed. I'm getting error "UnKown RunTime Error" and "INner HTML Error " on debugging. I don't know why is this happening so, can anyone please let me know the correct way.
Below is my code:
<cc1:TabPanel runat="server" HeaderText="TabPanel4" ID="TabPanel4">
<HeaderTemplate>
4. Make Payment
</HeaderTemplate>
<ContentTemplate>
<div>Please click on the below paypal button to complete your payment process.</div>
<asp:Panel ID="pnlDefaultPP" runat="server" Visible="true">
<div runat="server" id="DefaultPP" visible="false">
</div>
</asp:Panel>
<p></p>
<asp:Panel ID="DyPP" runat="server" Visible="false">
<div runat="server" id="paypal" visible="true"></div>
<asp:Button ID="btnPay" Text="Make Payment" runat="server" />
</asp:Panel>
</ContentTemplate>
</cc1:TabPanel>
[Code]....
In the above cs code, if I get promoid, then I'm binding the relative paypal code to div layer. And making the tabpanel4 enabled. When I debug the code, the control is going till tabpanel4.enabled=true, after that I'm getting unknown runtime error or html error.
I have this array: string[,] productData = new string[5,7];
I bind it to a repeater and a call a method like: <img src="<%# getPhoto1WithReplace(Container.ItemIndex) %>"
Which is defined like:
public String getPhoto1WithReplace(Object itemIndex) {
int intItemIndex = Int32.Parse(itemIndex.ToString());
if (productData[intItemIndex, 3] != null) return this.ResolveUrl(productData[intItemIndex, 3].ToString());
else return String.Empty; }
I do not understand why it calls getPhoto1WithReplace with itemIndex as 5. My array has 5 indexes: 0,1,2,3,4, so How Container.ItemIndex can be 5?
I am making samle of polling duplex in .net 4.0
when ever i put binding this tag in web.config it shows error.
<bindings>
<pollingDuplexHttpBinding/>
</bindings>
Warning 1 The element 'bindings' has invalid child element 'pollingDuplexHttpBinding'. List of possible elements expected: 'basicHttpBinding, customBinding, msmqIntegrationBinding, netPeerTcpBinding, netMsmqBinding, netNamedPipeBinding, netTcpBinding,
wsFederationHttpBinding, ws2007FederationHttpBinding, wsHttpBinding, ws2007HttpBinding, wsDualHttpBinding, netTcpContextBinding, wsHttpContextBinding, basicHttpContextBinding, mexHttpBinding, mexHttpsBinding, mexNamedPipeBinding, mexTcpBinding, webHttpBinding'.
D:DuplexTestTestPollingDuplexWcfTestPollingDuplexWcfTestPollingDuplexWcfWeb.config 9 8 TestPollingDuplexWcf
I am using AS 400 OLEDB with .NET. It uses '?' instead of '@param to bind parameters with a commandNow there is a situation where the command is like
SELECT ...
FROM
(SELECT ...
ROW_NUMBER() OVER(ORDER BY ColumnName) as RowNum
FROM Employees e
) as DerivedTableName
WHERE RowNum BETWEEN @startRowIndex AND (@startRowIndex + @maximumRows) - 1
Now my command becomes
SELECT ...
FROM
[code]...
consider classic example: Product and Category editing Product in dropdown Id of Category is selected - Category mapped as object with all fields empty except Id when submitting Product edit form - validation gives an error: "Category name is required" (I have Required attribute on Category Name property)
How deal with such errors if I want to use built-in validation (
[Code]....
Writing custom data binder which would fill all such id-only-objects with values from database comes to mind.
upd: I did small research of mvc code and found out that validation happens before binding - so this solution would't work.