sql

  1. G

    Find count of certain elements in the dataset

    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?
  2. G

    Question Update using Table Adapter

    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...
  3. A

    Question How to add column column unitmeasure dynamically based on Flag Allow is 1?

    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...
  4. P

    How do I convert my SQL query to Entity Framework DBContext

    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...
  5. P

    How do I optimise the query

    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...
  6. P

    In MS Test - running parallel tests - sql timeout comes

    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...
  7. L

    use big data with SQL, what is better?

    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...
  8. A

    Question when implement sqlclr function i get error on sql server 2012?

    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...
  9. H

    London-UK: Developer C# - Permanent

    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...
  10. H

    Houston, TX: Senior Developer C#, Xamarin - Permanent

    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...
  11. H

    Dublin, Ireland: Senior Developer C#, Xamarin - Permanent

    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...
  12. H

    London-UK: Senior Developer C# - Permanent

    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...
  13. N

    How set db and read it?

    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...
  14. U

    Question Datagridview Not populating

    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...
  15. O

    ERROR: An entity can only be attached as modified...

    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...
  16. C

    Multiple connection strings

    I have a winforms application & depending on the user selection regarding SQL authentication there are 2 possible connection strings :- - using (var con = new SqlConnection(String.Format("Data Source={0}; database={1}; Integrated Security=True", Sql_ServerName, Sql_DataBaseName))) - using (var...
  17. kiln23

    Question Questions regarding deploying a SQL database with app.

    Hi guys. I am new to SQL and I have a few silly questions I'm wondering about. I am a C# developer and have thus far only worked with access, .mdb files. Let's say you develop some software for a client. It;s to be loaded on a few workstations and they need to connect to a central database...
  18. S

    Question connection string over internet

    Hi, i am trying to learn C# programing language, so far i am an absolute beginner. I find visual studio and C# to be a fantastic tool. I am trying to make a very simple windows form application that would connect to SQL server over internet with which a user could add or change data in the...
  19. N

    Question Delivery report problem during sms sending

    Hello I use Ozeki ng to send sms through database user. The problem: After sending the sms, its status will not be "delivered". It remains "sent" despite the delivery reports arrive through the service provider connection. I followed this setup guide carefully, I installed the database...
  20. ScottLoudon-VerelogicIT

    Software Developer - C#, ASP.Net, MVC, T-SQL - Basingstoke - 45,000 P.A!

    Hello All, My client are urgently seeking a number of Software Developers to join their team in Basingstoke!:):) My client are a leading Risk Intelligent Data Solutions company and require 2 experienced Software Developers to Join their team! Key Skills: - At least 3 years commercial...
Top Bottom