sql

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. ScottLoudon-VerelogicIT

    C#.Net Software Developer Needed Urgently! - Sheffield - ?35,000 P.A

    Hello All, My client are urgently seeking a number of Software Developers to join their team in Sheffield! :):) Due to growth they are moving into new offices and require multiple C#.Net Developers to join their team. Originally based in London and the South East they are expanding their team...
  7. FisherRon

    Question Getting a SQL Connection object from a Db class to avoid repeating code

    I am trying to consolidate code that is always the same by putting it in a DbManager class. The problem is that I'm not sure if doing this with a SQL Connection object is working properly. This is the code I'm getting the connection for: public bool CheckIfChildRecordsExist(string tableName...
  8. A

    SQL Data to specified JSon Format

    LIST Time Status A 22:05 0 B 22:10 1 C 22:30 1 A 22:40 0 C 22:50 1 B 22:60 1 The above table needs to be converted to below JSON format [ { "name": "A", data: [ [22:05,0], [22:40,0] ] }, { "name": "B", data: [ [22:10,1]...
  9. S

    function for date search

    Hello! I have created a local database in Visual Studio 2010 and a web application which interracts with it. I have a text box in which i write a date (delivery date, for example) and a search button to display all the information about an invoice having the delivery date i mention in the text...
  10. M

    Question Problem with SQL query and RowFilter "SOLVED"

    I'm having problem with a school assignment. I'm almost done with my program but I have one problem that I can't solve. The problem is with one of my SQL query's that are supposed to show players with different scores. When running my program I get the following error: Syntax error near...
Top Bottom