|
Right click on Toolbox > Choose items > help yourself
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
|
hi, there is no concept of ActiveX in C#. the workaround for this -- Try this it will work (Register and Unregister)
namespace test{
[GuidAttribute("register with some guid ")]
[ProgId("Any string")]
[ClassInterface(ClassInterfaceType.AutoDual)]
public class ActiveXControl : System.Windows.Forms.UserControl
{
// ur code + constructor + all other stuff
[ComRegisterFunction()]
public static void RegisterClass ( string key )
{
StringBuilder sb = new StringBuilder ( key ) ;
sb.Replace(@"HKEY_CLASSES_ROOT\","") ;
RegistryKey k = Registry.ClassesRoot.OpenSubKey(sb.ToString(),true);
RegistryKey ctrl = k.CreateSubKey ( "Control" ) ;
ctrl.Close ( ) ;
RegistryKey inprocServer32 = k.OpenSubKey ( "InprocServer32" , true ) ;
inprocServer32.SetValue ( "CodeBase" , Assembly.GetExecutingAssembly().CodeBase ) ;
inprocServer32.Close ( ) ;
k.Close ( ) ;
}
[ComUnregisterFunction()]
public static void UnregisterClass ( string key )
{
StringBuilder sb = new StringBuilder ( key ) ;
sb.Replace(@"HKEY_CLASSES_ROOT\","") ;
RegistryKey k = Registry.ClassesRoot.OpenSubKey(sb.ToString(),true);
k.DeleteSubKey ( "Control" , false ) ;
RegistryKey inprocServer32 = k.OpenSubKey ( "InprocServer32" , true ) ;
k.DeleteSubKey ( "CodeBase" , false ) ;
k.Close ( ) ;
}
}
}
|
|
|
|
|
tanks
i am going to test it.
|
|
|
|
|
Hi, I want to create a custom textbox control in ASP.Net using C#, which extends the properties of the normal textbox control and it only allows numeric, alphabetic and alphanumeric characters depending upon the users choice. It should have a built-in client side validation for the same. Also, it should have a property called required, which when set to true, the text box also shows the property of the required field validator.
-----Have A Nice Day-----
|
|
|
|
|
assiduous wrote: Hi, I want to create a custom textbox control in ASP.Net using C#, which extends the properties of the normal textbox control and it only allows numeric, alphabetic and alphanumeric characters depending upon the users choice. It should have a built-in client side validation for the same. Also, it should have a property called required, which when set to true, the text box also shows the property of the required field validator.
-----Have A Nice Day-----
Well good for you. Let us know how you get on with that.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Combine all these and put it to one user control ? Now what problem u r facing ?
|
|
|
|
|
HI CODEPROJECT TEAM.
SOMEONE KNOW HOW INSERT A AUTONUMBER COLUMN IN EXCEL USING OLEDB?.
CONNECTION STRING EXAMPLE:
string cst;
cst="Provider=Microsoft.Jet.OLEDB.4.0;" +<br />
"Data Source=c:\\file.xls;" +<br />
"Extended Properties=\"Excel 8.0;IMEX=1;MaxScanRows=0;" +<br />
"HDR=YES\"";<br />
OleDbConnection conn = new OleDbConnection(cst);<br />
conn.Open();<br />
I NEED DO SOMETHING LIKE:
string SQL;<br />
SQL="ALTER TABLE [sheet1$] ADD [row_id] NUMBER NOT NULL AUTONUMBER";<br />
OleDbCommand cmd = new OleDbCommand(SQL, conn);<br />
cmd.ExecuteNonQuery();
THANKS IN ADVANCED.
SINCERELY.
ANTHONY ACUÑA
PREFERED PHRASE:
SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?
|
|
|
|
|
Sorry, I cant read CAPS.
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
AFAIK, Excel doesn't support autonumber columns. You'll have to use a database that does, like Access or SQL Server.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
You may have to *fake* an autonumbered column with a formula incrementing the value of the preceding cell.
imho, a person should stay away from anything complex in Excel. The next version may well break all your work -- and impose costs neither you or your clients are prepared to swallow. The more glorious your work, the more costly the *probable* catastrophe.
|
|
|
|
|
I want to compare 2 xml in c#. I have thw two documents loaded into two treeview. I would like to compare them showing the different and new nodes. I want to do something similar to the Source Safe file comparer.
Anyone can help me?
Thanks
|
|
|
|
|
Try to invoke command line and use the "fc" command
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
Hi all!!
I want to get the data types(int, varchar.. etc) of columns of sql server 2005 database tables, using c#.. pleaseeeee tell me how can i get that.. i've found various code samples but i cant remove the 100's of errors that are produced....
kindly reply if you know the solution...
I'm in deeep deeep sh*t..
|
|
|
|
|
hi,
Use FillSchema method of data adapter to get a data set with one table representing structure of the table returned by the SelectCommand. Then for each column in the Colums collection of the data table contained in the data set you can do whatever you want to do.
Hope the logic is clear.
"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder
coolestCoder
|
|
|
|
|
hmm.. yea the logic is clear... i'll try doing that and if i fail i'll ask you again...
thankss...
|
|
|
|
|
Hi,
I want to extract xml string from DataSet ( dset ) without create one file.
I try this:
Stream s = new MemoryStream();
dset.WriteXml(s);
How to do this?????
C# rules
|
|
|
|
|
Hi,
i'm not sure if there's an easier way of doing this. but here's what i would do:
<br />
MemoryStream blah = new MemoryStream();<br />
dset.WriteXml(blah);<br />
string xmlStuff = System.Text.Encoding.Default.GetString(blah.GetBuffer());<br />
greets
m@u
|
|
|
|
|
|
Hi,
Use the GetXML() method of dataset.
"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder
coolestCoder
|
|
|
|
|
Evrika!!!
Tks! My question was very stupid but i have not see the GetXML() method.
C# rules
|
|
|
|
|
I'm doing this coding and its running properly. This coding is to create a chart that can be drag and drop. I create the Panel as the bar. The panel will be generated depend on input. But the problem is the Panel is generated too many as it like there is nonstop loop. Can anyone solve this problem...plz
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
namespace CMSMS
{
public class mypanel:System.Windows.Forms.Panel
{
private bool isDragging=false;
public int x,y;
protected override void OnMouseDown(MouseEventArgs e)
{
base.OnMouseDown (e);
isDragging = true;
x = e.X;
y = e.Y;
}
protected override void OnMouseUp(MouseEventArgs e)
{
base.OnMouseUp (e);
isDragging = false;
}
protected override void OnMouseMove(MouseEventArgs e)
{
if (isDragging == true)
{
this.Left= e.X + this.Left - x;
this.Top = e.Y + this.Top - y;
}
}
}
}
using System;
using System.Drawing;
using System.Drawing.Imaging;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
namespace CMSMS
{
///
/// Summary description for GranttChart.
///
public class GranttChart : System.Windows.Forms.Form
{
...
private mypanel [] bar = new mypanel[60];
...
public void GenerateGranttChart()
{
GenerateChart();
}
private void GenerateChart()
{
for (int i = 0; i < 10; i++)
{
int xPosition = 100;
for (index = 0; index < 10; index++)
{
for (int j = 0; j < 10; j++)
{
DrawPanel( xPosition, yPosition,j,brush, length);
xPosition += length;
}
yPosition -= range;
}
}
}
private void DrawPanel(int X,int Y,int j,SolidBrush brush, int l)
{
bar[j]=new mypanel();
this.bar[j].Size = new Size(l,20);
this.bar[j].BackColor = brush.Color;
this.bar[j].Location = new Point(X,Y);
}
rotected override void OnPaint(PaintEventArgs e)
{
...
GenerateChart();
...
}
|
|
|
|
|
First thing that I see is that you have 1000 iterations of DrawPanel. You have three nested loops, so you get the following logic:
for each iteration of the outermost loop
for each iteration of the next loop
for each iteration of the inner loop
DrawPanel
end for
end for
end for
BTW - you have declared an array with a fixed size of 60, so you will get an overflow. You would be much better off declaring this as List<mypanel> bar = new List<mypanel> and then using this instead.
-- modified at 8:00 Friday 16th March, 2007
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hello!
I've got a main dialog with two splitters. The problem is that after opening and closing a sub-dialog, one of the splitters gets the focus.
Before opening a sub-dialog: Screenshot[^]. After closing the dialog: Screenshot[^].
How can I avoid that the splitter gets the focus?
Best regards
Dominik
|
|
|
|
|
Hi
set the canFocus Property to false, the splitter shouldn't get the focus then
greets
m@u
|
|
|
|