|
thanks my dear i create the following table
CREATE TABLE [dbo].[ProductsCategories](
[ProductCategoryId] [int] IDENTITY(1,1) NOT NULL,
[CategoryValue] [nvarchar](50) NOT NULL,
[DateSent] [smalldatetime] NOT NULL,
[ZOrder] [int] NOT NULL,
[Hide] [bit] NOT NULL,
[ArCategoryValue] [nvarchar](50) NULL,
[ParentId] [int] NULL,
PRIMARY KEY CLUSTERED
(
[ProductCategoryId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ProductsCategories] WITH CHECK ADD CONSTRAINT [FK_ProductsCategories_ParentId] FOREIGN KEY([ParentId])
REFERENCES [dbo].[ProductsCategories] ([ProductCategoryId])
GO
ALTER TABLE [dbo].[ProductsCategories] CHECK CONSTRAINT [FK_ProductsCategories_ParentId]
GO
ALTER TABLE [dbo].[ProductsCategories] ADD CONSTRAINT [DF_ProductsCategories_DateSent] DEFAULT (getdate()) FOR [DateSent]
GO
ALTER TABLE [dbo].[ProductsCategories] ADD CONSTRAINT [DF_ProductsCategories_ZOrder] DEFAULT ((0)) FOR [ZOrder]
GO
ALTER TABLE [dbo].[ProductsCategories] ADD CONSTRAINT [DF_ProductsCategories_Hide] DEFAULT ((0)) FOR [Hide]
GO
ALTER TABLE [dbo].[ProductsCategories] ADD CONSTRAINT [DF_ProductsCategories_ParentId] DEFAULT ((0)) FOR [ParentId]
GO
i need to create cascading dropdownlist from productscategories table based on parentId
|
|
|
|
|
Ok 3 things:
1. It might be a cultural thing, but don't reply to somebody calling them "dear" on the internet, it's kinda creepy (and might scare away people)
2. What are you using to create your page? ASP.NET?
3. I can't help you right now giving detailed information, but if you do a simple google search for cascading dropdownlists[^] you'll find that there's plenty of information out there (heck, the 4th link is another question here on CodeProject for basically the same stuff you want to achieve)
And another thing: I know your native language probably isn't English, still, read the sticky post in this forum (the second one from the top) on tips about how to write your question so it will be received with a better attitude and you will get more people to respond.
Always try stuff on your own first, and search for solutions on your own (i.e. Google search), if you show you've done some effort, it is more likely that you will get help.
If after googling you can't seem to make it work, come back and show us what you have done and what's the problem that you have.
If you think you can do a thing or think you can't do a thing, you're right - Henry Ford
Emmanuel Medina Lopez
|
|
|
|
|
Hi, I am currently sitting on a slight problem.
I want to create a Windows Metro Style Application using C# in visual studios.
There is one problem though, I have no idea how to create the GUI completely.
I currently have a blank app and I would like to add a new item, item being a grid page. I cannot seem to be able to do this, and I have tried everything. Once I can get that done, I would like to be able to move through pages, and this must be compatible with landscape and portrait views, also with docking and snapping.
Please Help!
Kind regards,
A Developer
|
|
|
|
|
Member 10033886 wrote: I have tried everything.
Including these[^]?
Use the best guess
|
|
|
|
|
Thanks a bunch, it didn't give me the answers completely but it set me on the right track.
|
|
|
|
|
Besides what Richard above linked, I would also recommend this book[^]
If you think you can do a thing or think you can't do a thing, you're right - Henry Ford
Emmanuel Medina Lopez
|
|
|
|
|
Start by reading some books.
|
|
|
|
|
i prefer using Microsoft Expression Blend for design, styles and applying graphic effects and then continue work on project in Visual Studio for coding.
also if you don't know about WPF, you must reading some educational resources[^] or you can use some available components about metro style like "Telerik Rad Control" which with them you don't need any more WPF. 
-Amir Mohammad Nasrollahi
/* LIFE RUNS ON CODE */
|
|
|
|
|
Sorry for the late reply, but thank you both very much, this helped me a lot and now I have a fully functioning Metro App up and going. It's a pity Microsoft is taking them down again though, I was just getting good at it.
|
|
|
|
|
I'm trying to design some classes that call base in the constructor. But I want to pass the derived class to the base class as it's parameter in the constructor. It's simple in C++ but I can't find a way to do it in C#. If anyone could tell me a way to convert the type in the constructor would help me keep my sanity.
public class CWebFormField
{
public CWebFormField(ref CWebFormField ff)
{
}
}
public class CWebRectFormField : CWebFormField
{
public CWebRectFormField(ref CWebRectFormField ff) : base(ff)
{
m_Rect = ff.m_Rect;
}
}
Because I try to pass ff to the base class I get an error of
Error 2 Argument 1: cannot convert from 'VSWebForm.CWebRectFormField' to 'ref VSWebForm.CWebFormField'
|
|
|
|
|
The problem is the ref requirement:
From the C# specification:
"When a formal parameter is a reference parameter, the corresponding argument in a method invocation must consist of the keyword ref followed by a variable-reference (§12.3.3) of the same type as the formal parameter"
http://www.jaggersoft.com/csharp_standard/17.5.1.2.htm[^]
And the problem is that your type isn't exactly the same type - it's derived. And you can't take a ref of a cast of a variable to prevent you from accidently changing the parameter to a different derived class from the same base and passing it back...
public void BuggerItUp(ref Control c)
{
c = new Label();
}
...
DataGridView dgv = new DataGridView();
BuggerItUp(ref (Control) dgv)
Do you really need the ref here?
The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)
|
|
|
|
|
|
You're welcome!
The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)
|
|
|
|
|
Is the idea behind your code a "copy constructor"? Then you might look at the IClonable interface and how to implement it in the .Net world.
|
|
|
|
|
It is. Thanks for the advice I'll check it out.
|
|
|
|
|
how to create a export xml file in SQL database using c# tnx..
|
|
|
|
|
There are a huge number of ways!
The easiest is to use a DataSet.
Easy write:
Create your data in a DataTable, then:
DataSet ds = new DataSet();
ds.Tables.Add(dt);
ds.WriteXml(@"D:\Temp\td.xml");
Easy Read:
DataSet ds = new DataSet();
ds.ReadXml(@"D:\Temp\td.xml");
dt = ds.Tables[0];
You can use DataTable.ReadXml instead, but it doesn't support schema inference, DataSet.ReadXml does.
The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)
|
|
|
|
|
Hi everyone,
My application was written in Visual Studio 2010.
After closing my application, there is still a running process that showed in the Task Manager.
Do you know, how to dispose all resources after I close my C# application ?
Thanks and regards,
Tai
|
|
|
|
|
taibc wrote: After closing my application, there is still a running process that showed in
the Task Manager.
Do you know, how to dispose all resources after
I close my C# application ?
All .NET objects will be disposed of by the runtime. Did you launch a (non-background) thread?
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Yes.
I found out a way to do that by use the statement:
Process.GetCurrentProcess().Kill();
Thanks and kind regards,
|
|
|
|
|
taibc wrote: Process.GetCurrentProcess().Kill();
Yep.... that will work.... if you do not want to do it correctly.
|
|
|
|
|
Actually, that'll leak resources, not close them.
|
|
|
|
|
Dave Kreskowiak wrote: Actually, that'll leak resources, not close them.
What resource do you think will be leaked after the Process exits?
|
|
|
|
|
Off the top of my head, anything that holds an unmanaged handle, such as GDI objects: Brush, Pen, Graphics, ...
That's by no means a complete list of the stuff that can be orphaned, just a sample.
|
|
|
|
|
I doubt that a Process will hold on to any of those when the Process exits, regardless of how it exits.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
