|
This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind - we only get exactly what you type to work with.
Please try to explain in better detail what the problem is, what you have tried to do to fix it, where you are stuck, and what help you need.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Hi,
From below xml file i need to get hospital names in combo box using c# , i have searched in net but i cant find the hint how can we read.
?xml version="1.0" encoding="utf-8" ?>
<hospitals>
<hids>
<hid>1</hid>
<hos_type>0</hos_type>
<hcode>SV</hcode>
<hname>St Vincents</hname>
<address>Australia</address >
<landline>56456456456</landline>
<mobile>569678768</mobile>
<email>bijibtrack1@gmail.com</email>
<status>0</status>
<created_by>fgdfgdfgdfg</created_by>
<created_on>2011-02-26 10:10:50</created_on>
<notes>dfgdfgdfg</notes>
<is_pms>0</is_pms>
<c_insert>1</c_insert>
<c_update>0</c_update>
<c_timezone></c_timezone>
</hids>
<hids>
<hid>2</hid>
<hos_type>0</hos_type>
<hcode>ARC</hcode>
<hname>ARC Clinic</hname>
<address>Australia.</address >
<landline>34563456</landline>
<mobile>34563456</mobile>
<email>bijibtrack1@gmail.com</email>
<status>1</status>
<created_by></created_by>
<created_on>2012-10-10 00:00:00</created_on>
<notes>australia</notes>
<is_pms>0</is_pms>
<c_insert>1</c_insert>
<c_update>0</c_update>
<c_timezone>2011-02-11 18:27:09</c_timezone>
</hids>
|
|
|
|
|
|
yes, i am trying to read data from xml to display in combo box but i am unable to get exact solution..
|
|
|
|
|
So what code did you try, and what did it do that your didn't expect, or not do that you did?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I have tried below code but i am not getting the values in combobox
void MainFormLoad(object sender, EventArgs e)
{
string myXmlfile=@"C:\Users\anusha\Documents\SharpDevelop Projects\hospitals.xml";
DataSet ds= new DataSet();
System.IO.FileStream fsReadXml= new System.IO.FileStream
(myXmlfile,System.IO.FileMode.Open);
ds.ReadXml(fsReadXml);
cmbHospitals.DataSource=ds;
cmbHospitals.DisplayMember="name";
}
<pre lang="c#">
|
|
|
|
|
Well, a very quick debugging session and some light thinking would have told you several things:
1) Your XML is missing the opening < and will not process as a result.
2) Your XML is missing the closing tag: </hospitals>
3) You code expects the ComboBox to work out for itself which table to use: don't pass the dataset as the DataSource, pass the table. DataSets can contain multiple tables.
4) There is no "name" data in your XML file. There is "hname" data though...
5) You shouldn't hold the file open: add a using block round the FileStream creator.
DataSet ds = new DataSet();
using (System.IO.FileStream fsReadXml = new System.IO.FileStream(myXmlfile, System.IO.FileMode.Open))
{
ds.ReadXml(fsReadXml);
}
cmbHospitals.DataSource = ds.Tables[0];
cmbHospitals.DisplayMember = "hname";
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Thanks sir for clarifying, I have given the correct coding.I have written below code for displaying hospital names but i am unable to display names.
void MainFormLoad(object sender, EventArgs e)
{
XmlDocument xDoc = new XmlDocument();
xDoc.Load("hospitals.xml");
XmlNodeList hospitals = xDoc.GetElementsByTagName("hospitals");
for (int i = 0; i < hospitals.Count; i++)
{
cmbHospitals.Items.Add(hospitals[i].Attributes["hname"].InnerText);
}
}
|
|
|
|
|
Did you read the code I gave you, at all?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
yes , i have gone through it,but i am trying to get values into combobox, i am totally confused of what i am doing.and what the helpers are trying to guide
|
|
|
|
|
Just copy the code from my post, and paste it into your app. Run your code, and (provided you've fixed the other problems) it should load the hospital names into the combobox.
It did for me when I tested it against your (corrected) data!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Thanks you sir.. I got the required output
|
|
|
|
|
You're welcome!
Do you understand why?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Yes sir, It was mistake in xml code only thats why i am not getting the values.i tried using try and catch blocks to check the error.
|
|
|
|
|
If you run your code in the debugger, it will stop on an unhandled exception and show you where (and what) the problem is - and it will let you look at data, change code, run it again, single step your code ... a whole lot more useful than just changing your code to try and find an error!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
ok sir thank you, for your valuable suggestions i will take your suggestions and do further codings.
|
|
|
|
|
I Need To Read SMS Message in C# using AT Command
|
|
|
|
|
If you are waiting for permission, then consider it given: go right ahead.
If you need something else, then please explain what you have tried, what happened when you tried, where you are stuck, and what help you need.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Hi all,
First time poster here and excited to interact with the forum.
I'm using C# and Postgres. I rolled my own security to escape the special chars I was aware off (like single quote), but then was advised that I didn't need to do that - parameterization could do it all for me!
So I deleted (archived) my code and replaced it all with parameterized Npgsqlcommands. Great!
However, a bit of testing shows that it doesn't escape single quotes when using NpgsqlCommand.ExecuteReader().
It seems to work fine when I do NpgsqlCommand.ExecuteNonQuery(). I listed my working code at the bottom of this message in case anyone doing this stumbles across it and finds it useful.
I'm kind of a novice, and would really appreciate someone more experienced to look over my code and help me understand what I'm doing wrong.
Here's my method for SQL queries that return data:
public static bool ExecuteSQLQuery(NpgsqlCommand cmdText, out DataTable dataTable)
{
try
{
string connectionString = ConfigurationManager.AppSettings["connectionString"];
NpgsqlConnection sqlConnection = new NpgsqlConnection(connectionString);
sqlConnection.Open();
cmdText.Connection = sqlConnection;
dataTable = new DataTable();
dataTable.Load(cmdText.ExecuteReader(CommandBehavior.CloseConnection));
sqlConnection.Close();
return true;
}
catch(Exception ex)
{ dataTable = new DataTable(); return false; }
}
Here's my code for calling that code:
DataTable dataTable = new DataTable();
NpgsqlCommand sqlCommand = new NpgsqlCommand("SELECT * FROM users.users WHERE (email ilike @email or username ilike @username)");
sqlCommand.Parameters.AddWithValue("email", NpgsqlTypes.NpgsqlDbType.Varchar, email);
sqlCommand.Parameters.AddWithValue("username", NpgsqlTypes.NpgsqlDbType.Varchar, username);
DatabaseConnectivity.ExecuteSQLQuery(sqlCommand, out dataTable)
If I feed it a single quote character it fails.
Thanks in advance for any help.
PS: Here's my working code for SQL that doesn't return any data:
public static bool ExecuteSQLNonQuery(NpgsqlCommand cmdText)
{
try
{
string connectionString = ConfigurationManager.AppSettings["connectionString"];
NpgsqlConnection sqlConnection = new NpgsqlConnection(connectionString);
sqlConnection.Open();
cmdText.Connection = sqlConnection;
cmdText.ExecuteNonQuery();
sqlConnection.Close();
return true;
}
catch (Exception ex)
{ return false; }
}
|
|
|
|
|
Quote: If I feed it a single quote character it fails.
How does it fail?
Is there an error message?
What happens that you don't expect, or doesn't happen that you do?
What - exactly - did you do to test it?
What does the debugger show is happening, and where?
Have you tried using:
sqlCommand.Parameters.AddWithValue("@email", NpgsqlTypes.NpgsqlDbType.Varchar, email);
sqlCommand.Parameters.AddWithValue("@username", NpgsqlTypes.NpgsqlDbType.Varchar, username);
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
|
how I can download usbclass library for win 10?
|
|
|
|
|
|
Just like you download anything else.
|
|
|
|
|
I am facing an issue with SQL Server 2016, we have an application in windows forms to block multiple logins with the same username.
The logic that we implemented to prevent this is: the first time a user logs in to the application a DB connection will be opened and the connection will not be closed until he logs out.
When the second user connects the application using the same username, we will kill the first connection using the KILL command (this logic is implemented inside a stored procedure) after this when the first user does some DB operation the connection StateChange event will be fired and the application will be closed.
This was working perfectly up to ms SQL Server 2012. Recently we have migrated our application to framework 4.7 and SQL Server 2016 after that we are having this issue. In SQL Server 2016 when we kill the first user connection it will disappear from the SYSPROCESSES table but if the user performs any DB fetching the connection will be reopened automatically (with the same connection id) and the StateChange event will not fire. We are not using any connection pooling. I have tried different combinations of .NET framework and SQL Server (not checked in SQL Server 2014)
• Up to SQL Server 2012, it will work in all dot net frameworks
• In SQL Server 2016, this will work only if the framework is 3.5.
Connection string used:
Data Source=DBServer;Network Library=DBMSSOCN;Initial Catalog=DBName; User ID=DBUserName; Password=DBPassword; POOLING=false;Trusted_Connection=false;APPLICATION NAME = STATECHANGE_ISSUE
SQL Server 2016 version
Microsoft SQL Server 2016 (SP1-GDR) (KB4019089) - 13.0.4206.0 (X64) Standard Edition (64-bit)
Did anyone face this issue before? Is there any workaround for this in .Net framework 4.7.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
