Home
Get Started
Learn
Downloads
AJAX
MVC
Community
Wiki
Forums
Sign in
|
Join
Home
›
ASP.NET Forums
›
Search
Search
You searched for the word(s): userid:760347
More Search Options
RSS Available
Matching Posts
Re: ConnectionString property has not been initialized
[quote user="mehmeterdgn"]I am absolutely sure that.[/quote] Well in that case, it must be available. Can you put a break point on the statement where the connection object is created and try to see if the connection string property is available/set for the object just after the object creation statement ? The error simply means that the connection object doesn't have the connection string which it must have to open the connection. So, you our goal is to verify whether it actually gets
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
dhimant
on 10/9/2009
Re: ConnectionString property has not been initialized
[quote user="mehmeterdgn"]I tried that your said but i am getting same error.[/quote] It should work for sure. This is the way to use the connection string since the introduction of the connectionstrings section. Are you sure you've written something like below ? SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["baglanti"].ConnectionString); Apart from all this, just a piece of advice here. While asking for help on public places like this, do not
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
dhimant
on 10/8/2009
Re: ConnectionString property has not been initialized
[quote user="mehmeterdgn"] <connectionStrings> <clear/> <add name="baglanti" connectionString="Persist Security Info=True;User ID=User_f6****;Password=******;Initial Catalog=DB_f6***;Data Source=sqlhosting02.myhosting.com" /> </connectionStrings>[/quote] [quote user="mehmeterdgn"]ConfigurationManager.AppSettings["baglanti"][/quote] You've set the connection string in the connection strings section and trying to utilize
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
dhimant
on 10/8/2009
Re: Check The Condition From Server Date?
[quote user="ankurtandon"]I am wanting a condition to be checked. i.e. a entry in a textbox for a date to be not less than the server date. The server date is the date of the system where database is setup. How can i get the server date? [/quote] There are a few options avialable to get the current date of the SQL Server, "getdate()" is perhaps widely used. "select getdate()" will return you the current date time value of your SQL Server.
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
dhimant
on 4/21/2009
Re: How to count number of occurence of a data in a column.
select Catg , count ( catg ) from <your table> group by Catg
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
dhimant
on 4/21/2009
Re: row exceeds the maximum
Can you post your table creation query ? You must have some really large columns and as a result of that SQL Server is throwing up this error.
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
dhimant
on 4/21/2009
Re: Connecting with Sql server
This is a common problem, and there are multiple solutions to it. I would suggest you should create a user in your SQL Server and use that to connect to the server and do the activities. That way you will never run into trouble no matter from where you are running your application.
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
dhimant
on 4/21/2009
Re: max() and null value
[quote user="Ganesh@Nilgris"]now if i use max() in sql i should get the value as "null" because i consider it as the maximum value.[/quote] Does this mean that if you have "null" in any of the rows then you are considering them to be the maximum values amongst all the rest of the rows ? If yes, why are you using such logic ?
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
dhimant
on 4/21/2009
Re: Access Webservice or DLL from SQL side.
[quote user="JK883"] Thanks Dhimant, I really like your idea! Do you think it would be possible to reverse step #1, so that SQL Stored procedure calls the Application, giving it the address? I'd like it to be initiated from the SQL side instead of the web side. [/quote] Well, the steps that I mentioned earlier are based on the simple thought that the application ( may be a web or windows application depending upon your needs ) is working as a bridge between your database and the external
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
dhimant
on 4/8/2009
Re: Access Webservice or DLL from SQL side.
You may imagine one small web application working in the middle of your database and the DLL. As Limno suggested you may utilize ADO.Net class library classes to interact with the database ( like calling an SP and updating the tables etc...). Below are the some steps using the application. The application calls a stored procedure ( using ADO.Net ) and gets the address ( to be sent to the DLL ). The application executes the DLL and supplies the address to it. The application collects the results from
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
dhimant
on 4/7/2009
Page 1 of 114 (1132 items) 1
2
3
4
5
Next >
...
Last »
Channel 9:
E2E: Brian Beckman and Erik Meijer - Co/Contravariance in Physics and Programming, 1 of 2
TechNet Edge:
Windows Server 2008 R2 Quick Look #3 - PowerShell V2
ASP.NET:
2009 Blogged - Greatest Hits
WindowsClient:
2009 Blogged - Greatest Hits
Channel 9:
Nikolaj Bjørner and Leonardo de Moura: The Z3 Constraint Solver
Channel 9:
MEF & Silverlight 4 Beta - Part 2, Imports & Exports
Channel 9:
MEF & Silverlight 4 Beta - Part 1, Introduction
WindowsClient:
The (Near) Final Word on Multi-Monitor Taskbars for Windows 7 - Ultramon vs. DisplayFusion
WindowsClient:
Looking back at 2009, and forward to 2010
Silverlight:
Polling Video – A Viable sub-second alternative?
TechNet Edge:
Windows Server 2008 R2 Quick Look #2 - Active Directory Recycle Bin
Channel 10:
I'm a Windows 7 PC Themes
Channel 10:
24 Years of Windows Box Art
WindowsClient:
Silverlight tutorial: HOW TO build CommandLink Control in Silverlight with Expression Blend 3 and Behaviors
ASP.NET:
Converting an RGB Color To Hex With JavaScript
Silverlight:
Silverlight HVP Design – Configuration & Scenarios
Channel 9:
Channel 9 Live at PDC09: Day 3 Welcome
Channel 9:
Channel 9 Live at PDC09: TWoC9 Day 3
Channel 10:
Microsoft's Mobicast: Stiched Cell Streams
Channel 10:
Festive Bing
Microsoft Communities
ASP.NET
Channel 8
Channel 9
Channel 10
IIS.NET
Silverlight
TechNet Edge
WindowsClient
Mix Online