|
Hello,
i have created WindowsApplication, and i want to add MS Access database file to it. I am configuring Data Source COnfiguration Wizard, and on the last step when i must choose objects for my dataset i get an error "Some updating commands could not be generated automatically.The database returned the following error: Dynamic SQL generation is not supported against a SelectCommand that does not return any base table information."
when i press OK, i get the following message:
Could not retreive schema information for table or view PersonTable.
where could be the problem? thanks in advance
|
|
|
|
|
can anyone help me with this or no?
one thing which i noticed is, when i tried to do the above procedures on my Home PC everything was just Fine! and i used the same C# express downloaded from internet, and same database file. but at my job PC i have this problem... what do u think? what is the reason?
|
|
|
|
|
Hi. In my windows form, there is a button control.
When i click on it, just removing the controls from window and adding progressbar dynamically to the window. It working fine and progress bar appearing nice.
At the same time, i am adding Label control to form at runtime only. But it appearing last(i.e after completion of process of progressbar).
Why it wont appear on window first...
in code i added label to form first and then progressbar
can any one give idea reg this.........
G. Satish
|
|
|
|
|
Windows execute the code in message queue.
So after the label display you have to use
Application.DoEvents();
Hope this help.
Regards
Pankaj Joshi
|
|
|
|
|
Thank U for giving solution.
Another one, i want to add label dynamically.
How to set size and font family to that label?
G. Satish
|
|
|
|
|
Sorry this time
This is graphics related issue I suppose. I can't help it out.
Regards
Pankaj Joshi
|
|
|
|
|
Hi!
Simply take a look at the Label.Font property. That wasn't hard, was it?
Regards,
mav
--
Black holes are the places where God divided by 0...
|
|
|
|
|
hi, i am sending Bulk mails to users by getting mailid's from text file.
But i want to put the mails in queue..bcz after sending nearly 1000 mails. it getting error as...
Remote host forcibly disconnected...etc
can any one has idea reg this. How can put the mails in Queue?????
G.Satish
|
|
|
|
|
I think 1000 mails are more than enough
Regards
Pankaj Joshi
|
|
|
|
|
Hello All,
I am using a reportviewer control in my application.In order to show a report in this control i have used the getreportdefinition and loadreportdefinition methods of the Reportservice2005. It works fine on my local machine but when i try to access it through a network machine i get a error Permissions insufficient for user "Domain\username" can any one help me out.....
|
|
|
|
|
Hi all,
In my project i am reading a binary file of 81MB size and this information need to be inserted in to different tables of database.
The binary file is having several sections, contains some millions of records. while reading the binray information i am conveting the bytes in to c# datatypes and saving in arraylist, finally i am inserting in to the database Which is taking huge amount of time.
to insert this 81 MB size file in to database my application is taking 30 min.
Can any one suggest me how can i optimize the performance?
Thanks in advance
|
|
|
|
|
|
Sorry, previously what i given response is wrong. ignore it
satish......
|
|
|
|
|
Hard to say.
There are a lot of ways to boost performance.
- Is the algorithm optimized? Are your for loops ok? (you don't perform actions in for loops that could be done outside eg.)
- Do you have GUI updates like a progress bar or something?
- Try an Ngen compilation, it might help (See MSDN)
- Can you use threads? eg Read in a block of bytes and while the DB updates, Read the next block at the same time etc...
- Did you use optimezed objects? (StringBuilder for string concatination eg.)
Hope this helps...
V.
If I don't see you in this world, I'll see you in the next one... And don't be late. (Jimi Hendrix)
|
|
|
|
|
Hi,
You are use following tips/suggestions/whatever
1. Dont use INSERT when "LOADING" the data, use BULK INSERT
2. You can convert the data into c# format, and dump it as required in some temporary file, and bulk insert data using that file. If you are good at threading, you can boost the performance considerably.
3. If you are comfortable with Dynamic SQL, use it after converting data to c# datatypes.
And if you are good in threading and dynamic SQL then you can have a boost in performance as "complete loading of a 45 GigaBytes of data to 12 tables in 1.5 hours". That is what i experienced once!
Hope that much performance is enough for now and you find it useful!
Regards,
Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
|
|
|
|
|
Just for information, are you developing data warehouse?
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
|
|
|
|
|
I'm Having a combobox which having items from itemtable. When table is empty then I have to show "No items" and if items are their in table then I have to show the item. So I fill datatable like
if (dataTableItems.Rows.Count >= 1)
{
cmbItem.Items.Clear();
cmbItem.DataSource = dataTableItems;
cmbItem.DisplayMember = dataTableItems.Columns["ItemName"].ColumnName;
}
else
{
cmbItem.Items.Clear();
cmbItem.Items.Add("No items");
cmbItem.Text = "No items";
}
This is working fine on form's load event.
But I have a button that will get items from other datatsource and fill the item tables. On click of the button I again fill the datatable and same code
if (dataTableItems.Rows.Count >= 1)
{
cmbItem.Items.Clear();
cmbItem.DataSource = dataTableItems;
cmbItem.DisplayMember = dataTableItems.Columns["ItemName"].ColumnName;
}
else
{
cmbItem.Items.Clear(); <-- ERROR COME HERE
cmbItem.Items.Add("No items");
cmbItem.Text = "No items";
}
But it will give error "Items collection cannot be modified when the DataSource property is set."
please help
Regards
Pankaj Joshi
|
|
|
|
|
First you should set the combobox's datasource to nothing:
cmbItem.DataSource = string.Empty;
Hope it helps.
I will use Google before asking dumb questions
|
|
|
|
|
Giving error
"Complex Databinding accepts as a datasource either as IList or an IListSource"
Regards
Pankaj Joshi
|
|
|
|
|
I tried a lot and finally write this
cmbItem.DataSource = null;
This is working fine.
Will it create problem in the future...? Please reply...:->
Dear Christian Graus your suggestion needed this time...
Regards
Pankaj Joshi
|
|
|
|
|
Wow. It's urgent with three exclamations. That makes it much more likely to get answered quickly. Wait, if I post urgent and put four exclamations in, does this mean my question will get answered before yours?
Now, please post questions with meaningful titles and respect the fact that these boards are looked after by volunteers who will get to your problem when they are ready. If your problem really is that urgent, then you should probably seek an answer in an area where people get paid to help.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Thanks for your suggestion
Regards
Pankaj Joshi
|
|
|
|
|
Maybe the forums should support canned responses. So you don't have to type the same messsage about "cross-post" or "urgent" posts 20 times a day
Take care,
Tom
-----------------------------------------------
Check out my blog at http://tjoe.wordpress.com
|
|
|
|
|
Edit Grid View
-- modified at 5:44 Thursday 15th November, 2007
|
|
|
|
|
Paramita07 wrote: Edit Grid View
Any questions there?
I will use Google before asking dumb questions
|
|
|
|