|
The question is somehow wrong.
XML is a way to format data so that they can easily be read in a standarized way. SQL is a language to retrieve data from databases. So they are targeting completely different things. There are even database where an SQL query works on or even returns XML.
The advantage of XML is that its a standarized way to format data and libraries exist for nearly every programming language to easily read them. Because it is generally file based and needs many string operations it is relatively slow (compared to other formats).
With SQL you have a language at hand where you describe what data you want to get from a datasource. The advantage is that about every database allows SQL queries and the syntax is nearly the same on all of them. But it doesnt provide any way to access the database. For that you'll need some libraries which transfer your commands to the database and retrieve the data so you can access it. In .Net this is done by various providers (e.g. for OleDb, ODBC, Oracle...). Depending on which one you choose this access is generally by far faster than XML (at least when it comes to large amounts of data).
|
|
|
|
|
OK,That helps me ,Thanks a lot.
|
|
|
|
|
Hello everybody,
I'm sure many of you have noticed that the doubleclick event of a datagrid object does not respond when clicking on a cell.
I googled and found that it's because the first click selects the textbox and the second click raises the Click event of that textbox.
now the obvious question is: how can I make the doubleclick event work? is there a way to make the datagrid control less complicated, or use a simple class of it's own instead of a textbox?
|
|
|
|
|
hi,
you can call the grid's double click event whithin the textbox's double click event.
that's all
Mohamed Hasan is usally called as Hasan. He is very much interested in C++ programming . He slowly picking up .NET programming. He done his Bachler degree in Arumugam Pillai Seethai Ammal college Thiruppathur. and Master degree in MK university College.
Contact him at: hasansheik@hotmail.com
hasansheik@yahoo.co.in
hasansheik@lycos.com
|
|
|
|
|
Hello Hassan,
right I could point the two at the same procedure, but this will enforce a triple click to raise the double click event(1click =select +2clicks=dblckick) which is not what I want to achieve
|
|
|
|
|
Hi
I downloded motion detection in vedio from this link
http://www.codeproject.com/csharp/Motion_Detection.asp
But i want to adjust the motion detection sensitivity means if set sensitivity to large then it will detect the motion only in large scale,if it is set to small scale then it will detect small motion also.
Please give me solution related to that.
Otherwise give me an idea where can i adjust detection rate.
Please send me solution to mail2mamathak@yahoo.com
Thanks in advance.
Mmatha
|
|
|
|
|
Hi
I am getting difficulty on making RAS Application Using C# for desktop application.
I have two computer which are connected on modem thr telephone.
Both computers are not on network.
When i dial the other computers using dial up it starts calling and after registering its get connected on LAN.
I have to make that application in C#.
Actually my application is to connect remote computers using DIal up and after that it will connect with database MySql . I only need to write code for Dial so that remote computers can be made on LAN. Once its on LAN i can do maipulatiuon on database
Anyone can give me idea or program
Regards
sanjeev
Regards,
sanjeev
|
|
|
|
|
I create one appl. in C# and now i wanna insert string-text from textboxes to datagrid but it shows me one error. here is the code which i did write: The code is for InsertButton.I am not using storedProcedure.
string ins = "INSERT INTO tabela(Column1,Column2,Column3,Columns4)VALUES ("+
"'"+ this.txtColumn1.Text + "'" + ","+
"'" + this.txtColumn2.Text + "'" + "," +
"'" + this.txtColumn3.Text + "'" + "," +
"'" + this.txtColumns4.Text + ")";
SqlConnection stringuu = new SqlConnection( "workstation id=mypc;packet size=4096;integrated security=SSPI;data source=mydatabase;persist security info=False;initial catalog=");
SqlDataAdapter daa = new SqlDataAdapter();
DataSet dss = new DataSet();
daa.Fill(dss,"table");
SqlCommand inscomm= new SqlCommand(shtoje,stringuu);
stringuu.Open();
inscomm.ExecuteNonQuery();
stringuu.Close();
can somebody tell me where is mistake???
|
|
|
|
|
seferi wrote:
can somebody tell me where is mistake???
1. "'" is superfluous, you could just put them in with the other text.
2. None of your variable names are remotely meaningful, in your code or ( far worse ) in your database
3. You didn't tell us what the error message was
4. Why aren't you using stored procedures, if you can ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
seferi wrote:
string ins = "INSERT INTO tabela(Column1,Column2,Column3,Columns4)VALUES ("+
"'"+ this.txtColumn1.Text + "'" + ","+
"'" + this.txtColumn2.Text + "'" + "," +
"'" + this.txtColumn3.Text + "'" + "," +
"'" + this.txtColumns4.Text + ")";
Your first problem comes after your this.txtColumns4.Text. You forgot the ending "'".
Like I said, that is your first problem and actually your smallest. Your biggest problem is that you are open for Sql Injection errors. You should really be using paramterized queries to prevent this.
Please see http://www.codeproject.com/useritems/SqlWrapper.asp[this]
|
|
|
|
|
why the windows form can't be debugging when i tried to compiled in and there's no event handling??
|
|
|
|
|
Can you explain much more ?
|
|
|
|
|
well I tried to design my form..
apparently, when i tried to compile it said something wrong with my event handling..dunno why..
and i also have problem with serilization in soccer game..
it would be agood idea if i could attach u the file..but i dunno how...unless you give your email address.
|
|
|
|
|
Just show here the code that gives the error.
|
|
|
|
|
this.picSnow.Image = ((System.Drawing.Image)(resources.GetObject("picMove.Image")));
//cboSnow
private void cboSnow_SelectedIndexChanged(object sender, System.EventArgs e)
{
switch (cboSnow.Text)
{
case "move" : picSnow.Image = picMove.Image;
MessageBox.Show ("move the snow");
break;
default: picSnow.Image = picSnow.Image;
break;
}//end switch
}//end cboSnow event
i paste a few code..the switch has 3 cases..move,throw and make..when i compile the event handler highlight the this.picSnow.Image ....
and before it's said there is no debug folder..and i should make one..how??
|
|
|
|
|
Sounds like you defined an event handler, then deleted the code, but the code in InitialiseComponent is still trying to hook up an event handler to the method that you deleted.
And you can't debug until your program compiles, a program that can't compile is one the compiler doesn't know how to turn into something that runs.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
When I try to call Console.KeyAvailable I get the error measage:
Can not see if a key has been pressed when either application does not have a console or when console input has been redirected from a file. Try Console.In.Peek.
Why?
I haven't redirected it from a file or anyting.
The PROgrammer Niklas Ulvinge aka IDK
|
|
|
|
|
It's a console app, right ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Yepp
For the real problem I wrote in another thread. (Small UI prob)
The PROgrammer Niklas Ulvinge aka IDK
|
|
|
|
|
guys can anyone can help me to do my assignment?? i'm abit confused in here..
i could't not attach the file in here..
so anyone can help me..please leave your email address thanks..
|
|
|
|
|
No - no-one will do your homework for you, and they would not be helping you if they did.
Try to do it yourself, and then ask SPECIFIC questions. You'll find we're keen to help if people are willing to try it themselves.
Also, no-one will give you an email address, if you want to communicate, do it here. We get enough spam.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
sorry..i didn't mean like that..i need the email to attach the code..because it's kinda along (i only give the error code and the command error) that's it..
i do by myself..but sometimes it's complicated to say it through forum..
|
|
|
|
|
If you can't narrow down which bit of code is causing the error, to post it here, then you need to look at it closer yourself.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
I think i did narrowed down which bit of code that has error on it..hoaa..you're too fussy man! be cool!! i'm asking you thought that you can help me..and i'm not begging you to do al my assignment man!, i do my best, but when i'm stuck is it wrong if i'm asking you? and i'm not pushing u to answer my questions man! there's alot people can help me!aniwe. thans for ur suggestion..c'ya
|
|
|
|
|
nume wrote:
you're too fussy man! be cool!! i'm asking you thought that you can help me
I *can* help you, I answer at least 20 questions a day. However, it's generally rude to appear on a forum, and ask people for email contact. The forum is here for you to contact us. If you have worked out where the problem is, by all means post the code so we can try and help.
Christian Graus - Microsoft MVP - C++
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
