|
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
|
|
|
|
|
Hehe, tried that already  Unfortunately, the CanFocus property is read-only. You also cannot override it in a derived class 
Another idea?
|
|
|
|
|
well what you could try in a derived class would be the setStyle method:
<br />
public class myFocusAvoidingSplitter:Splitter<br />
{<br />
public myFocusAvoidingSplitter()<br />
{<br />
SetStyle(ControlStyles.Selectable,false);<br />
}<br />
}<br />
hope that helps
greets
m@u
|
|
|
|
|
Thanks for the tip! The splitter doesn't get the focus any more after the sub-dialog is closed.
One problem remains, though. When clicking the splitter with the left mouse, it appears like this: Screenshot[^].
But I guess this can be solved somehow by handling the mouse events. Thanks a lot again!
|
|
|
|
|
Hi ,
Please give me some guidance.How can we extract characters from image(which is in JPEG format) using image processing algorithms and how to remove noise from image. Could u please tell us how to proceed to reach our requirement.
|
|
|
|
|
i smell something fishy...
I am a SysAdmin, I battle my own daemons.
|
|
|
|
|
|
JanapatiBalu wrote: Please give me some guidance.How can we extract characters from image
Using OCR.
JanapatiBalu wrote: which is in JPEG format
You can't do anything with the compressed file. You have to open the file so that you get the uncompressed data.
JanapatiBalu wrote: and how to remove noise from image
That can be done using the same technique as programs like Raw image converters and Neat Image uses. I doubt that it will remove the kind of noise that you are trying to remove, though.
JanapatiBalu wrote: Could u please tell us how to proceed to reach our requirement.
Build a program that noone in the world has managed to build so far.
I guess it would be much easier to build a clone of the system that you are trying to hack into, than it is to build the program that would hack into it.
---
single minded; short sighted; long gone;
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
