|
What do you mean by "real-time" in this context?
Executing a query will take time, fetching and using the resulting data will also take time. How time-critical would this need be? Does it need to complete within 20ms? Less?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Current execution time is 5 rec per sec. Which is not acceptable
|
|
|
|
|
A "long" execution time for your query can have multiple causes. How big is each record? What speed is the network? I'm starting with these, as it seems to be the load-time that's your biggest bottleneck.
Can you show us how you load your data?
Have you tried comparing it to other compatible providers? (is ODBC available there?)
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
And you showed us the connection string, not the query...
What does the query look like? Any JOINs WHERE clauses etc? Appropriate indices?
|
|
|
|
|
If you are finding that actually establishing the connection, in the first instance, is slow, this is quite common with most databases. The way to get round this is to use a connection pool where inactive connections are stored ready for use again.
|
|
|
|
|
Hi People
Hope anyone can help me.. I am trying to download some file.. and when i click on the Download All files.
It down loads a .NET file extension file.
so what programme i can use in order to open the .net file and download the main files
Thanks
|
|
|
|
|
I would suggest either opening in NotePad to determine if you can tell what type of file it is or better yet, ask the person who posted it online.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
add mimetype of the type of file you want to download in your IIS
Thanks
Do not forget to comment and rate the article if it helped you by any means.
|
|
|
|
|
I am new to WPF and the MVVM structure but I have create a simple? project which works fine.
DataModel
class MotionModel : INotifyPropertyChanged
{
public event PropertyChangedEventHandler PropertyChanged;
public event PropertyChangingEventHandler PropertyChanging;
private string m_TabletID;
public string TabletID
{
get { return m_TabletID; }
set
{
if (PropertyChanging != null)
PropertyChanging(this, new PropertyChangingEventArgs("TabletID"));
m_TabletID = value;
if (PropertyChanged != null)
PropertyChanged(this, new PropertyChangedEventArgs("TabletID"));
}
}
private string m_Instance;
public string Instance
{
get { return m_Instance; }
set
{
if (PropertyChanging != null)
PropertyChanging(this, new PropertyChangingEventArgs("Instance"));
m_Instance = value;
if (PropertyChanged != null)
PropertyChanged(this, new PropertyChangedEventArgs("Instance"));
}
}
private string m_Database;
public string Database
{
get { return m_Database; }
set
{
if (PropertyChanging != null)
PropertyChanging(this, new PropertyChangingEventArgs("Database"));
m_Database = value;
if (PropertyChanged != null)
PropertyChanged(this, new PropertyChangedEventArgs("Database"));
}
}
public class DelegateCommand : ICommand
{
Predicate<object> canExecute;
Action<object> execute;
public DelegateCommand(Predicate<object> _canexecute, Action<object> _execute)
: this()
{
canExecute = _canexecute;
execute = _execute;
}
public DelegateCommand()
{
}
public bool CanExecute(object parameter)
{
return canExecute == null ? true : canExecute(parameter);
}
public event EventHandler CanExecuteChanged;
public void Execute(object parameter)
{
execute(parameter);
}
}
ViewModel
class MotionViewModel : BaseModel
{
ObservableCollection<MotionModel> motiontablets;
ICommand _command;
public MotionViewModel()
{
Title = "Tablets";
TabletInfo = new ObservableCollection<MotionModel>();
TabletInfo.Add(new MotionModel { TabletID = "RHL005771", Instance = @"\SQLEXPRESS", Database = "ACQ_RH_EXP_TABLET"});
TabletInfo.Add(new MotionModel { TabletID = "RHL005772", Instance = @"\SQLEXPRESS", Database = "ACQ_RH_EXP_TABLET" });
TabletInfo.Add(new MotionModel { TabletID = "RHL005773", Instance = @"\SQLEXPRESS", Database = "ACQ_RH_EXP_TABLET" });
TabletInfo.Add(new MotionModel { TabletID = "RHL005774", Instance = @"\SQLEXPRESS", Database = "ACQ_RH_EXP_TABLET" });
TabletInfo.Add(new MotionModel { TabletID = "RHL005775", Instance = @"\SQLEXPRESS", Database = "ACQ_RH_EXP_TABLET" });
TabletInfo.Add(new MotionModel { TabletID = "RHL005776", Instance = @"\SQLEXPRESS", Database = "ACQ_RH_EXP_TABLET" });
}
public ObservableCollection<MotionModel> TabletInfo
{
get
{
return motiontablets;
}
set
{
motiontablets = value;
OnPropertyChanged("TabletInfo");
}
}
public string Title { get; set; }
public ICommand RemoveCommand
{
get
{
if (_command == null)
{
_command = new RHG_MVVM.Model.MotionModel.DelegateCommand(CanExecute, Execute);
}
return _command;
}
}
private void Execute(object parameter)
{
int index = TabletInfo.IndexOf(parameter as MotionModel);
if (index > -1 && index < TabletInfo.Count)
{
TabletInfo.RemoveAt(index);
}
}
private bool CanExecute(object parameter)
{
return true;
}
My XAML is
<Window x:Class="RHG_MVVM.MainWindow"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:View="clr-namespace:RHG_MVVM.View"
Title="MainWindow" Height="350" Width="525">
<Grid>
<View:Tablets/>
</Grid>
</Window>
My question is how do I get me TabletINfo to load and write back to a XML file as two way binding???
Thanks
|
|
|
|
|
I keep getting this argumentexception "value does not fall within the expected range" when trying to set the cooperativeLevel for a keyboard. please what could I be doing wrong? Thanks in advance.
|
|
|
|
|
Without seeing the relevant code it's impossible to tell you what you did wrong.
|
|
|
|
|
It would help to see your code but the error should be pretty clear. You are setting something that is invalid.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Sounds like the initial value of a control with "minimum and maximum" values is being exceeded.
|
|
|
|
|
Hello,
I was wondering, if there is any way to create out of office rules (Reply-With Templates, forwardings... http://office.microsoft.com/en-us/outlook-help/send-out-of-office-notices-automatically-with-an-exchange-account-HP001232830.aspx#BM2[^]) in Exchange 2010 using c#? (Preferably EWS)
I know that this can be done in Exchange 2003 using MAPI, but I was unable to find any Information for Exchange2010...
Any suggestions?
|
|
|
|
|
|
Hi i have created one web application and in that i need to read the data from Mysql database and bind to gridview.
I have written Mysql query as follows
SELECT @row_number:=@row_number+1 AS row_number,Name FROM tablename, (SELECT @row_number:=0) AS r
After running in Mysql in database it will and work show the result.
But if take same query and execute through C# code below error is coming.
An exception of type 'MySql.Data.MySqlClient.MySqlException' occurred in MySql.Data.dll but was not handled in user code
Additional information: Fatal error encountered during command execution.
and i will get Break or continue pop up. If i give continue it will show Parameter '@row_number' must be defined.
even i defined like int @row_number = 0; but same error.
I need to achieve serial number as shown below
ex in database
slno name
10102 nama1
2123 name2
5203 name3
result
1 nama1
2 name2
3 name3
how to achieve this. If anybody knows please reply me.
Thanks in advance.
|
|
|
|
|
ven753 wrote: If i give continue it will show Parameter '@row_number' must be defined. There's an @-sign in there (declaring a user-variable), so .NET will assume you're declaring a parameter. There's no parameter in the collection with those names, hence the exception.
Easiest way out is to create a stored procedure. Wrap your SQL in there, call the sproc from .NET.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
while I am sending SMS it give me Error Like "The Operation has time out " and I trace that error is in this line - "objStream = sResponse.GetResponse.GetResponseStream()"
Following is my Code
Dim sURL As String
Dim objReader As StreamReader
Dim objStream As Stream
Dim sResponse As WebRequest
sURL = " MyAPI"
sResponse = WebRequest.Create(sURL)
objStream = sResponse.GetResponse.GetResponseStream()
Can Any one help what is wrong I don't understand because first time it not give me that error while I am sending second time it give me that error
Help Me Please...
Thank You
Haresh Prajapati
|
|
|
|
|
What is that URL supposed to be because what you have in there is not a URL and that's probably why your getting the timeout.
|
|
|
|
|
Perhaps the OP obfuscated it for posting -- since this is about an SMS.
If it were not valid the second time, it would not have been valid the first time either -- and OP stated -- it worked the first time -- but not the second time.
|
|
|
|
|
I would advise you to examine very carefuly your use of the streams and the WebResponse -- also avoid trying to reuse them -- this is an inherently asynchronous process and trying to create an SMS bulk texting application is not what those classes are intended to do -- it is one thing to use them to mimic browser fetches, but quite another to use them statically for multiple texts.
At the very least, close them and get them each time -- the Response -- are you reading to the end and closing the response?
|
|
|
|
|
does anyone know if it is possible to sample an area of my screen,
eg every 5 second into my memory for it to be processed?
|
|
|
|
|
You're going to have to explain that in quite a bit more detail before you get any kind of useful answer.
"Sample"? Define that exactly and what you mean by "process".
|
|
|
|
|
hi,
sorry for being ambiguous.
what i meant was is it possible to sample the image being displayed on my monitor and process it.
eg if my monitor top left pixel is red then a message box will appear saying its red.
|
|
|
|
|
Possible, yes. It's quite easy to get a copy of any part of the screen as a Bitmap. Just use Graphics.CopyFromScreen[^].
|
|
|
|