Yes, SQL Server is installed on that machine. Even if i run that setup on my own pc(which has sqlserver), it is giving this error :-(

I created setup(as instructed in that link) just included 1 application of my proj(from >bin>debug)and my 2 sqlserver (database files) in the application setup(as instructed in that given link). (In that link they used access,i have used sqlserver.) It is build successfully, but M getting this error after running the created setup (application): System.InvalidOperationException: The ConnectionString property has not been initialized. at System.Data.SqlClient.SqlConnection.PermissionDemand() at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at WindowsApplication1.login.login1_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.PerformClick() at System.Windows.Forms.Form.ProcessDialogKey(Keys keyData) at System.Windows.Forms.Control.ProcessDialogKey(Keys keyData) at System.Windows.Forms.TextBoxBase.ProcessDialogKey(Keys keyData) at System.Windows.Forms.Control.PreProcessMessage(Message& msg) at System.Windows.Forms.Control.PreProcessControlMessageInternal(Control target, Message& msg) at System.Windows.Forms.Application.ThreadContext.PreTranslateMessage(MSG& msg) plz chk n tell thanks. wen r u coming?? tc cu soon.

-I have made an application in c#.net,window application. -Now to install it on other computers, i want to make its setup. -I have already made setup of the application using d below link : http://www.codersource.net/csharp_installer_projects.html[^] - I have made my database in sqlserver2000, -I have copied its 2 (database file and log file) from its actual path (C:\Program Files\Microsoft SQL Server\MSSQL\Data) and pasted it in my dotnet application folder. -While making setup of application i just included those 2 database files with the application(from >bin>debug) of project (as instructed in above link) Setup is build without errors, but when i run i get errors,they r related to sqlserver. -Do i need to make database setup separately?How? I would be grateful,if any help is offered. Thank you. Regards nekshan.

Thank you Sir, yes it is working now :-) Regards Nekshan.

thanx its working. www.meebo.com is not allowed :-( i'll try again. how r u? wen r u coming?? c u soon!! nekshan.

da.Fill(ds); what is 'da' in your code? no definition for it. nekshan.

i m making an application in c#.net2005, window application. How can i connect datagridview to database(sqlserver2000) at runtime? - not from design, only by coding. i have written this code, but no data is listed in grid : SqlConnection conn = new SqlConnection("Data Source=......"); private void Form1_Load(object sender, EventArgs e) { conn.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from tblsummary", conn); DataSet ds = new DataSet(); da.Fill(ds, "tblsummary"); //dataGridView1.Columns.Add(sitehit); dataGridView1.DataSource = ds; conn.Close(); } Does i miss something else for connection? Hope to get a reply.. thank you in adv. nekshan.

I m making a project in c#.net,a window application. I have a form on which i have kept a listbox, which show names of clients who are online at that particular time through a query. Now, how can i display a small smiley image(a .jpg image) before the clients name who is online(in the listbox)? Before each clients name in d listbox this smiley icon should appear (as in yahoo messenger)... How can i do this? Thank you in advance. Regards nekshan.

i m making a window application in dotnet c#. How can i make exe of my appliction? Thanking You. Regards Nekshan.

i am making a window application in dotnet c#. There is site, whose information i need to keep in database on local client machine. If someone visits that site, value '1' must be stored in 'sitehit' column of my database else it must contain '0'. i have field in my database : 'sitehit'. how is this possible? Thanking you in adv. regards nekshan.

i have field in my database : sitehit. If someone has visited my site, value '1' must be in 'sitehit' else it must contain '0'. how is this possible? Thanking you in adv. regards nekshan.

I am doing a project in .net c# 2.0 with sqlserver2005 i have a listbox in the form in which i need to display some data from database. i need to get the loginnames of those clients who have levelid= 2 and 3, and who r logged in. For levelid and logindatetime are stored in 2 different tables 'login' and 'dealerlogin' respectively. Now to get his data i queried (in sqlserveranalyzer): select loginname from login as a, dealerlogin as b where ((b.levelid = 2) or (b.levelid = 3)) AND ((a.logindatetime is not null) and (a.logoutdatetime is null)) But there is some error. There is some problem in joining the 2 diff. clauses of 2 diff. tables. How can i do this? Hope to get a reply. regards nekshan.

i have these data in table 'dealer': dealerid@@@campaignid@@@keyvalue @1@@@@@@@@3@@@@@@@6 @2@@@@@@@@4@@@@@@@3 @3@@@@@@@@2@@@@@@@5 @4@@@@@@@@1@@@@@@@4 @5@@@@@@@@1@@@@@@@2 @6@@@@@@@@2@@@@@@@1 @7@@@@@@@@3@@@@<@NULL@> = NULL is null value in database without the '@'sign between brackets '<','>' and 'NULL' '@' = spacebar,to separate the data. Now i want the dealerid where campaignid = 3 n keyvalue = NULL So, i queried in queryanalyzer of sqlserver2005: SELECT dealerid FROM dealer WHERE (keyvalue = NULL) AND (campaignid = 3) I must get output as 7. But i dont get any output in its output window, neither i am getting any error. Hope to get a reply. regards Nekshan. -- modified at 3:17 Wednesday 4th April, 2007

yes my problem is solved. datetime datatype stores data in mm/dd/yyyy format. now its working. thank you. :)

SELECT MIN(CONVERT(varchar, DateCreated, 111)) FROM tblsummary error in query analyzer: Invalid Columnname 'DateCreated'. 'accessdate' column in 'tblsummary'table has 'datetime' datatype. Did u understand my problem in last post? My query is not checking month. Does 'datetime' datatype takes data in database as 'mm/dd/yyyy'? I inserted data as 'dd/mm/yyyy'.

i have this in database: accessdate 5/2/2007 3/2/2007 2/3/2007 8/3/2007 2/4/2007 2/5/2007 5/5/2007 Now want to access minimum date from it : SELECT MIN(accessdate) FROM tblsummary i shud get : 5/2/2007(as minimum), But i m getting : 2/3/2007(as it is just comparing 2<5 ie date, but not month which is 2<3) Same is happening for max(accessdate) too. How can i rectify it,it wud b pleasure if some1 can help. Thank You in adv. Regards Nekshan.

Thank you joon_ :-)

No, '.columns[1]' is also not there after .rows[0] After tables[0].rows[0] is there and ------tables[0].columns[0] is there. how to use? if possible chk it wen u have time, i m leaving office now. Going home, if net is working send u the copy of documentatn. ok. cu soon. tc. thanx. regards nekshan.

str = dss.Tables[0].Rows[0].Item[1].ToString(); It is giving error at all ".Item[1]" s of the block : 'System.Data.DataRow' does not contain a definition for 'Item'

Dim ds As DataSet1 // this is in vb. how to declare this in c#? :-(