|
sorry iam new to this kind of forums.here after i will keep discussion in the same thread.
i tried as u said and given the code also but still the same kind of error is coming----The ConnectionString property has not been initialized
ERROR IS The ConnectionString property has not been initialized IN CON1.OPEN().Plz help in solving these problem, iam a fresher.Thanks in advance
public partial class detail : System.Web.UI.Page
{
//string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\DataFinal.mdb;User Id=admin;Password=;";
String con1 = "Provider=Microsoft.JET.OLEDB.4.0;data source=path\\db1.mdb";
String con2 = "Provider=Microsoft.JET.OLEDB.4.0;data source=path\\db2.mdb";
protected void Page_Load(object sender, EventArgs e)
{
}
private void InitializeComponent()
{
}
protected void Button1_Click(object sender, EventArgs e)
{
OleDbConnection con1 = new OleDbConnection();
con1.Open();
DataTable tables1 = con1.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
foreach (DataRow row in tables1.Rows)
DropDownList1.Items.Add(row[1].ToString());
OleDbConnection con2 = new OleDbConnection();
con2.Open();
DataTable tables2 = con2.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
foreach (DataRow row in tables2.Rows)
DropDownList2.Items.Add(row[1].ToString());
}
-- modified at 2:20 Friday 24th August, 2007
|
|
|
|
|
I would have attempted to answer this AGAIN had you not been rude enough to delete your original message below.
In future please keep discussion on the same topic to the same thread.
|
|
|
|
|
I have already answered the same question several messages below. I guess you are the same person and you have deleted the message? Don't double post
|
|
|
|
|
you must pass the strConn in the oledbconnection() constructor..
or set the
con1.connectionstring = strconn
|
|
|
|
|
His previous nice was 'shemvignesh'. Now it is 'svignesh'. Looks like Numerology/Nameology suggestion and hence he is trying to debug that issue first and thne debug this ConnectionString issue. 
|
|
|
|
|
Hi
can anyone please help me of how to craete a class that will connect dotnetCharting with database.
or namespace that i can use to access dataengine
thanx
Mamphekgo
|
|
|
|
|
System.Data
ADO.NET is the thing to google if you don't know how to connect to a database. There's also tons of articles here and elsewhere
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
i using crystal report in my project. i want to add page wise total for a column(stock) please give me a idea.....
|
|
|
|
|
You should be able to have a running sum in the header or footer of the report.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi all,
In my project i am retriving some values from database. For eg: id,brand,status,comments.
After retriving this i am storing the values in the dataset. My doubt is, i want to get the count of records with the same brand, and also i want to bind the those records into datagridview which come under an specified category form the dataset.
For eg:
id brand status comments
1 aaa 1 test
2 bbb 1 test
3 aaa 1 test
4 ccc 1 test
5 bbb 1 test
6 aaa 1 test
7 aaa 1 test
In the above i want to dispaly only the record with brand "aaa" in datagridview, and want to display the count of "bbb","ccc" in a label control.
Plz any one help.
Thanks in advance
Know is Drop, Unknown is Ocean
|
|
|
|
|
You should change your SQL statement..
SELECT brand, COUNT(status), comments FROM Table1 GROUP BY brand,comments
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. 
|
|
|
|
|
hi Michael,
thank you very much for your suggestion., But i need it to be done using datatable, dataview. So plz suggest me an option to like so.
Thank you very much
Know is Drop, Unknown is Ocean
|
|
|
|
|
How did you bind the data to DataView?
In SQL statment, you have to change the statment like above....
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.
|
|
|
|
|
Dear sir,
how i create a DB Connection module which will read Data Source (IP ) from .txt File. I only write IP in the .txt file and call that method from form load.
i done it in VB but i can't in C#.
plz help me
Shafik
|
|
|
|
|
hi,
imagine that i have five arraylists(ShapeTypeList,ColorList,CoordList,SizeList,PathList). All contains different types such as enum,Color,Point[] and etc. This arraylist is used in the form to store information on the Shapes to be drawn onto the form. Then, there is a Save function which is used to store all the informations in the arraylist using xml. I've create a AllData class inorder to serialize the class to an xml file. Can anybody give me some guides or tips on how to use xmlserializer to save the arraylist into xml file? the format i'm looking for is as below:
<RootClass>
<Arraylist1>
<ArrayItem1a>....</ArrayItem1a>
</ArrayList1>
<ArrayList2>
<ArrayItem2a>....</ArrayItem2a>
<ArrayItem2b>....</ArrayItem2b>
.......
........
........
</ArrayList5>
However other format also acceptable as long as i can deserialize it later.
Thanks in advance.
-- modified at 3:59 Wednesday 22nd August, 2007
|
|
|
|
|
|
|
You can either pass connection string as a parameter to the constructor or set the ConnectionString property of OleDbConnection.
For example:
<br />
string connstring="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\bin\LocalAccess40.mdb"<br />
OleDbConnection con1 = new OleDbConnection(connstring);<br />
OR:
<br />
string connstring="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\bin\LocalAccess40.mdb"<br />
OleDbConnection con1 = new OleDbConnection();<br />
con1.ConnectionString=connstring;<br />
If you have problem in constructing the connection string itself then this website will help you:
Connection Strings[^]
|
|
|
|
|
shemvignesh wrote: OleDbConnection con1 = new OleDbConnection();
con1.Open();
you're missing a line in there which tells the OleDbConnection how and where to connect to a database.
the line will look like:
con1.ConnectionString = "Your connection string here....";
See www.connectionstrings.com[^] for info on what to write in there.
|
|
|
|
|
I am trying to use the DbConnection and i used the following code.
public DbConnection mConnection = null;
mConnection.ConnectionString =value; //value has the connection string
but at the runtime its giving me
"Object reference not set to an instance of an object." Exception.
Can any body pls tell me how to use DbConnection.
Thanks.
|
|
|
|
|
The problem is that your object mConnection has not been instantiated. You need to instantiate a class to be able to use it. Instantiating means creating an instance, exactly what the exception message is telling you You do this by calling the constructor of the class.
public Dbconnection mConnection = new DbConnection();
mConnection.ConnectionString = value;
Voila
Talal
-- If this is a post that has been helpful to you, please vote for it. Thank you!
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
--Rich Cook
|
|
|
|
|
Talal Sultan wrote: public Dbconnection mConnection = new DbConnection();
mConnection.ConnectionString = value; // this should work now as the class exists.
Except it won't work becuase DbConnection[^] is an abstract class and cannot be instantiated. You need to use a concrete class derived from DbConnection (e.g. SqlConnection)
-- Always write code as if the maintenance programmer were an axe murderer who knows where you live.
Upcoming FREE developer events:
* Glasgow: Agile in the Enterprise Vs. ISVs, Mock Objects, SQL Server CLR Integration, Reporting Services, db4o ...
* Reading: SQL Bits
My website
|
|
|
|
|
oops, right about that. Sorry. I knew something was wrong with that class, I just didn't take the time to investigate more. Sorry about that. My mistake.
-- If this is a post that has been helpful to you, please vote for it. Thank you!
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
--Rich Cook
|
|
|
|
|
I was thinking he was messing out on something on a DAL factory front and not properly using the IDBConnection.
|
|
|
|
|
Hi
It seems like you are working with the wrong DB Connection class.
In order to connect SqlServer Database use the SqlConnection under the System.Data.SqlClient namespace otherwise you can use the OleDbConnection under the System.Data.OleDb namespace
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
