Click here to Skip to main content
12,697,662 members (28,715 online)
   

Database

 
GeneralRe: xBase question Pin
DavidCrow15-May-12 8:30
memberDavidCrow15-May-12 8:30 
GeneralRe: xBase question Pin
Kevin Marois15-May-12 8:31
memberKevin Marois15-May-12 8:31 
GeneralRe: xBase question Pin
DavidCrow15-May-12 8:37
memberDavidCrow15-May-12 8:37 
GeneralRe: xBase question Pin
Kevin Marois15-May-12 8:44
memberKevin Marois15-May-12 8:44 
QuestionOracle: Replace single occurrence of a character Pin
Lash2014-May-12 9:21
memberLash2014-May-12 9:21 
AnswerRe: Oracle: Replace single occurrence of a character Pin
rana ray15-May-12 1:56
memberrana ray15-May-12 1:56 
GeneralLinq to Sql Pin
sindhuan14-May-12 2:10
membersindhuan14-May-12 2:10 
GeneralRe: Linq to Sql Pin
Kevin Marois14-May-12 12:45
memberKevin Marois14-May-12 12:45 
sindhuan wrote:
Is this the right way to do??


No, because

dc.users.InsertOnSubmit("us");


won't even compile, because you're trying to insert a string "ur". Your code is expecting an entity of type user. So you want

dc.users.InsertOnSubmit(us);


So, you first want to query the user to get the name, then insert the new row.

using (MyDataContext dc = new MyDataContext())
{
    var userName = (from u in dc.tblUsers
                    where u.Id = someId
                    select u.UserName).FirstOrDefault();


    user us = new user
    {
        Date = DateTime.Now,
        name = userName
    };

    try
    {
        dc.users.InsertOnSubmit(us);
    }
    catch(Exception e)
    {
        // Handle exception here
    }
}


You will have to adjust the data context and table names and column names, but this should get you started.
If it's not broken, fix it until it is


modified 14-May-12 18:00pm.

QuestionDoubt in a piece of code [Transact-SQL database audit]. Pin
vValkir13-May-12 22:54
membervValkir13-May-12 22:54 
AnswerRe: Doubt in a piece of code [Transact-SQL database audit]. Pin
Mycroft Holmes13-May-12 23:36
memberMycroft Holmes13-May-12 23:36 
GeneralRe: Doubt in a piece of code [Transact-SQL database audit]. Pin
vValkir13-May-12 23:54
membervValkir13-May-12 23:54 
AnswerRe: Doubt in a piece of code [Transact-SQL database audit]. Pin
djj5514-May-12 5:08
memberdjj5514-May-12 5:08 
QuestionOracle Question: Split String into two Pin
Lash2011-May-12 6:57
memberLash2011-May-12 6:57 
AnswerRe: Oracle Question: Split String into two Pin
Jörgen Andersson11-May-12 10:08
memberJörgen Andersson11-May-12 10:08 
AnswerRe: Oracle Question: Split String into two Pin
Lash2011-May-12 10:33
memberLash2011-May-12 10:33 
GeneralRe: Oracle Question: Split String into two Pin
Jörgen Andersson11-May-12 10:47
memberJörgen Andersson11-May-12 10:47 
Questiontimestamp Pin
vijaylumar11-May-12 2:39
membervijaylumar11-May-12 2:39 
AnswerRe: timestamp Pin
Eddy Vluggen11-May-12 2:42
memberEddy Vluggen11-May-12 2:42 
QuestionWhat is database SQL query to display the name of the table only in to datagrid? Pin
LAPEC10-May-12 2:04
memberLAPEC10-May-12 2:04 
AnswerRe: What is database SQL query to display the name of the table only in to datagrid? Pin
PIEBALDconsult10-May-12 4:16
memberPIEBALDconsult10-May-12 4:16 
AnswerRe: What is database SQL query to display the name of the table only in to datagrid? Pin
vvashishta10-May-12 5:17
membervvashishta10-May-12 5:17 
GeneralRe: What is database SQL query to display the name of the table only in to datagrid? Pin
Eddy Vluggen10-May-12 8:05
memberEddy Vluggen10-May-12 8:05 
Questionchoosing a database Pin
davood_b8-May-12 2:19
memberdavood_b8-May-12 2:19 
AnswerRe: choosing a database Pin
PIEBALDconsult8-May-12 4:16
memberPIEBALDconsult8-May-12 4:16 
QuestionRe: choosing a database Pin
Eddy Vluggen8-May-12 6:05
memberEddy Vluggen8-May-12 6:05 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.170118.1 | Last Updated 20 Jan 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid