|
I have edited your post to remove the sensitive information such as the uid and password. You should never post them on a public site.
What is happening when you run your code? We can't see what's going on so we'll need more information from you as to what, exactly, you are seeing. I would also point out that your code is wide open to a SQL Injection attack[^]. Change your query to use parameters[^] instead. Finally, I'm concerned that you appear to have a very weak password protection in place here. In order for your code to work, the password the user types must match the password that's stored in the database; there's a suggestion here that the password you have must be stored in clear in the database because you aren't using any techniques to convert the users password into the same format that's inside the database.
This space for rent
|
|
|
|
|
Hi Pete O'Hanlon,
Many thanks to your advice.
For your info. This is what I get when I run the Program
"
An unhandled exception of type 'MySql.Data.MySqlClient.MySqlException' occurred in MySql.Data.dll
Additional information: Unable to connect to any of the specified MySQL hosts.
"
|
|
|
|
|
This suggests one of two things.
1. The connection string you are using is wrong - can't really help you here because these are the details for your server
2. The security at the server side is preventing your client from reaching the database. Again, we can't really help - you'll have to talk to the person who owns the database to see how they have their setup.
This space for rent
|
|
|
|
|
|
Is this a "local" or a "remote" database? Do you know the difference?
Can you access the database with one of the "MySql Administrator / Workbench" apps?
(This will help with knowing how to connect and testing the connection).
|
|
|
|
|
I need an example of Unity3d webservice.when it's deployed in IIS and called by any client,a simple 3D model will make some action (by different param from client),such as rotating.
|
|
|
|
|
|
I'm creating an application in WPF that takes a raw Excel or csv data file from a customer and processes it into an order in the business system. I've done all the back-end coding and 95% of it is in T-SQL.
On the front-end, I want to import the file into a datagrid, so the user can see the raw data as it is exactly in the original file, before it goes off to be processed on SQL Server.
The customer Excel or csv files vary in format and structure, so they have varying columns with varying formats. That's handled by the back-end. I want to just display the raw data in WPF.
So, one customer has the date formatted as "7-Nov-16" which my import code is converting to "42675", but I want it to show as "7-Nov-16" in the WPF datagrid.
My code loops through the cells to get the value to build a data-table and the line that gets the cell value is:
cellData = Convert.ToString(excelRange.Cells[rowCount, colCount].Value2);
Is there some clever way to get this to preserve the original format?
|
|
|
|
|
Try the Text property:
cellData = Convert.ToString(excelRange.Cells[rowCount, colCount].Text);
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Wow, how easy was that! It just goes to confirm that knowledge is power!
Many thanks for your help Richard.
|
|
|
|
|
Hello!
I am trying to make a Contact Book, where i can have my contacts and conversations(+other activities related to them) in C# WPF.I am also trying to learn MVVM withg this.
I have 2 listboxes each bound to an observable collection populated from a database using LinqToSQL.
Listbox 1(ContactsLstBx) is displaying a list of contact names, and in Listbox 2(ConversationLstBx), i want to display the conversations i had with the selected contact in Listbox 1.
The problem is that i dont know how to get the Listbox 1 selectedItem.Id(the contact's id) so that i can use it in a query to select the conversations i had with the selected contact.
Also, any advice regarding what i am doing is highly appreciated.
C#:
public class ContactViewModel : ViewModelBase
{
public ObservableCollection<Contact> ContactList;
public ContactViewModel()
{
ContactList = new ObservableCollection<Contact>(cbdc.Contacts);
}
public class ConversationViewModel : ViewModelBase
{
public ObservableCollection<Conversation> ConversationList;
public ConversationViewModel()
{
ConversationList = new ObservableCollection<Conversation>(cbdc.Conversations);
}
}
public class ViewModelBase: INotifyPropertyChanged
{
public ContactLinqToSQLClassesDataContext cbdc = new ContactLinqToSQLClassesDataContext();
#region INotifyPropertyChanged
public event PropertyChangedEventHandler PropertyChanged;
internal void RaisePropertyChanged(string propertyName)
{
if (PropertyChanged != null)
{
PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
}
}
#endregion
XAML:
<ListBox x:Name="ContactsLstBx" HorizontalAlignment="Left" Height="289" Margin="10,50,0,0" VerticalAlignment="Top" Width="115" ItemsSource="{Binding ContactList}">
<ListBox.ItemTemplate>
<DataTemplate>
<TextBlock Text="{Binding Path=Name}" />
</DataTemplate>
</ListBox.ItemTemplate>
</ListBox>
<ListBox x:Name="ConversationLstBx" HorizontalAlignment="Left" Height="134" Margin="333,50,0,0" VerticalAlignment="Top" Width="115" ItemsSource="{Binding ConversationList}">
<ListBox.ItemTemplate>
<DataTemplate>
<TextBlock Text="{Binding Path=Title}" />
</DataTemplate>
</ListBox.ItemTemplate>
</ListBox>
Thank You!
|
|
|
|
|
Normally I would point you to the correct forum for this type of question (we have a dedicated WPF/Silverlight forum that this is best suited for). In this case, I'll let you off  .
The thing you are missing is that you don't have a selected item in your contact list, so you have no way of triggering this. The first thing to do is to add a property to your ContactViewModel that you will bind your selected item from the ListBox to. So, change your VM to this:
public class ContactViewModel : ViewModelBase
{
private Contact selectedContact;
public ObservableCollection<Contact> ContactList;
public ContactViewModel()
{
ContactList = new ObservableCollection<Contact>(cbdc.Contacts);
SelectedContact = ContactList.FirstOrDefault();
}
public Contact SelectedContact
{
get { return selectedContact; }
set
{
if (selectedContact == value) return;
selectedContact = value;
RaisePropertyChanged("SelectedContact");
}
}
}Then, you change the relevant ListBox to include
SelectedItem="{Binding SelectedContact}"Now, that gets the selected contact binding properly and you'll need to handle this to select the items somehow. What I can't see, anywhere in your code, is the logical connection between these two ViewModels. I can't see any code that actually links the two. If I were doing this, I would combine them into one VM and have the second ObservableCollection updated from the change in SelectedContact.
This space for rent
|
|
|
|
|
Thank you!
I will try to combine the 2 ViewModels.
|
|
|
|
|
Hi, I would like to know how I can make a file erase automatically after the remaining time runs out
|
|
|
|
|
You can't. There is no "Autodestruct" data for files.
You would have to maintain a list of "monitored files" with their expiry date, and run an application or service on a regular basis to removed "old" files.
We can't tell you how to do that without knowing a load more about exactly what environment you are running in - it could be very different if it's a website instead of a Win10 desktop, or an Android phone instead of an iPad for example.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Secondly, as long as the file is being used you cannot remove or delete it, Windows won't let you do it. So, of course you can delete the file itself after the playing mode has stopped on the media player.
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
Afzaal Ahmad Zeeshan wrote: So, of course you can delete the file itself after the playing mode has stopped on the media player.
Video or audio is usually data, does not contain instructions. The file probably cannot delete "itself" if it is finished playing.
Also, I think he is informing about DRM, not the technical option to have a data-file delete itself.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Based on the "problem definition":
If I had a file that I wanted to get rid of in "one hour", I would launch "something" (service; console app; timer; etc.) that after a one hour had elapsed (via "sleep"; interval elapsed; etc.) simple runs and deletes the file.
(Assumes no file contention; etc.)
|
|
|
|
|
I have an Excel file to read out data as an object.
I don't know can i read as Object just on memory or not ?
(I just want to save on memory, not on Database or i don't want to show Datagrid or...)
Currently , i try to change Excel file to XML format and I will serialize again.
I think that it is too many step to do,right ?
And so, anyone can advice to me ?
Thanks
|
|
|
|
|
Sorry, but that doesn't make any sense - it's probably a comprehension problem at my end, but what you are trying to do doesn't really come through very well.
Try again, and explain what task you are trying to do and why, instead of concentrating on "Object" and "memory"; "XML" and "serialize". It may make it easier for us to help you if we know why you think "an object" will help you!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Message Closed
modified 2-Dec-16 0:58am.
|
|
|
|
|
Since you are talking about "upload" you will have the file data as a stream or an array of bytes - which both technically are already objects, just not ones that are directly much use to you! 
What I'd suggest is look here: c# - Read data from an Excel file - Stack Overflow[^] - the Velkumar solution uses the ExcelDataReader package and shows you how to convert a stream into a DataTable, which sounds like where you want to be.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Thanks for ur suggestion
Let me try
I am newbie and so all are still confusing 
|
|
|
|
|
NB: If you're writing a web application, don't use Excel Interop. It's not supported:
Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.
Assuming you're uploading a new format file (.xlsx), any of the following libraries should do what you need:
If you need to support old format files as well (.xls), then you'll need to use NPOI[^].
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Excel work sheets / files can be saved as CSV or XML (among other things); which are, in other words, "strings".
You can store or transport Excel files anywhere if you simple treat the file (contents) as a "long string".
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
