|
Thanks for the links, they seem to be helping quite a bit.
My issue at the moment is now figuring out how to load from a text box.
With
this.textBox1.Text = openFileDialog1.FileName; I am getting it to display my selected file, but I have a second button to confirm this file, is it possible to have the second button send the file to C# once the user has seen the directory of the file and confirmed it is the correct file? I feel like I'm looking at this the wrong way.
|
|
|
|
|
You now have the file name and path to open the file. This can be used to open the excel document using one of the libraries (I use Office Interop and agree with PIEBALD).
You should then use the libraries functionality to read the information into some structure you design to transfer the data to the email content which will be text.
The biggest problem with using excel is the users can change the excel file so reading in the data can be very difficult.
The issue with Office is that it is very version sensitive and MS have no compunction about breaking it when changing versions.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Dear community;
I need to run a FTP server in my programm written in c#. Is there any working lib for running a FTP server using c# which is able to support auth and the basic commands to transfer files in both directions? All I found doesn't work or would you suggest me to use a command line based FTP server for example "IndiFTPD" which I can controll via command line. Yes I need to run a FTP server not just download Files over FTP.
|
|
|
|
|
|
I don't want to right a FTP server lib aren't we all kind of lazy?
|
|
|
|
|
No, we aren't all lazy. Faced with something like this, I would
a. Write my own if I wanted the challenge
b. Actually search Google for details of things that match my criteria have already been written
c. Write my own because the result of b failed to turn up anything suitable
You failed to do any of these steps so, I suppose according to your own words, you're lazy.
|
|
|
|
|
Hello Everyone, I Was Working On My WPF Project & I'm Stuck In A Problem! I Have Two Form Names ViewProduct & Cart; I'm Creating An Instance Of Cart In The ViewProduct Form & Passing A DataSet Set To The Cart Class [Whose Constructor Is Overloaded & That Accept A DataSet]
Here Is My Code Of ViewProduct Form:
private DBConnect connection = new DBConnect();
private DataSet dataSet = new DataSet();
private BindingSource bindingSource = new BindingSource();
private Cart cart = null;
..... Some Stuff .....
Function In Which Cart Instance Is Created!
private void addCartBtn_Click(object sender, EventArgs e)
{
this.cart = new Cart(this.dataSet);
this.cart.Show();
foreach(DataGridViewRow row in this.dataGridView1.SelectedRows)
this.cart.AddProcudt(int.Parse(row.Cells["id"].Value.ToString()));
}
Cart Constructor:
public Cart(DataSet aDataSet)
{
this.dataSet = aDataSet;
this.bindingSouce.DataSource = this.dataSet.Tables["Product"];
this.dataGridView1.DataSource = this.bindingSouce;
bindingSouce.Filter = "id=0";
}
But I Get Error On The Following Line:
this.dataGridView1.DataSource = this.bindingSouce;
And The Error Is:
An unhandled exception of type 'System.NullReferenceException' occurred in ePurchase.exe
Additional information: Object reference not set to an instance of an object.
use the new keyword to create the instance of the object
On Calling Default Cart Constructor I Get No Error Because I Fill The dataset By Creating An Object Of DBConnect Class & Calling It's Method; Doing This I Get No Error But Calling 2nd Constructor I Get The Above Error!
Default Cart Constructor
public Cart()
{
InitializeComponent();
this.dataGridView1.AutoGenerateColumns = false;
DBConnect con = new DBConnect();
this.dataSet = con.GetRecord("Product");
this.bindingSouce.DataSource = this.dataSet.Tables["Product"];
this.dataGridView1.DataSource = this.bindingSouce;
bindingSouce.Filter = "id=0";
}
Also, In The Cart Form, I Initilized BindingSouce While Declaration & The Code Of Cart For Its Attribute Is As Follows:
private DataSet dataSet;
private BindingSource bindingSouce = new BindingSource();
private string purchasedItemId = "";
Can Anybody Please Help Me To Get Rid From This Error!
Thanks In Advance....!!
modified 23-Nov-14 13:31pm.
|
|
|
|
|
This is a very easy error to diagnose. Just step through the code in the debugger, line by line and hover the mouse over each variable. That will show you the contents of each variable.
Somewhere your code is assuming there is an object instantiated when there isn't.
|
|
|
|
|
As the error says it's a NullReferenceException.
Try to call the InitializeComponent() method in your overloaded constructor or just let it derive from your default constructor.
(A)
public Cart(DataSet set) { InitializeComponent(); }
(B)
public Cart(DataSet set) : this() { }
|
|
|
|
|
You Are Right..!!
This Is What A Silly Mistake I Made In My Project!
Sometimes, We Ignore Cases That Are So Simple To Understand But We Are Unable To Understand!
Anyhow, Thanks For Your Reply!
|
|
|
|
|
Dear community,
All I found via google were kind of examples how to use IIS under windows server. I am not working under windows server. I would like to redirect webrequests (port 80/443) if they matches to a domain/IP I specified to a new Domain/IP I specified too. I know I could edit HOSTS file, but I'm searching for another way how to do so. Is there any windoes file I could directly access using c# whitch supports redirects or did you've some ideas how to get this task done?
|
|
|
|
|
Your only other alternative is a separate proxy server. But, if you're doing this on a single machine connected to the internet, it's kind of pointless since it's easy to bypass a local proxy server and just go directly to the 'net with it.
All browser requests would go through this proxy and it can filter on whatever you want.
It's better to just go with an off-the-product than try to write your own.
|
|
|
|
|
First of all: whose traffic do you want to redirect? Some traffic originating somewhere in the web and requesting something from your web server? Or traffic originating from a web browser on that machine?
In the latter case, you can also use a proxy.pac script. That's essentially a JavaScript file with one function:
function FindProxyForURL(url, host)
{
if(dnsDomainIs(host, ".dirtypage.com")
{
return "your-redirection.com";
}
return "DIRECT";
}
|
|
|
|
|
Hi,
i am developing login page it contains Master page , masterpage contains login controls, after login i want to display User Name in content page(.ASPX)
How to retrive user name from Master Page control (Lable) and Display in aspx page.
using C#
Help me ..
Thanks
Aadi Kumar
|
|
|
|
|
|
Good morning. Lately I have started with C #, and emerged me some doubts. The main, and the only one I have to say for now is the design of the MenuStript.
I want to create a MenuStript like this:
http://oi61.tinypic.com/adk9wy.jpg
Who can help me with this problem?
Thank you
-- modified 23-Nov-14 9:48am.
|
|
|
|
|
Just add a MenuStrip control to your form from the toolbox in the Designer, and it's pretty obvious from there in - it even prompts you with "Type Here".
Then double click the menu options you need code for, and it will add the method skeleton for you.
If you try a basic google, it will find loads for you: Add Menu Strip C#[^]
examples, tutorial, videos. What more do you need? 
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Yes, but i refer the design xD! 
|
|
|
|
|
So get busy and create it. But, you'll need Win7 with Aero Glass to duplicate the visual aspects of the Window Frame.
«If you search in Google for 'no-one ever got fired for buying IBM:' the top-hit is the Wikipedia article on 'Fear, uncertainty and doubt'» What does that tell you about sanity in these times?
|
|
|
|
|
My brain and my Google skills are sucking this late at night.
Lets say I have a control height of 30 pixels
Lets say my data range is -5 to 15
I want to normalize my coordinates, but flipped in Y up fashion.
I.e. -5 is Y=29 on the screen, 15 is Y=0
Been googling transformation, coordinate systems, translation, etc. Lol, can't find a darn thing... I know this is simple math LOL.
Only thing I'm coming up with this late at night is +5 all the points to get to a 0 origin, * 0.66 to scale and then 29 - that... but that can't be right...
|
|
|
|
|
I am sure there is a proper mathematical way to do it, but this is what I figured out:
-5 to 15 = 0 to 20 is 21 'points'
0 to 29 is 30 pixels
thus
Y = ((y + 5) / 21 * 30) // transform 'points' to pixels
Y' = 29 - Y // flip down to up
|
|
|
|
|
Shouldn't that be done the other way round?
Y = ((y + 5) * 30) / 21 // transform 'points' to pixels Since all the values are given as integers (and are likely to be integers at source) doing the division first will not give you a good result.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Yes, but I tested it on my calculator and it worked fine. 
Actually, it would be better to use float values since Windows forms accepts them as co-ordinates.
|
|
|
|
|
So it's even unit tested? Ship it then!
It would be better to use floats, but you know and I know how few people round here think of that... 
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Hmm... seems more like this is the correct answer:
double Y = ((y + Math.Abs(dMin)) * (dHeight - 1)) / (dMax - dMin);
Y = dHeight - 1 - Y;
This works with:
lst.Add(0);
lst.Add(3);
lst.Add(7);
lst.Add(10);
With the commented and uncommented values.
dHeight = 30 (since the control is 30 pixels high, but the pixel range is 0 through 29)
With the original formula, the 0 would get to 29 correctly, but the 10 would only go to 1.72. With the -5 / 15 range, it would go to 0.43.
With this new formula, both ways got to 0 & 29.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
