|
System.IO.FileNotFoundException: Could not load file or assembly 'System.Data.SqlServerCe, Version=3.5.1.0
Above file is missing on other system.
Saidrex wrote: Do i need Sql server installed on other computers to launch my program?
Looks like, your application needs this dll on the system and thus installing it on the computer will resolve it
Saidrex wrote: Is it possible to make it somehow to launch without installing Sql server?
It should be possible. Design your application such that the dependency for the database is not directly on your system. You can try to access DB on other system or use a webservice designed to get data. Currently, it looks like your application is expecting database locally and trying to access it.
|
|
|
|
|
database file is in program folder, i moved my program to another computer with database file in it.
|
|
|
|
|
Saw you solved it. Good to know. 
|
|
|
|
|
Yeah, but anyway, i wanted to be able to launch my application anywhere without installing addition software. But for my fist application this will do. thx =)
|
|
|
|
|
Saidrex wrote: Do i need Sql server installed on other computers
No, you'll need to install Sql Ce.
Bastard Programmer from Hell 
|
|
|
|
|
I installed Microsoft SQL Server Compact 4.0 but i get same error everytime i launch my application.
|
|
|
|
|
Take a look at the version that your application is expecting - the exception mentioned 3.5 
Bastard Programmer from Hell
|
|
|
|
|
how stupid =))) later version should be more than enough, but, hey, that's microsoft, nothing ever works as it should =)))
|
|
|
|
|
Ah, yes, because all later versions are "automatically" completely compatible, right? 
Bastard Programmer from Hell
|
|
|
|
|
installed 3.5 version and now it works =))
|
|
|
|
|
Saidrex wrote: later version should be more than enough,
It is a major version change 3 => 4. So quite reasonable and expected that they shouldn't be mixed.
|
|
|
|
|
I have dataGridview table, when i click on specific cell in specific column, it searches text from that cell in other database tables and returns single rows. How to delete found rows from those tables?
I got this far:
private void datoru_sarakstsDataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
if (e.ColumnIndex == 7)
{
string a = datoru_sarakstsDataGridView.Rows[e.RowIndex].Cells[1].Value.ToString();
DataRow[] sarakstsRow = datori_database.Tables["datoru_saraksts"].Select("datora_id = '" + a + "'");
sarakstsRow[0].Delete();
DataRow[] konfigRow = datori_database.Tables["konfig"].Select("datora_id = '" + a + "'");
konfigRow[0].Delete();
DataRow[] osRow = datori_database.Tables["operetajsistemas"].Select("datora_id = '" + a + "'");
osRow[0].Delete();
DataRow[] progRow = datori_database.Tables["programmas"].Select("datora_id = '" + a + "'");
progRow[0].Delete();
But when i execute my program and try it, it doesn't delete those rows.
Sorry for my bad english.
|
|
|
|
|
Delete marks the row for deletion by updating the status to Delete.
You still need to call AcceptChanges to delete these rows.
You can read more about the Delete method here[^].
|
|
|
|
|
nope, nothing there helped me.
|
|
|
|
|
Do you want to delete the rows from the datatable or from the database or both?
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
|
I tried delete rows only from 1 table and it worked, but when i try code posted in first post i get and error: IndexOutofRangeException was unhandled
|
|
|
|
|
Tried another way to delete rows:
string a = datoru_sarakstsDataGridView.Rows[e.RowIndex].Cells[1].Value.ToString();
DataRow[] osRow = datori_database.Tables["operetajsistemas"].Select("datora_id = '" + a + "'");
int index = datori_database.operetajsistemas.Rows.IndexOf(osRow[0]);
datori_database.Tables["operetajsistemas"].Rows[index].Delete();
datori_database.operetajsistemas.AcceptChanges();
And again nothing happens.
|
|
|
|
|
Sir my humble request is if u could please help me with Http Handlers implementation using C#.
Sir i have a textbox in which i retrieve name of employee from database on button click , now i want to implement a handler between .
I am not able to understand what code i should write inside the ProcessRequest method of the handler, and how to register handler in IIS.
In-case u have some documentation or code which could help me understand these things better,I request u sir please mail me, my email id is Jyant_money@yahoo.com.
|
|
|
|
|
You are asking your questions in the wrong way, mixing up UI elements with HttpHandler logic.
It usually works like this: UI generates an event, in response to which the page issues a request with specific URL that's sent to your HttpHandler, which then writes the response back.
You can find a few article on this forum about use of HttpHandler, I will only add to the list the one that I published: Basic Routing for HttpHandler[^]
|
|
|
|
|
Don't include your email in posts on a public forum. You will get lots of spam. CP users can email you if you have ticked the 'allow private email replies' box, and you don't need to expose your email.
You shouldn't need to mess about with HTTP handlers for this, just use a traditional AJAX request sent to a URL which is handled by the normal ASP.net framework (i.e. something.aspx in the old way, or /Controller/Method in MVC).
|
|
|
|
|
How to override button click event in c#
Thanks & Regards
Thahir
|
|
|
|
|
Sorry?
What do you mean by "override button click event"?
Do you mean add a handler? Or prevent an existing handler from working?
Ideological Purity is no substitute for being able to stick your thumb down a pipe to stop the water
|
|
|
|
|
prevent an existing handler from working.
|
|
|
|
|
If the app is a .NET WinForms app where you have something that implements a Form or other Container, holding a Button having a Click handler implemented by providing an OnClick() handler, then you should provide your own override OnClick(...) handler and inide it NOT call base.OnClick(). If OTOH the current handler was added using Click+=new EventHandler(myNewClickHandler) then you have to remove that handler, either by removing the code that adds it, or by actually removing it using the -= operator.
See, it would be easier if you stated a more complete and clear question, possibly showing some code.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
