You searched for the word(s): userid:760347

More Search Options

RSS Available

• 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