|
Thanks Sebastian. Inheriting FileStream is a very good idea. I just finished an ugly for loop for that purpose but I will put you tip in use. 
Cheers.
modified 15-Dec-21 21:01pm.
|
|
|
|
|
Please help me with a code to set Page Margin (Left, Right, Top and Bottom) using Calc with C#
Thanks
modified on Tuesday, September 15, 2009 5:08 AM
|
|
|
|
|
I have found solution of my problem
public override void Margins()
{
XStyleFamiliesSupplier xSupplier = (XStyleFamiliesSupplier)_app.XSpreadsheetDocument;
XNameContainer xPageStyleCollection = (XNameContainer)xSupplier.getStyleFamilies().getByName("PageStyles").Value;
XPropertySet xPropertySet = (XPropertySet)xPageStyleCollection.getByName("Default").Value;
xPropertySet.setPropertyValue("LeftMargin", new uno.Any((Int32)1500));
xPropertySet.setPropertyValue("RightMargin", new uno.Any((Int32)1000));
xPropertySet.setPropertyValue("BottomMargin", new uno.Any((Int32)1000));
xPropertySet.setPropertyValue("TopMargin", new uno.Any((Int32)1000));
}
YES!!!
|
|
|
|
|
hi
I want set audio device dynamic from application.. Now we are used directx capture, That given capture a file ie) The audio get from audio device then store local system
, but we want opposite scenario... Want local system file to send audio device . How can we handle this... Give some idea or Article
Thanks....
|
|
|
|
|
Hi all..
If there any one know how to save input from window form c# to MS Access DB..
After that, I need to retrieve also.
Thanks in advance,
Kyi Kyi
|
|
|
|
|
You could look into SQL queries, parameterised queries, and the System.Data.OleDb namespace. The general sequence of events is something like this:
- Create OleDbConnection
- Put together an SQL query string (hopefully using parameters)
- Create a new DataAdapter, giving it the OleDbConnection and the query string
- Fill a DataTable from the DataAdapter
Then, you make your changes to the table, and Update the DataAdapter.
|
|
|
|
|
Thank you very much.. i will try like that.
|
|
|
|
|
Your Question is too Basic, i think if you can Google , you will definitely find an Answer. But that will be the last thing you should do. The First thing you need to do is to buy a Book , because is covered in any .NET book that has to do with Databases. You cant learn to program on Forums or on the internet. Buy a Book and read it and if you have questions about what you have read , then we can help.
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
you should search to google. if u not find then ask to forum.So try urself first.
happy coding
|
|
|
|
|
Hi,
use odbc;
c# Provide Ado.net , 'oledbconnection' ...
// for example to connect access
OleDbConnection conObj;
conObj = new OleDbConnection();
conObj.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; Data source = " + Application.StartupPath + @"\用户.mdb";
conObj.Open();
you can get help from google
modified 27-May-14 5:36am.
|
|
|
|
|
Dear Developers..
Greetings of the day.
I need to copy any file from any local machine to the Shared directory located on remote machine.
On Remote Machine,can i pass user name and password in Network Path
when I pass @"\\1.168.1.1\d$\MyDir"
it gives network path was not found..
Thanking you
modified on Tuesday, September 15, 2009 2:25 AM
|
|
|
|
|
What happens if you type that into your computer ? Are you using the same username/password you logged in as ? You need admin access to use D$ in a path.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Hi Christian Graus,
I user administrator username and password to access this path from my pc
actually i dont have rights on that directory so I shared that directory on remote pc.
now I am thinking to write admin username and pwd in my code so that it can be accessed by any pc.
Please tell me how to pass username and pwd with my network path.
Thanking you,
|
|
|
|
|
Hi,
i'm also working on same kind of process.
I want to access files from shared folder in network, but icould not able to access. below i give the code
void imperson()
{
try
{
try
{
DirectoryInfo Dir1 = new DirectoryInfo(@"\\192.168.100.251\StreamManager3\Current");
FileInfo[] FileList1 = Dir1.GetFiles("*.wav");
FileInfo getPrope1 = new FileInfo(@"\\192.168.100.251\StreamManager3\Current\" + FileList1[0].Name);
}
catch (Exception ex)
{
}
ConnectionOptions connec = new ConnectionOptions();
connec.Impersonation = ImpersonationLevel.Impersonate;
connec.EnablePrivileges = true;
connec.Username = "administrator";
connec.Password = "admin";
ManagementScope scope = new ManagementScope(@"\\192.168.100.251\root\cimv2", connec);
//scope.Path = @"192.168.100.251";
scope.Options = connec;
scope.Connect();
DirectoryInfo Dir = new DirectoryInfo(@"\\192.168.100.251\StreamManager3\Current");
FileInfo[] FileList = Dir.GetFiles("*.wav");
FileInfo getPrope = new FileInfo(@"\\192.168.100.251\StreamManager3\Current\" + FileList[0].Name);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
Can you help me whats wrong in the code
S. Ramkumar
|
|
|
|
|
i have to read the column names of excel file and list the column names in a column of grid control..hw can i do that?
|
|
|
|
|
What have you tried ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
|
|
i have bind dataset to my grid but data of excel is loading in grid instead i need to extract the column names and show them in grid and not data.
|
|
|
|
|
Are you capable of any sort of research ? Of writing any code ? Have you tried anything ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
yes i m loading excel data to data grid but i need to get column names of my excel file and load those column names in grid
|
|
|
|
|
Someone shoot me.
here[^]
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Come on Christian, what don't you understand? He just needs to get column names of his excel file and load those column names in grid 
|
|
|
|
|
Hi,
Give you a example. Hope it is helpful
/************************************************************
from Web
************************************************************/
private void Automation_CellByCell()
{
// Start a new workbook in Excel.
m_objExcel = new Excel.Application();
m_objBooks = (Excel.Workbooks)m_objExcel.Workbooks;
m_objBook = (Excel._Workbook)(m_objBooks.Add(m_objOpt));
// Add data to cells of the first worksheet in the new workbook.
m_objSheets = (Excel.Sheets)m_objBook.Worksheets;
m_objSheet = (Excel._Worksheet)(m_objSheets.get_Item(1));
m_objRange = m_objSheet.get_Range("A1", m_objOpt);
m_objRange.set_Value(m_objOpt,"Last Name");
m_objRange = m_objSheet.get_Range("B1", m_objOpt);
m_objRange.set_Value(m_objOpt,"First Name");
m_objRange = m_objSheet.get_Range("A2", m_objOpt);
m_objRange.set_Value(m_objOpt,"Doe");
m_objRange = m_objSheet.get_Range("B2", m_objOpt);
m_objRange.set_Value(m_objOpt,"John");
// Apply bold to cells A1:B1.
m_objRange = m_objSheet.get_Range("A1", "B1");
m_objFont = m_objRange.Font;
m_objFont.Bold=true;
// Save the workbook and quit Excel.
m_objBook.SaveAs(Application.StartupPath + "\\Book1.xls", m_objOpt, m_objOpt,
m_objOpt, m_objOpt, m_objOpt, Excel.XlSaveAsAccessMode.xlNoChange,
m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt);
m_objBook.Close(false, m_objOpt, m_objOpt);
m_objExcel.Quit();
}
private void Automation_UseArray()
{
// Start a new workbook in Excel.
m_objExcel = new Excel.Application();
m_objBooks = (Excel.Workbooks)m_objExcel.Workbooks;
m_objBook = (Excel._Workbook)(m_objBooks.Add(m_objOpt));
m_objSheets = (Excel.Sheets)m_objBook.Worksheets;
m_objSheet = (Excel._Worksheet)(m_objSheets.get_Item(1));
// Create an array for the headers and add it to cells A1:C1.
object[] objHeaders = {"Order ID", "Amount", "Tax"};
m_objRange = m_objSheet.get_Range("A1", "C1");
m_objRange.set_Value(m_objOpt,objHeaders);
m_objFont = m_objRange.Font;
m_objFont.Bold=true;
// Create an array with 3 columns and 100 rows and add it to
// the worksheet starting at cell A2.
object[,] objData = new Object[100,3];
Random rdm = new Random((int)DateTime.Now.Ticks);
double nOrderAmt, nTax;
for(int r=0;r<100;r++)
{
objData[r,0] = "ORD" + r.ToString("0000");
nOrderAmt = rdm.Next(1000);
objData[r,1] = nOrderAmt.ToString("c");
nTax = nOrderAmt*0.07;
objData[r,2] = nTax.ToString("c");
}
m_objRange = m_objSheet.get_Range("A2", m_objOpt);
m_objRange = m_objRange.get_Resize(100,3);
m_objRange.set_Value(m_objOpt,"objData");
// Save the workbook and quit Excel.
m_objBook.SaveAs(Application.StartupPath + "\\Book2.xls", m_objOpt, m_objOpt,
m_objOpt, m_objOpt, m_objOpt, Excel.XlSaveAsAccessMode.xlNoChange,
m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt);
m_objBook.Close(false, m_objOpt, m_objOpt);
m_objExcel.Quit();
}
private void Automation_ADORecordset()
{
// Create a Recordset from all the records in the Orders table.
ADODB.Connection objConn = new ADODB.Connection();
ADODB._Recordset objRS = null;
objConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
m_strNorthwind + ";", "", "", 0);
objConn.CursorLocation = ADODB.CursorLocationEnum.adUseClient;
object objRecAff;
objRS = (ADODB._Recordset)objConn.Execute("Orders", out objRecAff,
(int)ADODB.CommandTypeEnum.adCmdTable);
// Start a new workbook in Excel.
m_objExcel = new Excel.Application();
m_objBooks = (Excel.Workbooks)m_objExcel.Workbooks;
m_objBook = (Excel._Workbook)(m_objBooks.Add(m_objOpt));
m_objSheets = (Excel.Sheets)m_objBook.Worksheets;
m_objSheet = (Excel._Worksheet)(m_objSheets.get_Item(1));
// Get the Fields collection from the recordset and determine
// the number of fields (or columns).
System.Collections.IEnumerator objFields = objRS.Fields.GetEnumerator();
int nFields = objRS.Fields.Count;
// Create an array for the headers and add it to the
// worksheet starting at cell A1.
object[] objHeaders = new object[nFields];
ADODB.Field objField = null;
for(int n=0;n
|
|
|
|
|
Hi,
I had an application of BHo developed using Vs2005 c#.
I build a setup in Vs2005.
In the installation folder, I added my dll and Microsoft.Mshtml.dll. In the "Uninstallation" folder also, I added the same (my dll and Microsoft.Mshtml.dll).
while Uninstalling the is an error
"Exception occured while initializing the installation.
'System.IO.FileNotfoundException': could not load file or assembly "file:///C:\Program Files\ AB\SetupName\MyDll.dll' or one of its dependencies. The system cannot find the file specified."
How to solve this?
Now my setup is not getting "UnInstalled". I tried in many ways, but unable to remove it form my "Add or Remove Programs". How to remove this setup from my add remove programs.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
