Comments by Ramana Bellary (Top 20 by date)

Below is my code:

public class TextBoxBehavior
{
public static DependencyProperty OnLostFocusProperty = DependencyProperty.RegisterAttached(
"OnLostFocus",
typeof(ICommand),
typeof(TextBoxBehavior),
new UIPropertyMetadata(TextBoxBehavior.OnLostFocus));

public static void SetOnLostFocus(DependencyObject target, ICommand value)
{
target.SetValue(TextBoxBehavior.OnLostFocusProperty, value);
}

///

/// PropertyChanged callback for OnDoubleClickProperty. Hooks up an event handler with the
/// actual target.
///

private static void OnLostFocus(DependencyObject target, DependencyPropertyChangedEventArgs e)
{
var element = target as TextBox;
if (element == null)
{
throw new InvalidOperationException("This behavior can be attached to a TextBox item only.");
}

if ((e.NewValue != null) && (e.OldValue == null))
{
element.LostFocus += OnPreviewLostFocus;
}
else if ((e.NewValue == null) && (e.OldValue != null))
{
element.LostFocus -= OnPreviewLostFocus;
}
}

private static void OnPreviewLostFocus(object sender, RoutedEventArgs e)
{
UIElement element = (UIElement)sender;
ICommand command = (ICommand)element.GetValue(TextBoxBehavior.OnLostFocusProperty);
if (command != null)
{
command.Execute(e);
}
}
}
---------------
public class Customer : INotifyPropertyChanged
{

public event PropertyChangedEventHandler PropertyChanged;
public void RaisePropertyChanged(string propertyName)
{
if (PropertyChanged != null)
PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
}

private string name;
public string Name
{
get
{
return name;
}
set
{
name = value;
//RaisePropertyChanged("Name");
}
}

private string country;
public string Country
{
get
{
return country;
}
set
{
country = value;
RaisePropertyChanged("Country");
}
}

private int id;
public int Id
{
get
{
return id;
}
set
{
id = value;
RaisePropertyChanged("Id");
}
}
}

public class MyViewModel : INotifyPropertyChanged
{
public event PropertyChangedEventHandler PropertyChanged;
public void RaisePropertyChanged(string propertyName)
{
if (PropertyChanged != null)
PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
}

private ICommand nameChangeCommand;
public ICommand NameChangeCommand
{
get
{
if (nameChangeCommand == null)
nameChangeCommand = new RelayCommand(ValidateAndChangeName);

return nameChangeCommand;
}

}

private void ValidateAndChangeName(object obj)
{

}

private Customer customer;
public Customer Customer
{
get
{
return customer;
}
set
{
customer = value;
RaisePropertyChanged("Customer");
}
}
}
----------------

Thank you Pete O'Hanlon.

No, I want to disable the close button of an excel file .

I need to open a .txt file as .xls file in WPF window and I should be able manually edit(copy/paste/Cut) the content.

It may take much time to loop through each and every cell and read the content. Instead I'm looking for some approach where I can read the entire content at once.

I want to read the excel content , convert it into binray format and then insert into DataBase. I'm not sure if it can be done by using Ado.Net or not. If it is possible can u provide me the source code ?

I want to read the excel content , convert it into binray format and then insert into DataBase. I'm not sure if it can be done by using Ado.Net or not. If it is possible can u provide me the source code ?

Instead of looping through each used cell , can't get the entire data at once ?

I want to read the content present in a Excel WorkSheet without loopiing through each cell.

I want to read the excel content without looping through each cell , even in case of Used range also. Is it possible to do so ?

Thanks for your reply. I don't want in Ado.Net .

Thanks for your reply.Even here it will loop through each cell, which I don't want.

no

Hi,
from that handle how can I read the content present in the excel file ?

DatePicker will not accept the text entered through the keyboard,will allow the user to ender some text, which should not be the case.