Re: compare 2 datetime and get hours - C# Discussion Boards

#realJSOP4-Oct-08 3:13

4-Oct-08 3:13

I *did* try that and it didn't work.

Everything I've managed to find on the web says that the normal DOS path should work, and nobody else has mentioned the "file://" thing.

"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

Re: WebBrowser Control and Images

Wendelius4-Oct-08 7:14

Wendelius

4-Oct-08 7:14

Few ideas:
- when you used Application.StartupPath, did you place the css-file in your projects \bin\Debug-directory, not in the project directory?
- you can try using / as directory separator instead of \
- most html-files use double quotes for href's like href="..." so that would be also worth trying.

The need to optimize rises from a bad design

Re: WebBrowser Control and Images

#realJSOP4-Oct-08 8:42

#realJSOP

4-Oct-08 8:42

Ya know, a lot of people wouldn't come back to a thread like this simply to admit that they were an idiot... But I was an idiot. Smile | :)

I was copying the files in question to the WRONG debug folder. Smile | :)

Cannot implicitly convert type 'System.Web.UI.Control' to 'System.IO.MemoryStream'

technette3-Oct-08 13:51

technette

3-Oct-08 13:51

I'm trying to correctly write the stream data to control.

Response.Write(stmDetailData = DWGControl);

Full event code:

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
Control DWGControl = FindControl("dwgViewerCtrl");
const string sql = "SELECT Detail_ID, Detail_DWG from Detail_Info";
try
{
using (System.Data.SqlClient.SqlConnection cn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["DetailsDBFConnectionString3"].ConnectionString))
cn.Open();

using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT Detail_ID, Detail_DWG from Detail_Info"));

System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter();
DataSet_Details ds = new DataSet_Details();
da.Fill(ds, "DetailInfo");
int c = ds.Tables["DetailInfo"].Rows.Count;

if (c > 0)
{
Byte[] byteDetailData = new Byte[0];
byteDetailData = (Byte[])(ds.Tables["DetailInfo"].Rows[c - 1]["Detail_dwg"]);
System.IO.MemoryStream stmDetailData = new System.IO.MemoryStream(byteDetailData);
Response.Write(stmDetailData = DWGControl);

}
cn.Close();
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }

}

Re: Cannot implicitly convert type 'System.Web.UI.Control' to 'System.IO.MemoryStream'

Jaime Olivares3-Oct-08 19:33

Jaime Olivares

3-Oct-08 19:33

I don't understand your line:
Response.Write(stmDetailData = DWGControl);

I think it should be instead:
Response.ContentType = "application/dwg";
Response.BinaryWrite(stmDetailData.ToArray());

Best regards,
Jaime.

compare 2 datetime and get hours

Mohammed Elkholy3-Oct-08 9:36

Mohammed Elkholy

3-Oct-08 9:36

first thanks for evryone help others in this website

i would like to compare between tow datetime and get the deffrance between them in hours

example

in parking we get the entrance datetime and leave datetime

i want to compare tow datetime and get the real hours of parking

MD_NADA

Re: compare 2 datetime and get hours

J4amieC3-Oct-08 9:56

J4amieC

3-Oct-08 9:56

TimeSpan ts = dateTime1 - dateTime2;
Console.WriteLine(ts.TotalHours);

Re: compare 2 datetime and get hours

J$3-Oct-08 9:59

3-Oct-08 9:59

You should look into the TimeSpan object.

TimeSpan timeSpan = DateTime.Now.Subtract(new DateTime(2008, 10, 3));

To get the whole number of hours, its as simple as int hours = timeSpan.Hours

If you want to get the total hours, double totalHours = timeSpan.TotalHours

If you're unclear on any of this I recommend taking a look at the documentation or doing a google search on System.TimeSpan

Put sound on own simple program

MorganSim3-Oct-08 8:46

MorganSim

3-Oct-08 8:46

Have been trying up an easy program, but now want to try make it more user friendly by maybe playing a song in the background. How can I go about this one.Anyone help please.(C# base). Cry | :((

Re: Put sound on own simple program

DaveyM693-Oct-08 9:04

DaveyM69

3-Oct-08 9:04

It depends on how you want to do it. The simplest way is:

System.Media.SoundPlayer soundPlayer = new System.Media.SoundPlayer();
soundPlayer.SoundLocation = @"c:\chord.wav"; // full path to file
soundPlayer.Play();

Don't forget to call soundPlayer.Dispose() when you're finished with it!

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

Re: Put sound on own simple program

MorganSim3-Oct-08 10:22

MorganSim

3-Oct-08 10:22

Thanks alot that helped and am able to get through.could have kissed you if you were next to me.(just a jok)
Now check here, that method can only work with .wav file type only? or you can use other files(file size for a wav file is too large).
waiting....
Thanks alot D'Oh! | :doh:

Re: Put sound on own simple program

Dan Neely3-Oct-08 10:32

Dan Neely

3-Oct-08 10:32

IT would have taken less time to change your code to point to an .mp3 file than it did to post the question here.

Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots.
-- Robert Royall

Re: Put sound on own simple program

DaveyM693-Oct-08 10:58

DaveyM69

3-Oct-08 10:58

You may be better off embedding media player. Right click on your toolbox and select Chose Items (you may have to wait a while for the next dialog!). Click on the COM Components tab and scroll down and select Windows Media Player.

Drag and drop (& resize) a WMP onto your form. Set the URL property to point to your file and you're done.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

Re: Put sound on own simple program

PIEBALDconsult3-Oct-08 9:37

PIEBALDconsult

3-Oct-08 9:37

Sounds user hostile to me.

Re: Put sound on own simple program

MorganSim3-Oct-08 9:51

MorganSim

3-Oct-08 9:51

What's that supposed to mean? Confused | :confused:

Re: Put sound on own simple program

PIEBALDconsult3-Oct-08 10:23

PIEBALDconsult

3-Oct-08 10:23

The user may not want sound playing.

Pass Dataset table to a stored procedure as a parameter

Litani3-Oct-08 8:46

Litani

3-Oct-08 8:46

I have a program that allows the user to multi-select categories. The control is bound to a dataset table. When the user clicks the get data button, I have to pass the selected categories to a SQL Server stored procedure and limit products to the select categories.

The data is in a table in memory. I know I can loop through the rows of the data table and create some sort of a list and pass it as a varchar(max) parameter to the Store Procedure and parse it. Is there a more efficient method? A method that does not involve looping.

Re: Pass Dataset table to a stored procedure as a parameter

nelsonpaixao3-Oct-08 14:20

nelsonpaixao

3-Oct-08 14:20

you are doing a your way thing i don´t imagine what it is.

i think you are using 1 varchar(max) column instead of 8 whatever columns.
you put all string in that varchar(max) and use "," to separate strings, isn´t thats right?!? so you need to loop to get them after.

i don´t use that, i add more columns and leave some empty if required, but you can do that don´t know if runs faster!

i heard of that in sql forum keep that way it´s ok to me. D'Oh! | :doh:

nelsonpaixao@yahoo.com.br

trying to help & get help

Progammatically pressing underscore,$,% etc keys

Sandeep Kalra3-Oct-08 7:43

Sandeep Kalra

3-Oct-08 7:43

************Programming Challenge**********************

Hi All

Again I have spent more than five hours but still fighting.

I just want to type underscore in my windows textbox.I am able to type characters, Hit enter key etc etc but do not yet found how to print underscore and other special characters like @,$,%,^

I have tried following code .Discovered new things but still trying to find the solution

SendKeys.SendWait(Keys.Decimal.ToString());
SendKeys.SendWait(Keys.S.ToString());
SendKeys.SendWait(Keys.A.ToString());
SendKeys.SendWait(Keys.N.ToString());
SendKeys.SendWait(Keys.D.ToString());
SendKeys.SendWait(Keys.E.ToString());
SendKeys.SendWait(Keys.Oem1.ToString());
SendKeys.SendWait(Keys.Oem102.ToString());
SendKeys.SendWait(Keys.Oem2.ToString());
SendKeys.SendWait(Keys.Oem3.ToString());
SendKeys.SendWait(Keys.Oem4.ToString());
SendKeys.SendWait(Keys.Oem5.ToString());
SendKeys.SendWait(Keys.Oem6.ToString()); // with this type of code getting Oem6 in
// textbox but i wanted 6.
SendKeys.SendWait(Keys.Oem7.ToString());
SendKeys.SendWait(Keys.Oem8.ToString());
SendKeys.SendWait(Keys.OemClear.ToString());
SendKeys.SendWait(Keys.OemBackslash.ToString());
SendKeys.SendWait(Keys.OemCloseBrackets.ToString());
SendKeys.SendWait(Keys.Oemcomma.ToString());
SendKeys.SendWait(Keys.OemMinus.ToString());
SendKeys.SendWait(Keys.OemOpenBrackets.ToString());
//with this code getting OemOpenBrackets in textbox but desired was (.

SendKeys.SendWait(Keys.OemPeriod.ToString());
SendKeys.SendWait(Keys.OemPipe.ToString());
SendKeys.SendWait(Keys.Oemplus.ToString());
SendKeys.SendWait(Keys.OemQuestion.ToString());
SendKeys.SendWait(Keys.OemQuotes.ToString());
SendKeys.SendWait(Keys.OemSemicolon.ToString());
SendKeys.SendWait(Keys.Oemtilde.ToString());

SendKeys.SendWait("{OemSemicolon}"); //givin error
SendKeys.SendWait(Keys.KeyCode== 106); //giving error

SendKeys.SendWait(Keys.E.ToString());
SendKeys.SendWait(Keys.P.ToString());
SendKeys.SendWait(Keys.U.ToString());
SendKeys.SendWait(Keys.K.ToString());
SendKeys.SendWait(Keys.A.ToString()); //working fine
SendKeys.SendWait(Keys.L.ToString());
SendKeys.SendWait(Keys.R.ToString());
SendKeys.SendWait(Keys.A.ToString());
SendKeys.SendWait(Keys.NumPad5.ToString()); //
//with this type of code getting NumPad5 in textbox desired was 5

SendKeys.SendWait(Keys.NumPad4.ToString());
SendKeys.SendWait("{Enter}"); //working fine

Any studymaterial ,sample application or anything related to this will help.I am also trying to find .

Thanks in advance

THE SK
I am the ONE

Re: Progammatically pressing underscore,$,% etc keys

Sandeep Kalra3-Oct-08 8:08

Sandeep Kalra

3-Oct-08 8:08

Hi All

Finally got it on below link

http://msdn.microsoft.com/en-us/library/8c6yea83(VS.85).aspx

The correct way is

SendKeys.SendWait("{+}"); //for typing plus
SendKeys.SendWait("{_}"); //for typing underscore

For this spent more than five hours ... great

THE SK
I am the ONE

Re: Progammatically pressing underscore,$,% etc keys

led mike3-Oct-08 8:49

led mike

3-Oct-08 8:49

Sandeep Kalra wrote:
I just want to type underscore in my windows textbox.

Try using Fire_Fox. See it works I just_did_it. Oh wow, I did it again _ and again! Only took me like 5_seconds!

led mike

Re: Progammatically pressing underscore,$,% etc keys

Sandeep Kalra3-Oct-08 9:01

Sandeep Kalra

3-Oct-08 9:01

Hey led mike

U have used Fire_Fox.I think u should use Fire_Lion now.It will take 50 years to you Laugh | :laugh:

Re: Progammatically pressing underscore,$,% etc keys

Jason Lepack (LeppyR64)3-Oct-08 9:02

Jason Lepack (LeppyR64)

3-Oct-08 9:02

Programattically... Using C#...

Re: Progammatically pressing underscore,$,% etc keys

PIEBALDconsult3-Oct-08 10:32

PIEBALDconsult

3-Oct-08 10:32

You can't just append the character to the text? Confused | :confused:

The process cannot access the file because it is being used by another process

Alan Balkany3-Oct-08 6:51

Alan Balkany

3-Oct-08 6:51

Hi all,

I'm testing an application by writing bitmaps to a temporary file. I thought it would be neat to have an application that monitors this file and updates its picture whenever the file changes.

I use FileInfo to get the last write time, and if it's changed, I make a new Bitmap with the file's contents and display it. The file is never opened. Sounds simple.

The problem is the system thinks the file is in use, and won't let me overwrite it. It says: "The process cannot access the file because it is being used by another process." But I never open the file, and just use it temporarily to get the last write time and make a bitmap.

How can I make Windows realize the file isn't being used in between samples?

Here's the relevant code:

public void monitorFile()
 {
     while (!Form1.done)
     {
         fi = new FileInfo(fname);
         DateTime dt = fi.LastWriteTime;

         if (lastWrite < dt)
         {
             lastWrite = dt;
             parent.showBitmap (new Bitmap(fname));
         }

         fi = null;
         Thread.Sleep(3000);
     }
 }

Thanks!
Alan

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.