|
|
Thanks Russ.
I will check it.
Mayur Patel
|
|
|
|
|
|
|
high guys
i have a problem
when i press F5 on visual studio to start debugging of my project, it runs good no errors
but
when i press ctrl+F5 on visual studio to start without debugging of my project,it gets error message
the error message is:
Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immedediately.
the type initializer for 'System.Data.SqlClient.SqlConnection'threw an exception.
Details..
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.TypeInitializationException: The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception. ---> System.TypeInitializationException: The type initializer for 'System.Data.SqlClient.SqlConnectionFactory' threw an exception. ---> System.TypeInitializationException: The type initializer for 'System.Data.SqlClient.SqlPerformanceCounters' threw an exception. ---> System.PlatformNotSupportedException: This operation is only supported on Windows 2000 SP3 or later operating systems.
at System.Security.Principal.SecurityIdentifier..ctor(WellKnownSidType sidType, SecurityIdentifier domainSid)
at System.Diagnostics.SharedUtils.EnterMutexWithoutGlobal(String mutexName, Mutex& mutex)
at System.Diagnostics.SharedPerformanceCounter.GetCounter(String counterName, String instanceName, Boolean enableReuse, PerformanceCounterInstanceLifetime lifetime)
at System.Diagnostics.SharedPerformanceCounter..ctor(String catName, String counterName, String instanceName, PerformanceCounterInstanceLifetime lifetime)
at System.Diagnostics.PerformanceCounter.Initialize()
at System.Diagnostics.PerformanceCounter.set_RawValue(Int64 value)
at System.Data.ProviderBase.DbConnectionPoolCounters.Counter..ctor(String categoryName, String instanceName, String counterName, PerformanceCounterType counterType)
at System.Data.ProviderBase.DbConnectionPoolCounters..ctor(String categoryName, String categoryHelp)
at System.Data.SqlClient.SqlPerformanceCounters..ctor()
at System.Data.SqlClient.SqlPerformanceCounters..cctor()
--- End of inner exception stack trace ---
at System.Data.SqlClient.SqlConnectionFactory..cctor()
--- End of inner exception stack trace ---
at System.Data.SqlClient.SqlConnection..cctor()
--- End of inner exception stack trace ---
at System.Data.SqlClient.SqlConnection..ctor()
at System.Data.SqlClient.SqlConnection..ctor(String connectionString)
at Computer_Sales_System.Form2.button1_Click(Object sender, EventArgs e) in D:\My first project\Computer Sales System\Computer Sales System\Form2.cs:line 178
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3074 (QFE.050727-3000)
CodeBase: file:----------------------------------------
Computer Sales System
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3074 (QFE.050727-3000)
CodeBase: file:----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3074 (QFE.050727-3000)
CodeBase: file:----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3074 (QFE.050727-3000)
CodeBase: file:----------------------------------------
PresentationCore
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.1500 built by: QFE
CodeBase: file:----------------------------------------
WindowsBase
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.1500 built by: QFE
CodeBase: file:----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3074 (QFE.050727-3000)
CodeBase: file:----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3074 (QFE.050727-3000)
CodeBase: file:----------------------------------------
WindowsFormsIntegration
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.1500 built by: QFE
CodeBase: file:----------------------------------------
PresentationFramework
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.1500 built by: QFE
CodeBase: file:----------------------------------------
PresentationFramework.Aero
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.1500 built by: QFE
CodeBase: file:----------------------------------------
System.Management
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3074 (QFE.050727-3000)
CodeBase: file:----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3074 (QFE.050727-3000)
CodeBase: file:----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
the code is:
SqlConnection cn = new SqlConnection(@"Data Source='MOHAMEDEWEHISHY\SQLEXPRESS';Initial Catalog='Computer Sales System';integrated security=sspi");
try
{
SqlCommand cmd = new SqlCommand("backup_database", cn);
cmd.CommandType = CommandType.StoredProcedure;
if (System.IO.File.Exists(@"D:\SQLServerBackups\Computer Sales System.bak"))
{
System.IO.File.Delete(@"D:\SQLServerBackups\Computer Sales System.bak");
}
cn.Open();
int i = cmd.ExecuteNonQuery();
if (i < 0)
{
MessageBox.Show("Your database is backed up successfully");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
MessageBox.Show("Sorry ... You can not back up your database");
}
finally
{
cn.Close();
}
so the problem is using SqlConnection with others not DML commands
i tried to use OLEDBConnection but it not gets result
So what is the solution????????
Thanks,
Mohamed El-Wehishy
|
|
|
|
|
i have a datatable and i have to show the data of its 3rd column in gridview.hw can i do that
|
|
|
|
|
By binding it to the gridview. Plenty of examples are there on web. You can read through them.
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
Hi,
I am using a text box on the UI to query the database using the entered text.
Following is the code snippet
string refNum = (from Example in db.Orders
where Example.Reference == textBox1.Text
select Example.OrderId).First().ToString();
My question is..
How to show a friendly error message if Example.Reference is not equal to input value in textBox OR if no value is entered into the text field ?
Because am getting this error "{"Sequence contains no elements"}" when no value is entered or if any wrong value is eneterd. Can any1 tell me how to catch this error and show it as a friendly message to the user.
Thanks,
|
|
|
|
|
if (string.IsNullOrEmpty(textBox1.Text)) {
MessageBox.Show("Please enter some data.");
} else {
your code...
}
|
|
|
|
|
hi ,
Thanks for ur reply,
What if the user input invalid reference number which is not there in the database ..., how to catch that error.
Thanks ,
|
|
|
|
|
Use FirstOrDefault instead of First.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Thanks mate 
|
|
|
|
|
if (string.IsNullOrEmpty(textBox1.Text)) {
MessageBox.Show("Please enter some data.");
} else if (!IsValidInput(textBox1.Text)) {
MessageBox.Show("Not a valid input.");
} else {
your code...
}
Write a method IsValidInput that queries the database to find out if the input is valid and returns true or false accordingly.
|
|
|
|
|
Hi, I have a word document where I have put many shapes and equations. I am reading and modifying that document through the c# code. Now I need to hide/show those shapes according to different criteria. Can anyone let me know the solution.
Pankaj
|
|
|
|
|
Hi
I add a panel to my form in code behind.
how can i set background of panel in code behind?
how can i add this panel to my form in code behind?
THX alot
|
|
|
|
|
Try doing it in the designer and then looking at the code the designer generates.
However, remember to set the size and location as well. E.g. :
Panel mypanel = new Panel();
mypanel.BackColor = System.Drawing.Color.Red;
mypanel.Size = new System.Drawing.Size(100,200);
mypanel.Location = new System.Drawing.Point(10,10);
this.Controls.Add(myPanel);
If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
www.JacksonSoft.co.uk
|
|
|
|
|
Hi everyone...
I'm using an SQL Server Compact Edition
I can do all the queries without a problem but I cannot create a table.
in the runtime, when it comes to create a table, the line of the "ExecutNonQuery" gives an error:
"There was an error parsing the query [Token line number=1, Token line offset = 14]..etc"
I now that this kind of error appears when your SQL command syntax is wrong
can anybody tell me what is my fault?
string CreCom = "CREATE TABLE " + TCkim + YilBox.Text + " (Aylar nvarchar (10), Statu nvarchar (20), Odeme nvarchar (20), Servis nvarchar (20), Kiyafet nvarchar (20), Kitap nvarchar (20), Tiyatro nvarchar (20), Sinema nvarchar (20), Yemek nvarchar (20), Muze nvarchar (20), Piknik nvarchar (20), Parti nvarchar (20), Diger nvarchar (20), Yoklama nvarchar (20), Aylik nvarchar (20), Odenen nvarchar (20), Kalan nvarchar (20))";
SqlCeCommand CreateCommand = new SqlCeCommand(CreCom, conn);
CreateCommand.ExecuteNonQuery();
note: SqlCeCommand is the "SqlCommand" for Compact Edition. Usage is all the same
|
|
|
|
|
BTW
my CreCom string is created as below in the runtime:
"CREATE TABLE 444442009 (Aylar nvarchar (10), Statu nvarchar (20), Odeme nvarchar (20), Servis nvarchar (20), Kiyafet nvarchar (20), Kitap nvarchar (20), Tiyatro nvarchar (20), Sinema nvarchar (20), Yemek nvarchar (20), Muze nvarchar (20), Piknik nvarchar (20), Parti nvarchar (20), Diger nvarchar (20), Yoklama nvarchar (20), Aylik nvarchar (20), Odenen nvarchar (20), Kalan nvarchar (20))"
is there something wrong?
|
|
|
|
|
well,
I just found out that when I put an "a" to the beginning of the table name, this problem is no more
but still, thank you all =)
|
|
|
|
|
a table name is an identifier, it cannot start with a digit. Similar to most programming languages.
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
|
|
|
|
|
table A
Field: a(char(40)) b(char(40))
q -- ss
q -- fs
q -- ffr
q -- egg
w -- ffh
w -- gykk
e -- hrh
e -- kyk
e -- jjtj
the Purpose: field "a" as father node,field "b" as child node,field "a" should not be repeated!this is part of my code,but it can't meet my Requirements.
public void AddTree(TreeNode pNode)
{
DataSet ds=new DataSet();
DataView dvTree = new DataView(ds.Tables[0]);
foreach (DataRowView Row in dvTree)
{
if (pNode == null)
{ //add father node
TreeNode Node = treeView1.Nodes.Add(Row["a"].ToString());
}
else
{
TreeNode Node = pNode.Nodes.Add(Row["b"].ToString());
}
}
it only can show feild "a" on treeview,like this:
q
q
q
q
w
w
e
e
e it repeat the Field 'a',can someone help me ,thanks very much!!   always waiting online
|
|
|
|
|
Looking at the sample you've posted, pNode will always be null, hence the reason a is shown again and again. What you need to do is:
if (pNode == null)
{
pNode = treeView1.Nodes.Add(Row["a"].ToString());
}
else
{
TreeNode Node = pNode.Nodes.Add(Row["b"].ToString());
}
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
i want get the Results like
q(father node)
..ff(child node)
..grt
..trt
..hth
w
..trt
..fgh
..hth
e
..htj
..htr
..trt
..ht
which is your changed code shown:
q(father node)
..ff(child node)
..grt
..trt
..hth
..trt
..fgh
..hth
..htj
..htr
..trt
..ht
if do thisif (pNode == null){ //add father node pNode = treeView1.Nodes.Add(Row["a"].ToString());}else{ TreeNode Node = pNode.Nodes.Add(Row["b"].ToString());} pNode=null;
shown only father node like:
q
w
e
|
|
|
|
|
To be honest, your logic has more fundamental problems. You have two columns here which you are trying to work with, but the logic you have in the if/else only applies to one column level. What you could do is reimplement your logic like this:
foreach (DataRow dr in ds.Tables[0])
{
string colName = dr["a"].ToString();
TreeNode node = treeView1.Find(colName);
if (node == null)
{
node = treeView1.Nodes.Add(colName, colName);
}
node.Nodes.Add(dr["b"].ToString());
}What you are doing here is adding a node with a specific key into the treeview - and this key is the value of column a. You look for this node using the Find method and add it in if it doesn't exist. Finally, you add column b to the node.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
thanks for you,but when runing the code you have give me it shows:
"System.Windows.Forms.TreeView" does not contain a "Find" Definition?
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
