hello to all

i am using sql helper class. while executing the sql insert statement i am writing the syntax as

SqlHelper.ExecuteNonQuery(ConfigurationSettings.Ap pSettings["ConnectionString"], CommandType.Text, sqlInsert);

my this query goes to sql helper class there i found i am not getting the value of connection string which is in web.config file.

please guide me what i am writing wrong as i am not passing the connection string.

my query is right as well as i am not getting the ConfigurationManager.Appsetting in my intellisense.



regards,

Munish Bhatia



thanks......

__________________
thanks......

import the namespace as
using System.Configuration;

Regarding not getting web.config value, please check for exact name in the web.config file...



Regards
Mike

Fortune favours the brave, so don't regret on missed oppurtunities.

hello mike thanks to suggest. i found my problem as i was using wrong syntax.i am to use:
ConfigurationManager.Connectionstring..........

thanks


thanks......

I have a good example for ConfigurationManager.Connectionstring..........

it's correct and you can read for experience.


<WebMethod()> _
    Public Function getPrice(ByVal productid As Integer) As DataSet

        Dim conn As New Data.SqlClient.SqlConnection(ConfigurationManager. ConnectionStrings("AdventureWorksConnectionString" ).ConnectionString.ToString())
        Dim myDataAdapter As SqlDataAdapter
        Dim myDataSet As DataSet
        Dim cmdString As String = "Select ListPrice From Production.Product where Production.Product.ProductID =" & productid



        myDataAdapter = New SqlDataAdapter(cmdString, conn)

        myDataSet = New DataSet()
        myDataAdapter.Fill(myDataSet, "Price")


        'price = datareader

        'conn = New SqlConnection("Server=localhost; uid=sa; pdw= ; database=AdventureWorks ")


        'Page(1029)


        Return myDataSet
    End Function


I am a database programmer and .Net programmer

Thanks for a example.

thanks......