|
Thanks for your Reply.
Mkanchha
|
|
|
|
|
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.
|
|
|
|
|
Are you able to display the excel data in grid ?
|
|
|
|
|
ya i can read data in datagrid with column names also.. but i don't know how to insert those datas in mysql database table. pls help me..
|
|
|
|
|
I need to implement a server farm with 10 machines.
- How can I share the sessions ?
- Where I should create the session ?
- Is it needed to copy my entire ASPX application in all servers ?
- Which is good program for load balancing ?
- Which will be the entry point of the request ?
Please guide me.
|
|
|
|
|
Hi,
This is my first post and i have a problem in asp.net 2.0
You have a drop down list and a calender control.
Drop down has items say one,two,three...
if u select any item from dropdown list the appropriate date should get the focus in the calender control
can anyone tell me how the focus should come on calender control when i select a city in the dropdown
Thanks
Mukkanti
|
|
|
|
|
HI,
Have you tried any code so far?
Thanks and Regards,
Chetan Ranpariya
|
|
|
|
|
More information is always needed, what is your code behind? The simple logic is, to make sure your drop down menu is in POSTBACK, I'd bulid a Case statment, to set focus on whatever needs focus depending on what answer it was.
|
|
|
|
|
i am using c# as code-behind
can you send me the code please
its urgent
Thanks
Mukkanti
|
|
|
|
|
Do your own work, or at least attempt to. Plus there is no way I can write the code, I dont know your variables. People here arent here to just do your job for you, they are here to offer help and assistance, and no one is going to help, with someome that is just saying "give me the code", there are way WAY better programmers on here than me, but none have responded, cause of just what I said.
What dont you understand about what I said?
|
|
|
|
|
I want validat a text box --
up to 10 numeric character and
two "-" hyphen character.
Parwej Ahamad
g_parwez@rediffmail.com
|
|
|
|
|
|
My project is on ASP.NET 1.1 and it runs on ie only. In this project i have a setup in which there is one base page and all of the rest pages are as component. their is a strange problem when i move from one specific page say page1 to another say page2 and then check its source from view source. i am seeing source of page1 whereas the ie displays page2. but when i goes from some other page3 to page2 every thing is fine. i m getting error when in base page i have used some javascript and it is saying hidden field is null. but when i go from page3 to page 2 there is no error. any possible reasons?
Regards
Shajeel
|
|
|
|
|
Shajeel wrote: i am seeing source of page1 whereas the ie displays page2.
That's just plain not possible, unless the source is being changed in script ( you see the original source ).
Shajeel wrote: i m getting error when in base page i have used some javascript and it is saying hidden field is null.
OK, apparently, your hidden field is null. You need to check your javascript and markup, and if you want meaningful help, you need to post it, so we can comment on your code.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi all,
I've got a small issue I need to figure out and I thought someone might have the answer. I need to send a print job (HTML page) to a networked printer connected to the web server, rather than the client's printer. Essentially this is a letter printing exercise for a corporate application. The letters are written with a wysiwyg, web-based HTML editor. They can then either be printed (for posting to the recipient) or emailed (which is, as you would expect, a doddle). Printing is causing some issues in that, while it's extremely simple to get a print job to a client-side printer, printing to a printer connected to the server is a bit of a nonsense. I thought of creating an instance of a web browser control on the server side and programmatically filling it with the HTML and asking it to print, but apparently this will pop up a dialog on the server, which is less than desirable. At the moment my solution is to do some fairly arcane transformations on the HTML in order to turn it into postscript, fire the postscript at a printer (which is relatively easy), and hope to god the printer understands it. Most of ours are HP printers and cope admirably with being given raw postscript, but it's not really a future-proof solution. If the users end up getting a new printer that doesn't understand postscript natively, they'll just be printing what will look like complete gibberish.
If anyone's got a nice, slick answer to this, I'd appreciate it. The postscript solution has a certain raw charm, but it's nowhere near as elegant as it should be. Something I can actually show my boss without being slapped round the back of the head would be good.
|
|
|
|
|
with dotnet framework 2 , it will always ask for that print dialog. it was possible with framework 1.1.
|
|
|
|
|
Fortunately I'm still in a 1.1 world! How do I get around the print dialog?
|
|
|
|
|
|
So... it might be possible to run a web browser instance on the server, insert the HTML I want to print, and tack the javascript on the end? That's kind of intriguing, I'm going to take a look at that. I suspect some of the posts further down that page mean that I'm not likely to get very far, since MS seem to have locked that functionality down in XP, but... the server in question is running 2000... Hmmm...
Thanks, I'll look into this and see how far I get.
|
|
|
|
|
Hey
I have a GridView with an ImageField, inside this image field I would like to display a scaled down version of an image (to fit the dimensions of the ImageField) - and show the full sized one if the user chooses to.
I was just wondering is it possible to do this and if so can any one give some hints or will there need to be 2 images one full size and one that is the correct dimensions for the ImageField?
Thanks
Dan
|
|
|
|
|
hi,
Are U trying to do both of the things(scaled and full size image), in the same image control inside the gridview.
Sherin Iranimose
|
|
|
|
|
No - sorry for not being clear.
One page has a gridview with a list of companies and a scaled down image (in an imagefield) - selecting one of the companies will take the user to that companies area (different web page) where the fullsize image will be displayed.
Basically on the company's area there will be a 200 x 600 banner but on the gridview I only want to show this image as a 50 x 150 image (kind of like a teaser image)
Thanks
Dan
|
|
|
|
|
hi Dan,
You can specify height and width for image control inside the gridview.
So all images inside the gridview have same size.
If didnot specify the height and width it will take actual image size.
Dan Is this u are expecting?????
Sherin Iranimose
|
|
|
|
|
I have used a style sheet to set the itemstyle's height and width but it didnt work - I have also tried setting it in the actual mark up but all that happens is that the cell stretches to fit the images full size rather than the image shrinks to fit the cell.
Is is just a case of having 2 different sized images or is it possible to force the image to fit the cells dimensions?
Thanks for your help
Dan
|
|
|
|
|
<asp:TemplateField>
<ItemTemplate>
<asp:Image ID="Image2" runat="server" Height="50px" ImageUrl='<%# Bind("imgpath") %>'
Width="50px" />
</ItemTemplate>
</asp:TemplateField>
are u trying like this..
Sherin Iranimose
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
