.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Problem with create ActionResults using 2 tables

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :ASP.Net

I have a create actionlink the data that I'm adding belong to table name

One of the fields (name company_Id), is connect to table name company,(one2many
table),  So, if I'm trying to write data that already exist
in the company table , the model is invalid ,

Ne w company name,it is valid, how can write a new data entry and still
use the company table existing data entry

I'm adding my code so mybe my Q. will be more understandable ,


public  interface Irepository
       IEnumerable<company> list1();

       IEnumerable<cosmetic> list();
       cosmetic Get(int id);
       void Create(cosmetic cosmeticToCreate, company conpanyToCreate);
       void Edit(cosmetic cosmeticToEdit);
       void Delete(cosmetic cosmetToDelete);

//the class
 public class CompanyRepository :Irepository
        SR_1Entities _entitiy = new SR_1E

View Complete Post

More Related Resource Links

Problem to create assembly which depends on other dll's from SQL Server

I am developing an application in .Net but I need to access to some procedures in ASP.Net since SQL Server.I have got it but i have problems to assembly the dll if it has dependencies of another dll's.I have read that if a dll need other dll it call it automatically but when I try to assembly my class in .NET there is the next error: Create failed for SqlAssembly 'ClaseEjemplo'. Assembly 'csyt.dal, version=, culture=neutral, publickeytoken=null.' was not found in the SQL catalog. (.Net SqlClient Data Provider) Nevertheless if I the class hasn't another dependencies it works.The class I am trying to assembly is ClaseEjemplo.If I try to use the procedure of other class "'csyt.dal" I have problems.If ClaseEjemplo hasn't dependencies it works perfectly!My class ClaseEjemplo is: using System;using System.Collections.Generic;using System.Text;using Csyt.DAL;using Csyt.Info; namespace ClaseEjemplo{    public class Class1    {        public static long devolucion()        {            AIAlarmaDB.TipoCondicion aux1 = new AIAlarmaDB.TipoCondicion();                        AIAlarmaDB aux = new AIAlarmaDB();            aux1=aux.GetTipoCondicionById(1);            return aux1.Id;        }     }}Thanks in advance

Dynamically Drop and Create tables, overcoming 4000 charachter limit

We have a Navision SQL-server database for 7 companies. Each table starts with the name of the company. Except for the CompanyName-part, the tables names are equal. I made a Foreach loop that dynamically transfers tables/data from the the Navision-database to a staging-database. I also want to Drop and re-Create the tables dynamically. However, if I try to do that via an expression in a SQL Task, SSIS complains about the 4000 character limit. What is a better way to do this? I want to execute SQL-commands and have SSIS replace part of the tablename with the contents of a variable (being the name of one the 7 companies). I have no access to the Management Studio or the DB so I need it to be done within the package. What is the best way to do that?

is there any problem if i create a site collection through programmatically which web application ha

hi all, My web application have 2  types of authentication -- for internal users (windows authentication) and external users (Form based authentication). I am creating site collections through programmatically in the web application. so this site collection should have the permission as form based authentication for external users and windows authentication for internal users. is it possible are not? please give me some suggestions on creating site collections which have form based authentication and windows authentication. thanks in advance......

How to create a SSIS package to import records form SQl Server 2008 tables to text files

I am a newbie to SSIS and would like to create a package to accomplish the task referenced in the above title. Will appreciate any links and pointers in the right direction.   Thanksakoranteng

SharePoint 2010 + RBS.msi does not create tables ("mssqlrbs") at the content DB

Installed on W2K8 SP2 + SQL 2 K 8 R2 CTP November + SPS2010 beta. SQL instance by default MSSQLSERVER and WSS_Content default content database. Step by step following installation and use of remote Blob Storage capacity documentation:http://technet.microsoft.com/en-us/library/ee748631(office.14).aspxThe RBS.msi, at the log file component installation it seems that installation is correct, but displays the error:... Executing op: ActionStart(Name=FixFilestreamStoreConfig,,)Información 2769. El instalador ha encontrado un error inesperado. El código de error es 2769. La acción personalizada CreateFilesNoUI no ha cerrado 21 identificadores MSIHANDLE.... Executing op: CustomActionSchedule(Action=FixFilestreamStoreConfig, ActionType=3070, Source=BinaryData, Target=RepairProvider, CustomActionData=filestream;C:\Program Files\Microsoft SQL Remote Blob Storage10.50\Provider Libraries\Filestream Provider\FilestreamProviderConfiguration.xml)...The content database have not created the necessary tables "mssqlrbs" and running the command in the SharePoint Shell: $ rbss.Installed () returns "False" I have not found a walkarround or anything let me to implement tables and simulate the installation that performs the .msi, provided in the Feature Pack for Microsoft ® SQL Server ® 2008 R2 November Community Technology Preview (CTP)Any h

Create view that amins to tables of another database on the same sql server instance

Hi to everybody, I found a situation ever met before. I develop on Dynamics NAV 5.01 and I have developed a method to be able to see some particular tables of an external database. In substance it deals with a property of tables of Dynamics NAV. When I create a table in NAV, I can create it in 3 different ways: table common to all the companies table  for company or table linked to a view.    This last case is mine, on the same db of NAV I have created a view with some fields, I have created in NAV a table linked with equal fields and types. Until here all normal.    The view, however, aims to another database that doesn't center anything with NAV but that it is on the same intance of SQL server.    The consumer that accesses NAV is a consumer type database SQL Server and has the permitted db_public and db_datareader on both the database. Then he can read the views on the db of nav both on the db of the other database.    When it tries to enter from the console of sql server, with the consumer database, all it works, if I do it by NAV, it show me an error "The server principal "username" is not able to access the database "some_database_name" under the current security context. (Microsoft SQL Server, Error: 916) "    If I add on the database NAV to the consumer, the role db_owner,

Problem create a web application on SharePoint 2007 (Project Server 2007)

I installed a Project Server 2007 in a 3 server structure (all Win 2003 sp2; one for App server hosting Central Admin, Project Server service & Search service; one for web server; one for database server).  They are only in the same domain and I use the same network account for the installation as well as the WSS service account.  The same network are local admin for those 3 servers. All installation & patches seem ok (at least I don't get error messages) until I attempt to create my first Web Application.  After I filled out the web appliction and try to click OK, the page does not change and i saw the java error at the right bottom corner from my IE browser (version 6). The message is .... Line: 1686 Char: 1 Error: 'WebForm_PostBackOptions' is undefined Code: 0 URL: http://myservername:28804/_admin/extendvs.aspx On my SP log, below are the portion of the log when the error happen. 09/09/2010 12:28:29  1  INF        Entering function UserInterface.ShowCentralAdmin 09/09/2010 12:28:29  1  INF          The show central admin command has been chosen 09/09/2010 12:28:29  1  INF          Searching for registry key Software\Microsoft\Shared Tools\Web Server Extensions\12.0\WSS\CentralAdministrati

Problem with EventSetter - "Failed to create a 'Handler' from the text" ...

I have a DataTrigger which when active sets the Template of a ListBox. Within the ListBox i then have a custom type which is based on a border. I wanted to get the MouseDown event for the Border, so in the custom type created a routed event which is fired when the MouseDown event occurs. Im using an EventSetter to hook this up and it compiles, however when ever the DataTrigger becomes active and the Template is changed i get an error: "Failed to create a 'Handler' from the text (name of method in code behind).   xaml: <ListBox x:Name="buttonDisplay" VerticalAlignment="Center" HorizontalAlignment="Center"> <ListBox.Resources> <Style x:Key="answerBtnStyle" TargetType="{x:Type cc:callControlButton}"> <EventSetter Event="borderClicked" Handler="ccAnswerBtn_MouseDown"/> </Style> </ListBox.Resources> <ListBox.Style> <Style TargetType="{x:Type ListBox}"> <Setter Property="Template"> <Setter.Value> <ControlTemplate></ControlTemplate> </Setter.Value> </Setter> <Style.Triggers> <DataTrigger Binding="{Binding ElementName=window,Path=currentCall.callstate}" Value="ringi

Joining Dimtime table by a referenced Join create a problem



I am trying to join a dimtime table by a refernced join to an orderlines table which is the fact.

(the referenced join was defined in the relationship matrix of the cube ).

The referenced table is the ordersheader which had no measures in it but only used a linking table between those two other.

The join from the dimtime to the ordersheader  is done by date and from ordersheader to orderlines by orderid

The problem is that in the cube browser measures are shown as they were multiplied across all dates (like the join was done in a wrong way )

I have created an sql query and the logic is working just fine when quering directly from the DB


What am I doing wrong

problem seems to be related to grouping by on columns with the same name in different tables


using OLEDB provider IBMDADB2.1

and the following SQL run from ReportBuilder


sect.name as Team,

tasktype.name as TaskType,










The SQL runs fine in a DB2 query tool but when run through ReportBuilder I get

[DB2/LINUXX8664] SQL0119N  An expression starting with "TASKTYPE" specified in a SELECT clause, HAVING clause, or ORDER BY clause is not specified in the GROUP BY clause or it is in a SELECT clause, HAVING clause, or ORDER BY clause with a column function and no GROUP BY clause is specified.  SQLSTATE=42803


Basically the problem seems to be related to grouping by on columns with the same name in different tables.

Anyone know a work around?

How do I create a query that joins two tables and returns a single entry with the most recent update


Say I have the following two tables (Purchase & Customer). 

CustomerID StoreName PurchaseDate
1 Asheville 9/14/2010 15:49

Multiple Tables needed for Report Builder Problem


I have 3 tables I need to join: Voucher, Voucher_Detail, and Place
Voucher is related to Voucher_Detail by column voucher_run_id
Voucher has no relationship to Place
Voucher_Detail is related to Place by column place_id

I have solved the one to many relationship problem I was having between Voucher and Voucher_Detail by adding a New Named
Query called LeftOuterJoin.

In my DSV, the Voucher table links to the LeftOuterJoin which links to the Voucher_Detail which links to the Place

When I go into Report Builder, as soon as I select Voucher_Detail ( which is the table that has the most columns I need in the report),
the Voucher table disappears from view.

Not sure what I have missed. Obviously I need access to all 3 tables' data.

How to create tables from XSD schema?


I am newbie for xsd/xml.
Can you give me an idea how to create tables from the xsd at below.


<?xml version="1.0" encoding="UTF-8"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:element name="listings" type="listingsType"/>
  <xs:complexType name="componentType">
      <xs:extension base="xs:string">
        <xs:attribute type="xs:string" name="name" use="optional"/>
  <xs:complexType name="addressType">
      <xs:element type="componentType" name="component" maxOccurs="unbounded" minOccurs="0"/>
    <xs:attribute type="xs:string" name="format" use=&qu

Problem aligning two tables


Hi, I'm fairly new to aspx. I'm trying to create two quite similar pages of web form. However, the two tables on the two different pages have different table style and one of them drags across the whole page and the other just occupies half of it. I've tried dragging the table and changing the style, but nothing seems to help. Is there a solution?

Problem with create SOAP clinet...



I have problem with create soap client. I get WebApi documentation and find example in PHP:

try {
// access key to WebAPI
$accessKey = "ABSDFB34FI651N4MJAXY564F";
// create client object Soap
$soapClient = new SoapClient("http://beta.otodom.pl/webapi2/?wsdl");
// login to WebAPI.  Method  doLogin returned session key
$sessionKey = $soapClient->doLogin($accessKey,"twojemail@domena.pl","twojehaslo" );
echo "Login OK. Session key : $sessionKey.\n";
} catch (SoapFault $fault) {
echo "login is not success. Error code: [{$fault->faultcode}]

how to translate it in ASP.NET to C# ????



Problem with viewing grid with linked tables



My grid doesn't show on the web form when I configure its datasource to access the link table and display data from the receiver table. Both link and receiver tables are associated/linked in the .dml file. Any ideas why the grid doesn't show on the form?



Can I create multiple report tables from one Dataset?


I'm producing a report in Report Builder 3.0 that needs to show events grouped by time of day, and another table with the same data grouped by day of week. Both tables show the same results, just grouped differently. The query that generates the ungrouped data is expensive, so I don't want to run it twice.

I've created queries in Management Studio that get the ungrouped data into a global temp table, and then I can fetch both grouped data sets from there. Unfortunately I can't get this to work in Report Builder. I have one Dataset that runs the main query, saves it into global temp, and then returns the first result set. The second Dataset returns the results from global temp. This keeps failing, the second result set is blank.

Does Reporting services run the queries in the order they are in the report, or are they run concurrently? If they are run concurrently this would explain it. Is there anything I can do to change this so that the second query doesn't run until the first one has completed?

Is there a better way of achieving the results I'm after?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend