Click here to Skip to main content
15,175,953 members
Home / Discussions / C#
   

C#

 
QuestionC# How to use place holder in string variable Pin
Mou_kol18-Nov-21 6:34
MemberMou_kol18-Nov-21 6:34 
AnswerRe: C# How to use place holder in string variable Pin
Mou_kol18-Nov-21 6:53
MemberMou_kol18-Nov-21 6:53 
AnswerRe: C# How to use place holder in string variable Pin
phil.o18-Nov-21 13:33
mvephil.o18-Nov-21 13:33 
GeneralRe: C# How to use place holder in string variable Pin
Mou_kol19-Nov-21 5:03
MemberMou_kol19-Nov-21 5:03 
AnswerRe: C# How to use place holder in string variable Pin
BillWoodruff19-Nov-21 18:00
mveBillWoodruff19-Nov-21 18:00 
GeneralRe: C# How to use place holder in string variable Pin
Mou_kol16-Dec-21 7:31
MemberMou_kol16-Dec-21 7:31 
GeneralRe: C# How to use place holder in string variable Pin
Mou_kol16-Dec-21 7:32
MemberMou_kol16-Dec-21 7:32 
QuestionAsp.net web api(GET) to pull the records(8 lac records) Pin
Sai Kumar18-Nov-21 5:43
MemberSai Kumar18-Nov-21 5:43 
Hi All,
As i am using below C# code in Asp.net web api(GET) to pull the records(8 lac records),i am facing an error i.e system.outofmemoryexception was thrown.Can anyone helpme out on this.Thank You.

    public HttpResponseMessage GetLocation([FromBody] data data)
        {
            try
            {
                ds = objTransactionMgr.Getlocationdetails(data, ref objError);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    var JsonList = ds.Tables[0].AsEnumerable().Select(dataRow => new get_location_details()
                    {
                        name = dataRow.Field<string>("name"),
                        order = dataRow.Field<string>("order"),
                        date = Convert.ToDateTime(dataRow.Field<datetime?>("date")),
                        location = dataRow.Field<string>("location"),
                        type = dataRow.Field<string>("type"),
                        id = dataRow.Field<string>("id"),
                        category = dataRow.Field<string>("category"),
                        seq = Convert.ToInt32(dataRow.Field<decimal?>("seq")),
                        address = dataRow.Field<string>("address"),
                        uom = dataRow.Field<string>("uom"),
                        volume = dataRow.Field<string>("volume"),
                        total = Convert.ToInt32(dataRow.Field<double?>("total")),
                        task_value = Convert.ToInt32(dataRow.Field<decimal?>("task_value"))
                    }).ToList();
                    return Request.CreateResponse(HttpStatusCode.OK, JsonList);
                }
                else
                {
                    _messages.status = "Success";
                    _messages.message = "No rows to return";
                    return Request.CreateResponse(HttpStatusCode.OK, _messages);
                }
            }
            catch (Exception ex)
            {
                return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message);
            }
        }
AnswerRe: Asp.net web api(GET) to pull the records(8 lac records) Pin
Richard Deeming18-Nov-21 5:47
mveRichard Deeming18-Nov-21 5:47 
GeneralRe: Asp.net web api(GET) to pull the records(8 lac records) Pin
Sai Kumar18-Nov-21 6:06
MemberSai Kumar18-Nov-21 6:06 
GeneralRe: Asp.net web api(GET) to pull the records(8 lac records) Pin
Richard Deeming18-Nov-21 6:24
mveRichard Deeming18-Nov-21 6:24 
GeneralRe: Asp.net web api(GET) to pull the records(8 lac records) Pin
Sai Kumar18-Nov-21 6:38
MemberSai Kumar18-Nov-21 6:38 
QuestionTrouble using Canon's EDSDK in VS on mac Pin
Member 1543145718-Nov-21 5:19
MemberMember 1543145718-Nov-21 5:19 
AnswerRe: Trouble using Canon's EDSDK in VS on mac Pin
Luc Pattyn18-Nov-21 5:55
sitebuilderLuc Pattyn18-Nov-21 5:55 
QuestionC sharp Picturebox linking error Pin
ÖmürTokman9-Nov-21 0:05
MemberÖmürTokman9-Nov-21 0:05 
AnswerRe: C sharp Picturebox linking error Pin
OriginalGriff9-Nov-21 0:27
mveOriginalGriff9-Nov-21 0:27 
GeneralRe: C sharp Picturebox linking error Pin
ÖmürTokman9-Nov-21 1:09
MemberÖmürTokman9-Nov-21 1:09 
GeneralRe: C sharp Picturebox linking error Pin
OriginalGriff9-Nov-21 1:17
mveOriginalGriff9-Nov-21 1:17 
AnswerRe: C sharp Picturebox linking error Pin
Richard MacCutchan9-Nov-21 0:39
mveRichard MacCutchan9-Nov-21 0:39 
GeneralRe: C sharp Picturebox linking error Pin
ÖmürTokman9-Nov-21 1:13
MemberÖmürTokman9-Nov-21 1:13 
AnswerRe: C sharp Picturebox linking error Pin
Eddy Vluggen10-Nov-21 4:06
professionalEddy Vluggen10-Nov-21 4:06 
Questionwriting content of csv files into oracle Pin
md arif 20215-Nov-21 0:27
Membermd arif 20215-Nov-21 0:27 
AnswerRe: writing content of csv files into oracle Pin
Richard MacCutchan5-Nov-21 1:34
mveRichard MacCutchan5-Nov-21 1:34 
AnswerRe: writing content of csv files into oracle Pin
OriginalGriff5-Nov-21 2:30
mveOriginalGriff5-Nov-21 2:30 
GeneralRe: writing content of csv files into oracle Pin
Richard MacCutchan5-Nov-21 3:09
mveRichard MacCutchan5-Nov-21 3:09 

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.