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


Post New Web Links

handling default notnull column in linq to sql

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :ASP.Net
 
I have a column called regdate datetime default getdate() , the column is notnull.I am using linq to sql.I have created instance of that table and when i try to insert record into the table, I am getting daterange exception.(range should be 1/1/1753 to 31/12/9999).In that object I am not setting any value to regdate property as that would be taken care by sql server.If i set regdate = datetime.now.date then record is inserted successfully.I dont want to set any value from front-ent.I want sql server to do that for me like we do it using stored procedure.Please guide me who to do this?thankssuman


View Complete Post


More Related Resource Links

Linq to Sql column mismatch using stored procedures

  
I'm using Linq to Sql to call some  stored procedures for more complex work; is there any way Linq to Sql can tell me when the output columns from the stored procedure do not match the properties of my entity object? It seems that Linq to Sql tries its best to match the columns and ignores any mismatches.Cheers 

Change Default Column Value programatically

  
On a Document Library Settings Page, there is a new setting in SP2010: "Change Default Column Value". Changing the default value of the Field is different from this value. Does anyone know what this value is and where to set it programatically? Also, what libraries is this setting available on? This code updates the field's default value but not the property mentioned above: SPField field = list.Fields["Column"]; field.DefaultValue = "DefaultValue"; field.Update(); Thanks!

Problem while retrieving data from a lookup column from sharepoint linq.

  
Hi I am working with sharepoint linq concept. When I am giving a query with lookup column It's working fine.  But when i am trying to retrieve the data from a look up column to spgridview. I was unable to get the output. Here is the above code which i have worked.   string strTitle = string.Empty; string strStatus=string.Empty; var context = new LinqSampleDataContext(SPContext.Current.Web.Url); EntityList<SharePoint2010ConceptsItem> Concept = context.GetList<SharePoint2010ConceptsItem>("SharePoint 2010 Concepts"); var query = from cs in Concept where cs.Status.Title.ToString()!="Completed" select new { cs.Title, cs.Id, //cs.Status }; sgvConcepts.DataSource =query; sgvConcepts.DataBind();   Any help me plz how to retrieve the data from a lockup column.bvnprasad

Problem with Retrieving data from lookup column using SharePoint 2010 Linq Concept

  
Hi I am working with sharepoint linq concept. When I am giving a query with lookup column It's working fine.  But when i am trying to retrieve the data from a look up column to spgridview. I was unable to get the output. Here is the above code which i have worked.   string strTitle = string.Empty; string strStatus=string.Empty; var context = new LinqSampleDataContext(SPContext.Current.Web.Url); EntityList<SharePoint2010ConceptsItem> Concept = context.GetList<SharePoint2010ConceptsItem>("SharePoint 2010 Concepts"); var query = from cs in Concept where cs.Status.Title.ToString()!="Completed" select new { cs.Title, cs.Id, //cs.Status }; sgvConcepts.DataSource =query; sgvConcepts.DataBind();   Any help me plz how to retrieve the data from a lockup column.bvnprasad

What lists and what column types allow for setting "column default value settings"

  
There is a new setting for lists in 2010 called "Column default value settings". What lists does this setting apply to (I think just lists with a base template of Document Library)? And for what column types is it available? It was available on a "Single line of text" column but not a lookup column. Thanks in advance!

Missing column statistics from default trace

  
I am seeing Missing statistics events on my default trace and was wondering whether I need to create statistics on the table. Missing Column Statistics Is this a good practice considering the advice on http://msdn.microsoft.com/en-us/library/ms190397.aspx

multiple default value on a choice column

  

 

can I have multiple default value on a choice column?

 

 


Calculated column Default Value not retained in site template.

  

On a new blank site, create a custom list and make these changes to the Title field:

  1. Change the name to Date
  2. Change Required to No
  3. Change Default Value: to Calculated Value
  4. Enter the formula "=TEXT(Today,"d-mmm-yyyy")" so that it defaults to today's date

Save thsi site as a template, then create another site based on this template. Items 1 and 2 above are carried over to the new site but items 3 and 4 revert to the default setting.

Does anyone know how to get around this ... er ... abnomaly?


Default Column Values in a Document Library (SP2010) do not show up in word 2010 until you save and

  

when you create a document in a SP 2010 document library (of a particular content type, by clicking new, letter (content type name) in sharepoint for example) which has default values set on in in the library (set by using library settings -> change default column values), the default values do not show up until you create the document , save it and reopen it again.  Is this a bug or by design.  If it is by design, it is horrible since if some of the column default values are mandatory in the content type then you actually have to type them in before you could possibly save the file which defeats the whole point of having default column values.  Also it is tremendously clunky for a user to have to create file, save it , close it, and reopen it just to view the default metadata in the document information panel that is supposed to be there.

Anyone have any thoughts/solutions to this problem?


krd

select query for linq on Default.aspx.cs page

  

how do i create linq query and asign that query to as data source to datalist on default.aspx.cs page


Html column with ListaData.svc + linq + custom webpart

  
Hello Everybody, 

I'm developing a custom web site with sharepoint, so, I have one custom list that has a html column type. 
I'd like to get this column with linq and ListData.svc, on my custom webpart. But, when I called the method, it's not return this column.

So, my question is:  Can I get a Html column by listdata.svc ?

Tks, 
Arley 

Using "select" as default in list choice column

  
I have some choice columns in a list.  I set the first item in the choice to read "Select".  However, if that field was not changed (it's not required) it displays the "select" on views and in the DisplayForm.aspx.  Is there a way to have it NOT display anything?  I tried setting the column to not show anything for the default, but it wouldn't work.
There are no mistakes; every result tells you something of value about what your are trying to accomplish.

How to retrive a date time value from TimeStamp column using Linq?

  

I have a Timestamp column in my Table. I want to read the date time value and display in UI.

In Linq the Timestamp column is represented as System.Data.Linq.Binary.

I dont know how to retirve date time value in "MM-dd-YYYY" format from this Linq.Binary

 

- Why I am using Timestamp?.

I want to perform some operations based on the last modified date time of the particular row. Since I am using TimeStamp column in my Table as version column, It will contain the last modified date details, So i want to read the date time value from this time stamp column to do some other operations.

 

 


VB.NET Linq - Multiple column Group By using Anonymous types does not work properly

  

I am attemping to do a multiple column group by in linq using VB.  I've followed a code sample i obtained at the following url:

http://msdn.microsoft.com/en-us/vbasic/bb737926.aspx#grpbymult

the sample code is:

GroupBy - Multiple Columns

This sample uses Group By to group products by CategoryID and SupplierID.

Public Sub LinqToSqlGroupBy09()
    Dim categories = From p In db.Products _
                     Group By Key = New With {p.CategoryID, p.SupplierID} Into Group _
                     Select Key, Group

    ObjectDumper.Write(categories, 1)
End Sub



My code result though is not correct, as i am getting duplicates.   The first query is using the data which is stored in a datatable.  The second table pulls the data from a list of objects which i manually built in an effort to get closer to the Example provided above.

Dim listNamesWithSeverity = From myrow As DataRow In dt.Rows _
                

Default button handling in datalist.......urgent help

  

Hiii all,

 

i'm using datalist to display product details.

every item in datalist contains...

Default Value for 'Person or Group' column in a Sharepoint 2010 Custom List

  

Hello,

In Sharepoint 2010 I have a Custom List with a column of the type 'Person or Group'.
I would like to have a default name for this 'Person or group' column.
So when a user creates a new list entry and leves the 'Person or Group' column value blank the list entry should be created with the default value für the 'Person or Group' column.

Is there a way to schieve this?

Many thanks in advance.

Roberto Rocco.

 

 


Set dynamic default value for a Single line of text column type

  

Hi all,

I have a Project name site column(type is Single line of Text) and need to populate it with site name. Since Site name is not known until site is created, how can I deal with this through XML.No coding should be used.And this column is also being used in Roll up process for the site.The Project Name value that is being populated in the text box should be a default value too.

Thanks,



Categories: 
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