|
(tested and used a lot.. I'm just too lazy to make an article about it...)
<br />
public class ConfigFile<br />
{<br />
#region GetDefaultPath(..)<br />
<br />
public static string GetDefaultPath()<br />
{<br />
return GetDefaultPath(ConfigurationFolder.LocalApplicationData, null);<br />
}<br />
public static string GetDefaultPath(ConfigurationFolder folder)<br />
{<br />
return GetDefaultPath(folder, null);<br />
}<br />
public static string GetDefaultPath(ConfigurationFolder folder, string name)<br />
{<br />
string dir = AppInfo.GetDataDirectory(folder);<br />
if (string.IsNullOrEmpty(name))<br />
name = AppInfo.AppName;<br />
return Path.Combine(dir, string.Format("{0}.config", name.PathSafe()));<br />
}<br />
<br />
#endregion<br />
<br />
#region GetShared config files<br />
<br />
public static ConfigFile GetShared()<br />
{<br />
return GetShared(GetDefaultPath());<br />
}<br />
public static ConfigFile GetShared(ConfigurationFolder folder)<br />
{<br />
return GetShared(GetDefaultPath(folder));<br />
}<br />
public static ConfigFile GetShared(ConfigurationFolder folder, string name)<br />
{<br />
return GetShared(GetDefaultPath(folder, name));<br />
}<br />
public static ConfigFile GetShared(string path)<br />
{<br />
lock (configFiles)<br />
{<br />
ConfigFile result;<br />
if (!configFiles.TryGetValue(path, out result))<br />
{<br />
result = new ConfigFile(path);<br />
configFiles[path] = result;<br />
}<br />
return result;<br />
}<br />
}<br />
<br />
static Dictionary<string, ConfigFile> configFiles = new Dictionary<string, ConfigFile>();<br />
<br />
public static void SaveAll()<br />
{<br />
lock (configFiles)<br />
{<br />
foreach (var cf in configFiles.Values)<br />
cf.Save();<br />
}<br />
}<br />
<br />
#endregion<br />
<br />
#region instance methods: Save(), Reload(), GetSection<T>()<br />
<br />
XDict config = new XDict();<br />
<br />
public ConfigFile(string path)<br />
{<br />
FilePath = path;<br />
if (string.IsNullOrEmpty(path))<br />
throw new ArgumentNullException("path");<br />
Reload();<br />
}<br />
<br />
public string FilePath { get; private set; }<br />
<br />
public void Save()<br />
{<br />
string dir = Path.GetDirectoryName(FilePath);<br />
if (!Directory.Exists(dir))<br />
Directory.CreateDirectory(dir);<br />
<br />
XDocument doc = new XDocument(config.ToXNode());<br />
doc.Save(FilePath);<br />
}<br />
<br />
public void Reload()<br />
{<br />
if (File.Exists(FilePath))<br />
try<br />
{<br />
XDocument doc = XDocument.Load(FilePath);<br />
XElement xdict = doc.Root;<br />
config = new XDict();<br />
if (xdict != null)<br />
config.FromXNode(xdict);<br />
}<br />
catch (InvalidOperationException) { }<br />
catch (XmlException) { }<br />
}<br />
<br />
public XDict GetSection<T>()<br />
{<br />
string key = typeof(T).FullName;<br />
XDict section = config.Get<XDict>(key);<br />
if (section == null)<br />
{<br />
section = new XDict();<br />
config[key] = section;<br />
}<br />
return section;<br />
}<br />
<br />
#endregion<br />
}<br />
<br />
public interface IXObject : IXmlSerializable<br />
{<br />
XNode ToXNode();<br />
void FromXNode(XNode node);<br />
}<br />
<br />
public class XValue : IXObject<br />
{<br />
public XValue() { }<br />
public XValue(string s) { StringValue = s; }<br />
<br />
public string StringValue { get; set; }<br />
<br />
public override string ToString()<br />
{<br />
return StringValue;<br />
}<br />
<br />
#region Strongly Typed Value<br />
<br />
public T Get<T>()<br />
{<br />
return Get<T>(default(T));<br />
}<br />
public T Get<T>(T defaultVal)<br />
{<br />
T ret;<br />
if (!string.IsNullOrEmpty(StringValue))<br />
{<br />
if (Converter.TryGetTValue<T>(StringValue, out ret))<br />
return ret;<br />
StringValue = null;<br />
}<br />
return defaultVal;<br />
}<br />
<br />
public void Set<T>(T val)<br />
{<br />
Set<T>(val, default(T));<br />
}<br />
public void Set<T>(T val, T defaultVal)<br />
{<br />
if (Equals(val, defaultVal))<br />
{<br />
StringValue = null;<br />
}<br />
else<br />
{<br />
string ret;<br />
if (Converter.TryGetStringValue<T>(val, out ret))<br />
StringValue = ret;<br />
}<br />
}<br />
<br />
#endregion<br />
<br />
#region static IXObject Create(XNode node)<br />
<br />
internal static IXObject Create(XNode node)<br />
{<br />
if (node == null)<br />
return null;<br />
if (node is XText)<br />
{<br />
XValue val = new XValue();<br />
val.FromXNode(node);<br />
return val;<br />
}<br />
else if (node is XElement)<br />
{<br />
XElement xe = (XElement)node;<br />
switch (xe.Name.LocalName)<br />
{<br />
case "list":<br />
XList xl = new XList();<br />
xl.FromXNode(xe);<br />
return xl;<br />
case "dictionary":<br />
XDict xd = new XDict();<br />
xd.FromXNode(xe);<br />
return xd;<br />
}<br />
}<br />
return null;<br />
}<br />
<br />
#endregion<br />
<br />
#region IXObject Members<br />
<br />
public XNode ToXNode()<br />
{<br />
var s = StringValue;<br />
if (s == null)<br />
s = "";<br />
return new XText(s);<br />
}<br />
<br />
public void FromXNode(XNode node)<br />
{<br />
XText t = node as XText;<br />
if (t != null)<br />
StringValue = t.Value;<br />
}<br />
<br />
#endregion<br />
<br />
#region IXmlSerializable Members<br />
<br />
public XmlSchema GetSchema()<br />
{<br />
return null;<br />
}<br />
<br />
public void ReadXml(XmlReader reader)<br />
{<br />
try<br />
{<br />
reader.Read();<br />
XNode node = XNode.ReadFrom(reader);<br />
FromXNode(node);<br />
}<br />
catch (InvalidOperationException) { }<br />
catch (XmlException) { }<br />
}<br />
<br />
public void WriteXml(XmlWriter writer)<br />
{<br />
ToXNode().WriteTo(writer);<br />
}<br />
<br />
#endregion<br />
}<br />
<br />
public class XList : List<IXObject>, IXObject<br />
{<br />
public override string ToString()<br />
{<br />
StringBuilder sb = new StringBuilder("[");<br />
for (int i = 0; i < 10 && i < Count; i++)<br />
{<br />
if (i > 0)<br />
sb.Append(", ");<br />
sb.Append(this[i]);<br />
}<br />
if (Count > 9)<br />
sb.Append(", ...");<br />
sb.Append("]");<br />
return sb.ToString(); ;<br />
}<br />
<br />
#region IXObject Members<br />
<br />
public XNode ToXNode()<br />
{<br />
XElement top = new XElement("list");<br />
foreach (var item in this)<br />
{<br />
top.Add(new XElement("item", item.ToXNode()));<br />
}<br />
return top;<br />
}<br />
<br />
public void FromXNode(XNode node)<br />
{<br />
XElement xe = node as XElement;<br />
if (xe == null || xe.Name != "list")<br />
return;<br />
foreach (XElement item in xe.Elements("item"))<br />
{<br />
XNode itemNode = item.FirstNode;<br />
Add(XValue.Create(itemNode));<br />
}<br />
}<br />
<br />
#endregion<br />
<br />
#region IXmlSerializable Members<br />
<br />
public XmlSchema GetSchema()<br />
{<br />
return null;<br />
}<br />
<br />
public void ReadXml(XmlReader reader)<br />
{<br />
try<br />
{<br />
reader.Read();<br />
XNode node = XNode.ReadFrom(reader);<br />
FromXNode(node);<br />
}<br />
catch (InvalidOperationException) { }<br />
catch (XmlException) { }<br />
}<br />
<br />
public void WriteXml(XmlWriter writer)<br />
{<br />
ToXNode().WriteTo(writer);<br />
}<br />
<br />
#endregion<br />
}<br />
public class XDict : Dictionary<string, IXObject>, IXObject<br />
{<br />
public override string ToString()<br />
{<br />
StringBuilder sb = new StringBuilder("{");<br />
int i = 0;<br />
foreach (var item in this)<br />
{<br />
if (i > 0)<br />
sb.Append(", ");<br />
i++;<br />
sb.Append(item.Key);<br />
sb.Append(": ");<br />
sb.Append(item.Value);<br />
}<br />
if (Count > 9)<br />
sb.Append(", ...");<br />
sb.Append("}");<br />
return sb.ToString(); ;<br />
}<br />
<br />
public new IXObject this[string key]<br />
{<br />
get<br />
{<br />
IXObject result;<br />
TryGetValue(key, out result);<br />
return result;<br />
}<br />
set<br />
{<br />
if (value == null)<br />
Remove(key);<br />
else<br />
base[key] = value;<br />
}<br />
}<br />
<br />
#region Strongly Typed Helper<br />
<br />
public T Get<T>(string key)<br />
{<br />
return Get<T>(key, default(T));<br />
}<br />
public T Get<T>(string key, T defaultVal)<br />
{<br />
IXObject xo;<br />
TryGetValue(key, out xo);<br />
if (typeof(IXObject).IsAssignableFrom(typeof(T)))<br />
{<br />
if (xo is T && xo != null)<br />
return (T)xo;<br />
return defaultVal;<br />
}<br />
<br />
XValue xv = xo as XValue;<br />
T ret;<br />
if (xv != null && !string.IsNullOrEmpty(xv.StringValue))<br />
{<br />
if (Converter.TryGetTValue<T>(xv.StringValue, out ret))<br />
return ret;<br />
}<br />
Remove(key);<br />
return defaultVal;<br />
}<br />
<br />
public void Set<T>(string key, T val)<br />
{<br />
Set<T>(key, val, default(T));<br />
}<br />
public void Set<T>(string key, T val, T defaultVal)<br />
{<br />
if (typeof(IXObject).IsAssignableFrom(typeof(T)))<br />
{<br />
IXObject xo = val != null ? (IXObject)val : (IXObject)defaultVal;<br />
this[key] = xo;<br />
return;<br />
}<br />
<br />
XValue xval;<br />
if (Equals(val, defaultVal))<br />
{<br />
xval = null;<br />
}<br />
else<br />
{<br />
string ret;<br />
if (Converter.TryGetStringValue<T>(val, out ret))<br />
xval = new XValue(ret);<br />
else<br />
xval = null;<br />
}<br />
if (xval == null)<br />
Remove(key);<br />
else<br />
this[key] = xval;<br />
}<br />
<br />
#endregion<br />
<br />
#region IXObject Members<br />
<br />
public XNode ToXNode()<br />
{<br />
XElement top = new XElement("dictionary");<br />
foreach (var item in this.Keys)<br />
{<br />
XElement xitem = new XElement("item", this[item].ToXNode());<br />
xitem.Add(new XAttribute("key", item));<br />
top.Add(xitem);<br />
}<br />
return top;<br />
}<br />
<br />
public void FromXNode(XNode node)<br />
{<br />
XElement xe = node as XElement;<br />
if (xe == null || xe.Name != "dictionary")<br />
return;<br />
foreach (XElement item in xe.Elements("item"))<br />
{<br />
string name = item.Attribute("key").Value;<br />
XNode itemNode = item.FirstNode;<br />
this[name] = XValue.Create(itemNode);<br />
}<br />
}<br />
<br />
#endregion<br />
<br />
#region IXmlSerializable Members<br />
<br />
public XmlSchema GetSchema()<br />
{<br />
return null;<br />
}<br />
<br />
public void ReadXml(XmlReader reader)<br />
{<br />
try<br />
{<br />
reader.Read();<br />
XNode node = XNode.ReadFrom(reader);<br />
FromXNode(node);<br />
}<br />
catch (InvalidOperationException) { }<br />
catch (XmlException) { }<br />
}<br />
<br />
public void WriteXml(XmlWriter writer)<br />
{<br />
ToXNode().WriteTo(writer);<br />
}<br />
<br />
#endregion<br />
}<br />
<br />
A train station is where the train stops. A bus station is where the bus stops. On my desk, I have a work station....
_________________________________________________________
My programs never have bugs, they just develop random features.
|
|
|
|
|
That smells like an Article, to me! 
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Ho.. ok, well I might do an extra effort this week end! 
Caught in my own trap! 
A train station is where the train stops. A bus station is where the bus stops. On my desk, I have a work station....
_________________________________________________________
My programs never have bugs, they just develop random features.
|
|
|
|
|
Thanks a lot that was very helpful!
|
|
|
|
|
Good!
Now I should write an article about that! 
A train station is where the train stops. A bus station is where the bus stops. On my desk, I have a work station....
_________________________________________________________
My programs never have bugs, they just develop random features.
|
|
|
|
|
not able to view the form controls when thread is running
can any one help...plss
m using thread and timer
any problem in using timer or thread
This code was posted by me...
modified on Friday, July 31, 2009 8:57 AM
|
|
|
|
|
|
Hi
i created a web service to load some information from sql server 2005 database, it works good but it has very low speed to return data, wheras sql server load data without overhead. i think the decreasing performance occures in while loop, here is my code :
[WebMethod]
public List<InputOutput> GetAllInputOuts()
{
List<InputOutput> list = new List<InputOutput>();
using (System.Data.SqlClient.SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["IOXPConnectionString"].ConnectionString))
{
using (SqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = "select * from vLinkToDataSource";
SqlDataReader dr = null;
if (con.State != ConnectionState.Open)
con.Open();
dr = cmd.ExecuteReader();
while (dr.Read())
{
InputOutput io = new InputOutput();
io.Code = dr.GetInt32(2);
io.Name = dr.GetString(1);
io.Family = dr.GetString(0);
io.DateInput = dr.GetString(3);
io.TimeInput = dr.GetString(4);
io.DateOutput = dr.GetString(5);
io.TimeOutput = dr.GetString(6);
list.Add(io);
}
}
}
return list;
}
how to improve the performance ?
Note 1 : the sql server 2005 return results good.
Note 2 : almost 17000 records exists in database.
Note 3 : beacuse i want to use this web Service in sharepoint, i must return result as List<T>.
Any help would be great appreciated
|
|
|
|
|
So, you're returning all 17,000 records, adding them one at a time to the List<t>, then having the Web Method serialize the entire List<t> (will probably take a while), tranferring what amounts to megabytes of XML text, then having the client deserialize the entire list (will probably take a while, again)??
I think you biggest problem is trying to handle 17,000 records all at once. I'd probably want to limit the data I return from the database and reduce the dataset to only the data that is absolutely necessary at a certain point in time. What are you doing with all 17,000 records that you need to transfer them all?
|
|
|
|
|
Hi Dave
my goal is load all data into sharepoint via bussiness data catalog (bdc), it's finder method, then write another webMethod to find only data which matched to criteria, It's specific finder method.
|
|
|
|
|
Well, then I'd probably look at a caching solution on the Sharepoint side if your data doesn't change very often, or if your SQL Server is 2005 or above, some kind of solution to return the query as your XML dataset and returning that to the client.
|
|
|
|
|
Thanks Dave
but, what's XML dataset ?
can u give me an example ?
thanks
|
|
|
|
|
I don't have any examples, but you can start your own research into it by Googling for "SELECT FOR XML".
|
|
|
|
|
I am experiencing difficulty trying to make a trackbar scroll when the middle mouse button/ball is clicked and scrolled.
I need the mouse scroll wheel to scroll up and down when it is clicked and reset the value to the middle when realised.
Does anyone know how this can be done.
Thanx George
|
|
|
|
|
I have tried this:
private void trackBar1_Scroll_1(object sender, MouseEventArgs m)
{
if (m.Button == MouseButtons.Middle)
{
label1.Text = trackBar1.Value.ToString();
}
}
but dont know if it will work as havent got it to compile because its complaining about the delegate
this.trackBar1.Scroll += new System.EventHandler(this.trackBar1_Scroll_1);
I dont know how to change it, it works with eventArgs but i put in mouseEventArgs which i need and it does not like it.
|
|
|
|
|
Hi,
you can't just change the partameter types; Scroll gives an EventArgs, not a MouseEventArgs.
you are aware of the Control.MouseWheel event? That one offers a MouseEventArgs.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Thanks for that. You just answered my question too! lol  
2 answers in 1!
Regards,
Jason Pezzimenti.
|
|
|
|
|
Thank you that was a silly thing to do.
This is the first time i have worked with events so will probably make a few mistakes along the way.
|
|
|
|
|
suppose a company has two branches in UK & US. say two windows client apps are there and they would like to transfer data to each other and their local data will be synchronozed with those data. so please guide me how can i develop a webservice which will work as a bridge and accept bulk data from client a and pass to client b vice versa. if i can get the concept then i can develop a good synchronization system by webservice. where webservice will play the role like bridge who can accept bulk data and also pass bulk data to other client.
please help me to accomplish this task.
Thanks in Advance
tbhattacharjee
|
|
|
|
|
You may want to look into the MS Sync Framework[^] before you try developing your own sync services, which Web Services are not really suited for anyway.
|
|
|
|
|
In c#, How can I hook the IE wiindow.
Can I use Hooking API's in c#?
How to use these for getting the current printer settings when a print is given from an IE window?
similarly, How to know the handles of Navigation Toolbar on IE window through windows API's?
Totally, How can I hook each and every object on IE window through c#
|
|
|
|
|
// please anyone could help me write the update code
public DataTable GetCustomers()
{
string query = "SELECT * FROM Customer_2";
SqlDataAdapter da = new SqlDataAdapter(query, constr);
DataTable table = new DataTable();
da.Fill(table);
return table;
}
// For Inserting Customers
public void InsertCustomer(string customerName)
{
string query = "INSERT INTO Customer_2 (CustomerName) VALUES (@CustomerName)";
SqlConnection con = new SqlConnection(constr);
SqlCommand com = new SqlCommand(query, con);
com.Parameters.Add("@CustomerName", SqlDbType.NVarChar).Value = customerName;
con.Open();
com.ExecuteNonQuery();
con.Close();
}
// For Deleting Customers
public void DeleteCustomers(List&lt;int&gt; customerIDsToDelete)
{
string query = "DELETE FROM Customer_2 WHERE CustomerID = @CustomerID";
SqlConnection con = new SqlConnection(constr);
SqlCommand com = new SqlCommand(query, con);
SqlTransaction tr = null;
try
{
con.Open();
tr = con.BeginTransaction();
com.Transaction = tr;
com.Parameters.Add("@CustomerID", SqlDbType.Int);
foreach (int item in customerIDsToDelete)
{
com.Parameters["@CustomerID"].Value = item;
com.ExecuteNonQuery();
}
tr.Commit();
}
catch (Exception ex)
{
tr.Rollback();
throw ex;
}
finally
{
con.Close();
}
}
// please anyone could help me write the update
|
|
|
|
|
Write what update code? The C# or SQL? How about this[^]?
only two letters away from being an asset
|
|
|
|
|
Wow! ur so rad man! i'd nvr thnk 2 bing!
[NOTE THE JOKE ICON - the norm is to use google!]
Panic, Chaos, Destruction.
My work here is done.
|
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
