|
What the hell are you talking about ? What server name ? Is this an ASP.NET question ?
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
i have a project in c# and sql server and i have to make the server name in this project as a parameter how i make the end user to chose the server name to connect the project to the server database.
thanks for your efforts.
|
|
|
|
|
Hi there,
I’m trying to write a program that reads .xls file, formats it by removing specific rows and columns into table, sorts the data and then displays the data in dataGridView.
The .xls file is not formatted into table and in order to do that I need to delete 4 first rows and 2 first columns.
And here’s the problem when I’m trying to do that the program removes only 2 first rows and columns one and three instead of one and two. Here’s the code:
DataTable sampleDataTable = new DataTable();<br />
<br />
OleDbConnection aConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\file.xls;Extended Properties=Excel 8.0");<br />
<br />
aConnection.Open();<br />
<br />
OleDbDataAdapter oleDbCommand = new OleDbDataAdapter("Select * from [file$]", aConnection);<br />
oleDbCommand.Fill(sampleDataTable);<br />
<br />
dataGridView1.DataSource = sampleDataTable;<br />
<br />
dataGridView1.Columns.RemoveAt(0);<br />
dataGridView1.Columns.RemoveAt(1);<br />
<br />
dataGridView1.Rows.RemoveAt(0);<br />
dataGridView1.Rows.RemoveAt(1);<br />
dataGridView1.Rows.RemoveAt(2);<br />
dataGridView1.Rows.RemoveAt(3);<br />
I don’t know what’s wrong as I tested it several times by programatiacally counting coulumns and rows but it’s still not working. It does work when I format the file before opening it by the program though.
Hope that somebody will point me in the right direction.
Thanks, Darius
|
|
|
|
|
One problem I can see is that after removing a row at index 0, the row that was at index 1 is now at index 0 (everything gets shifted).
So you would want this I believe:
dataGridView1.Columns.RemoveAt(0);
dataGridView1.Columns.RemoveAt(0);
dataGridView1.Rows.RemoveAt(0);
dataGridView1.Rows.RemoveAt(0);
dataGridView1.Rows.RemoveAt(0);
dataGridView1.Rows.RemoveAt(0);
|
|
|
|
|
Thanks howlett,
I just tried it and it worked, so now I can move further. Thanks again, Darius
|
|
|
|
|
Can anyone help me how to navigate a web page which has frames using C#. I need to click on a hyperlink automatically on a particular frame within the table of a website.
Regards...
|
|
|
|
|
do you know the id of the link and the frame in which the link migh reside? if you do then you can access the link using window.frames[...].document.getElementById("....") and call its click method from there. I'd suggest though that you look into Jquery. It is rich Javascript framework that will be a part of Visual Studio 2010. It makes traversing and manipulating DOM elements very easy. More information on Jquery is http://jquery.com/
|
|
|
|
|
 Thankxx alot dear,, I'll try this approach 2day. Actually the link i wanna click exist in a Column of a table using MSHTML lib,, if u have any more ideas plz do share.
Regards
|
|
|
|
|
Hi guyz i am working on an ftp application need to know how to upload a file.
i am having a trouble at
Stream ftpstream = ftp.GetRequestStream();
error is
The remote server returned an error: (550) File unavailable (e.g., file not found, no access)..
|
|
|
|
|
GetRequestStream[^] on msdn with example to upload a file.
Dude this is the 4th time you ask this question, there are plenty of examples on the net; if you don't figure it out this time then maybe you should re-evaluate your entire code.
modified on Monday, March 30, 2009 4:32 PM
|
|
|
|
|
thanks man its really helpfull. 
|
|
|
|
|
Yeah that documentation, its a bugger, only wish they didn't hide it under the clever name of msdn[^]. If they only had a way of remembering it easily, as if the internet where a book and that would be a page and you could bookmark[^] it..
|
|
|
|
|
Hi guys!
I wonder if anyone can help me figure out a thing because I think my head will explode soon if I keep head butting my keyboard
The problem is:
I inject from C# a DLL (coded in C) into a process.
The injected DLL hooks Winsock and give recv/send packets back to the controller (the C# program) through SendMessage/WM_COPYDATA.
So far so good, it works flawlessy.
Now I have the inverse problem. How can I give data back to the DLL?
For example the controller receive a specific packet from the DLL and tells it how to act. I dont want to add too much things to the DLL but keeping it pretty simple/small and make the controller do the hard work.
Hope I explained my problem enough
Thank you all in advance.
|
|
|
|
|
Hi
I have Date Var in Oracle, and I try to insert Data from my C# program
sql = "insert into Table(MyDate) values (" + convert.todatetime(txt) + ")";
I get an Error, what can i do ?
|
|
|
|
|
E_Gold wrote: I get an Error, what can i do ?
If I were you, I'd post the error here.
E_Gold wrote: sql = "insert into Table(MyDate) values (" + convert.todatetime(txt) + ")";
Use parameters instead of concatenation[^]
|
|
|
|
|
it will be nice if u paste ur error msg here though i find a prob with your code. I just want to be sure
|
|
|
|
|
It would be even nicer if you didn't use SMSSpeak to write your posts.
|
|
|
|
|
What is the error?
I somehow feel it is related to conversion. Check if txt is a valid date.
जय हिंद
|
|
|
|
|
1) Oracle expects date to be in a certain format.
If your table name is MyTable with column MyDate, use bind variables to pass values. Do this:
sql = "Insert Into Mytable(MyDate) Values(:Date)";
OracleConnection conn = ...
OracleCommand cmd = conn.CreateCommand();
cmd.Parameter.AddWithValue("Date", Convert.ToDateTime(txt));
...
modified on Monday, March 30, 2009 2:44 PM
|
|
|
|
|
You can also use the 'TO_DATE(..)' function from Oracle SQL.
|
|
|
|
|
hi
writing another language in textbox whitout using system.globalization or api
this is may be????
???
??
?
.
|
|
|
|
|
You need the System.Globalization reference, there's no way about that, but it doesn't have to be too difficult.
First, the actual language has to be installed on the system, then you can do something like this:
InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(System.Globalization.CultureInfo.GetCultureInfo("ar-JO"));
This is how I localize a textbox to Arabic
If the post was helpful, please vote!
Why won't the worm just leave me be?
|
|
|
|
|
thanks but i know that
i want to write another language that not depend on to system.globalization
|
|
|
|
|
As far as I know, that would be impossible (without reverting back to some API, System.Globalization or otherwise) because they would not be installed on the system. Short of performing Malicious activity which would be installing said scripts/languages on the host system without their knowledge and then utilizing it, if you find out do tell please.
If the post was helpful, please vote!
Why won't the worm just leave me be?
|
|
|
|
|
behzadcp wrote: i want to write another language that not depend on to system.globalization
Why?
It comes as part of the .NET Framework so it is already there.
What is reason for the constraint that demands that you do not use System.Globalization?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
