|
Hi Everyone,
i need the C# code for exporting data in excel sheet to XML file.
Kindly help me out.
Thanks,
Srikanth
|
|
|
|
|
You can accomplish this using Excel object library and few lines of code
|
|
|
|
|
ok please let me know the code.
Thanks,
Srikanth
|
|
|
|
|
Excel object library exposes methods for opening excel files and saving them to the format you specify. If you explore Excel object library using object browser you will be able to identify those methods. No one is going to write instead of you.
|
|
|
|
|
Hi,
I am trying to print a file. The file can be word, ppt, xls etc etc.
Instead using the COM objects i want to print the required file, so i thought i would open the file through binary reader and then send the bytes to the printer thereby printing the required file!
Is there any other way? To print the required file
The printer setting are set in a way that the file after print would be saved in a default location!
gauthee
|
|
|
|
|
In order to print directly to a printer, you have to send native codes in the language of the printer. This is all done for you in the background via the windows printer drivers. So, unless you have specific knowledge of each printer your application is going to use, use the windows print drivers.
If you try to send a word file directly to the printer, nothing will happen.
Hogan
|
|
|
|
|
gauthee wrote: i thought i would open the file through binary reader and then send the bytes to the printer thereby printing the required file!
And in each and every case, you'll be printing pages and pages of complete garbage. You can NOT just send what the application saved to disk to the printer and expect a nice image to appear on the paper. The printer doesn't know anything about any applications file format and applications don't save their files as a nice printed image on disk.
|
|
|
|
|
Hi
I m sending a large file using streaming.I want to read the no. of bytes recieved in my recieved buffer. As buff.length give the size of buffer, it doesn't specify the no. of bytes read. SO plz tell me any method for it ASAP.
Regards.
Shanzay
|
|
|
|
|
Maybe:
FileStream myFS = new FileStream(filename, FileMode.Open, FileAccess.Read); BinaryReader myBR = new BinaryReader(myFS);
byte[] outData = new byte[myBR.BaseStream.Length];
for (int x = 0; x == myBR.BaseStream.Length; x++)
outData[x] = myBR.ReadByte();
gauthee
|
|
|
|
|
Hi,
(1) Is there any reason why I have to click three times on the dropdown button of a DataGridViewComboBox before the dropdown list actually gets displayed?Is it the Control property that an user needs to click thrice.
(2) We want that the items list should be made visible by clicking it once. And then by next click the item should be selected. Please let us know how to achieve it.
Thanks & Regards,
Rudra
|
|
|
|
|
I have file I want to transfer it from pc to another via modem the problem is I want to make the procedure on one button click. one in the sender side to send the file and another on the receiver side to receive the file.
I think it would be possible to do it depending on hyper terminal but i couldn't find way to run hyper and work on it on c# project ?
if any body can help on this way or another ?
best regards
sam
|
|
|
|
|
Hi
I have a problem with load WSE 3.0 to ma project in Visual Studio 2005 (C#).
I am doing liki in this site: http://dotnetslackers.com/articles/aspnet/GettingStartedCreatingWSEEnabledWebService.aspx
and
http://www.15seconds.com/issue/040603.htm
but when I right click on the asp project I don't have WSE Settings..
" Step 1
Right click on the web service project http://localhost/DocumentLibraryService and select WSE Settings 3.0… from the context menu.
"
I installed WSE3.0 with opiton for Visual Studio Developer and I have it in the start menu, but I don't have in the my project. I must set several option that add to the web.config but how I do it ?
Best regards
difit
I
|
|
|
|
|
How do I make textbox (or label) to have a value, who
is increment for 1, every time when I put some
data in database?
For exaplme, textbox had a value=1!
When I press button, ex: Insert data,
the data are inserted in database, and
textbox then, should have a value 2!
Like a sequence number, I need for
inserting data in database, but I don't user
to enter this, number, instead, the number to
increment it self, when I press button, ex: Insert data,
and, value of that textbox to go in database...
Thank you!
kpp
|
|
|
|
|
KppsK wrote: How do I make textbox (or label) to have a value, who
is increment for 1, every time when I put some
data in database?
For exaplme, textbox had a value=1!
When I press button, ex: Insert data,
the data are inserted in database, and
textbox then, should have a value 2!
Like a sequence number, I need for
inserting data in database, but I don't user
to enter this, number, instead, the number to
increment it self, when I press button, ex: Insert data,
and, value of that textbox to go in database...
You have a counter somewhere. In your button handler for the insert you increment the counter and update the Text property of the TextBox.
|
|
|
|
|
just keep your textbox's enabled property = false...
and in the click function of the button
write this
private void button1_Click(object sender, EventArgs e)
{
int i = int.Parse(textBox1.Text) + 1;
textBox1.Text = i.ToString();
}
Kuldeep
|
|
|
|
|
Well - first of all, the database must support an autoincrement. Then, you need to get this value back. If it's SQL Server, then you are in luck because you can use the Scope_Identity in the same command to retrieve the value just inserted. Ideally, you would do this in a stored procedure. For instance:
CREATE PROCEDURE [dbo].[SaveData]
@ID INT OUT,
@Name NVARCHAR(50)
AS
SET NOCOUNT ON
INSERT INTO MyTable (Name) VALUES (@Name)
SET @ID = Scope_Identity() To retrieve the information, you would use a SQL Command and add the @ID and @Name parameters yourself. The OutputDirection of @ID would be InputOutput, which allows you to retrieve the incremented value from @ID.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
From a windows application form I need to print a ticket from a special ticket printer. that ticket includes a 2D barcode which is a string of all the information about a customer. I need to encrypt it and get as a byte array so I use Cryptoservices and done that. to concatenate that data with other data I've done something like this
System.Text.ASCIIEncoding enc = new System.Text.ASCIIEncoding();
string str = System.Text.Encoding.ASCII.GetString(b);
So printing part is working fine. But when I scan the barcode and try to get it back to byte array like this,
byte[] b = System.Text.Encoding.ASCII.GetBytes(data);
Then my array size gets smaller and when I try to decrypt it it throws an error saying that invalid length of string.
can anybody help me.
|
|
|
|
|
You can't use ASCII encoding to get the bytes as a string. It only support seven bit character codes, which means that any byte that is between 128 and 255 is replaced by a question mark.
Actually, you shouldn't use any text encoding at all to turn arbitrary bytes into text. Most encodings does't have a character for every possible byte value. Text encodings are used to turn text into bytes and back, not the other way around.
You have to encode the bytes in a different way. You can for example use base64 encoding:
string str = Convert.ToBase64String(b);<br />
<br />
byte[] b = Convert.FromBase64String(str);
---
single minded; short sighted; long gone;
|
|
|
|
|
when I use base64 its working fine. But i want to optimise the space taken by the barcode. I tried hex conversion and that also works fine. and then the size of the barcode is smaller. I want to make it much smaller.
|
|
|
|
|
Base64 puts 6 bits of data in each character, which only gives an overhead of 33%. That's the most compact way that you can easily represent binary data as text.
Hexadeximal representation only puts 4 bits of data in each character, giving an overhead of 50%.
Even if you find some complicated conversion that can squeeze almost 8 bits of data in each character, that is only about 30% better than base64. If you want to make the string substantially shorter, look at what the data represents and see if you can remove any unused parts of it.
---
single minded; short sighted; long gone;
|
|
|
|
|
I have a datatable named EmployeeDT. I am using hastable to store data. I want to to take an employeeID of EmployeeName from data table When i select Employee name in the combobox and add to HashTable.
But i am Binding only EmployeeName.So how can i get Emplyee Id to add to Hash Table?
I am binding data to combobox using this method
foreach(DataRow drow in EmployeeDT.Rows)
{
cboemployee1.Items.Add(drow["Name"].ToString().Replace("\"","\'"));
cboemployee2.Items.Add(drow["Name"].ToString().Replace("\"","\'"));
cboemployee3.Items.Add(drow["Name"].ToString().Replace("\"","\'"));
}
From this code how can i add key to the hash table
|
|
|
|
|
Please don't repost problems so soon after you've posted them before.
I notice that you've been presented with an answer and that you have chosen to ignore this. This site isn't for us to do your work for you.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
The other thing is, don't use 'Urgent' in the subject line.
God Bless,
Jason
I am not perfect but I try to be better than those before me.
So those who come after me will be better than I am.
|
|
|
|
|
am developing application in ASP.Net with C#. i am using button for FileOpenDialog to browse any image from hard drive as follows
openFileDialog1.ShowDialog();
string s = openFileDialog1.FileName;
textBox6.Text = s;
problem is:
i want the browsed image to be copied in local hosti.e,""C:\\Inetpub\\wwwroot\\15 WebSite\\images\\1.jpg"
i have the follwing idea in mind
File.Copy("C:\\Inetpub\\wwwroot\\15 WebSite\\images\\1.jpg", "C:\\Inetpub\\wwwroot\\15 WebSite\\images\\xyz.jpg");
or
File.Copy(s.Substring(13,s.Length-13), "C:\\Inetpub\\wwwroot\\15 WebSite\\images\\xyz.jpg");
but i dont want to existing image to be overwrite, i want all images to ve saved in local host
can anyone sugesst me what to do?
|
|
|
|
|
If you use File.Copy("C:\\Inetpub\\wwwroot\\15 WebSite\\images\\1.jpg", "C:\\Inetpub\\wwwroot\\15 WebSite\\images\\xyz.jpg");
it will throw IOException if the destination already exists so you should check that before you start copying. What so you want to do if the file already exists? I suggest you give them all unique name using GUID.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
