Click here to Skip to main content
15,891,864 members
Home / Discussions / C#
   

C#

 
GeneralRe: Add control to form ,from UserControl Pin
Said Ali Jalali2-Nov-10 23:53
Said Ali Jalali2-Nov-10 23:53 
QuestionHow to use Get Post in C# Pin
Sonu J30-Oct-10 20:38
Sonu J30-Oct-10 20:38 
AnswerRe: How to use Get Post in C# Pin
Abhinav S31-Oct-10 0:02
Abhinav S31-Oct-10 0:02 
AnswerRe: How to use Get Post in C# Pin
Eddy Vluggen31-Oct-10 0:05
professionalEddy Vluggen31-Oct-10 0:05 
AnswerRe: How to use Get Post in C# Pin
Ravi Bhavnani31-Oct-10 16:33
professionalRavi Bhavnani31-Oct-10 16:33 
AnswerRe: How to use Get Post in C# Pin
VarunSharma432-Nov-10 20:44
professionalVarunSharma432-Nov-10 20:44 
QuestionPopulate c# datastructure from table or view [modified] Pin
Michael Pauli30-Oct-10 14:48
Michael Pauli30-Oct-10 14:48 
AnswerRe: Populate c# datastructure from table or view Pin
Karthik. A30-Oct-10 15:59
Karthik. A30-Oct-10 15:59 
You can do something like this instead of looping throught the dataset/SqlDataAdapter. First you can create a class that inherits DataContext. And then you can use methods of DataContext like to ExecuteQuery<> to convert your results in to objects. With this method you can directly use your queries you wrote earlier.

Consider the following example. First you need to define a class for interacting with your database

public class DBManagerDataContext : DataContext
{
    private static string connectionString = ""; // Your connection string

    public static DBManagerDataContext CreateInstance()
    {
        return new DBManagerDataContext(connectionString);
    }

    protected DBManagerDataContext(string connectionString)
        : base(connectionString, new AttributeMappingSource())
    {

    }
}


Then you can use this context to execute queries and convert them in to objects as shown below:

public class Report
{
    public int ReportID;
    public string ReportTitle;
    public DateTime ReportDate;

    private static string query = "select ReportID, ReportTitle, ReportDate from dbo.Reports"; // Your query

    public static List<Report> GetReportList()
    {
        DBManagerDataContext context = DBManagerDataContext.CreateInstance();
        return context.ExecuteQuery<Report>(query).ToList();
    }
}


You can use the method "GetReportList()" given above like this for example:

List<Report> reports = Report.GetReportList();


Please note that the query column names should match the definition in the object

This is just an example. You could do something like this, that would serve your purpose.
I guess this is what you are asking about...
Cheers,
Karthik

QuestionResizing form according to the screen resolution Pin
Nouman Bhatti29-Oct-10 22:03
Nouman Bhatti29-Oct-10 22:03 
AnswerRe: Resizing form according to the screen resolution Pin
OriginalGriff29-Oct-10 22:31
mveOriginalGriff29-Oct-10 22:31 
GeneralRe: Resizing form according to the screen resolution Pin
Michael Pauli30-Oct-10 14:55
Michael Pauli30-Oct-10 14:55 
GeneralRe: Resizing form according to the screen resolution Pin
OriginalGriff30-Oct-10 20:53
mveOriginalGriff30-Oct-10 20:53 
AnswerRe: Resizing form according to the screen resolution Pin
Eddy Vluggen31-Oct-10 0:14
professionalEddy Vluggen31-Oct-10 0:14 
AnswerRe: Resizing form according to the screen resolution Pin
fjdiewornncalwe31-Oct-10 9:40
professionalfjdiewornncalwe31-Oct-10 9:40 
Questiondatagridview KeyDown event doesnt working Pin
Erdinc2729-Oct-10 21:45
Erdinc2729-Oct-10 21:45 
AnswerRe: datagridview KeyDown event doesnt working Pin
Richard MacCutchan29-Oct-10 22:45
mveRichard MacCutchan29-Oct-10 22:45 
GeneralRe: datagridview KeyDown event doesnt working Pin
Erdinc2730-Oct-10 1:14
Erdinc2730-Oct-10 1:14 
GeneralRe: datagridview KeyDown event doesnt working Pin
Dave Kreskowiak30-Oct-10 9:02
mveDave Kreskowiak30-Oct-10 9:02 
GeneralRe: datagridview KeyDown event doesnt working Pin
Richard MacCutchan30-Oct-10 9:28
mveRichard MacCutchan30-Oct-10 9:28 
AnswerRe: datagridview KeyDown event doesnt working Pin
Michael Pauli30-Oct-10 15:14
Michael Pauli30-Oct-10 15:14 
GeneralRe: datagridview KeyDown event doesnt working Pin
Erdinc273-Nov-10 0:24
Erdinc273-Nov-10 0:24 
Questionproblem related to "Nural networks face detection algprithm" Pin
inayathussaintoori29-Oct-10 15:07
inayathussaintoori29-Oct-10 15:07 
AnswerNural networks Repost Pin
Richard MacCutchan29-Oct-10 22:34
mveRichard MacCutchan29-Oct-10 22:34 
AnswerRe: problem related to "Nural networks face detection algprithm" Pin
Dave Kreskowiak30-Oct-10 8:59
mveDave Kreskowiak30-Oct-10 8:59 
GeneralRe: problem related to "Nural networks face detection algprithm" Pin
inayathussaintoori30-Oct-10 10:13
inayathussaintoori30-Oct-10 10:13 

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.