|
AWSOME! You are absolutely correct. My recursion method is just stupid compared to the power of XPath! /bow
XPathDocument doc = new XPathDocument(filename);
XPathNavigator nav = doc.CreateNavigator();
XPathExpression expr = nav.Compile("//Schema/SqlConnection");
XPathNodeIterator iterator = nav.Select(expr);
XPathNavigator sqlConnection;
while (iterator.MoveNext())
sqlConnection = iterator.Current.Clone();
(just a quick crude code example, I'll refine and post the full solution shortly)
I never used XPath queries in the past. I didn't know they were so powerful. Recursion is always such a resource hog.
I haven't started researching yet, but do you know of any significant drawbacks of using XPath queries, off the top of your head?
Again, Thanks!
|
|
|
|
|
internal class Program
{
private const string FILENAME = "Testfile.xml";
private static readonly string[] SectionNames = new[] { "Schema" };
private static readonly string[] ConfigItems = new[] { "SqlConnection", "Output" };
private static void OutputNavigatorData(XPathNavigator navigator)
{
Console.WriteLine(navigator.Name);
if (navigator.MoveToFirstAttribute())
{
Console.WriteLine(" - " + navigator.Name + " : " + navigator.Value);
while (navigator.MoveToNextAttribute())
{
Console.WriteLine(" - " + navigator.Name + " : " + navigator.Value);
}
}
}
private static void Main(string[] args)
{
XmlDocument xmlDocument = new XmlDocument();
xmlDocument.Load(FILENAME);
XPathDocument doc = new XPathDocument(FILENAME);
XPathNavigator nav = doc.CreateNavigator();
foreach (var sSectionName in SectionNames)
{
foreach (var sConfigItem in ConfigItems)
{
XPathExpression expression = nav.Compile("//" + sSectionName + "/" + sConfigItem);
XPathNodeIterator iterator = nav.Select(expression);
while (iterator.MoveNext())
{
OutputNavigatorData(iterator.Current);
}
}
}
}
}
|
|
|
|
|
Hello i have altered my method of displaying my data since my last post and instead of a listview i am now using a datagrid as i thought it would be easier to use for what i want.
I now am stuck in terms of i do not have a clue how i am going to display the rest of the data from my table?
What i need to have is when the user clicks on a row of data e.g. 'client' all records are show in the tabbed page area?
(the picture will help to explain bettter)
Picture :
I have used a dataset to show the data when client is clicked but i dont think i can use that same dataset as it only retrieves four recods.
How can i have the four records displayed on one side of the page and then when highlighted display all infomation about the client in the seperat tabbed area?
My Code so far which displays client (when clicked) and contractor (when clicked)
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using MySql.Data.MySqlClient;
namespace Deroche_Consultants
{
public partial class main_screen : Form
{
string dataCategory = null;
DataSet myDataSet;
public main_screen()
{
InitializeComponent();
}
private void client_pic_Click(object sender, EventArgs e)
{
ClientDataLoad();
}
private void client_label_Click(object sender, EventArgs e)
{
ClientDataLoad();
}
private void client_buttonBox_Click(object sender, EventArgs e)
{
ClientDataLoad();
}
private void ClientDataLoad()
{
string connectionString = "Data Source=localhost" + "; Database=_consultants" + "; User ID=root" + "; Password=password;";
MySqlConnection MySqlConn = new MySqlConnection(connectionString);
string strSQL = ("SELECT company_id, company_name, contact_fname, contact_sname, employee_count FROM client");
MySqlCommand mysqlCommand = new MySqlCommand(strSQL, MySqlConn);
MySqlDataAdapter myDataAdapter = new MySqlDataAdapter(mysqlCommand);
try
{
MySqlConn.Open();
DataSet myDataSet = new DataSet();
myDataSet.Clear();
myDataAdapter.Fill(myDataSet, "client");
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = myDataSet.Tables[0];
MySqlConn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Data Load Error "+ex.Message.ToString(),
"Error",MessageBoxButtons.OK,MessageBoxIcon.Error);
MySqlConn.Close();
}
}
private void job_pic_Click(object sender, EventArgs e)
{
}
private void job_label_Click(object sender, EventArgs e)
{
}
private void job_boxButtons_Click(object sender, EventArgs e)
{
}
private void contractor_pic_Click(object sender, EventArgs e)
{
ContractorDataLoad();
}
private void contractor_label_Click(object sender, EventArgs e)
{
ContractorDataLoad();
}
private void contractor_boxButton_Click(object sender, EventArgs e)
{
ContractorDataLoad();
}
private void ContractorDataLoad()
{
string connectionString = "Data Source=localhost" + "; Database=_consultants" + "; User ID=root" + "; Password=password;";
MySqlConnection MySqlConn = new MySqlConnection(connectionString);
string strSQL = ("SELECT contractor_id, forename, surname, availability, daily_cost FROM contractor");
MySqlCommand mysqlCommand = new MySqlCommand(strSQL, MySqlConn);
MySqlDataAdapter myDataAdapter = new MySqlDataAdapter(mysqlCommand);
try
{
MySqlConn.Open();
DataSet myDataSet = new DataSet();
myDataSet.Clear();
myDataAdapter.Fill(myDataSet, "contractor");
myDataAdapter.Fill(myDataSet);
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = myDataSet.Tables[0];
MySqlConn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Data Load Error "+ex.Message.ToString(),
"Error",MessageBoxButtons.OK,MessageBoxIcon.Error);
MySqlConn.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
Form2 addclient = new Form2();
addclient.Show();
}
private void button3_Click(object sender, EventArgs e)
{
}
}
}
Thanks in advance,
C~Rose
modified on Wednesday, December 31, 2008 4:36 AM
|
|
|
|
|
|
Also you need to split your app.
Shove all the DB connection stuff into another class so the connection is built only once and is local to the DB class.
Create a method for each of your load requirements that return a table (this is exactly the same code as you are using except it returns table[0])
This will start you on a better designed app that will be MUCH more readable and supportable.
Consider using stored procs instead of SQL strings (arguments for/against this are endless).
If, as Mark suggest, you want a parent child then you can move both tables into a dataset, create the relations and bind the dataset to the DGV.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hello yer at the moment the code is all in one big chunk.... How doi go about shoving all the db connection stuff into a class so it is only built once
is this ok?:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data.MySqlClient;
namespace _Consultants
{
class connectionStringClass
{
private void connectionString ()
{
string connectionString = "Data Source=localhost" + "; Database=_consultants" + "; User ID=root" + "; Password=password;";
MySqlConnection MySqlConn = new MySqlConnection(connectionString);
MySqlCommand mysqlCommand = new MySqlCommand(MySqlConn);
}
}
}
and then in the "main screen" class refer to it as a normal method right? like
connectionStringClass ();
|
|
|
|
|
I am testing a dll by including it in a project.
In that project I have a App.config file where there is a sharedListeners tag with one or more custom listener.
Test is success in the case.
==============================
I am testing that dll in another project where there is a configuration file but name is not App.config instead name is xxxx.yyyy.config.
Test fail in this case. No log file generated from custom listener. Exact code inside both config file only name is different. Changing name to App.config works fine but this is not an option for me.
How can I configure the application, so that it will take the parameter from config file even though name is not App.config.
Any idea will be greately appreciated
|
|
|
|
|
Usually when you deploy the application, the app.config becomes xyz.exe.config where xyz.exe is the application executable name.
One more thing app.config should be in the same directory where the executable located.
|
|
|
|
|
I am attempting to write my first custom component which requires a custom collection.
So far I have:
using System;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.ComponentModel.Design;
using System.Drawing.Design;
namespace MultiColumnComboBox
{
public partial class MultiColumnComboBox : ComboBox
{
public MultiColumnComboBox()
{
InitializeComponent();
}
}
[Editor(typeof(ColumnCollectionEditor),UITypeEditor)]
public ColumnCollection Columns
{
get { return Columns; }
set { Columns = value; }
}
public class Column
{
#region private variables
private bool _autoColumnWidth = false;
#endregion
#region public properties
public bool AutoColumnWidth
{
get { return _autoColumnWidth; }
set { _autoColumnWidth = value; }
}
#endregion
}
public class ColumnCollection : CollectionBase
{
public Column this[int index]
{
get { return (Column)List[index]; }
}
public void Add(Column column)
{
List.Add(column);
}
public void Remove(Column column)
{
List.Remove(column);
}
}
public class ColumnCollectionEditor : CollectionEditor
{
public ColumnCollectionEditor(Type type)
: base(type)
{
}
protected override string GetDisplayText(object value)
{
Column item = new Column();
item = (Column)value;
return base.GetDisplayText(string.Format("{0}", item.AutoColumnWidth));
}
}
}
The compiler does not like the section:
[Editor(typeof(ColumnCollectionEditor),UITypeEditor)]
public ColumnCollection Columns
{
get { return Columns; }
set { Columns = value; }
}
it highlights the ColumnCollection reference, but I don't understand why. Can an experienced C# coder please point me in the right direction of where I am failing?
It's hard being a simpleton 
|
|
|
|
|
kanchoette wrote: The compiler does not like the section
it highlights the ColumnCollection reference
What is the error you get at compilation?
|
|
|
|
|
I get
"Expected class, delegate, enum, interface, or struct" and the ColumnCollection reference is highlighted (red wiggly line)
|
|
|
|
|
It's been awhile since I last worked with editors but if I recall correctly, you should use typeuf on the second parameter also. And when using two types, the second parameter is used for the base class so perhaps something like:
[Editor(typeof(ColumnCollectionEditor), typeof(CollectionEditor))]
Does that help or change the error in anyway?
|
|
|
|
|
Unfortuantely I get the same error. Many thanks for trying to help me though - much appreciated.
I know it's going to end up being something really dumb. Just wish I knew just what .. Grrrr .....
|
|
|
|
|
One more observation. If I'm reading correctly, the custom editor class is a nested class inside the MultiColumnComboBox. If so, what if you try to move the editor class outside directly under the namespace (along with the column class) or use MultiColumnComboBox.ColumnCollectionEditor syntax.
|
|
|
|
|
Dear All,
I am developing small application using c# where it could only send and recieve single attachment with body text.
I am using System.Net.Mail namespace to send my msgs, I can send msg and attachments using the classes located in this namespace.
i find some references to use EAGetMail.dll to recieve msgs with attachment, sure i used EAGetMail.dll, but i can recieve my email with attachment with the extenstion of .eml where i specify for it, "based on reference".
now i dont want to open my msgs with other applications, i wd like to open it my c# application which i am developing.
Your cooperation is really appreciated.
Abdul Rahaman Hamidy
Senior Student Student in Computer Science
Kabul, Afghanistan
Software Developer
|
|
|
|
|
Ok, so what is your question?
|
|
|
|
|
[code]
EAGetMail.MailClient mClient=new EAGetMail.MailClient("TryIt");
EAGetMail.MailServer sClient=new MailServer("mail.domain.com","user name","password", ServerProtocol.Pop3);
mClient.Connect(sClient);
MailInfo[] mInfo=mClient.GetMailInfos();
int count=mInfo.Length;
for (int i=0; i<count;> {
MailInfo info=mInfo[i];
Mail m=mClient.GetMail(info);
m.SaveAs(String.Format("c:\\{0}.xal", i), true);
}
[/code]
if u just pay attention, i am saving all my emails with the extension of ".xal".
now i dont know how to open this file in my own c# app. like the one which MS OUTOOK opens.
Abdul Rahaman Hamidy
Senior Student Student in Computer Science
Kabul, Afghanistan
Software Developer
|
|
|
|
|
Abdul Rahman Hamidy wrote: now i dont know how to open this file in my own c# app. like the one which MS OUTOOK opens.
With code, I guess. File.ReadAllText will do it to get the text, although storing the files at the root of c is obviously retarded. I'd use a database.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Yeah i can read the text from the file, but how about attachments, i have to show name of attachments in my application may be in a label.
now the problem is how to understand that there is an attachment with the email.
regarding saving file, its temporary i am going to save to database using stream.
Abdul Rahaman Hamidy
Senior Student Student in Computer Science
Kabul, Afghanistan
Software Developer
|
|
|
|
|
Hello fellow developers,
I have written an application to find and replace just about anything. It even has a nice web interface and keeps everything stored in a SQL Server DB.
I have no problem finding what I am looking for, the issue comes when I replace a hard coded string inside of an EXE or DLL.
For simplicity sake I just grab the whole file as bytes, use Encoding to get me a string, and use a RegEx to Find / Replace what I am searching for. I then take the string with the values replaced and use Encoding to switch it back to bytes and overwrite the file.
This works fine on text, but DLLs and EXEs appear to have been corrupted. I get the following error when I try to execute the EXE or and executable that references a DLL I have replaced the strings inside of.
Here is a copy of the Exception, 'ConfigurationManagement.Controllers' is the DLL I changed:
System.BadImageFormatException was unhandled
Message: Could not load file or assembly 'ConfigurationManagement.Controllers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The module was expected to contain an assembly manifest.
I am assuming I am writing the file incorrectly and by adding new bytes to it, that there is some internal data inside the DLL or EXE that does not match its file size and locations anymore.
Does anyone know how to correctly edit the strings inside of a binary file?
Kind Regards,
Ryan
|
|
|
|
|
Hi,
A lot of data in an executable file is not absolute; it could be offsets, pointer tables, whatever.
So you should not try and replace a byte array by another byte array of different length.
You can pad a string with spaces or null characters to replace a larger string.
If you need to replace by a larger string you are in some trouble; you then have to find space
to put the new data and adapt some pointers...
|
|
|
|
|
Wow, looks like I am going to need the help of a File I/O expert. I have no idea how I would adapt the pointers.
Unfortunately, I have no control over the string size being replaced. I am basically writing this application because we have a lot of legacy applications ( I mean A LOT ) that need to have their connection strings, folder locations, web service names, etc changed... some we don't even have source code for some of them anymore as it was lost in TFS migration.
This doesn't seem to be a well documented developer issue. I've tried searching for the past week, but I don't seem to be entering the correct tags to pop a good search. If anyone has any good links to some articles to help out with this, I would be grateful.
Regards,
Ryan
|
|
|
|
|
Hi,
first of all you may want and have a look at the PE File Format[^]; that will show you an EXE is
not that simple.
second, if they are truly legacy, then you don't have to worry about signed assemblies, and other
.NET stuff.
I am not familiar with TFS, wikipedia tells me it exists to keep source code safe, not to throw
it away?
changing strings isn't a developer issue any more, since normal development includes both
keeping the sources handy (and not patching object or executable files), and putting
configuration stuff into some configuration repository (often a simple INI file, nowadays often
an XML file).
if you are looking for an automated solution for patching new and arbitrary string values, you are out of luck. On the other hand, if you are in control of the new strings, you can apply some tricks to make them shorter rather than longer, e.g.:
- choose short names for servers, folders, ...
- use "map network device" to replace most of a path by something really short
etc.
If that does not solve it, I am afraid you have a major task at hand and might want and consider a full rewrite using modern technology, and resulting in having source files again.
|
|
|
|
|
Yes, TFS is to store your code, but unfortunately, there were no developers on the team that migrated it from SVN.....( doh! ) so some code was lost.
Very true about changing connection strings not being a developer issue anymore, and I agree whole heartedly, unfortunately, some developers are not as skilled as others, especially in the past... some even thought that by hard coding them that they were more secure... it's amazing who could pass for a developer a few years ago...
The whole point of this project I am on is to fix our current environment to point to network aliases so when our Data Center blows up... we can simply point the alias to our Disaster Recovery center and we are back in business.
I should have mentioned I am a contract developer, I'm just trying to fix the web of chaos that is at my current site
Thank you for your feedback about PE File Format!
Ryan
|
|
|
|
|
You're welcome.
And good luck...
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
