Click here to Skip to main content
15,916,371 members
Home / Discussions / C#
   

C#

 
Questionfetch the physical path of file saved in cache Pin
sujithkumarsl31-Oct-10 8:33
sujithkumarsl31-Oct-10 8:33 
AnswerRe: fetch the physical path of file saved in cache Pin
Richard Andrew x6431-Oct-10 12:23
professionalRichard Andrew x6431-Oct-10 12:23 
AnswerRe: fetch the physical path of file saved in cache Pin
T M Gray1-Nov-10 4:32
T M Gray1-Nov-10 4:32 
QuestionAdd control to form ,from UserControl Pin
Said Ali Jalali30-Oct-10 22:30
Said Ali Jalali30-Oct-10 22:30 
AnswerRepost Pin
OriginalGriff30-Oct-10 22:39
mveOriginalGriff30-Oct-10 22:39 
GeneralRe: Repost Pin
Said Ali Jalali30-Oct-10 23:18
Said Ali Jalali30-Oct-10 23:18 
GeneralRe: Repost Pin
Abhinav S31-Oct-10 23:47
Abhinav S31-Oct-10 23:47 
AnswerRe: Add control to form ,from UserControl Pin
Shuaib wasif khan1-Nov-10 1:50
Shuaib wasif khan1-Nov-10 1:50 
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 

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.