16,019,043 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Visual Basic questions
View Javascript questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Member 14921707 (Top 14 by date)
Member 14921707
1-Nov-21 13:55pm
View
30 rows with 27 column
Member 14921707
1-Nov-21 13:52pm
View
currently i am working on 30 list, imagine what if i have 200,000 guest, which is common in my case! i know it related with my computer memory, some time it work like charm and some time it take more than 7 sec! after the problem i run in my sql which fast then test in from the app it became ok!
Member 14921707
1-Nov-21 13:48pm
View
here is my sp
```
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_loadGuest]
-- Add the parameters for the stored procedure here
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
select g.id as 'id',
g.name as 'Name',
g.host_by as 'Host By',
g.purpose_of_visit as 'Purpose Of Visit',
g.companyName as 'Company Name',
g.occupication as 'Occupication',
g.address as 'Address',
g.city as 'City',
g.country as 'Country',
g.contact_no as 'CountactNo' ,
g.email as 'Email',
g.profile_image as 'profile Image' ,
g.doc1_image as 'Doc1 Image',
g.doc2_image as 'Doc2 Image',
g.gender as 'Gender',
g.religion as 'Religion',
idType.card_type as 'Id Type',
g.id_no as 'Id No',
g.note as 'Note',
g.created_at as 'Created At',
g.updated_at as 'Updated At',
idType.id as 'idTypeId',
vi.id as 'vechicleId',
vi.brand_id as 'Vechilebrand',
vi.model as 'VechileModel',
vi.vechile_no as 'VechileNo',
vi.color as 'Color'
from guest_table g
inner join id_type_table idType on g.id_type_id =idType.id
LEFT JOIN vechile_info_table vi on ( g.vehicle_id=vi.id OR ( g.vehicle_id IS NULL AND vi.id IS NULL))
order by g.created_at desc
END
```
Member 14921707
1-Nov-21 13:46pm
View
Deleted
my store procedure
```
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_loadGuest]
-- Add the parameters for the stored procedure here
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
select g.id as 'id',
g.name as 'Name',
g.host_by as 'Host By',
g.purpose_of_visit as 'Purpose Of Visit',
g.companyName as 'Company Name',
g.occupication as 'Occupication',
g.address as 'Address',
g.city as 'City',
g.country as 'Country',
g.contact_no as 'CountactNo' ,
g.email as 'Email',
g.profile_image as 'profile Image' ,
g.doc1_image as 'Doc1 Image',
g.doc2_image as 'Doc2 Image',
g.gender as 'Gender',
g.religion as 'Religion',
idType.card_type as 'Id Type',
g.id_no as 'Id No',
g.note as 'Note',
g.created_at as 'Created At',
g.updated_at as 'Updated At',
idType.id as 'idTypeId',
vi.id as 'vechicleId',
vi.brand_id as 'Vechilebrand',
vi.model as 'VechileModel',
vi.vechile_no as 'VechileNo',
vi.color as 'Color'
from guest_table g
inner join id_type_table idType on g.id_type_id =idType.id
LEFT JOIN vechile_info_table vi on ( g.vehicle_id=vi.id OR ( g.vehicle_id IS NULL AND vi.id IS NULL))
order by g.created_at desc
END
```
Member 14921707
31-Oct-21 13:10pm
View
it is just load guest..in my sql server it only take 0.01 sec
Member 14921707
7-Sep-21 8:45am
View
Deleted
var policy = Policy
.Handle<exception>()
.OrResult<httpresponsemessage>(r => !r.IsSuccessStatusCode)
.RetryAsync(2);
string fullUrl = baseUrl + specificUrl+ date;
using (var requestMessage = new HttpRequestMessage(HttpMethod.Get, fullUrl))
{
requestMessage.Headers.Add("access_token", token);
using (HttpResponseMessage res = await policy.ExecuteAsync(() => client.SendAsync(requestMessage)))
{
string data = await res.Content.ReadAsStringAsync();
if (string.IsNullOrEmpty(data)) { return string.Empty; }
return data;
}
}
This is working but when the second try, it says "The request message was already send, cant send same request multiple time! "
that is why i make await policy.ExcuteAsync at the first line
Member 14921707
7-Sep-21 8:45am
View
var policy = Policy
.Handle<exception>()
.OrResult<httpresponsemessage>(r => !r.IsSuccessStatusCode)
.RetryAsync(2);
string fullUrl = baseUrl + specificUrl+ date;
using (var requestMessage = new HttpRequestMessage(HttpMethod.Get, fullUrl))
{
requestMessage.Headers.Add("access_token", token);
using (HttpResponseMessage res = await policy.ExecuteAsync(() => client.SendAsync(requestMessage)))
{
string data = await res.Content.ReadAsStringAsync();
if (string.IsNullOrEmpty(data)) { return string.Empty; }
return data;
}
}
This is working but when the second try, it says "The request message was already send, cant send same request multiple time! "
that is why i make await policy.ExcuteAsync at the first line
Member 14921707
7-Sep-21 8:37am
View
return string.Empty;
return data;
this two are highlighted, error of "Convert type 'string ' to 'system.net.http.httpresponsemessage'"
Member 14921707
27-Jun-21 1:37am
View
instead of calling all method one by one like
Copy Code
await rePostRoomReservation(); await rePostHallReservation();
There is method for Execution parallel not one by one, for fast execution.
Member 14921707
26-Jun-21 10:44am
View
show me in code, please
Member 14921707
17-Jan-21 3:48am
View
see my update code..i add full code
Member 14921707
17-Jan-21 3:12am
View
i am asking simple question. i have already open window (checkIn widow)..i want to fill my guest information in to it, when i click list of guest it open window with grid view, when i click the cell i want to fill the first window guest information. how can i do this?? ``` checkInfrm.Show()``` open me new window i dont want this
``` update my code please!!```
Member 14921707
16-Jan-21 13:28pm
View
i want to see my code , i know that is work, but how can i use foreach in my case ?
Member 14921707
16-Jan-21 10:43am
View
all the above article i already read them,, pass data for new opening window.
my question how can i pass data if there is already open window, instead of opening again
Show More