|
I forget to mention that im using for Windows application.
Does windows application support session?
Can you tell me a lil detail
Thanks
|
|
|
|
|
Can you tell me how to use google?
Panic, Chaos, Destruction.
My work here is done.
|
|
|
|
|
im sorry but i didnt expect anything ques like that.
I understand what u mean...
Np thanks
Yes i can tell you...google it
|
|
|
|
|
It's bad practice to open a connection to the database and leave it sit idle. SQL Server connection licenses are quit expensive.
Normally, you'd get all of your data from the forms, open the connection, start a transaction, do all of your queries to update the database, commit the trasaction, and close the connection.
|
|
|
|
|
Not sure I agree there. There is normally an expense to continuously opening and closing connections. In most systems there is no need for a connection per user, but often it is beter to maintain a pool of sesions and when a client needs to access the database it will take the next available session.
Unless of course we're talking about single user, single connection, single cell. Then the connect and drop might be excusable, but generally keep sessions open for the life of the system, but not always one per client.
Panic, Chaos, Destruction.
My work here is done.
|
|
|
|
|
Well, there's a different perspective. ADO.NET caches connection client-side. You can open and close them all you want without suffering a huge performance hit by going back to the SQL Server to establish the connection. In you're code's eyes, the connection is closed, but ADO.NET maintains the open connection with the server, keeping it cached in a connection pool. When you code opens the connection again, it's already open by ADO.NET and it just executes the query.
Where I work, there are SQL Servers with only 1,000 seats, but supporting about 2,000 users because the application's data use is pretty sparse, even though the apps are open all day long...
|
|
|
|
|
williamnw wrote: Can you tell me how to use google?
That is easy.
Take the content of your subject line, and paste it into google's editbox
without all the "hi", "doubt", "urgent" and "plz" of course (hoping that leaves something to search for)
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
|
|
|
|
|
Hello,
I would read all lines of my excel file, can you help me? thank you verry mutch.
|
|
|
|
|
Read the previous post, that's about writing Excel. Reading is done in roughly the same way.
You can Google for examples if you like
I are troll
|
|
|
|
|
Hello ,
I try for :
<br />
Microsoft.Office.Interop.Excel.Application excelApplication = null;<br />
Microsoft.Office.Interop.Excel.Workbook workbook = null;<br />
Microsoft.Office.Interop.Excel.Worksheet worksheet = null;<br />
<br />
excelApplication = new Microsoft.Office.Interop.Excel.Application();<br />
excelApplication.Visible = false;<br />
<br />
workbook = excelApplication.Workbooks.Open(@"D:\Après\mailing_RA_20090219.xls", 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);<br />
worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[2];<br />
<br />
<br />
<br />
<br />
excelApplication.Quit();<br />
excelApplication = null;<br />
<br />
string cellValue = "";<br />
object cellObject = null;<br />
Microsoft.Office.Interop.Excel.Range range = null;<br />
<br />
<br />
range = (Microsoft.Office.Interop.Excel.Range)worksheet.Cells[3,2];<br />
<br />
cellObject = range.get_Value(null);<br />
cellValue = (cellObject == null ? "" : cellObject.ToString().Trim());<br />
<br />
<br />
Console.WriteLine(cellValue);<br />
i have the exception on : range = (Microsoft.Office.Interop.Excel.Range)worksheet.Cells[3,2];, thank you verry mutch.
|
|
|
|
|
Is there a chart in that range of cells?
I are troll
|
|
|
|
|
Yes, I have 1506 rows and 10 collumns, thank you verry mutch.
|
|
|
|
|
If there's a graphic or a chart at cell 3,2 then you won't be able to convert this to a string. That's seems to be the main problem when you Google for the error-code.
Furthermore, you're closing the Excel-application before you're reading, on these lines;
excelApplication.Quit();
excelApplication = null;
Is that as it was intended?
I are troll
|
|
|
|
|
Thank you,
i try :
<br />
Microsoft.Office.Interop.Excel.Application excelApplication = null;<br />
Microsoft.Office.Interop.Excel.Workbook workbook = null;<br />
Microsoft.Office.Interop.Excel.Worksheet worksheet = null;<br />
<br />
excelApplication = new Microsoft.Office.Interop.Excel.Application();<br />
excelApplication.Visible = false;<br />
try<br />
{<br />
workbook = excelApplication.Workbooks.Open(@"D:\Après\mailing_RA_20090219.xls", 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);<br />
worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[2];<br />
<br />
<br />
<br />
<br />
<br />
<br />
string cellValue = "";<br />
object cellObject = null;<br />
Microsoft.Office.Interop.Excel.Range range = null;<br />
<br />
<br />
range = (Microsoft.Office.Interop.Excel.Range)worksheet.Cells[4,7];<br />
<br />
cellObject = range.get_Value(null);<br />
cellValue = (cellObject == null ? "" : cellObject.ToString().Trim());<br />
<br />
Console.WriteLine(cellValue);<br />
<br />
excelApplication.Quit();<br />
excelApplication = null;<br />
<br />
Console.Read();<br />
<br />
<br />
<br />
<br />
}<br />
catch (Exception ex)<br />
{<br />
Console.WriteLine(ex.ToString());<br />
Console.Read();<br />
}<br />
But i have an empty output, thank you verry mutch.
|
|
|
|
|
Sounds like two monologues intertwined...
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
|
|
|
|
|
I don't find any thing.please help me thank you verry mutch.
|
|
|
|
|
I'm sorry, but I got no clue how
I are troll
|
|
|
|
|
/*excelApplication.Quit();
excelApplication = null;
string cellValue = "";
object cellObject = null;
Microsoft.Office.Interop.Excel.Range range = null;*/
remove this code Bro
|
|
|
|
|
I am trying to convert xml data to Excel. But, I am not able to figure out how to create a excel by C#. Pls help me.
|
|
|
|
|
link[^]
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
|
AFAIK, that's a hyperlink that points to Google. There are a lot of articles explaining how to export to Excel.
Excel can read "Comma separated" files, where each line is a row in Excel, and each value (separated by a comma) is a column.
You can also use ODBC to write Excel files, you can go to ConnectionStrings.com[^] to get a connectionstring for Excel.
..and there are some articles on InterOp and stuff. Enjoy
I are troll
|
|
|
|
|
|
hi
i got link breaks from google chached pages
Example.
if one click on the link which is chached in google (www.mysite-problem.com/default..aspx) showing the error
HTTP Error 400 - Bad Request.
here i want to replace ".." with "."
or how can i redirect my page to if this error accured.
thanks in Advance
max
modified on Friday, March 13, 2009 8:58 AM
|
|
|
|
|
Don't you think the question is completely out of context ??????????
-Regards
Bharat Jain
bharat.jain.nagpur@gmail.com
|
|
|
|
|