|
Hi DuckFace
Thank you for ur response. I will try to work it out. If find any problem then i will keep a message
Suresh.R
|
|
|
|
|
Hi,
I have a C#.net application in which i have read the datas from excel sheet and displayed in a datagrid in my Aspx form.
The code is here
private void Button2_Click(object sender, System.EventArgs e)
{
try
{
string strConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Salary.xls;Extended Properties=""Excel 8.0;HDR=YES;""";
OleDbConnection conn = new OleDbConnection(strConnection);
//conn.Open();
OleDbCommand command = new OleDbCommand("SELECT * FROM [Sheet1$]", conn);
// command.Connection = conn;
// command.CommandType = CommandType.Text;
// command.CommandText = "SELECT * FROM [Sheet1]";
OleDbDataAdapter da = new OleDbDataAdapter(command);
DataSet ds = new DataSet();
//DataTable dt = new DataTable();
conn.Open();
da.Fill(ds, "EmpSal");
DataGrid1.DataSource=ds;
DataGrid1.DataBind();
//da.Fill(dt);
conn.Close();
lblError.Text="The Excel sheet has been read";
//return dt;
}
catch (Exception ex)
{
Response.Write( ex.Message);
//return null;
}
}
the thing is that i have to upload the datas into the mysql database table. can anybody pls help me with the C#.net code. i need to use only mysql database.(coz we r using mysql db in our project)
Regards
Vijay.
|
|
|
|
|
First get the mySQL driver and use the OLEConnection, that is it. Create another connection use it to upload the information
|
|
|
|
|
As per our requirement i have created a word report with password.
And i am exporting it to the client system.
It works fine in some system. But in some client system the gif images are not correctly loaded.
For all the clients the images are correctly generated at the server(i commented the code of deleting the file at the server).
And it also happened that for some clients where the images were not correctly loaded it began to load when tried another day. And vice versa also happened yet another day. I really don't know why this inconsistancy is happening.
And i was checking out at the clients were Word 2000 was installed. As i was automating Word 2000(Word 9.0.2720) at the server.
Actually while creating the document at the server i am inserting a table containing those gif images, with some formatted headings in it...
And that table is made as a header for the word document...
I just copied the file from the client system where the image is not correctly loaded to the client system where the image is correctly loaded.
Found out that it is correctly loaded.
Again i opened the file through the network from the system where the images are correctly loaded. It was alright. And everything is displayed correctly.
Now feel that it is due to some client side settings in the Word at the desktop.
In Word 9.0 what are the settings to be enforced to load or insert images correctly ?
In the client system where the gif images was not correctly loaded i just double clicked on the header...The header tool bar got active...
I right clicked on the picture & there was 'Edit Picture' option on the pop up menu...i clicked on that... and it gave out an error message that....
'You cannot edit a picture that is not saved in the document'
But the same picture is correctly displayed when the same file is opened from another system (where it was also correctly getting from the server)...
I really don't know whether files are correctly generated at the client...If that is the case why is it displaying in one system and not on the other...
I copied those images
to 'C:\InetPub\WWWroot\FolderName\images\' and directly inserted those from the Word Application where it was not getting from the server. It was displaying correctly. I tried to edit it [U]without saving[/U] it was opening the edit window for the editing of the picture...
-- modified at 2:08 Wednesday 16th May, 2007
O
|
|
|
|
|
HI all
Is it possible to consume the web service from the client slide code (Java Script). it is asked by one of my senior i replied "NO"
i think we can't consume Web service from javascript
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
Yes we can, the best example you can find is AJAX network call back approach. Where a web service exposed in the server side is consumed by the proxy client in the client system using javascript.
Regards,
Prakash Kalakoti
|
|
|
|
|
Thanks Prakash
i gave a wrong answer :->
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
Friend Ajax is the best example for you which does the same thing.... In fact this is leveraged most in .NET 3.0
|
|
|
|
|
Course you can ...look for the JS Soap Client on this VERY SITE
"Knock me down, I'll get straight back up again, I'll come back stronger than a powered up pacman"
(Lilly Allen / Kaiser Chiefs)
|
|
|
|
|
Hi Friends
I have to set up a server which stores audio and video files. This has to be done
using ASP.NET and SQL Server.That is, whenever there is a new audio or video file I should be able to browse and store it in the database.
Any idea how to achieve this.
Thank you
|
|
|
|
|
Can you please clarify your problem a little more?
Regards,
Prakash Kalakoti
|
|
|
|
|
I have to store audio files in SQL Server. WebPage users should be able to download those files when clicking on it. Iam using ASP.NET application. How can I do it.
|
|
|
|
|
A powerful server, hell lot of bandwidth and a seriously large storage disk. Coming down to the actual implementation, you can store any binary type in the SQL Server image datatype or the VarBinary(MAX) datatype (SQL Server 2005). You can design your ASP.NET application to handle your files like any other file stored in the database, unless you want to stream your content.
SG
|
|
|
|
|
Hi
Have you any idea that how to print a page in a button click without showing Print dialog for a web page.
If we use javascript window.print(), it prompts Print dialog. The requirement is direct printing on client side without prompting print dialog in a single button click on a web page. I am using ASP.NET with C#.
Solution require as soon as possible.
Thanks in advance.
|
|
|
|
|
I don't thik this is possible, as we don't have any control on client machine, any how if this is possible then it seems a big security issue.
Regards,
Prakash Kalakoti
|
|
|
|
|
To do that you need direct access to the client computer, and for that you need to use an ActiveX component that runs in the browser. This of course rules out all non-Windows operating systems.
---
single minded; short sighted; long gone;
|
|
|
|
|
Please write the ActiveX component name and how to use it.
|
|
|
|
|
Elena2006 wrote: Please write the ActiveX component name and how to use it.
I don't know of any specific component that does what you want. You have to decide exactly what it is that you want, and start looking around for components that do this.
---
single minded; short sighted; long gone;
|
|
|
|
|
Hi Elena
Did you ever find the solution to print without print dialog box in Java script ?
I'm in urgent need for it.
Thanks
Vishal Simon
|
|
|
|
|
Hi,
In an asp.net1.1 application I have a datagrid which was working but now its Command events (ButtonColumn and EditCommandColumn events )are not handled any more.The only change I made is adding a header and footer usercontrols.
Please any suggestion could be helpful.
I am too late but i will never give up
|
|
|
|
|
This is an issue with VS, if you open the page in design view some time the registered events gets removed automatically, so re-register your event.
Regards,
Prakash Kalakoti
|
|
|
|
|
Hi,
If you mean double click the event in the properties window then I did it already but no use.I have checked the event handling code (eventname+=new...) but every thing is ok.I forgot to mention that the datagrid is in a table cell (td) and the table is in a usercontrol.
I am too late but i will never give up
|
|
|
|
|
Hi,
As Prakash said, this is an issue with VS. I had faced similar problem just two days back. I had just clear the aspnet_wp.exe from the task manager, rebuild the application more than one times, then it got corrected. Try once more. it will work.
Best Wishes
Meeram395
|
|
|
|
|
Hello all,
i need to develop Content mgmt. system in ASP.NET/MySQL
any idea on how to start....?
|
|
|
|
|
I am trying to insert my COM Component into the toolbox of ASP.NET page using choose Items... but it is not embeddeding into the toolbox. sometimes it is visible in the tool box but in DISABLEd state.
How can I put my com component into the toolbox and make it Enable?
thnx in advance for suggestions
poojaaa
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
