sql server - using dynamic sql in c# code in visual studio -

-

I am developing an application in which I have to prepare a report based on staff entries and entries. I do not have experience with databases related applications using dynamic queries. In this particular application, I have to pass dynamic SQL queries.

In this I have to select column names based on user selection and then they will have to pass them in other SQL queries as parameters. Here are the questions ... 

  DECLARE @ cols AS NVARCHAR (MAX), @class AS NVARCHAR (maximum) select @cols = STUFF ((SELECT ',' + QUOTENAME (date + Select 'Log In Union', select 'Door', Convert (Four (10), Dordert, 101) XML Path (Choose from '_' + LogName) ('.', 'NVARCHAR (Max)'), 1 (Convert for '', type), (10), Dorardet, 112), 10), Dordreit, 112), Date, LogName Order. , 1, '') set @query = 'select employee, name,' + @ cols + '(employee Select name, convert (four (8), dortream, 108) dormitimate, date + "_" '+ from col col_names (select p.employeeid, p.name, convert (char (10), d. Doordate, 101) change the date, minute (d.doordate) [in], max (d.doordate) [out] from person p left P.employeeid = d.employeeid group p.employeeid, p.name, (char Join Logog D. (10), d.doordate, 101)) SQF Unprivate (in colonel (for [these] to do not, [out]) Unpiv) P Axis (maximum (doortime) for col_names (' + @ Cols + ')) Piv' executed (@coke) y)   
 I will use this code in the C # code Industry have found how to make sense no data in this way.  
 Please help.  
 Thanks in advance ...   
 
 
 Your best bet is your database In order to create a stored system that performs incoming requests, and execute queries. Here are some more information about stored procedures:  
  
 Then you have to make a connection to your database in your C # code:  
  
 In the end you will be called your stored procedure using the connection made by you and will need to pass the parameters from your C # code, which has been answered many times over the stack overflow:

Comments

Post a Comment

Popular posts from this blog

excel vba - How to delete Solver(SOLVER.XLAM) code -

-
After opening several examples of macro / code written, I suddenly get stuck with a code that seems safe. Solver (SOLVER.XLAM) is doing this notation and I would like to remove it from my system. I do not think this is a relativant code. Can anyone tell me what should I do? I have already installed something to remove the password but Solver is still asking for password and I can not get rid of it! itemprop = "text"> Solver Excel is add-in If you want to delete it, then Excel Application & gt; Options & gt; Add-ins & gt; Search for 'Go to' button and gt; Uncheck the solver on the list like press something (I can not give you the exact path because I have the Polish version of Excel). Trying to open Solver's VBA code is not good because it There is allegedly copyright. Besides, I do not think Solver creates any disadvantages while working with Excel or VBA.
Read more

jsp - Google line chart x-axis shrinks on transition -

-
I am using a Google line chart on my page, which refreshes every 5 seconds but weird thing It is that every refresh chart causes the line to be removed, although the size of the chart remains the same. My script - google.load ('visualization', '1', {package: ['corechart']}); Google.setOnLoadCallback (drawLine); // call clickChart when the google.load () function meets the drawLine () {var gaugeData = new google.visualization.DataTable (); GaugeData.addColumn ('string', 'time'); // X-axis gazeta.dk column ('number', 'memory'); // Y-axis gazedata.edc column ('number', 'cpu'); // Y-axis square gauge option = {title: 'system description'}; // tile of var gauge chart; Var tempArray; // store json object value from server var tempArray2; // Server gauge = Modify the json object value = new google.visualization.LineChart (document.getElementById ('line_chart_div')); SetInterval (function () {$ aja...
Read more

java - Reaching JTextField in a DocumentListener -

-
So, I ended up making a Sudoku Solver, but I want to improve it. To do this, I need to reach betterJTextField to documentListener . I am using a documentListener to read from my betterJTextFields in real-time, I have the problem that insertUpdate (DocumentEvent e) . I need to reach Better Zest Field that happened to DocumentEvent . For example, if invalid input, would be better zestfield turn red etc. I have all my better zestfield in the matrix if you should know. Each area handles a number in the Sudoku. @ Override public zero inserted (DocumentEvent e) {// Code removed which checks that the input in the fine zest field is OK. } ( JFormattedTextfield extended JTextField ) public class betterJeststeffiledJFormattedTextField {private int row; Private int column; Public BetterJustStस्टfield (format format, infinite row, EIT column) {super (format); This.row = Line; This.column = Column; // To-O Auto-Generated Constructor Stub} Public Ent Miller () {ret...
Read more