Re: Help to a new user please - C# Discussion Boards

N a v a n e e t h29-Jan-09 5:29

N a v a n e e t h

29-Jan-09 5:29

Look at the classes in System.Data.OracleClient[^] namespace. If you need more, download ODP.NET from oracle website.

Smile | :)

Navaneeth

How to use google | Ask smart questions

Giorgi Dalakishvili29-Jan-09 5:29

Giorgi Dalakishvili

29-Jan-09 5:29

1. Learn how to write.
2. Read the documentation.
3. Ask for a hint, not for source code.

Giorgi Dalakishvili

#region signature
My Articles

Asynchronous Registry Notification Using Strongly-typed WMI Classes in .NET [^]

My blog
#endregion

sridhar88729-Jan-09 18:15

sridhar887

29-Jan-09 18:15

i'm extremely sorry 4 askin de source code... i don no how to ask ma doubt so i jus typed tat... thank u very much 4 ur guidance... i want to know how to connect oracle 10g database with c#.net...

thanks in advance!!!

musefan29-Jan-09 5:31

29-Jan-09 5:31

try this:

http://www.oracle.com/technology/pub/articles/cook_dotnet.html[^]

and I suggets you do more research in future cuz people here dont like helpin those you dont try for themselves first. there is alot of database info out there

J4amieC29-Jan-09 5:49

J4amieC

29-Jan-09 5:49

Believe me, some of us hate txtspk more!

musefan29-Jan-09 6:04

29-Jan-09 6:04

well i use predictive text so i wouldnt use 'cuz' well writing an sms message

New values and Old Values

sridhar88729-Jan-09 18:18

sridhar887

29-Jan-09 18:18

ya sure.. i tried of ma own... but i cudn't bring t up.. but i'll try... moreover i don no de way 2 ask my doubt n tis forum....

thanks in advance!!!

ziwez029-Jan-09 4:12

ziwez0

29-Jan-09 4:12

For the past few months Ive had to design a way of keeping a log\ tracking changes to a web app.

Now as this was a urgent requirment, I just kinda got on and did it in the way I knew how to.
But im now at the point where im logging more data and obviously want to be more efficient in how i do this.

So this is what I currently do.

Example:

1.User wants to change a contact phone no, brings up the record, it reads "1234567" user enters "123456789"
presses update and the code will do the following

2.I will do a db look for that customer record (i passed a paramter of the customerid),
grab the contact no and store it in a string, close the connection.
// I question this bit as I all ready pulled out the value once to show to the user (1.)

3.Im now going to update my record with the new value, done.

4. Now i need to log the old value and the new value into my log class which is like

public class Log
{
private bool xLogRecordInserted;
ProfileCommon profile = HttpContext.Current.Profile as ProfileCommon;

ProfileBase pb;

public Log(string NewComments, string OldComments, int LogCategoryOID, int OID)
{
try
{

string strInsertLog = "INSERT INTO tbl_Log (UserOID, dtRasiedDate, Comments, Comments2, LogCategoryOID, RelatedRecordOID) VALUES (@UserOID_2, @dtRasiedDate_2, @Comments_2, @Comments2_2, @LogCategoryOID_2, @RelatedRecordOID_2)";
Connection c = new Connection("Connection_Log");
//--Connection

SqlConnection con = c.Connect();
//--Commands
SqlCommand cmd_InsertLog = new SqlCommand();
cmd_InsertLog.Parameters.AddWithValue("@UserOID_2",profile.UserID);
cmd_InsertLog.Parameters.AddWithValue("@dtRasiedDate_2", DateTime.Now);
cmd_InsertLog.Parameters.AddWithValue("@Comments_2", NewComments);
cmd_InsertLog.Parameters.AddWithValue("@Comments2_2", OldComments);
cmd_InsertLog.Parameters.AddWithValue("@LogCategoryOID_2", LogCategoryOID);
cmd_InsertLog.Parameters.AddWithValue("@RelatedRecordOID_2", OID);

//--Open Connection
cmd_InsertLog.Connection = con;
//--Command Types

cmd_InsertLog.CommandText = strInsertLog;
// Execute Query and count rows

int intAffectedRows = cmd_InsertLog.ExecuteNonQuery();

if (intAffectedRows > 0)
{
xLogRecordInserted = true;
}
else
{
xLogRecordInserted = false;
}

con.Close();
con.Dispose();
c.Disconnect();

}

catch (Exception ea)
{
xLogRecordInserted = false;
ErrorLog ErrorLogEntry = new ErrorLog("Log.CS", "Log", profile.UserName, ea.ToString(), "Class");
}

}

public bool LogRecordInserted
{
get {return xLogRecordInserted;}
}
}

musefan29-Jan-09 4:22

29-Jan-09 4:22

Do you have a question to go with all those words?

Can you not pass old number as parameter to avoid excess database query?

Other than that your just logging a change with one query, how else would you be able to do it that would be better

Rob Philpott29-Jan-09 5:11

Rob Philpott

29-Jan-09 5:11

What sort of database are you using here? I'd recommend putting some of that function into stored procs if you can.

If you update a phone number and log the previous one, you really want that operation to be atomic, which means it should run in a transaction. You could do this in code, but I'd argue a stored proc which replaces the phone number and logs the old one is they way to go.

Personally, I don't care for raw sql commands in code at all. It's ugly, fussy, not as secure, don't get exec plans and you increase the scope of transactions which could slow the system down.

Regards,
Rob Philpott.

N a v a n e e t h29-Jan-09 5:25

N a v a n e e t h

29-Jan-09 5:25

So what is your question? Are you asking for some alternative methods to do this? I'd create a trigger on that table which fires when update happens. In that trigger, you can put the old value to the tbl_log. This will help you to avoid step2.

Smile | :)

Navaneeth

How to use google | Ask smart questions

A problem with DataBinding. [modified]

ziwez029-Jan-09 7:36

ziwez0

29-Jan-09 7:36

So my question was how can i make the code more effcient?,
my DBA wont allow triggers on the SQL db.

AxiliuM29-Jan-09 4:09

AxiliuM

29-Jan-09 4:09

I have 2 tables

>>Tb_orders (date, ... , id_cust1, id_cust2)
>>Tb_customers(id_cust, name ...)

and I need to edit the fields id_cust1, id_cust2 using ComboBox

cBox1.DataSource = Tb_customers;
cBox1.DisplayMember = "name";
cBox1.ValueMember = "id_cust";
cBox1.DataBindings.Add("SelectedValue", Tb_orders, "id_cust1");
cBox2.DataSource = Tb_customers;
cBox2.DisplayMember = "name";
cBox2.ValueMember = "id_cust";
cBox2.DataBindings.Add("SelectedValue", Tb_orders, "id_cust2");

everything is clear but cBox1 and cBox2 have the same value. I dont know what I have to do..

modified on Saturday, January 31, 2009 2:03 AM

Re: A problem with DataBinding.

MadArtSoft29-Jan-09 23:27

MadArtSoft

29-Jan-09 23:27

Try to use diffrent data source. I mean create separate Data source object.

C# controls, .Net components. Help Desk Software

Re: A problem with DataBinding.

AxiliuM30-Jan-09 20:03

AxiliuM

30-Jan-09 20:03

Thank you! Smile | :)

Send e-mail with .mht body from program

collapo29-Jan-09 3:47

collapo

29-Jan-09 3:47

Hi!

I'd like to send a message, which has an .mht body.
Can someone provide me with some info on how to do this?
I've seen the Chilkat.dll version from google, but for me it is not good
because of its license.

Thanks in adwance.

Re: Send e-mail with .mht body from program

vaghelabhavesh29-Jan-09 13:36

vaghelabhavesh

29-Jan-09 13:36

Found this link[^] from the discussion going here[^]

It uses the method name CreateMHTMLBody [^], I have never tried that but it may help Smile | :)

Be careful, there is no Undo Button(Ctrl+Z) in life.

Re: Send e-mail with .mht body from program

collapo29-Jan-09 22:02

collapo

29-Jan-09 22:02

Thanks,

Unfortunately it is a vb code, but I'll check if i find the same in c#

this cdosys looks interesting.

accessing database in SQL server 2005 through C#

Deepali Khalkar29-Jan-09 2:35

Deepali Khalkar

29-Jan-09 2:35

I am developing an application for Win mobile 6.0 in visual studio 2008 under smart device.This application involves reading and writing the data from a table in SQL server 2005 to a C# smart device form.I cannot read and write the data to the table made in SQL server 2005 to c# form. Plz someone help me with the steps to be followed to achieve this. Also help me with the steps for database connectivity.

Thanks.

Re: accessing database in SQL server 2005 through C#

musefan29-Jan-09 2:45