|
Hi.
The DataColumn class exposes a DefaultValue property that you should be able to use.
Example:
DataTable table = new DataTable("SomeTable");<br />
table.Columns.Add("Column1", typeof(string));<br />
table.Columns.Add("Column2", typeof(string));<br />
<br />
table.Columns["Column1"].DefaultValue = "Foo";<br />
table.Columns["Column2"].DefaultValue = "BlahBlah";
If you were to execute the code above, then add a row to the table it creates, the row's Column1 value would be preset to "Foo" and the Column2 value would be "Blah".
Hope this helps,
The most exciting phrase to hear in science, the one that heralds the most discoveries, is not 'Eureka!' ('I found it!') but 'That's funny...’
|
|
|
|
|
This is indeed a solution, but I wanted to avoid putting these default values into my program. That's why I've filled in these values while creating my SQL table.
So I was hoping for a trick to get/read these values into the program.
Can I retrieve default values from a database using Stored Procedures?
Thanks
|
|
|
|
|
The example I provided was simply to indicate that default values were available at design-time for the System.Data.DataColumn class.
If you want to determine the characteristics of columns in your database at runtime, there are a number of ways to do it. You could use SQL to inspect the system tables in your database directly or you could use something like System.Data.OleDb.OleDbConnection.GetOleDbSchemaTable to retrieve tons of information about your physical database.
For instance, to retrieve column info, you might use (where conn is an OleDbConnection):
DataTable columnInfo = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[4]{null, null, "MyTable", null});
The call uses the OleDbSchemaGuid class to specify the type of database object you're trying to fetch information about, and the object array is a list of restriction values (like a filter) that determines which specific instance(s) of the database object type you want to investigate.
Best of luck.
The most exciting phrase to hear in science, the one that heralds the most discoveries, is not 'Eureka!' ('I found it!') but 'That's funny...’
|
|
|
|
|
Hi,
I need to have UI more or less same as VS .NET editor.
It should have panes as "Solution explorer", and "Output Window".
The toolbars and the menus should be the same as .NET editor.
If anyone has any sample code, will be very helpfull.
Thanx in advance
Saleem.
|
|
|
|
|
Tremble in awe at the power of the almighty Google! SharpDevelop[^], an open source .NET IDE.
In all seriousness, this really isn't the place for this kind of post. The CodeProject community is happy to help with a specific issue that you're having while working on your application, but please don't post asking someone to find you code that matches your requirements. If you are just looking to "borrow" from others, please, at least, do your own searching of Google, the articles, and message boards. If none of those help, you may wish to try Rent-A-Coder[^].
--Jesse
|
|
|
|
|
You might want to take a look at DotNetMagic[^]
"I think I speak on behalf of everyone here when I say huh?" - Buffy
|
|
|
|
|
I have a radio button.On click of that radio button ,the text box present should be enabled.
I found that no click event is available for the radio button.
pls help
Sukanya
|
|
|
|
|
You should use the CheckedChanged property.
ex:
RadioButton1_CheckedChanged(object sender, System.EventArgs e)
{
if (RadioButton1.Checked == true)
{
TextBox1.Enabled = true;
}
}
Paul Lyons, CCPL Certified Code Project Lurker
|
|
|
|
|
This did not work
pls suggest something
there is no click event for the server side control
what to do?
Sukanya
|
|
|
|
|
Ah ha... You didn't say you were using it on a WebForm.
Have a look at this[^].
Note that the control does not immediately cause the page to post back to the server by default. You need to set the AutoPostBack property to true for an immediate reaction to it's change in state.
Hope this helps you.
Paul Lyons, CCPL Certified Code Project Lurker
|
|
|
|
|
You could use the mouse down event - you can use the MouseEventArgs parameter to test which mouse button was used.
|
|
|
|
|
itssuk wrote:
I found that no click event is available for the radio button.
Where did you found that info? The
MSDN topic[^] of the RadioButton lists the Click event and it's also available in the Visual Studio form designer.
www.troschuetz.de
|
|
|
|
|
I have been trying and looking everywhere for a way to replace the TreeView control default plus and minus signs with customized images. Can it be done?
Elie
|
|
|
|
|
Hey!
I have created a Windows Control Library
I have built this and added the dll file to my main project
This workt well, but when i closed and then started upp my main progject again the control was not visible in the form?
And i got the folowing errors (menuPanel1 is my dll control)
C:\ForumProject\ForumClient\ForumClient.cs(324): The variable 'menuPanel1' is either undeclared or was never assigned.
An exception occurred while trying to create an instance of ForumClient.MenuPanel. The exception was "Invalid parameter used.".
But i can run the program and then the control is visible?
I have tryed to rebuild the control and add it to the project, but i get this message when i am draging it to my main form
An exception occured whule trying to creat an instance of Forum.MenuPane. Exception was "Invalid parameter used.".
My construkter in the control looks like this
public MenuPanel()<br />
{<br />
InitializeComponent();<br />
<br />
}
and The automated code to create it looks like this
private MenuPanel menuPanel1;<br />
<br />
private void InitializeComponent()<br />
{<br />
this.menuPanel1 = new MenuPanel();<br />
<br />
this.menuPanel1.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("menuPanel1.BackgroundImage")));<br />
this.menuPanel1.Location = new System.Drawing.Point(0, 0);<br />
this.menuPanel1.Name = "menuPanel1";<br />
this.menuPanel1.Size = new System.Drawing.Size(272, 568);<br />
this.menuPanel1.TabIndex = 6;<br />
<br />
this.Controls.Add(this.menuPanel1);<br />
}
Ples help me with this
Best Regards
Jimmy
|
|
|
|
|
I have mange to fix this problem.
I hade the folowing
Bitmap imageOne = Bitmap.fromfile("tools//pictures//test.bmp");
locataed first in the class and this dident work.
Have changed it to store only the string of the pach, and when the image is needed it will load it.
//Jimmy
|
|
|
|
|
hai friends,
i want to drag an image from one picturebox and drop it on another.i tried it with dragdrop events of pidtureboxes. but it is not working. please any one can help me?
regards,
rathish
|
|
|
|
|
Hey
I am developing a simple Client program and i have made an Windows Control Library(DLL file) that i am adding to my client.
AnyWay This Control contains a Bitmap picture that is 272x600 wit 3 buttons on it with is 202x36, all is BMP.
When moving other Windows ower my Client(where the Bitmaps is) thay are updated wary slow? Is there any easy way to make it go faster?
I am loading all pictures in to Bitmaps object on startup and then adds them to the right controls.
Best Regards
Jimmy
|
|
|
|
|
|
Thanks
i have added the following line ni bouth the MainClient(project) and Windows Control Libraray(the control) in theres cunstructer:
SetStyle(ControlStyles.AllPaintingInWmPaint | ControlStyles.DoubleBuffer | ControlStyles.UserPaint, true);
But this dosent do anything. When i am moving an other window ower the bitmaps the window that i am moving over is lagging on the bitmap creating alot of windows, and it take about 1 sec before the bitmap is updated and the Window crap on the bitmap is over painted.
Im i doing any wrong ? shold i not be abled to move a Window over my project with a bitmap in with out this problem?
Best Regards
Jimmy
|
|
|
|
|
Try calling the method inside of an event handler for the Load event and add a call to the UpdateStyles method, which forces the assigned styles to be reapplied to the control.
www.troschuetz.de
|
|
|
|
|
Do you mean that you could call this in the contructer of my Main project
SetStyle(ControlStyles.AllPaintingInWmPaint | ControlStyles.DoubleBuffer | ControlStyles.UserPaint, true);<br />
this.UpdateStyles();
This does not changes
Or how do you mean i shold add it?
|
|
|
|
|
I'm not sure if it's sufficient, if you call it only in your main project. I never used double buffering myself (never needed too), but it was sometimes mentioned in this forum when talking about flickering or drawing problems.
But I'm pretty sure that placing the code inside the constructor won't have any effect cause the documentation for the UpdateStyles method states that "The UpdateStyles method has no effect if the IsHandleCreated property value is false.", which is the case during construction. So try moving it into an event handler for the Load event.
www.troschuetz.de
|
|
|
|
|
Thanks!
I have tryed your ide and it siems to work a little.
But the buttons and so on that is placed on the bitmap is steal lagging alot, when moving window over them.
Do i realy have to make my own buttons and use this Style on them?
|
|
|
|
|
I'm glad that I could help a bit
Unfortunately I can't answer your last question cause as I said I've never used double buffering myself and therefor haven't that much experience and knowledge. Sorry.
www.troschuetz.de
|
|
|
|
|
I have a solution that I have created using .Net remoting and am having a lot of trouble upgrading it to use events.
The solution uses a remote singleton object which I'm hosting with my own server. A requirement of the solution is that the remote object's assembly must remain seperate from the client so I am using an interface.
I have created a seperate assembly so that it can be referenced by both the client and the remote object's assemblies. This new assembly contains a single class that implements the Activator.GetObject method and subscribes to the remote event. After a little playing around with the formatter sink classes I can instantiate this class from the client application and it seems to successfully subscibe to the remote event (or at least it no longer throws exceptions). However the client side event handler is never called. I have implimented tracing on the server side to ensure that the event is being raised and event handlers are working there.
Does anyone know where I'm going wrong?
|
|
|
|