|
Cool Thanx, I will give it a try
|
|
|
|
|
missing plus sign
strSql += " where (2010Outcome.Review_ID_FK = '" + StringRevID "')";
strSql += " where (2010Outcome.Review_ID_FK = '" + StringRevID  + "')";
|
|
|
|
|
when can we use begin invoke
suresh
|
|
|
|
|
|
sureshhi wrote: when can we use begin invoke
Any time you like! 
|
|
|
|
|
Hi
I have a program that needs Microsoft Sql Server for my database .
Now i want to create an installer for my program with Installshield Software and i want to know what should i add to my installer for using sql database?
|
|
|
|
|
SQL Server, SQL Express or MSDE? I assume that you're referring to the free version, SQL Express. There's no merge-module anymore, but an executable that you can run from your own setup;MSDN states: SQL Server Express no longer uses merge modules to embed the SQL Server Express Database Engine. Instead, it contains a single-setup executable that can be bundled with your custom application. This executable accepts command-line parameters for a smooth installation experience.
More information can be obtained here[^].
Good luck
I are Troll 
|
|
|
|
|
The best thing is to have them separately. Your setup will be fairly large if you can try to add it to your setup. Install SQL separately.
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Just put a statement in the documentation that they need to have some version of SQL Server available somewhere on there network. That's the best you can do. Likewise for .net or any other product that you didn't write.
|
|
|
|
|
If we have many unused namespaces in a class, does it affect performance in any way?
|
|
|
|
|
In visual studio you can:
Main Menu - On the Edit menu, point to IntelliSense, point to Organize Usings, and then click Remove Unused Usings.
Context Menu - Right-click anywhere inside the code editor, point to Organize Usings, and then click Remove Unused Usings.
My feeling is that, it will be removed during compilation time (JIT) so the performance will be impacted during the load of the file, evaluation of it. But not during the runtime.
|
|
|
|
|
|
jdkulkarni wrote: if you add extra unused references then yes
They may affect compile time, but not run time.
|
|
|
|
|
Only during the compile phase when the compiler builds its internal reference tables. The final object code should not be affected.
|
|
|
|
|
That question makes no sense.
0) Namespaces aren't in classes.
1) If it's unused, it's not in the class.
|
|
|
|
|
Hi guys...
I have an issue with my xml file... actually im developing a console application which inserts the data from an Xml file
into my database... This happens with
certain verifications done within the console application, like
checking whether the application id given by the user matches with the application id present in the xml file and also whether that application
has certain permissions, like certain applications hav certain
previleges, sumthing like dat...
Accordingly the insertion of datas into the database takes place... the code is as follows:
class Class1
{
public string app;
public void perform()
{
OdbcConnection con= new OdbcConnection();
ADIBCrypto.Encryption64 crpto = new ADIBCrypto.Encryption64();
try
{
string connString = crpto.GetCnnStr(ConfigurationSettings.AppSettings["appname"],ConfigurationSettings.AppSettings["dsnSybase"]);
con.ConnectionString = connString;
con.Open();
Console.WriteLine("Connection Opened Successfully");
Console.WriteLine("Enter the application");
app=Console.ReadLine();
XmlDataDocument doc = new XmlDataDocument();
doc.Load(ConfigurationSettings.AppSettings["app"]);
XmlNodeList nodes = doc.GetElementsByTagName("Row");
foreach(XmlNode node in nodes)
{
if(node.HasChildNodes && node.ChildNodes.Count > 0)
{
string a_ID = node.ChildNodes[0].InnerText;
string a_ApplicationDescription = node.ChildNodes[1].InnerText;
string a_Category = node.ChildNodes[2].InnerText;
string a_Business_Owner = node.ChildNodes[3].InnerText;
string a_CreatedID = node.ChildNodes[4].InnerText;
string a_CreatedTimeStamp = node.ChildNodes[5].InnerText;
string a_Status = node.ChildNodes[6].InnerText;
if(a_ID==app)
{
Console.WriteLine("App Inserted");
}
}
}
XmlDataDocument doc1 = new XmlDataDocument();
doc1.Load(ConfigurationSettings.AppSettings["fun"]);
XmlNodeList nodes1 = doc1.GetElementsByTagName("Row");
foreach(XmlNode node1 in nodes1)
{
if(node1.HasChildNodes && node1.ChildNodes.Count > 0)
{
string f_ID = node1.ChildNodes[0].InnerText;
string f_FunctionDescription = node1.ChildNodes[1].InnerText;
string f_AppId = node1.ChildNodes[2].InnerText;
string f_FileName = node1.ChildNodes[3].InnerText;
if(f_AppId==app)
{
Console.WriteLine("fun--{0}",f_FileName);
XmlDataDocument doc2 = new XmlDataDocument();
doc2.Load(ConfigurationSettings.AppSettings["funfile"]+"\\"+f_FileName+".xml");
XmlNodeList nodes2 = doc2.GetElementsByTagName("Function");
foreach(XmlNode node2 in nodes2)
{
if(node2.HasChildNodes && node2.ChildNodes.Count > 0)
{
string ff_Id = node2.ChildNodes[0].InnerText;
string ff_FunctionDescription = node2.ChildNodes[1].InnerText;
string ff_Url = node2.ChildNodes[2].InnerText;
string ff_AppId = node2.ChildNodes[3].InnerText;
string ff_Type = node2.ChildNodes[4].InnerText;
string ff_MenuCommand = node2.ChildNodes[5].InnerText;
string ff_Status = node2.ChildNodes[6].InnerText;
Console.WriteLine("funfile--{0}",ff_Id);
}
}
}
}
}
Console.WriteLine("Function Inserted");
XmlDataDocument doc3 = new XmlDataDocument();
doc3.Load(ConfigurationSettings.AppSettings["fungrp"]);
XmlNodeList nodes3 = doc3.GetElementsByTagName("Row");
foreach(XmlNode node3 in nodes3)
{
if(node3.HasChildNodes && node3.ChildNodes.Count > 0)
{
string fg_GroupId = node3.ChildNodes[0].InnerText;
string fg_AppId = node3.ChildNodes[1].InnerText;
string fg_FuncId = node3.ChildNodes[2].InnerText;
string fg_FileName = node3.ChildNodes[3].InnerText;
if(fg_AppId==app)
{
XmlDataDocument doc4 = new XmlDataDocument();
doc4.Load(ConfigurationSettings.AppSettings["fungrpfile"]+"\\"+fg_FileName+".xml");
XmlNodeList nodes4 = doc4.GetElementsByTagName("FunctionGroup");
foreach(XmlNode node4 in nodes4)
{
if(node4.HasChildNodes && node4.ChildNodes.Count > 0)
{
string fgf_GroupId = node4.ChildNodes[0].InnerText;
string fgf_AppId = node4.ChildNodes[1].InnerText;
string fgf_FuncId = node4.ChildNodes[2].InnerText;
string fgf_Status = node4.ChildNodes[3].InnerText;
Console.WriteLine("fungrp--{0}",fgf_FuncId);
XmlDataDocument doc5 = new XmlDataDocument();
doc5.Load(ConfigurationSettings.AppSettings["grp"]);
XmlNodeList nodes5 = doc5.GetElementsByTagName("Row");
foreach(XmlNode node5 in nodes5)
{
if(node5.HasChildNodes && node5.ChildNodes.Count > 0)
{
string g_Id = node5.ChildNodes[0].InnerText;
string g_Description = node5.ChildNodes[1].InnerText;
string g_FileName = node5.ChildNodes[2].InnerText;
if(fgf_GroupId==g_Id)
{
XmlDataDocument doc6 = new XmlDataDocument();
doc6.Load(ConfigurationSettings.AppSettings["grpfile"]+"\\"+g_FileName+".xml");
XmlNodeList nodes6 = doc6.GetElementsByTagName("Group");
foreach(XmlNode node6 in nodes6)
{
if(node6.HasChildNodes && node6.ChildNodes.Count > 0)
{
string gf_Id = node6.ChildNodes[0].InnerText;
string gf_Description = node6.ChildNodes[1].InnerText;
string gf_Type = node6.ChildNodes[2].InnerText;
string gf_Level = node6.ChildNodes[3].InnerText;
int gf_DailyLimit = Convert.ToInt32(node6.ChildNodes[4].InnerText);
string gf_Status = node6.ChildNodes[5].InnerText;
Console.WriteLine("grp--{0}",gf_Id);
}
}
}
}
}
}
}
}
}
}
con.Close();
Console.WriteLine("Connection Closed");
Console.ReadLine();
}
catch(OdbcException)
{
Console.WriteLine("Record already exists");
Console.ReadLine();
}
}
The problem is that on loading the "doc3" the tags in the xml file are not in the same order.. The Xml file is as follows:
<Row>
<AppId>CAPRC</AppId>
<GroupId>CAPRC02</GroupId>
<FuncId>cap63</FuncId>
<FileName>FG_53</FileName>
</Row>
<Row>
<GroupId>ICCBranch</GroupId>
<AppId>ICC</AppId>
<FuncId>00001</FuncId>
<FileName>FG_54</FileName>
</Row>
<Row>
<GroupId>ICCBranch</GroupId>
<AppId>ICC</AppId>
<FuncId>00002</FuncId>
<FileName>FG_55</FileName>
</Row>
<Row>
<AppId>ICC</AppId>
<GroupId>ICCCardCen</GroupId>
<FuncId>00003</FuncId>
<FileName>FG_56</FileName>
</Row>
so u can see that the AppID and the GroupId tags are not in the right order.. in certain rows the tag-appid is in childnode[0]
and in certain rows the tag
is in Childnode[1]... so my check in the application is not
performed properly.. instead of childnode index number can i make it check with the name of the tag...
please guide i am 95% done with my application and at the final stage i found out this bug   ... please guide me with
any better ideas...
Thanxx in advance...
Regards,
Tash
modified on Thursday, December 10, 2009 3:44 AM
|
|
|
|
|
Replace
foreach(XmlNode node in nodes)
{
if(node.HasChildNodes && node.ChildNodes.Count > 0)
{
string a_ID = node.ChildNodes[0].InnerText;
string a_ApplicationDescription = node.ChildNodes[1].InnerText;
string a_Category = node.ChildNodes[2].InnerText;
string a_Business_Owner = node.ChildNodes[3].InnerText;
string a_CreatedID = node.ChildNodes[4].InnerText;
string a_CreatedTimeStamp = node.ChildNodes[5].InnerText;
string a_Status = node.ChildNodes[6].InnerText;
if(a_ID==app)
{
Console.WriteLine("App Inserted");
}
}
};
With something like this:
foreach(XmlNode node in nodes)
{
if(node.HasChildNodes)
{
string a_ID = string.Empty;
string ...
...
IEnumerator nodeEnumerator = node.GetEnumerator();
while (nodeEnumerator.MoveNext())
{
XmlNode currentChildNode = (XmlNode)nodeEnumerator.Current;
if (currentChildNode.NodeType != XmlNodeType.Element)
continue;
switch (currentChildNode.Name)
{
case "AppId": a_ID = currentChildNode.InnerText; break;
case "GroupId": ...
...
}
}
}
};
Greetings
Covean
|
|
|
|
|
The app I'm doing now, to manage equipment records in an electrical substation, uses about 6 major devices - reclosers, regulators, transformers, capacitors, load tap changers, and breakers - but I'm only working with one type right now. Initially I defined that class in the main form of the app, but I know that's going to get unwieldy later when I add the rest of the devices. So tonight I added a code file, moved the recloser class there, and modified the 'using' statements in the rest of the project to reference the new namespace containing the equipment classes. It worked very nicely, with no errors, so I must be learning something. 
Whenever I create a new form or other component in my project, VS automatically adds those ubiquitous 'using' statements, and I notice they're all selected from the list under References in Project Explorer. Is there a way I can set up the IDE to automatically add my custom namespace to each new item I create as the project grows? I tried adding a reference, but my new namespace doesn't show up in any of the tabs of the selection box. It's a minor thing, but it would be a convenience, and would probably save me a few errors later when I inevitably forget to type in the reference manually.
Or should I just shut up and go back to typing?
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
|
|
|
|
|
Update the class file in the following zip file:
Microsoft Visual Studio 8\Common7\IDE\ItemTemplates\CSharp\1033\Class.zip
Then, save it ans reopen VS with /setup switch. It will change the default class file.
Although, same default will be used for all the projects. So any new project you create which is not related to your current one, will throw error.
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
d@nish wrote: any new project you create which is not related to your current one, will throw error.
Sounds like more trouble than it's worth. I'll just get used to typing. 
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
|
|
|
|
|
Can't help you there; I don't use any using directives.
|
|
|
|
|
I was pretty much sure that as DataGridViewColumn implements IComponent, it should throw exception when manipulated by another thread. I am little bit surprised to see that we can change any property of DataGridViewClumn from any thread while it is not possible for DataGridView itself.
How is it possible that DataGridView is not editable from another thread while the datagridviewcolumn is?
I am waiting for the answer since 24 hours.. 
Jayant D. Kulkarni
modified on Thursday, December 10, 2009 11:29 PM
|
|
|
|
|
On creation of multifile assembly,
When i run the csc command, it gives error stating that csc command is not valid.
Can anyone say how to compile the files to create multifile assembly.
Thanks & regards,
sandhiya
|
|
|
|
|
Determine the full path of CSC and either use it or add it to the PATH environment variable.
|
|
|
|
|
I am trying to understand the standard class HashSet<T>. As I understand it, this class implements a hash table. For example, it supports the method Add which adds members to the hash table. It also supports a method Contains which returns a boolean value whether or not the data item is in the table. Let say, I am writing an application with the following class:
class person {
public int id;
public string name;
}
Now, I am going to need to overload the operators == and != for the class person. My comparison
operator will return equal if and only if the classes have the same id. If I do that,
then I believe that I can write the following declaration:
HashSet<person> personSet;
Now, given the declaration of personSet, I know how to add things to it, but given an id, how do I find the person's name. That is, I would expect that the class should have some kind of find method. However, after looking thought the documentation, I failed to find such a function. I did find a method Contains, but that just returns a bool value. What am I missing?
Thanks
Bob
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
