|
I am getting a Disconnected Context Error when I execute my code which basically programmatically creates an Excel spread sheet.
What is the reason for this and how do I fix it?
Thanks
Tim
|
|
|
|
|
I am having the same trouble as well, and actually with the Excel COM object. just opening and writing to spreadsheets.
It is doubly weird because I am running the same code on my windows xp machine at work - no problems.
I run it at home on my windows 7 machine and I get the disconnected context error.
I am not using any fancy multi-threading.
Running VS 2010
Any help on this issue would be much appreciated. I am pretty stuck.
|
|
|
|
|
i have write a code for haar wavelet transform but i coudn't input image to its inverse transform any body can help me!
modified on Friday, April 16, 2010 4:38 PM
|
|
|
|
|
Do not Repost.[^]
This same question was down voted yesterday, you should have found out why it was down voted and rephrased the question. Since you are new to code project, you are excused.
No one understands your question. What have you tried and what doesn't work? What do you mean by I couldn't input image? Which API/method are you using and what failed when you try to pass the image?
If you find it tough to write your question in english, use Google translate[^] to help you figure out what you want to type.
Tarakeshwar Reddy
There are two kinds of people, those who do the work and those who take the credit. Try to be in the first group; there is less competition there. - Indira Gandhi
|
|
|
|
|
How to Make textbox autocomplete?
|
|
|
|
|
Set the TextBox's AutoCompleteMode, AutoCompleteSource and AutoCompleteCustomSource Properties to appropriate values depending on what exact behavior you wish it to have.
MSDN[^]
|
|
|
|
|
i changed AutoCompleteMode ==>suggest
Autocmpletesource ==>Customersourc
In foreach (DataRow row in (SelectAccounts().Rows)
{
textBox1.AutoCompleteCustomSource.Add( row["Account_Name"].ToString());
}
it worked successfuly and displayed names in table Account
now i want to get id for accountname that user enter
SelectAccounts() return table accounts{id,Account_Name}
|
|
|
|
|
OK, so loop through the rows again until you find the one where the account name matches what they entered in the TextBox and then grab the ID from that row. If you want to get fancy about how you do it then you could probably do it using Linq but looping and searching will work just fine.
|
|
|
|
|
See this[^] article.
/ravi
|
|
|
|
|
If anyone is familiar with Delphi and it's TADOQuery component, I would like to do something similar to the TADOQuery.Locate method.
If your not familiar with Delphi's TADOQuery.Locate, I want to be able to programatically select a newly added row. So the user can have a visual reference that a post was successful.
I read online sometime a ago that the TableAdapter.Select() method was the way to go but I can't seem to get it to work. Anyone?
I found this answer here
http://www.akadia.com/services/dotnet_find_methods.html
but it requires your tables to have primary keys and just my luck none of my tables have primary keys. By the way I didn't create these tables. How do I do the find without primary keys? I don't want to have to add them to all my Tables.
modified on Friday, April 16, 2010 4:53 PM
|
|
|
|
|
I am making a couple of assumptions here that may or may not be accurate. 1. Your datastore is a SQL database 2. You have no identity column (primary key is one type of identity column).
Without an identity column defined, SQL databases methods to return the last inserted record (@@identity or Scope_Identity()) will return NULL. Soooo you need another way to skin that cat.
One way, and there could be many options would be to make a clone of your current datatable before refreshing the data from the database and then compare the records to find the new one.
A way to do that would be something like:
datable1.merge(datatable2);
datatable3 = datatable2.GetChanges();
Then you could find the row or rows from datatable3 in your table and make that or them your current selection.
Hope this is helpful.
|
|
|
|
|
It's an SQL Server database and we do have identity columns but they are no primary key columns. I am able to use @@Identity and Scope_Identity() in the Delphi App and it works fine. I just need to figure out how to do it in C#.
|
|
|
|
|
This may work for you assuming you are dynamically generating your sql and submitting through an ADO query object.
Add a statement such as "Select Scope_Identity() From Table MyTable;" to the end of your dynamic sql. Then instead of submitting as ExecuteNonQuery(), run it as a regular query and the return value should be the row you added.
ymmv
|
|
|
|
|
I'm sorry I'm taking so long to reply to this thread, I'm a little busy. Ok so everything you said works but now how do I select the newly added row. I've tried several ways so far. e.g. this.bindingsource.contains(NewID), this.bindingsource.find(NewID). this.bindingsource.FindRows(NewID). But they never select any row except the very first row.
|
|
|
|
|
After searching long and hard I finally found a way to do it. Makes me wonder why I didn't think of this before.
for ( int i = 0; i < GridContact.Rows.Count; i++ )
{
if ((int)GridContact.Rows[i].Cells[1].Value == ID )
{
GridContact.ClearSelection();
GridContact.Rows[i].Selected = true;
}
}
|
|
|
|
|
After searching long and hard I finally found a way to do it. Makes me wonder why I didn't think of this before.
for ( int i = 0; i < GridContact.Rows.Count; i++ )
{
if ((int)GridContact.Rows[i].Cells[1].Value == ID )
{
GridContact.ClearSelection();
GridContact.Rows[i].Selected = true;
}
}
http://www.c-sharpcorner.com/Forums/Thread/84582/how-to-auto-select-a-newly-added-row-in-the-datagrid.aspx
|
|
|
|
|
static void ClearBoard(out char[,] board)
{
for (int Row = 0; Row < 3; Row++)
for (int Column = 0; Column < 3; Column++)
board[Column, Row] = ' ';
}
board will be passed in and will ALWAYS be of the form char[3,3];
When compiling, I get the error
"The out parameter 'board' must be assigned to before control leaves the current method".
Any idea why?
|
|
|
|
|
An out parameter is expected to be initialized in the called method, just as the error is telling you. If you are passing something in and want the same object returned, then use ref.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
With any array I don't think ref is required either.
|
|
|
|
|
True, i was speaking generically about the differences between the two
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hi,
you don't need out nor ref, as all you are passing is an object, in this case an array of chars. objects get passed by reference, which means both parties (caller and callee) can access the object and modify it.
FYI: without out or ref the callee can not replace the object by a new object (actually, he can, but it will not affect the caller). But that is not what the name of the method implies, when it says ClearBoard it sounds like it is clearing an existing board.
If OTOH the method were intended to create a new and cleared board, I would call it CreateClearedBoard, and the proper way would be to make that the return object, dropping the void attribute.
|
|
|
|
|
performs a binary comparision. this memeber is equivalent to the visual basic constant vbBinaryCompare. what is the equivalent method in C#?
|
|
|
|
|
Seems like it does something comparable to StringComparison.Ordinal.. I'm not too sure though, I don't know VB.
|
|
|
|
|
I suggest you have a look at string.CompareOrdinal()
|
|
|
|
|
Please, I need some idea on how to secure a password string against keylogger spywares installed on a client host.
PLEASE, password input is via the KEYBOARD only.
thanks, ur suggestions will be appreciated.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Badger | [badger,badger,badger,badger...]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/badger.gif)
