Click here to Skip to main content

Submit your article

Parameter

Parameter

Great Reads

Named C++ Function Parameters, Yet Another Approach

by Sergey Alexandrovich Kryukov

Rather insane yet simple approach to the named function parameters

Dynamic Language Runtime in C#/.NET

by Uladzislau Baryshchyk

An overview of Dynamic Language Runtime DLR in C#

Default keyword in SQL Server

by Mel Padden

Default keyword in SQL Server

Identifying Used and Unused Resources in a Visual Studio’s Project Resources.resx File

by ToughDev

How to identify used and unused resources in VS Project Resources.resx file

Latest Articles

Into the Extreme – Fold-Expressions

by Coral Kashri

Fold-expressions in extreme cases

Identifying Used and Unused Resources in a Visual Studio’s Project Resources.resx File

by ToughDev

How to identify used and unused resources in VS Project Resources.resx file

How to create Regional Web ACL (WAFv2) with PowerShell

by Illya Reznykov

The post describes PowerShell script which creates WAF resources for the scenario when Application Load Balancer is used to serve content for a public website, but to block requests from attackers and to protect from OWASP Top 10 security risks.

Multithreading in C#

by Uladzislau Baryshchyk

An overview of multithreading in C#

All Articles

Parameter

Passing parameters between classes

28 Jul 2011 by #realJSOP

You can:0) Implement a public method to initialize the variable (passing the path as a parameter to the method).1) Make a public property that can be set externally of the class that contains it2) If the variable only has to be set one time, you could pass the path as a parameter to...

C# can my method take a parameter that orders/sorts my list?

28 Nov 2021 by #realJSOP

You could do it this way: public void DistributeChocolatesByAge(int choc) { ChocolatesDistributed(choc, People.OrderBy(x => x.Age).ToList()); } However, I would probably move the sort operation into the ChocolatesDistributed method so...

Stored procedure in SQL

29 Sep 2014 by /\jmot

Try like this..CREATE PROCEDURE usp_makebid( @userID varchar @auctionID varchar)ASBEGIN declare @HasBid intdeclare @Opres intset @HasBid=0set @HasBid=select bids from Users where id=@userIDif @hasBid>0begininseri into Auctions (column values)select...

SQL-Server-2008R2

stored-procedure

Procedure or Function 'Nav_Bulletins_Insert' expects parameter '@Bulletin', which was not supplied

14 Oct 2011 by 07navneet

hi,i am having trouble with this problem from last week.The problem gets more trickier bcoz when I try to insert record it shows this error"Procedure or Function 'Nav_Bulletins_Insert' expects parameter '@Bulletin', which was not supplied." but in DB the value is stored!PLease solve this...

Procedure or Function 'Nav_Bulletins_Insert' expects parameter '@Bulletin', which was not supplied

5 Dec 2011 by 07navneet

in procedure i had written exec at last line!! pointed by thatraja

Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

4 Jun 2013 by _Amy

This exception is obvious. You are trying to access a member of an collection which does not exist. For e.g. your ListView is not having any item or it is null but still if you are trying to access the ListItem. This will throw an error. Try stepping through your code and check the value of...

List all data in the table with paremeter

16 Jun 2013 by _Amy

Try this:CREATE PROC ListStudents @Name varchar(20)=''ASBEGIN SELECT * FROM StudentDet WHERE Name LIKE ''+@Name+'%'ENDWhen you need the details of particular student you can pass the name. If you'll not pass name then it'll list the details of all students.EXEC ListStudents...

Display image in reportviewer with a parameter

15 Nov 2016 by abboudi_ammar

Good evening, I try to display an image in a reportViewer from a send path as a parameter. But the result I get is an image in X formWhat I have tried:public...

Ref vs out which one is better to use

17 Feb 2018 by abdul wadood

Since ref passes the data in two ways and out passes the data in one way.But one thing i am not sure which one is better to use I have done a simple practical using ref and out which have the same output..If it has same output then whats the difference? Here is my code using out keyword: ...

Export existing crystal report in asp.net

1 Aug 2014 by Abhinav S

Crystal reports does offer an export to excel feature -How to Export Crystal Report on Button Click in to PDF, Excel, Word, HTML, Rtf in ASP.NET C#.[^]How to Export Crystal Reports Without Using the Report Viewer[^]

Passing Paramter into Crystal Reports "Enter the Parameter Value" Dialog box

18 Oct 2012 by Adersh Ram

Hi,You can pass the parameter like report.setparameter("paramname",value);Thanks,Adersh Ram

Passing parameters between classes

28 Jul 2011 by adnama

i have this codepublic partial class ScenarioEditorView : UserControl, IScreenSelectorSubItem, IActionable, INotifyPropertyChanged { ScenarioEditorViewModel viewModel = new ScenarioEditorViewModel(p1);the initialization is out of the method because it is used in...

Is it possible to add a clause to a Stored Procedure when calling it

19 Aug 2013 by Akbar Ali Hussain

Prepare an SQL as follows to call SP and return the result as XML. Then call this SQL from C#.e.g.select * from SPName() for xml auto

stored-procedure

null value parameter in stored procedure

24 Oct 2011 by Al Moje

Hi,Try this if could help...IF @parm is NULL BEGIN and columnname in (select idfield from otherTable) else and columnname = @parm END Regards,Al Moje

stored-procedure

hyperlink button click event code which is placed in datalist

8 Feb 2011 by Albin Abel

It is not clear why can't the record id also append in the query string as each record display a hyperlink.It may not be safe to pass the user id in the url string. Refer this article for further information how to securely pass the query string parameters.Preventive Method for URL...

Using Passing Parameters -arguments- to OnSuccess Callback function in a Asp.Net Ajax

5 Aug 2010 by Alejandro Barrada

How to pass custom args to the OnSuccess callback function of javascript ajax

Passing an event as a parameter

11 Jan 2016 by Alejandro Escribano Pindao

You can use reflection. Imports System.ReflectionPublic Class Form1 Private Sub Form1_Load(sender As Object, e As EventArgs) Handles Me.Load Me.setHandler("Click", CType(AddressOf test, EventHandler), Me.Button1) Me.setHandler("Click", CType(AddressOf test,...

Dynamic Controls Event Handling

8 Jan 2015 by Ali Albasri

Greetings to you allI have this table in asp.net and i`m creating dynamic rows for certain data of specific user, and I`m creating dynamic buttons for each row.I want to store each ID the of each row of the data in the button ID property of the button (because there is no tag property)...

Why I can't use Enum Parameter in This Function

13 Mar 2015 by amagitech

public static void LoadHemCombo(ComboBox cbo,Enum myEnum) { cbo.DataSource = Enum.GetValues(typeof(myEnum)) .Cast() .Select(value => new { ...

how to pass C# form textbox value to textbox in Reportviewer

3 Sep 2012 by AmitGajjar

Hi,First your method of generating Invoice number is incorrect. You should not use logic for generating Invoice number in C#. Instead i suggest you to use AutoIncrement Number in database to generate your invoice Number. Or if you have complex InvoiceNumber then you can create one SQL...

Selective parameters for functions

28 May 2012 by Andreas Gieriet

How about employing null and the ??-operator? E.g.// take one or the other argument.// If a is null, take b; if both are null, take "...".public void Func(string a = null, string b = null){ string c = a ?? b ?? "..."; // do something with c...}CheersAndi

table' argument cannot be null. Parameter name: table

26 Jul 2010 by Andrew Rissing

The new instance of the datatable set into "tbldt" is being reset by the line:tbldt = (DataTable)xmlDatadocTimeTable.DataSet.Tables["TIMETABLES"];I would check to make sure your file "TimeTable_Full.xml" indeed has the TIMETABLES table. Because it seems, it does not.

List all data in the table with paremeter

16 Jun 2013 by Anudeep Jaiswal - MCA

CREATE PROC ListStudents @Name varchar(20)=''ASBEGIN SELECT * FROM StudentDet WHERE Name = Case When @Name = '' then Name Else Name EndENDEXEC ListStudents 'Anudeep' -- Will Return Student Detail Name = AnudeepEXEC ListStudents '' -- Will Return All Student Detail...

Passing Paramter into Crystal Reports "Enter the Parameter Value" Dialog box

16 Oct 2012 by armarzook

I would like to have help regarding passing the parameter directly to the crystal reports in which it returns the value of current cell with all of its key references.The situation as of now is if i run the program and call the crystal report, A Dialog box appears asking "Enter Parameter...

Stored procedure in SQL

7 Oct 2014 by Arora_Ankit

Use thisIF EXISTS(SELECT id from Users WHERE bids>0 AND UserID=@userId)BEGIN UPDATE Auctions SET bidvalue += 1, lastbider = @UseId WHERE id = @AuctionId; UPDATE Users SET bids -= 1 WHERE id = @UseId;end

SQL-Server-2008R2

stored-procedure

Is it possible to transform a parameterized SQL query into LinQ to SQL?

28 Sep 2012 by AspDotNetDev

With LINQ to Entities, it'd look like this (the context variable would be an instance of your entity model):var cars = ( from car in context.vehicles where car.make == makeComboBox.SelectedItem && car.model == modelComboBox.SelectedItem && car.model_year ==...

ASP.NET C# Crystal Reports : Procedure or function 'sp_RptRouteWiseNetSaleDetails' expects parameter '@intFlag', which was not supplied.

31 Mar 2015 by axeemg

protected void Button1_Click(object sender, EventArgs e) { con.Open(); SqlCommand cmd = new SqlCommand("sp_RptRouteWiseNetSaleDetails", con); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt...

stored-procedure

Procedure or Function 'Nav_Bulletins_Insert' expects parameter '@Bulletin', which was not supplied

15 Oct 2011 by Bala Selvanayagam

This can happen, if you supply a NULL value for the parameter @Bulletin. Please check your parameter @Bulletin value.try somethingif (a == null) a = "";orAlter procedure [dbo].[Nav] (@Bulletin varchar(500)=null,@Url nvarchar(200),@IsActive...

datatable as sqlparameter

29 Feb 2012 by bcasillas

hi all!i just want to know if it's possible to pass a datatable as sqlparameter, becasuse I do not want to use a for-each to insert row by row in my databasebest regards!!improving my questioni had not a particular problem, i just want to know if it's possible to do something...

How do I pass a form to a sub to create a child form out of?

8 Jun 2017 by BeginnerCoderPete

I wanted a sub to create child forms but i am having issues Private Sub CreateChild(frm As Form) Dim frmChild As New frm frmChild.MdiParent = My.Forms.frmNavigation frmChild.Show() frmChild.Tag = My.Forms.frmNavigation.intTabCounter ...

Call same method using different datatype parameters without overloading

20 Mar 2014 by BillWoodruff

The easy way:private void TestHit(){ var intlist = new List {2, 3, 7}; var stringlist = new List {"A", "B", "C"}; Hit(intlist); Hit(stringlist);}private void Hit(List theList){ if (theList == null) throw new...

Prevent default "Enter Parameter Value" using C#

31 Oct 2015 by BillWoodruff

CodeProject is your friend; the sooner you learn to use the search facility here, the more productive you'll be :) See Thatraja's answer here: [^].And, since you know how to post a question on StackOverFlow, why not also easily find an answer there: [^].

Storing output in a parameter

11 Mar 2013 by Biodude Basava

I want to show current day. How do you store output value in a parameter '@getdate'? declare @getdate datetime set @getdate =day(getdate())Working in Microsoft SQL server 2008,Is this correct?Please help and thanks in advance.

SQL-Server-2008

passing a path to crystal report parameter for OLEobject from c#

7 Jul 2015 by bjay tiamsic

Hi. I'm trying to pass an image path to a parameter in Crystal Report where I used this parameter to fill in the picture object in the report.However when I tried to pass the image path to crystal report parameter using c#, I get this error: String reference not set to an instance of a...

File parser getting an error

22 Mar 2017 by bling

Here are three choices for you:Easiest fix is to get rid of the Conversion class and write specialized versions of getValueOfKey.Alternative 2: make Conversion a template class (instead of a class with template members).template class Conversion {Alternative 3: make...

My Crystal Report is not getting refreshed while passing parameter?

29 Dec 2011 by bluesathish

hi dinesh, You can refresh the report after each binding by adding the following code. crystalReportViewer.RefreshReport();Hope this will help you.Ref: http://msdn.microsoft.com/en-us/library/ms227086(v=vs.90).aspx[^]Regards,Bluesathish

Local Report Parameter Loading Problem

9 Jun 2011 by buraqenigma

i want to pass some paramaters to a localreport in my project but i get the "The source of the report definition has not been specified" error message. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim ds As New...

Fetch the values from the DB

5 May 2015 by chandra sekhar

I have to fetch list of values from DB and display them in a dropdown, how can i fetch without passing anything.what to use in place of sqlparams??public List GetTimeZones(){ using (SqlDataReader dr = SqlHelper.ExecuteReader(DatabaseConnection.Connection,CommandType.Text,...

Parameter other than string in main method

13 Apr 2016 by CHill60

You can have as many parameters to Main as you like, that is why it is defined as a string[] rather than string.Although all of the arguments are passed into Main as strings, they can be converted to other types. See the reference Command-Line Arguments (C# Programming Guide)[^]

How to execute a stored procedure with parameters?

20 Dec 2018 by CHill60

You have not declared @sql outside the body of the stored procedure. In the SP All you are doing is setting up a variable and doing nothing with it. Try moving the END to after the EXEC Edit: Another thought - that looks like a very poor database design. Firstly you appear to have your...

SQL-Server-2008R2

stored-procedure

Creating an invoice using crystal report parameteres in vb 2005

25 Dec 2010 by Chiranthaka Sampath

I have a program created using VB 2005 and MS Access 2003. In the program i have created a data grid which is connected using JET.4.0 OLEDB data provider. The data is been entered from text boxes to the data grid. I want to create a report using crystal report parameter passing which comes with...

Creating an invoice using crystal report parameteres in vb 2005 + Pastry shop

28 Dec 2010 by Chiranthaka Sampath

I have a program created using VB 2005 and MS Access 2003. In the program i have created a data grid which is connected using JET.4.0 OLEDB data provider. The data is been entered from text boxes to the data grid. I want to create a report using crystal report parameter passing which comes with...

Crystal Report Parameter passing

28 Jan 2011 by Chiranthaka Sampath

When creating crystal reports in VB 2005, passing parameters should I get one by one parameter for each field in the table which will be used for the creation of the crystal report? If so then how can I do that?

pass parameter from ms access to c#

8 Feb 2012 by Christian Graus

If by Access, you mean the Access presentation layer, not just the DB, then the answer is probably no. If you mean the actual DB, then the answer is still no, but it's easier to poll the DB for changes.

MVC: Use string variables of a view as parameter to a javascript function call

8 Jan 2013 by Christian Graus

You need to pass the values in through a model, then @Model.X and @Model.Y will work. Where do x and y come from ? If they are javascript variables, then remove the @, which tells the compiler to use Razor, when you want local values.

Custom DateTimePicker value not saved in application settings

23 Nov 2011 by contact97438

Hello everyone,I want to save a Custom DateTimePicker.Value in my Application Settings. The custom format is : dd/MM/yyyy hh:mm:ss, instead of dd/MM/yyyy The field i've created in the application settings parameters is LASTSAVE (DATE / APPLICATION)When I try to link in the...

Is it possible to Save a ChecklistBox in the application settings ?

24 Nov 2011 by contact97438

Is it possible to save a CHECKLISTBOX (not only a Checkbox) in the application settings ?I want to retreive my checkboxes checked in my CheckListBox when i load my form ?

Into the Extreme – Fold-Expressions

22 May 2023 by Coral Kashri

Fold-expressions in extreme cases

VB.net SQLparameter Listbox

20 Apr 2011 by Costica U

You can use parameterized query like this. Note that parameter are added before for loop and have the value updated in the loop.objConnection.Open() .CommandText = "INSERT INTO Tracks " & _ "(TrackTitle, TrackSeqNum) " & _ ...

How to pass more than one parameter in ssrs reporting at asp.net application side

29 Jan 2014 by dastaan

hello,friends I have SSRS report with many parameter. that is good at BIDS but now i want to run on asp.net C# in Report viewer , So how can i run it with more than one parameter, Help meThanksDastaan 1186..

c# Send operators inside method paramers

18 Jan 2016 by Dave Kreskowiak

Not the way you're sample is thinking, no.You'd be better off just creating a second method with the appropriate operators in place.Other methods are possible but they introduce performance hits on top of the bad code you're already writing.Get/SetPixel are VERY slow to execute once...

C# how to pass different number of command line arguments to a console app

22 Aug 2018 by Dave Kreskowiak

Your code doesn't make any sense. If the user doesn't pass in any args, it starts a Windows Forms app. If the user does pass in arguments, you add every argument to what appears to be a List (I have no idea because you never show the definition of mainObject!), assign the first two arguments to...

Selective parameters for functions

28 May 2012 by DaveAuld

You could probably implement something along the lines of this;private void doSomething(String db1, String db2){ if (!(String.IsNullOrEmpty(db1))) { //Do this } else { if (!(String.IsNullOrEmpty(db2))) { //Do this ...

IS "out" type data passed as parameter equal to return type?

16 Feb 2018 by david salaman

recently read about Out/ref keywords and i need to know how does the below method(FetchDeviceInfo) return serial number of a device, although the variable "returnValue" is string.Empty. and inside GetSerialNumber(machineNumber, out returnValue) method body there`s nothing? public string...

Prevent default "Enter Parameter Value" using C#

31 Oct 2015 by Debojyoti Saha

To set parameter on crystal I always do it this way:ReportDocument reportDocument = new ReportDocument();reportDocument.Load(reportPath);reportDocument.SetParameterValue("@id", YourParameterValue);if you want to convert your report to a pdf:var exportOptions =...

Input function is running extra times in settimeout (an extra time by setting the variable).

22 Sep 2023 by DesperatelyBadCoder

Hi, I am trying to solve the problem below. Write a function called solution that takes in 2 parameters, a number and a function. solution should execute the input function (which returns a number) after first input parameter milliseconds. The...

API: Don’t Forget about the Non-Public API!

14 Aug 2013 by Dev Leader

Don't forget about the non-public API

How to add a function to an ATL DLL with function pointer as parameter

18 Apr 2013 by dev_at_ccv

Hello,I tried to add a function with a function pointer as parameter to my ATL C++ project.Unfortunately, VS2008 doesn't provide function pointer as parameter type! :-(In my non-ATL DLL library, I declared my function as following:void SetCashierDisplayEventHandler(void...

Error on storing strings using parameters into oledb in VB.NET

30 May 2016 by Devil7DK

I have an patient report database, some of their values have database query constants like ' or " so i tried to insert these values using parameters. input was in English but when trying to retrieve the stored value it was returning a value of some kind of binary. the link for pictures and...

Procedure or Function 'Nav_Bulletins_Insert' expects parameter '@Bulletin', which was not supplied

15 Oct 2011 by devildx2050

set @PostedDate = getdate()here set @PostedDate =(select getdate())

C# how to pass different number of command line arguments to a console app

22 Aug 2018 by Dinesh Kumar Dora

Hello friends, I am wondering if we can pass different count of commandline arguments to a console application. for example: test.exe test.exe arg1 test.exe arg1 arg2 test.exe arg1 arg2 arg3 all the above 4 cmdprompt invocations must work. Is it possible? i tried the params option as shown...

My Crystal Report is not getting refreshed while passing parameter?

31 Aug 2018 by Dineshkumar Ramakrishnan

0 down vote favoriteshare [fb] share [tw] I have created my crystal report using command (sql query) in crytal report itself, by passing two parameters, i.e, say for eg:- Month & Year, While i preview the report, i can able to navigate through all pages by passing different parameters...

My Crystal Report is not getting refreshed while passing parameter?

29 Dec 2011 by Dineshkumar Ramakrishnan

Hi Sathish, For more info, I have created my crystal report by using the command in Database expert of crystal report and created my parameters there. I'm not talking parameters from code behind, even it throws error.My code is,public partial class Reports_MyCrystalReport:...

Call same method using different datatype parameters without overloading

20 Mar 2014 by Divakar Raj M

I want to call a method on two separate occasions. The two occasions pass two different types parameters, they differ by datatype. How do i achieve this without overloading.This is my codeusing System;using System.Collections.Generic;using System.Linq;using...

Call same method using different datatype parameters without overloading

20 Mar 2014 by Divakar Raj M

Solved it..using System;using System.Collections.Generic;using System.Linq;using System.Text;namespace DifferentDatatypeOfMethods{ class Program { static void Main(string[] args) { List intlist = new List(); ...

How to execute a stored procedure with parameters?

20 Dec 2018 by DrgIonuţ

I have a database with 40 tables. I want to select data from a certain table by using a single stored procedure. First table (TblSPAU1) has 6 columns, named: ID, COL_SPAU1_EA, COL_SPAU1_EQ, COL_SPAU1_ore, COL_SPAU1_nivel, DateTime. Fourth table (TblSPAU4), for example, has this 6 columns: ID,...

SQL-Server-2008R2

stored-procedure

Passing an event as a parameter

8 Nov 2010 by E.F. Nijboer

There is no use for this code:Private Sub setHandler(evt As Event, hndler As eventhandler)RemoveHandler evt, hndlerAddHandler evt, hndlerEnd SubYou remove and then add the same handler. It's useless to do this. It's somewhat the same as this code:temp = aa = 100a =...

Conversion failed when converting the varchar value '' to data type int

1 Oct 2013 by Eon Malherbe

You are atempting dynamic SQL and SQL is trying to cast the @Data parameter to an integer value. Rather try something like this:query = string.Format("update tablename set Confirmed=0 where data in ({0}) and id=@Id", Convert.ToString(_data)); sqlParameters = new...

C# can my method take a parameter that orders/sorts my list?

29 Nov 2021 by evedvvv

I have a program that currently distributes chocolates to x people in a list, and I have a general method that handles the sorting and several methods that orders the list by age, first name etc. depending on how you'd like to distribute the...

Pass comma separate string from view to another controller

24 Mar 2017 by F-ES Sitecore

str='1,2,3,4,5';window.locat...

Passing multiple values through form into SQL in keyword

25 Oct 2016 by Faran Saleem

Hello guys,I have a form with 3 fields. 1 is card number which is dynamic that is user can add more card numbers when they click on add more button. And the other 2 fields are start date and end date. What i want is when the user clicks submit button after filling up all details the values...

stored-procedure

File parser getting an error

22 Mar 2017 by FarhanShariff

I am try in to create a parser with to read configuration fileserror explicit specialisation in non namespace 'class Conversion'What I have tried:#include #include #include #include //holding the pair of parameter-value#include...

Creating an invoice using crystal report parameteres in vb 2005

22 Dec 2010 by fjdiewornncalwe

Try reading some of these articles.

How to call a procedure in this code? Iam frustated with code .plz help.

29 May 2016 by George Jonsson

Not sure which code block you want to keep, so I used the uncommented code.1. You should always use the using statement, as it will close the connection automatically or use try-catch-finally2. You forgot to assign the CommandText property3. You have an integer type in your parameter...

Ref vs out which one is better to use

17 Feb 2018 by George Swan

I would say that neither of your options are the best. I would use a Tuple. Something like this: static Tuple Remainder(int dividend, int divisor) { int quotient = dividend / divisor; int remainder = dividend % divisor; return...

Unable to pass the parameters from .NET application to SSRS report deployed on report server

26 Jun 2018 by Gerry Schmitz

Use a "parameter table". Insert parameters to table via "report request"; run report; report retrieves parameters from table and "joins" with reporting data to create parameterized report.

Must declare the scalar variable

3 Oct 2012 by ggoutam7

Hello,I am trying to fix this bug. Please help.I am getting below error and no data inserted :"Must declare the scalar variable "@bytImage"." Public Sub InsertFile() Dim sMainFolder As String = "D:\Project" Dim conAccess As Data.OleDb.OleDbConnection ...

SQL-Server-2008

how to pass C# form textbox value to textbox in Reportviewer

3 Sep 2012 by GoggatjieLiesl

Im using VS 2010. I have a form with a textbox and reportviewer on it.In my form textbox client inserts a value name Invoicenumber then when user press button the reportviewer must generate and in reportviewer textbox i want invoice number to display.I created a parameter for...

Problem Passing more then one parameter in C# reportviewer

22 Sep 2012 by GoggatjieLiesl

Hi,I am using C# ReportviewerI have a problem passing more than one parameter from my form textbox to report textbox.When i only passed one meter like this it worked perfectly this.reportViewer1.LocalReport.ReportPath = "Report2.rdlc"; ReportParameter rp = new...

Storing output in a parameter

11 Mar 2013 by gvprabu

Hi Friend,Read the following links...you will get some Idea about Data types and variables.Data Types (Transact-SQL)[^]SQL SERVER 2008 – 2012 – Declare and Assign Variable in Single Statement[^]Table-Value Parameters in SQL Server 2008 - VB.NET[^]Global Variables in SQL...

SQL-Server-2008

How to pass parameter to SSRS report in asp.net

3 Feb 2015 by Hamza Javed

Hi,i,m new in SSRS and for practice i,m passing parameter to report which accepts parameter but got exception "An exception of type 'Microsoft.Reporting.WebForms.ReportServerException' occurred in Microsoft.ReportViewer.WebForms.dll but was not handled in user codeAdditional...

Internal 500 error while http authenfication httpwebrequest C#

29 Jun 2016 by hapiten

I tried to sign in using httpwebrequest C# but I have faced internal 500 error..Here is the raw data that I copied with fiddlerPlease give me adviceThank you Source is private string login_autocafe() { string hidden_value = Get_hidden_value(); ...

Fetch the values from the DB

6 May 2015 by Harikrishna G

I guess you are looking for this,hope it will help youpublic DataTable GetAllEmployees() { DataTable dt = new DataTable(); SqlConnection con = new SqlConnection(conString); try { SqlCommand cmd = new...

null value parameter in stored procedure

23 Oct 2011 by Herman<T>.Instance

Hello everyone,I have a question about a query in a stored procedure.When the used parmeter @parm is null in my where clause the syntax should beand columnname in (select idfield from otherTable)if the @parm is filled with a value the syntax should be:and columnname = @parmHow to...

stored-procedure

null value parameter in stored procedure

24 Oct 2011 by Herman<T>.Instance

Admitting: this was a headache for 3 people but it works...AND (@parm is null OR @parm = CASE WHEN Isnull(@parm,0) = 0 THEN CASE when columnName in (select id from table) then columnName ELSE @parm END ELSE ColumnName END)

stored-procedure

datatable as sqlparameter

29 Feb 2012 by Herman<T>.Instance

The SqlParamater.SqlDBType cannot be set to a DataTable object.See here[^]. You have to do rowbased updates.

Detect function parameters in java

10 Apr 2014 by HuggableAlien

Hello everyone!I am trying to make a compiler for a custom file format my editor uses, and I want it to be able to handle custom classes automatically. I already know how to find a class by name, but I want to know if it's possible to detect what parameters the classes constructor takes in, if...

Is it possible to override the error with inheriting generic parameters?

21 Dec 2013 by IAmABadCoder

I've seen multiple questions like this but is it possible to find an external override to this error? By the way the error is:Cannot derive from 'T' because it is a type parameterHere is a basic example of the requested functionality:public class Mimic : T //Error{}I was...

Is it possible to add a clause to a Stored Procedure when calling it

19 Aug 2013 by iCanDivideByZero

Is it possible to add a clause to a Stored Procedure when calling it from your code; C#? I have Stored Procedure for which I need to add the clause "FOR XML AUTO" or "FOR XML RAW", but I do not have write access to change since its our clients stored procedure. I know the easiest would be to...

stored-procedure

How to create Regional Web ACL (WAFv2) with PowerShell

24 Sep 2022 by Illya Reznykov

The post describes PowerShell script which creates WAF resources for the scenario when Application Load Balancer is used to serve content for a public website, but to block requests from attackers and to protect from OWASP Top 10 security risks.

[C++] passing custom type (structure) to a function

17 Jul 2017 by Jochen Arndt

When using the struct keyword in your function declaration you have a so called "forward declaration": // Forward declaration // Definition must be present later in this scope struct Student; // Can now use the forward declaration within other declarations void passStructAsParam(Student s); ...

Is it possible to transform a parameterized SQL query into LinQ to SQL?

28 Sep 2012 by joshrduncan2012

Hi everyone,Is it possible to transform a query with parameters into LinQ to SQL (keeping the parameters in tact)?This is what I have so far in plain SQL.SqlCeCommand trans_comm = new SqlCeCommand("SELECT DISTINCT transmission_type FROM vehicles WHERE make = @make AND model_name =...

kinect smoothing mouse movement

23 Aug 2012 by Karl Sanford

You could use the skeletal smoothing, and that should help a bit. The best way I've found is with a moving average of your desired target (in your case, the mouse location). So instead of simply moving the cursor every time you have a movement in your fingertip point, use a queue to store the...

C++ callback stuff using static methods declared in header

17 Jun 2017 by KarstenK

Using this technique in C++ is named callbacks. Here you find a tutorial about callbacks. As an experienced programmer like interfaces more, because type checking from the compiler, debugging adavantages and cleaner concepts like modularity and maintenance. Here you find some tutorial about...

How do I can create conastant parameter in C++'s function?

10 Oct 2020 by KarstenK

best is to writeint Algorithm(int n, int start) to avoid confusion.

Internal 500 error while http authenfication httpwebrequest C#

29 Jun 2016 by KARTHICKEYANRAJU

Are you sure webservice server is up and running? In my case, there was a problem with server and I was getting the same 500 error.To see more error details, In IE, Tools -> Internet Options -> Advanced -> Browsing -> Uncheck "show friendly HTTP error messages". Now hit the URL directly in...

using LINQ to Sql to populate gridview using storeprocedure with parameters

9 Apr 2013 by Karthik Harve

Hi,try by modifying the LINQ query like below.var report = (from r in db.sp_getReportDateWise(Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtToDate.Text)) select r).CopyToDataTable();also, make sure the procedure is giving result set and the gridview is having bound fields...

how to pass C# form textbox value to textbox in Reportviewer

3 Sep 2012 by Kashinath Patil

http://go4answ...

What type can't C# Generic class parameter be?

15 May 2014 by kDiana

I know that C# generic class CAN'T take as a parameter 1. static class public static class StaticClass{...}...GenericClass obj= new GenericClass();...2. pointer( in unsafe mode )...GenericClass obj = new...

What type can't C# Generic class parameter be?

1 Feb 2015 by kDiana

Finally, I found it!!!It is dynamic class. Dynamic class can't be parameter of Generic class. When talking about dynamic class, I mean this => /* Load in the assembly. */ moduleAssembly = Assembly.LoadFile(fileName); /* Get the types of classes that are in this assembly....