I'm making a coach booking system and I'm at the final stage where the user has to select a seat before inserting the data within a table.
When the user selects one of the picture boxes it'll turn green, and that specific seat Id will be stored within the Booking table.
If another customer...
Hi i have a basic application that is used to display customer information from a sql database, i am using a datagridview to display the information, i also have a form that has texboxdes on it to enter customer information for adding to that database which currently works. what i need to do now...
Hi All,
I'm currently exploring options to provide a front end user to query a database tables by selection which items/filters they want. I came across this product EasyQuery which looks promising. My initial though was simply to use a data grid/or traditional report and then have the user...
USing theses Statements
no Table SELECT
SELECT FROM
WHERE
AND, OR, NOT, IN, LIKE
GROUP BY
HAVING (which also implies a join and a group by)
MC/TF portion
all multiple choice and True False
1. Show ship countries and a count of orders by Ship Country. Include orders placed in 1997 and...
I work on SQL server 2012 .really I don't understand what statement below do updatedand when
when NullFlag updated
and
when conflict flag updated
can you explain to me according to sample below
<code>
result of query data details rows without grouping :
Masked_ID DocumentID PartID NULLCount...
Hi, I have a database and a dataset in C# application. The dataset has the list of my friends with phone number, address and a id. This is for learning purposes. I need to find the count of certain elements , say for example the total count of all the friends with ID > 3. How can I do that?
Hi,
I have a sql server database with ID, First Name, Last Name, Phone Number and Address. I have created a wpf application that has a dataset of the database and uses a datagrid view to view the table. I did this as a learning procedure. Now I am learning how to update the database using wpf...
How to add column column unit dynamically when Flag Allow is 1 on table #nonparametric table ?
I work on SQL server 2012 I can't add column unit dynamically when Flag Allow=1
as example below I have two rows have Flag Allow=1
family 90AM will be family 90 and family unit AM on two column...
Hello All,
I have one query which I wrote in SQL but now i want to convert it to EF and I am finding difficulty on understanding how do I incorporate multiple select statements in EF
SQL Query:
SELECT TOP {count} *
FROM
(
SELECT co.orderid,co.orderStatusId...
Hello folks,
I have prepared one query, but I feel this can be even more optimised! But I'm not sure what can be done
Query
SELECT
TOP 10 *
FROM
(
SELECT
co.orderid,
co.orderStatusId,
co.paymenttransactionstatusid,
(
SELECT...
I have framework which runs 12 threads parallel - each will have different test but may have to get result from sql connection
Doing so - I'm receiving below error - Is there a way where I can do any workaround in my code to make it work without loosing parallel threads
<add...
Hello.
I wan to select \ write \ read \ delete \ change colums, rows in table, will be a big size data for web and win application.
Which of best way can you recommend with using c# language
1) Sql server or sqllite or mongoDB or some other
2) how to use data information cut big data for...
Problem
I work on SQL server 2012 windows 7 when implement clr function i get error
Msg 6522, Level 16, State 1, Line 1
A .NET Framework error occurred during execution of user-defined routine or aggregate "spExecuteParallel":
System.NullReferenceException: Object reference not set to an...
PERMANENT Full-time position
Below is an outline job description. If you are interested or have any questions, please email to Angela.Nguyen@virtusllc.com directly.
Developer - London, United Kingdom
Tracking Code
710-171
Job Description
Senior Developer required for a unique, highly...
PERMANENT Full-time position
Below is an outline job description. If you are interested or have any questions, please email to Angela.Nguyen@virtusllc.com directly.
Senior Developer - Houston, Texas
Tracking Code
401-171
Job Description
IT professional experienced in .NET programming...
PERMANENT Full-time position
Below is an outline job description. If you are interested or have any questions, please email to Angela.Nguyen@virtusllc.com directly.
Senior Developer - Dublin, Ireland
Tracking Code
611-171
Job Description
IT professional experienced in .NET programming...
PERMANENT Full-time position
Below is an outline job description. If you are interested or have any questions, please email to Angela.Nguyen@virtusllc.com directly
Senior Developer - London, United Kingdom
Tracking Code
699-171
Job Description
IT professional with experience in C# .NET, and...
Hello, I am really a beginner on C# development. But, sometimes i like to play around with C# and try to develop stuff.
I have sql express 2014. Visual C# 2017 Community Version.
I created a database through SQL Management Studio in my local computer.
The name of the DB is ReleasesLogin and has...
Hello, i have a method private void FillLevyRoll(), i put the method in a button on click event to fill a datagridview dgvLevyRoll my problem is when i run i am not getting an error and the dgv is remaining empty.Im lost confused tried but to no avail.The query works in SQL management studio...
Hi all,
I hope you can help me. This is an issue I have been battling with for days now, and I am struggling to resolve it.
My setup:
I am using VS2015 Community Edition
I am using LINQ to SQL
.Net 4.5
I have read up quite a bit on this specific error, and it seems there are a couple ways to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.