|
Hi Mate. It works fine. I missed something from your sample.
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
Okay 
- Stop thinking in terms of limitations and start thinking in terms of possibilities -
|
|
|
|
|
Mate, what if I have more than just the two columns??
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
It depends on your set of data. For example if I had 1000 random numbers in collection I would just increment iC column index. And when the column index hits 50 I would increment iR (row Index) and set iC (column Index) back to 1.
This is the code I used before for one my college projects. BUT KEEP IN MIND THAT IT HAS RANDOM NUMBERS ONLY. AND ORDER DOES NOT MATTERS IN THIS.
int iR, iC;
iR = 1;
iC = 0;
for (int i = 0; i <= Globals.Vars.arVbNums.Count - 1; i++)
{
iC++;
if (i % 30 == 0 && i != 0)
{
iR++;
iC = 1;
}
oSheet.Cells[iR, iC] = Globals.Vars.arVbNums[i];
}
But if you're dealing with something like, Data base where order of values matters you will have to stick to + operator. If you look at the code I gave you before it has something like [iR, iC+1] so you will just write something like [iR, iC+2] for next column.
- Stop thinking in terms of limitations and start thinking in terms of possibilities -
|
|
|
|
|
Hi
I m developing an application in C#. I m recording a video from Webcam and saving it on harddisk. it creates .avi file, which is very heavy file. so I want to convert it into .mpeg or any other format in which my video file is not as much heavy as .avi.
so plz tell me the solution or code for conversion.
Regardz
Shanzay
|
|
|
|
|
If you're looking for a full solution, and don't actually have a programming issue - gotta have actual code to have a programming issue right? - then you're far better off looking for bulk code on sourceforge.[^] You will probably have far better luck. Good luck.
Scott P
“It is practically impossible to teach good programming to students that have had a prior exposure to BASIC: as potential programmers they are mentally mutilated beyond hope of regeneration.”
-Edsger Dijkstra
|
|
|
|
|
Hi all.
I know i know first google then searching the forum and then ask stupid questions here we go:
I have a c# project which i can compile and run under Win2k. Now or company finally get XP ( yes  )
Now i got a second machine were i should test my systems. Now i can compile this application under XP but when i want to run the app
...this application has failed to start because the application configuration is incorrect...
error appears. I searched through the manifest and found nothing unusual.
[edit] I also went trough the app with the dependcy walker found the DWMAPI.DLL which could not be found any suggestions about that?
if you have any idea or article or any other clue please let me know
thanks
Mathias
modified on Friday, May 30, 2008 8:06 AM
|
|
|
|
|
hi
i want to report from my data with following code :
string htmText = System.IO.File.ReadAllText("Report\\report.htm");
htmText = htmText.Replace("[name]", this.txtName.Text);
htmText = htmText.Replace("[family]", this.txtFamily.Text);
htmText = htmText.Replace("[id]", this.txtStudentNo.Text);
this.webBrowser1.DocumentText = htmText;
this.webBrowser1.ShowPrintPreviewDialog();
it works good, but, at runTime, the printPreviewDialog has a button named 'HeaderFooter' that show header and footer info, is there any way to access HeaderFooter's text and change it by code ?
thanks
|
|
|
|
|
Hello,
I have a strange problem using typed datasets.
I have the following datatable in a typed dataset
ChainDetail
-----------
ChainID
Code
Description
I've populated an instance of the datatable with 2 rows loaded from SQL server.
Here's my problem...
When I either use DataTable.Select or create a DataView and apply a filter to retrieve one row, the select/filter work fine however the datarow returned has FOUR columns.
[0] contains ChainID
[1] contains Code
[2] contains {}
[3] contains Description
This means that I can't cast this to a ChainDetailDataRow, as column [2] should be Description.
Any help or suggestions will be much appreciated!
Thanks
A Very Confused Blakey404
|
|
|
|
|
Hi, how many columns are returned from the query that populates the datatable? if you're using 'SELECT * FROM...' change it to 'SELECT ChainID, Code, Description FROM...'
Perhaps you could post some of the code if this hasn't helped
"An eye for an eye only ends up making the whole world blind"
|
|
|
|
|
This is the strangest thing...
That is exacly what my query looks like, its in a stored procedure.
When i populate the datatable the three columns are there and correct...
its only when i create a dataview or use .Select that the extra colum is inserted into my results!!
i'm at home now but i will connect to work later on and give a code example...
cheers for the reply
|
|
|
|
|
I've just had a brainwave...
This datatable is populating a combobox, directly via databinding (datasource, datavalue etc)
To clear the combo box i am setting it's index to -1...
could this or something else related to the combobox be inserting my extra column?
i bet it is. crap that's going to be fun to find.
|
|
|
|
|
The databinding shouldn't be the problem here as that's very much a read-only action... then again, I've had all sorts of problems with the comboBox and datasource properties! Try removing the selection using .SelectedItem = null instead. Can you step through the code and find the point where the extra column is added?
Good luck! Rob
"An eye for an eye only ends up making the whole world blind"
|
|
|
|
|
Here's one for anyone to look out for in the future (i feel like an idiot)
the Description Column should really have been the "Name" column
therefore when i loaded the results into the dataset the name column was blank and the description colum was created
thanks for your help!
A very tired but enlightened Blakey404
|
|
|
|
|
Hi,
I have a Word table, I' ve read the values from this table to data grid. In the last column there is a long text which formatting is changing even within the same cell of table, for example the one part of text is bold, other italic, other underlined, other listed, and particular fragment has NormalStyle, Header 1, Header 2 etc instances of styles.
And my question is: how can I read programatically formatting of text from the single cell (or in general) in that way to be able to recognize the style.
Thank you very much for your help in advance. Each tip will be very helpful
|
|
|
|
|
try
{
// Server SvrNm = new Server();
// SvrNm.ShowDialog();
string line;
StreamReader sr = new StreamReader("Server.ini");
line = sr.ReadLine();
sr.Close();
string connString = "packet size=4096;data source='" + line.Trim() + "';user id='sa';password='';persist security info=False;initial catalog=uhtmch;";
//string connString = "Data Source='"+ line.Trim ()+"';Initial Catalog=uHTMCM;Integrated Security=SSPI;Pooling=False";
//string connString = "server='"+ line.Trim ()+"';database=uHTMCM;uid=sa;pwd=;Integrated Security=true";
conn = new SqlConnection(connString);
conn.Open();
}
Above is the code I wrote to connect to a SQL server database which is on the network(in another pc). The "Server.ini" file has the name of the pc in which the SQL Server ddatabase is running. But every time I run the code It says timeout, The server is not responding. How can I solve this problem?
|
|
|
|
|
try this...
using System.Data.SqlClient;
string ConnString = "User id = sa; Password = yourPassword; Initial Catalog = yourDataBaseName; Data Source = computerName";
SqlConnection sqlConn = new SqlConnection(ConnString);
sqlConn.Open();
SqlCommand cmd = sqlConn.CreateCommand();
cmd.CommandText = "SELECT column FROM table";
SqlDataReader reader = cmd.ExecuteReader();
while(reader.Read())
{
string someVariable = reader[0].ToString();
}
sqlConn.Close();
Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
think BIG and kick ASS
you.suck = (you.passion != Programming)
|
|
|
|
|
Thank you Harvey.But It's not working. Still same problem.
|
|
|
|
|
im thinking theres a firewall on the PC running the SQL server, i had the same problem before...
you need to either disable the firewall, or enable sql's default port (i think it 1433) so the firewall will let the connection through
hope it helps
Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
think BIG and kick ASS
you.suck = (you.passion != Programming)
|
|
|
|
|
Thank You Harvey. 
|
|
|
|
|
Its a pleasure, did it work?
Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
think BIG and kick ASS
you.suck = (you.passion != Programming)
|
|
|
|
|
Sorry I was out of here for sometime. And thank u that did work. I turned off the firewall of that pc. Now it's working.
Thank u once again
|
|
|
|
|
|
|
Hello everyone,
Here is my OnStop method of Windows service application. When click stop, the error message is, "Error: 1067 The process terminated unexpectedly".
I have tested if remove the Join method, the service can stop gracefully. Does it mean Join method is not allowed to be called in OnStop method of a Windows service? Any ideas?
protected override void OnStop()
{
MyWorkerThread.Join();
this.ExitCode = 0;
}
thanks in advance,
George
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
