|
hi here is my code in this i give the file name and sheet name and display the sheet in gride but my client want to open any excel file dynamically. Need a help,
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Microsoft.Office.Core ;
using System.Data.OleDb;
using Excel;
using System.Reflection;
using Microsoft.Office.Tools.Excel;
namespace WindowsApplication2
{
public partial class Form1 : Form
{
Excel.Workbook wb;
Excel.Worksheet ws;
public Form1()
{
InitializeComponent();
//wb = new Excel.Workbook();
// ws = new Excel.Worksheet();
}
private void button1_Click(object sender, EventArgs e)
{
string filename = @"C:\mangesh1\mor\abc.xls";
String connectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + filename + ";" +
"Extended Properties=Excel 8.0;";
OleDbConnection connection = new OleDbConnection(connectionString);
connection.Open();
//String connectionString="Provider=Microsoft.Jet.OLEDB.4.0;"+"Data Source="+filename +";"+"Extended Properties=Excel 8.0;";
OleDbCommand selectCommand = new OleDbCommand ("SELECT * FROM [sheet1$]", connection);
OleDbDataAdapter dataAdapter = new OleDbDataAdapter();
dataAdapter.SelectCommand = selectCommand;
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
System.Data.DataTable dataTable = dataSet.Tables[0];
dataGridView1.DataSource = dataSet.Tables[0];
MessageBox.Show(dataGridView1.RowCount.ToString());
connection.Close();
/* openFileDialog1.ShowDialog();
openFileDialog1.ShowDialog();*/
// return sum;
// directorySearcher1.FindAll();
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void openFileDialog1_FileOk(object sender, CancelEventArgs e)
{
//openFileDialog1.ShowDialog();
}
}
}
|
|
|
|
|
I want to download a file from server, I can do it with c# and webcliet method by connecting http
But What are the basic flow if I use HTTPS
Can you please give basics on how to connect and download files
If i use same code as HTTP connection, I am getting error like
Could not establish trust relationship for the SSL/TLS secure channel
Thanks in advance
PRabhakar
|
|
|
|
|
Hi
I am displaying a collection of objects in a datagridview by setting the datagridview's datasource to the collection property.
It works well, but now i want to display one of the properties as a combobox and not as a text field. I have found examples where one manually adds a new column and then setting it as a combobox, but nothing where the columns are automatically set from the properties of the object. Hope i make sense.
|
|
|
|
|
you have to manually add the ComboBox column.
try this
DataGridViewComboBoxColumn DGVcombo = new DataGridViewComboBoxColumn();
DGVcombo.HeaderText = "Combo Column";
DGVcombo.Name = "AnyName";
dataGridView.Columns.Add(DGVcombo);
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKQUFK[M`UKs*$GwU#QDXBER@CBN%
R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia> -----------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
Hi Guru,
I'm a newbie in C#, as i know i can get the MSIHANDLE by call MsiOpenDatabase from Win32 SDK, can i call this function directly or there is a better way to get MSIHANDLE.
|
|
|
|
|
Your best bet is to p/invoke the Win32 call.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
As has already been said, you could use PInvoke. However, I think you could also add a COM reference to Microsoft Windows Installer Object Library and work from there (msi.dll or something like that)
|
|
|
|
|
I have a little app that will resize its main form when data is loaded. Sometimes I need to move the form so it remains entirely visible on the screen.
If the mouse cursor happens to be over a particular control when that happens I would like to move the mouse cursor so its position relative to the top left of that control remains constant. I can only seem to get the mouse location relative to the top left of the screen and I can only seem to get the control position relative to the top left of its parent.
Back in my MFC days there were two methods ClientToScreen and ScreenToClient that would convert between positions relative to the top left of screen and top left of the controls client area. Is there an equivalent in dot net?
|
|
|
|
|
Your control and window classes have a PointToScreen and PointToClient method.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
I have a c# winforms app (must be a win app - responds to windows events) that accesses a web server side DB through a web app using a .ashx http handler that queries the DB into a dataset then coverts the dataset into XML and sends it back to the client.
My hosting service does not allow a remote DB connection (is this typical?) so I must do it this way.
Getting the server data into the client dataset is easy enough (ds.readXML) but is there an easy way to send back inserts/updates/deletes in the local dataset without coding all the SQL?
I know I can set up the generic insert/update/delete sql commands on the local DS but is there a way to get the actual resulting SQL statements and sent them to the server? or send the DS back as an object (the XML conversion loses the meta info on changed/inserted records)?
|
|
|
|
|
http://www.pcreview.co.uk/forums/thread-1237619.php[^]
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia> -------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
Thanks Xmen - but this is what I'm trying to avoid. I'm dealing with 5 or 6 tables and I was hoping to take advantage of the built in updating features of the DS as if it were local DS <-> local DB. It's early in development so I don't want to hard code field names for 5 tables. What I want to do just might not be possible.
|
|
|
|
|
did ya read full topic...I think there may be a solution
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKQUFK[M`UKs*$GwU#QDXBER@CBN%
R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia> -----------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
It's not exactly what I was looking for but it did lead me to Diffgrams (http://msdn.microsoft.com/en-us/library/ms172088(VS.80).aspx) which is exactly what I was looking for.
This converts the DS to XML including the DS meta data on updates/inserts/deletes
Thanks for the nudge in the right direction.
|
|
|
|
|
Hi, Sorry if i am posting in the wrng place, this is a general ques. I am doing an SMS application that communicates with the COM port, i want to use my O2 zinc phone as a modem, but whenever i connect the phone activesync use usb connection to connect, in the device manager also there is no COM port appear when i connect, so how can i use COM port with this O2 Zinc phone? (The cd comes with the phone also doesn't have any drivers for this purpose, internet also i searched and find no result  . Please help me with this..
|
|
|
|
|
i used DSOFile to read and Write File Summary infor....it successfully can work... but i having a problem....i can run application only on my pc when i try to install in another PC. System asking to install OLEdocument.....etc.....is there got any way to slove this problem....either by change codes.....
here is my code...
foreach (ListViewItem item in listView2.SelectedItems)
{
FileInfo fileInfo = new FileInfo(item.Text);
string image = "C:\\PhotoManager\\" + fileInfo.Name;
DSOFile.OleDocumentPropertiesClass file = new DSOFile.OleDocumentPropertiesClass();
file.Open(image, false, DSOFile.dsoFileOpenOptions.dsoOptionOpenReadOnlyIfNoWriteAccess);
{
tbxFileName.Text = file.Name;
tbxTitle.Text = file.SummaryProperties.Title;
tbxSubject.Text = file.SummaryProperties.Subject;
tbxAuthor.Text = file.SummaryProperties.Author;
tbxKeywords.Text = file.SummaryProperties.Keywords;
tbxComments.Text = file.SummaryProperties.Comments;
file.Close(false);
}
}
A S E L A
modified on Monday, March 16, 2009 9:11 PM
|
|
|
|
|
I would assume that you have a reference to the DSO stuff in your project. Make sure it is marked "copy local" otherwise it will not be deployed.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi,
I have a ReadOnlyObservableCollection<t></t> being returned in an AsyncCompletedEventArgs derived object. Is there any way in the get; accessor to automatically pass it back to the original thread without having to use the Dispatcher in the callback method?
At the moment I'm doing this:
void SyncCompletedCallback(object sender, SyncJobCompleteCallbackEventArgs args)
{
Dispatcher.BeginInvoke(DispatcherPriority.Normal, (ThreadStart)delegate
{
ReadOnlyObservableCollection<synceditem> history = args.SyncJobHistory;
HistoryView.ItemsSource = history;
});
}
</synceditem>
I'd rather let consumers have easy access to the collection like:
void SyncCompletedCallback(object sender, SyncJobCompleteCallbackEventArgs args)
{
HistoryView.ItemsSource = args.SyncJobHistory;
}
Thanks,
|
|
|
|
|
I am working on a touch screen application and I am trying to add a button(s) that function as pageup/pagedown on a MDI Parent form with the child forms as the items to scroll.
I've spent entirely way too much time scouring the internet for a solution to this. I've tried multiple items that I thought would be the answer to no avail.
I really thought that this would be the answer:
SendMessage(this.Handle, WM_VSCROLL, (IntPtr) SB_PAGEDOWN, IntPtr.Zero);
I know I'm close, but then again, I could be way off!
Ideas?
I guess no one has a solution for this...
For those who are wondering...
Given the scope of the project and the fact that I had to use a MDI parent and children (specs from customer)and buttons to scroll (touch screen app), I used a method to give the appearance of scrolling by setting the location of each form in a foreach loop. It moves the forms as if it were scrolling.
modified on Wednesday, March 18, 2009 9:22 AM
|
|
|
|
|
Hi All,
I'm just wrapping up some functionality in a class that uses some third party components under the hood. My wrapper object by default subscribes to some events on the third party components and forwards them on to consumers of my wrapper class.
In general I would expect consumers to subscribe to these events most of the time, however, I can't always assume that and I also want to optimise my wrapper. What is the general consensus on coding around this? At the moment I always subscribe to the third party events and then each time one of these events fires I check to see if the event handler is null before forwarding on the event.
Is there a better pattern for this?
|
|
|
|
|
If you're using delegates, your choices are
1 - check if it's null and if so, do nothing and
2 - check if it's null and if so, throw an exception.
Depends on if you want to force your clients to subscribe to the specific event.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi Christian,
I've already implemented option 1 as I didn't want to needlessly throw exceptions. Although I wasn't sure this was the best way.
Thanks,
|
|
|
|
|
Another option... If the methods in the wrapped class that raise the events i.e.
OnSpecificEvent(MaybeDerivedEventArgs e)
are protected virtual, then you can override them and fire your own events from your override methods so the original events will never get fired, only yours.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
|
|
|
|
|
Hi all
Can anyone tell me how to refreash an array;
I mean lets assume an array with some values.
Now I just want to clear all the contents of array by clicking a button.
That button will have the code like array.refreash....something like that I dont know.
I dont want to clear the array by using for loop to putting all array address(0-20) null.
Is there any way to do it.
Pls reply me
Thanks 
|
|
|
|
|
You're looking for the Array.Clear static method
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
