All Questions
Tagged with sql-server-2005 asp.net
689
questions
0
votes
1
answer
1k
views
How to solve Object reference not set to an instance of an object for input field in asp.net? [duplicate]
I want to store date to database.I am clicking the textbox it show an calender after date choose it stored into textbox nut not stored in Sql Database. It shows an error
Object reference not set ...
0
votes
1
answer
49
views
Pivot SQL Server 2005
My tables:
Introducermaster
ProjectAllocation
CompanyStructure
Query:
SELECT
Sno,
TopEmpName,
TopEmpID,
HighLevel,
CH, ED, DIR, GM, AGM, BDM, SMM,
LowEmpID
FROM
(SELECT
...
0
votes
0
answers
1k
views
How to retrieve Image from database to gridview in asp.net?
I just want to store and retrive image from database to gridview . After the image is store i want to display the stored image in a grid view. How to do?
retrieve Image from database to gridview in ...
1
vote
6
answers
17k
views
how to solve Conversion failed when converting date and/or time from character string?
Conversion failed when converting date and/or time from character
string
I am new in Asp.net. i want to upload image and save records in Sql Database it caught "Conversion failed when converting ...
0
votes
3
answers
1k
views
How to solve SqlException: Must declare the scalar variable "@RegNo" in ASP.Net [duplicate]
SqlCommand cmd = new SqlCommand("insert into Student(@RegNo,@Name,@Address,@CreatedTime) values(@RegNo,@Name,@Address,Getdate())");
here it display an error like SqlException:
Must declare the ...
0
votes
4
answers
143
views
InvalidOperationException: Connection property has not been initialized in update command?
protected void btnUpdate_Click(object sender, EventArgs e)
{
string constr = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
SqlConnection con = new ...
0
votes
0
answers
320
views
How to get the returnvalue from stored procedure which uses GetStoredProcCommand with an object array of parameters
I have an SP below which returns either 1 or 2. This is good.
IF EXISTS(select 1 from Emp where empId = @empId)
return 1
ELSE
return 2
In the test code, I can do like below and get the ...
0
votes
2
answers
825
views
Sql connection string for another pc
I have an application that runs on SQL 2005 database
I m trying to use same application on another machine same network,
I managed to log in on SQL 2005 using IP
Now I need to configure applications ...
0
votes
0
answers
55
views
Odata will not filter on datetime with SQL 2005 database
I have an ASP.NET application with a WCF service giving users access to a table on a SQL 2005 database.
Users are able to filter using int and Boolean fields etc. however, they are unable to filter ...
2
votes
1
answer
68
views
SSRS 2005 with ASP.NET Report Viewer
Hi unfortunately we only have SQL Server 2005 so I am stuck with SSRS 2005. I have created a report and runs as expected.
I have an issue though. When I combine it with the Microsoft Report Viewer it'...
0
votes
1
answer
42
views
Show projects on the basis of login user
I have a query which brings Project Name and mkey. The query is below
select
distinct
comp.company_name as 'Company',EMP.emp_name as 'Employee',
EMP.emp_card_no as 'Card_No',
EMP....
2
votes
1
answer
41
views
Add Values to dropdownlist on the basis of SQL Query
I have a dropdownlist whose values are binded by a query which is
select emp_card_no,
emp_name + '-'
+ cast(emp_card_no as varchar)
+ '('
+ ...
0
votes
1
answer
44
views
Stored Procedure Update
I want to insert those values also which have version null and and for version null I don't have status.
I am getting all data from datatable to procedure table type and then how do I check that the ...
2
votes
2
answers
1k
views
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value error
I am adding a date as "09/10/2014" into the textbox and clicking the submit button but getting error as:-
The conversion of a char data type to a datetime data type resulted in an out-of-range ...
-1
votes
2
answers
44
views
Invalid column name Menu_mkey
While debugging through the code, I am getting error as
Invalid column name Menu_mkey
Here is the code for that
string strsqlflag = "select count(*) from WMS_User_Rights where User_Id='" + ...