|
Hi ppl
Im again
In a data Entry software Most frequently usage is database Connection.
I have to insert data many tables in different forms. So I have to create diff connection for different table insert or update.
Like i have 3 forms. In 3 forms, I have to insert in 3 different table in a same database. So when I insert form1 in table1 then I have to create connection and close connection.
Again for form2 i have to do same jobs.
is there anyway to create one connection for all forms usage and close after manipulating, like "Visual Basic" ,module.
Or
any efficient way to do it?
or
Any Advice pls
Feel free to advice me
A lil detail of my problem:
i have to write all full conn every time.....
disgusting isnt it...like
//connection string
string connString = @"
server = HOME;
integrated security = true;
database = Monitoring
";
//query
string sql = string.Format(@"
SELECT Ins_ID, Ins_Nm
FROM Institution_Profile
WHERE Up_ID =
(SELECT Upazila_ID FROM Upazila
WHERE Upzila_NmB = '{0}')
", cmbUpazila.Text);
//create Connection
SqlConnection conn = new SqlConnection(connString);
try
{
//open Connection
conn.Open();
//create dataAdapter
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
//create dataSet
DataSet ds = new DataSet();
//fill dataset
da.Fill(ds, "Institution_Profile");
// get data table
DataTable dt = ds.Tables["Institution_Profile"];
foreach (DataRow row in dt.Rows)
{
cmbSchoolName.Items.Add(row["Ins_ID"].ToString() + " " + row["Ins_Nm"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show("Error:" + ex);
}
finally
{
conn.Close();
}
and again write the same code for another table insert or update...
------------
can i write once and use again n again
???
thanks
|
|
|
|
|
Nice answer today:
- create one session and use it for all your updates.
- use transations to ensure atomic units.
Panic, Chaos, Destruction.
My work here is done.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
