|
Hi Everyone,
I have created table in sql with 12 fields
Field1 Field2 Field3 Field4 ……… Field12
I have an excel sheet with 12 columns and 150 rows.
My question is how can I import all of the columns from the excel sheet to my table without losing any information.
thanks
Tirumal.
|
|
|
|
|
This is pretty easy.
1. Make an oledb connection as:
OleDbConnection ExcelConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ExcelFileName+";Extended Properties=\"Excel 8.0;HDR=NO;IMEX=1;\"");
2.Set the command. OleDbCommand ExcelCommand = new OleDbCommand();
3.ExcelCommand.Connection = ExcelConnection;
4.OleDbDataAdapter ExcelAdapter = new OleDbDataAdapter(ExcelCommand);
ExcelConnection.Open();
System.Data.DataSet ExcelDataSet = new System.Data.DataSet();
ExcelCommand.CommandText = @"SELECT * FROM [SHEET1$]";
ExcelAdapter.Fill(ExcelDataSet);
ExcelConnection.Close();
The ExcelDataSet can be looped thro' and data can be saved to the database.
Hope this helps!
Parimala
|
|
|
|
|
You can use OdbcConnection to open Excel file as a database, then use DataAdater(s) and DataSet(s) to transfer data from excel to SQL Server db
Cheers,
Suresh
|
|
|
|
|
Hi!
I'm trying to load an image from a web site into Image object..
i tried something like this:
<br />
HttpWebRequest hwr = HttpWebRequest.Create("http://www.onet.pl/_m/32006b80b5eb4c237bb11e1a25895e83.jpg") as HttpWebRequest;<br />
hwr.ContentType = "image/jpg";<br />
hwr.Method = "POST";<br />
hwr.BeginGetRequestStream(new AsyncCallback(Callback), hwr);<br />
<br />
void Callback(IAsyncResult result) {<br />
HttpWebRequest request = (HttpWebRequest)result.AsyncState;<br />
Stream stream = request.EndGetRequestStream(result);<br />
<br />
StreamReader sr = new StreamReader(stream);
pictureBox1.Image = Image.FromStream(sr.BaseStream);<br />
}<br />
but i get an exception that the stream is not readable..
i don't get it - why the EndGetRequestStream returns a stream if it's not readable..
anybody knows how to make this work or some other way to load jpgs from http?
thanks for any help!!
life is study!!!
|
|
|
|
|
Seishin# wrote: i don't get it - why the EndGetRequestStream returns a stream if it's not readable..
Since the request is what is sent to the web resource it is expected to be filled with information. You're interested in the response, so switch to the GetResponse or BeginGetResponse method.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
thanks!!!
i also had to switch hwr.Method form "POST" to "GET"..
life is study!!!
|
|
|
|
|
Hi,
basically getting data via Http contains two things:
1. the request
2. the response
The strean object of the Request object (HttpWebRequest) in your case is
to send data to the web. Getting the answer is to get the response and
reading it's stream.
So use something like this:
HttpWebRequest hwr = HttpWebRequest.Create("http://www.onet.pl/_m/32006b80b5eb4c237bb11e1a25895e83.jpg") as HttpWebRequest;<br />
HttpWebResponse resp = (HttpWebResponse) hwr.GetResponse();<br />
pictureBox1.Image = Image.FromStream(resp.GetResponseStream());<br />
resp.Close();<br />
resp = null;<br />
hwr = null;
Don't forget to close the repsonse! If not, you might run into exceptions
after getting data from the web multiple times.
-sa
--
http://www.livingit.de
http://www.not2long.net
|
|
|
|
|
|
|
Thanks Christian, but I'm pretty sure it has nothing to do with the database layer "Oracle in this case".. it's just the dataset . It's saving fine when typing the insert command in the sql from oracle but not through my c# app. but thanks anyways.
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
OK, so your problem is not Oracle at all, your data goes in fine, it's not coming back out ?
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 )
|
|
|
|
|
This[^] looks promising ?
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 )
|
|
|
|
|
Been there.. No luck
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
Well, the data is going in, so .NET *must* be able to understand/pass it. You can select it from Oracle client tools, but not in C#, right ?
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 )
|
|
|
|
|
We don't need to use another installer to make an uninstall file. Only msi package of WinXP, we can make an simple uninstall file automatically to help us much in development progress. An unique command like MSIEXEC /X {ProductCode} in Uninstall.bat. For {ProductCode}, after selecting Project in Solution Explorer, we access View/Property Window, surely {ProductCode} is in this grid. Concurrently we make a shortcut of Uninstall file in program file. Finally, our app is convienent for users.
[Uninstall.bat]
MSIEXEC /X {ProductCode}
It seems to be a bad way but it's also a way
It seem to be a solution or an answer.
|
|
|
|
|
hai all
i want to know how to assign strong name to a assembly
and how to publish assembly using gacutil
|
|
|
|
|
|
thanks but it is not working
error message is that attempt to install assembly with out strong name
|
|
|
|
|
did you add that AssemblyKeyFile(...) attribute to AssemblyInfo.cs and re-compile the project?
Or Just tell me what did you do?
Cheers,
Suresh
|
|
|
|
|
okay it works
can you tell me how to use install assembly
|
|
|
|
|
Do you want to use the installed assembly????
Cheers,
Suresh
|
|
|
|
|
iam new in c#.net can u tell me why we install install assembly globaly and
what are there uses and how can one make use of it
|
|
|
|
|
|
I made a DataGridView on my form and bound it to data from my database. Everything works fine.
What I want is to allow user to add rows to my database using this DataGridView. I set the 'AllowUserToAddRows' property to true. When running the application, I can add new rows to my DataGridView, but no changes are made to database.
How to make it?
Thank you very much in advance
|
|
|
|
|
You must update database from datagriview. Add this code into your app
using System.Data.Oledb;
DataTable dt = (DataTable)datagriview1.datasource;
OledbDataAdapter adap = new OledbDataAdapter ("Select * from <tablename> where <primaykey> = 0 (or "")", con); //con = new OledbConnection(<connectionstring)
oledbcommandbuilder buider="new" oledbcommandbuilder(adap);
adap.fillschema(dt,schematype.sourced);
adap.fill(dt);
bool="" result="(adap.Update(dt)==1)?true:false" ;
="" true="" :="" is="" successfull.="" otherwise="" not.
=""
<div="" class="ForumSig">It seem to be a solution or an answer.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
.. Please, someone, anyone, help me with this problem that I've been stuck in for the last two weeks..
