sqlserver

I am using Northwind database in Sql Server. I am using Stored Procedure to connect Visual Studio with Sql Server and draw data from database. In CRUD operations, I am tring to write a SEARCH button that is using Stored Procedure. Other CRUD buttons are working okay. Search button is not...

I have a table with weather data. The table consists of an ID, the temperature and the date. I would like to have the temperature data to and the respective year in a line chart output. I want to be able to select via a dropdown menu or via a textbox the respective ID, so that for the...

I have 2 asp.net WebForms, WebForm1 contains a button that redirects into WebForm2 which contains a contact form that needs to be filled to proceed an order. I have a drop down list in it that is connected to the database, and depending on which product a button on the WebForm1 is clicked, the...

I'm attempting to publish my database but I'm getting the errors below. Ive unchecked the "block incremental deployment if data loss might occur" option which usually works but for some reason this time it isn't. Does anyone know a fix for this?? Rename refactoring operation with key...

Hi there, I am DBA with zero C# programming experience however I would like to ask all C# programmers out there how they would handle large JSON data. Currently I have a very slow query when trying to convert filestream NVARBINARY(MAX) stored JSON data into NVARCHAR(MAX) from within SQL Server...

Hello C Sharpers... This is dtoxic, my experience in C# is "Hello World":hopelessness:. I have been recently appointed at a fuel station as a Data Entry Operator, there is no POS (Point of Sale) system installed here. All the data is maintained manually with pen and paper. It is actually a...

I've been trying to figure out how I can use LINQ to query a SQL Server database using C# for 2 days now. I've been through about a dozen tutorials but they all seem to lack that key step where you actually connect to a SQL Server database. I've been working in .NET and SQL Server for over 15...

I have created a WPF project, where a user can insert the Servername in a textbox, and the connection should be saved in the app.config (in Runtime), ones that is done the data from a DB table should be loaded in the datagrid. When i press the connect button (after inserted the servername in the...

Hello everyone I have started project where i want the user to be able to connect to a SQL server themselves. The reason for this is that the tables might/hopefully be moved from a test server to production server. however the tables names are static, meaning that the connection dialog should...

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Net; using System.Net.Sockets; using System.IO; using System.Threading; namespace newClient { class Connection { //Thread _threadObj; TcpClient _TcpObj...

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

hi for past 7 days i was wondering on how to create excel report from excel Template, populating excel report using sql select query in c# windows forms with sql server 2008. I have create an Excel Template in my same project folder named : Technician Details.xltx. Given below is my code in...

I am using Visual Studio 2010, language C# and SQL Server Express Edition as backend. There is one form with DataGridView control, I've setup columns manually using designer, then on runtime set the data source. connectionString = ConfigurationManager.AppSettings["connectionString"]...

I need some help to make a Order Form in C#. My development environment is: Microsoft Visual Studio 2010 Ultimate Sql Server Express Edition 2005 Programming Language C# Sample Database = NorthWind (Tables=Orders and OrderDetails) I've create a Form for order dataentry, which contain Textbox...

Hi All Experts, I am a newbie to C#, my development environment is: Visual Studio 2010 Ultimate Edition Sql Server 2005 Programming Language C#** I've a form with Unbound Datagridview, from which data is save to Sql Server 2005 by looping through For..Each and pass SQL INSERT Statement when...