Re: Seeing content of a SDF file ? - C# Discussion Boards

29-Jan-09 7:46

Hello guys.
I have a file with SDF extension ( database ).
I'm gonna see content of it ! I couldn't see it with VS2008 SP1 or SQL Express 2008 SP1.
How can I see it ?

Thanks in advance.

musefan29-Jan-09 8:10

29-Jan-09 8:10

Have you tried using the System.Data.SQLClient classes and specifying the .SDF file as the data source

Other than that dont know what to suggest

Mohammad Dayyan29-Jan-09 8:28

29-Jan-09 8:28

Hi musefan.

musefan wrote:
Have you tried using the System.Data.SQLClient classes and specifying the .SDF file as the data source

Actually I've known it and I've used it for using the database in my project.
But I'm gonna trace my program and see the content of the database after each query, so I need a program like MSSQL to see content of the database .
As I said I've used SQL Express and VS2008 , but they didn't show anything.

Thanks anyway

vaghelabhavesh29-Jan-09 8:23

vaghelabhavesh

29-Jan-09 8:23

Option 1:
Do you have SQL Server Management Studio? If so then open it and select the Database type as SQL Server Compact Edition and specify the path of sdf file in Database File option. Thats it!!

Option 2:
Open the Server Explorer Window in Visual Studio and right click the Data Connection and click add connection. In Data Source Click Change button and select the SQL Server Compact Edition. Then click OK. Now you will have to specify the path of sdf file.

<edit>
Try this[^]

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

Mohammad Dayyan29-Jan-09 8:46

29-Jan-09 8:46

Thanks a lot crudeCodeYogi.

crudeCodeYogi wrote:
Do you have SQL Server Management Studio? If so then open it and select the Database type as SQL Server Compact Edition and specify the path of sdf file in Database File option. Thats it!!

I have SQL Express 2008 SP1, Is it appropriate ?

vaghelabhavesh29-Jan-09 8:52

vaghelabhavesh

29-Jan-09 8:52

Mohammad Dayyan wrote:
I have SQL Express 2008 SP1, Is it appropriate ?

It should work on SQL Express 2008 also.

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

Mohammad Dayyan29-Jan-09 9:02

Help to a new user please

29-Jan-09 9:02

Thanks. It works. Thumbs Up | :thumbsup:

sridhar88729-Jan-09 5:20

sridhar887

29-Jan-09 5:20

i'm a new user of C#.. pls help me how 2 insert data into oracle 10g database???? and also how to fetch data from it???? pls help me soon.. pls provide source code r any idea for that...

thanks in advance!!!

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