is it wrong?

[pandapatin]

when i was trying to connect to the database there is an error occured. the erro r is: The ConnectionString property has not been initialized. i check it with the local window below it,the connection to database is null. what can i do?

[Ingo]

Generate a new Connection and set the ConnectionString property to a usable value. If you search in the Microsoft Help for the Database Connection Class you will find an example. So it's definitively wrong I guess. Greetings, Ingo ------------------------------ A bug in a Microsoft Product? No! It's not a bug it's an undocumented feature!

[albCode]

You should initialize connectionstring

[pandapatin]

how could i do that?

[albCode]

if u are using WebApplication example is below Dim SqlConnection conn As New SqlConnection; conn = System.Configuration.ConfigurationManager.ConnectionStrings["DBConn"].ConnectionString; If (Not Page.IsPostBack) Then 'Do Some Codeing Here EndIf

[pandapatin]

the error is : Value of type 'System.Configuration.ConnectionStringSettingsCollection' cannot be converted to 'System.Data.SqlClient.SqlConnection'. so?

[albCode]

Dude i am not vb programmer but maybe i can help by this Imports System.Configuration .. Dim ConnectionStringSettingsCollection c As New ConnectionStringSettingsCollection Dim cc,command As String cc=c[""urconn"].ConnectionString; command="select * from Customers" Dim SqlConnection scon As SqlConnection() scon(cc) Dim SqlCommand cmd As SqlCommand() cmd(scommand,scon) ...

[Steve Pullan]

You have posted similar questions before. It seems to me that you really are struggling with this topic despite the help provided by others. May I respectfully suggest that you go back to basics and read up on how to interact with these objects within VB? ...Steve "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." (Translation: I'll show you the way, but not write the code for you.) I read that somewhere once :-) -- modified at 18:58 Thursday 2nd March, 2006