Re: Datagridview to Database table - C# Discussion Boards

First Prev Next

Re: Beep() does not work

Rajesh R Subramanian14-Jul-09 23:55

Rajesh R Subramanian

14-Jul-09 23:55

gehbitte wrote:
public static void Alarm()
{
for (int i = 0; i < 3; i++)
{
Beep(500, 1000);
Beep(1000, 1000);
}
}

You are not bothering to check the return value from the API. Can you check it to verify that the function succeeds?

It is a crappy thing, but it's life -^ Carlo Pallini

Re: Beep() does not work

Luc Pattyn15-Jul-09 0:37

Luc Pattyn

15-Jul-09 0:37

Hi,

long time ago I started using this P/Invoke code:

/// <summary>
/// MessageBeep.
/// </summary>
/// <param name="type">Beep type:
/// 0x10 = "x" = HAND, ERROR, STOP = sound "Critical Stop"
/// 0x20 = "?" = QUESTION = sound "Question"
/// 0x30 = "!" = EXCLAMATION, WARNING = sound "Exclamation"
/// 0x40 = "i" = ASTERISK, INFORMATION = sound "Asterisk"
/// </param>
/// <returns></returns>
[DllImport("user32.dll")]
public static extern bool MessageBeep(int type);

Not sure I still have to do it this way though.
BTW: Make sure through Control Panel Sounds the right sounds are installed.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: Beep() does not work

gehbitte15-Jul-09 23:35

gehbitte

15-Jul-09 23:35

Thanks for the help, I found out that the PC Speaker is not supported anymore by Vista 64bit Systems!

Need help.

mjawadkhatri14-Jul-09 22:21

mjawadkhatri

14-Jul-09 22:21

Hi.
this is my coding

string MyString;
MyString = "Select * from timemgmt";
if (radioin.Checked == true)
{
cn = new OdbcConnection("Driver={Microsoft ODBC for Oracle};Server=orcl;UID=it;PWD=cr;");

cmd = new OdbcCommand(MyString, cn);
cn.Open();
cmd.CommandText = "insert into timemgmt values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";
cmd.ExecuteNonQuery();
cn.Close();

textbox1.text = employe ID
label19.text = System Date
label18.text = System Time

i want to do Accept employee ID in one time in a day 2nd time user give same Id in a same date not accepted
plzz give me some hints

thanks in Advance

Jawad Khatri

Re: Need help. [modified]

Blue_Boy14-Jul-09 22:30

Blue_Boy

14-Jul-09 22:30

This is SQL query

if(select id from timemgmt where id=@id)=0
begin
insert values
end

but be aware from SQL Injections

mjawadkhatri wrote:
"insert into timemgmt values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";

and rename controls by giving more meaningfull names.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

modified on Wednesday, July 15, 2009 4:40 AM

Re: Need help.

mjawadkhatri14-Jul-09 23:48

mjawadkhatri

14-Jul-09 23:48

Where i Put This Query???

Datagridview to Database table

5fingers14-Jul-09 22:10

5fingers

14-Jul-09 22:10

How can I load datagridview data to a database table
Thanks

Re: Datagridview to Database table

Vimalsoft(Pty) Ltd14-Jul-09 23:34

Vimalsoft(Pty) Ltd

14-Jul-09 23:34

Good Morning onyang2

You have to be carefull with the names.

There is a GridView and a Datagrid.

is this a Windows App or a Web App ?

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Re: gridview to Database table asp.net C#

5fingers14-Jul-09 23:37

5fingers

14-Jul-09 23:37

It is a web application

Re: gridview to Database table asp.net C#

Vimalsoft(Pty) Ltd14-Jul-09 23:47

Vimalsoft(Pty) Ltd

14-Jul-09 23:47

that is a gridview, you must asp such questions in the ASP.NET Forum next time.

here is a solution

http://www.dotnetfunda.com/articles/article131.aspx[^]

http://www.dotnetfunda.com/articles/article121.aspx[^]

How to get listbox items to string?

swetha_insoft14-Jul-09 21:04

swetha_insoft

14-Jul-09 21:04

listbox is having more than one value....
how to get those value to one string?

Re: How to get listbox items to string?

SeMartens14-Jul-09 21:09

SeMartens

14-Jul-09 21:09

Hi,

well you could iterate through the listbox-items and concat their text-properties. Just something like this:

StringBuilder oBuilder = new StringBuilder();
foreach(object oCurItem in myListbox.Items) {
  oBuilder.Append(oCurItem.ToString());
}
string sResult = oBuilder.ToString();

Let me know if this helps you.

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: How to get listbox items to string?

stancrm14-Jul-09 21:11

stancrm

14-Jul-09 21:11

StringBuilder sb = new StringBuilder();
foreach (string s in listBox1.Items)
  sb.Append(s);

Re: How to get listbox items to string?

swetha_insoft14-Jul-09 21:21

swetha_insoft

14-Jul-09 21:21

string s = "";
for (int i = 0; i < lstSelected.Items.Count; i++)
{
if (s != "")
{
s = s + "," + lstSelected.Items[i].ToString();
}
else
{
s = lstSelected.Items[i].ToString();
}
}

But S-->is getting "System.Data.DataRowView" value instead of listbox item.

Re: How to get listbox items to string?

SeMartens14-Jul-09 21:26

SeMartens

14-Jul-09 21:26

Try to use

<br />
<br />
((System.Data.DataRowView) lstSelectedItems.Items[i]).Item[0].ToString()<br />
<br />

instead.

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: How to get listbox items to string?

Blue_Boy14-Jul-09 21:53

Blue_Boy

14-Jul-09 21:53

StringBuilder s = new StringBuilder();

for (int i = 0; i < lstSelected.Items.Count; i++)
{
s.Append(lstSelected.Items[i].Text);
}

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: How to get listbox items to string?

dule4327-Aug-09 15:07

dule43

27-Aug-09 15:07

foreach (DataRowView item in listBox.Items)
{
txtBox.Text += item.Row["RowNameYouWant"].ToString() + "\n";
}

random number generation

givya14-Jul-09 21:02

givya

14-Jul-09 21:02

i wanna know how to create random numbers in c#. in my application i need to provide a default password if the user forgets the password. i wanna give this default password in the form of random numbers. pls help...

Re: random number generation

SeMartens14-Jul-09 21:04

SeMartens

14-Jul-09 21:04

Hi,

the .NET framework provides a Random-class. Have a look here: http://msdn.microsoft.com/en-us/library/system.random.aspx[^]

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: random number generation

Rajesh R Subramanian14-Jul-09 21:05

Rajesh R Subramanian

14-Jul-09 21:05

Hello Givya,

Have you tried searching[^]?

It is a crappy thing, but it's life -^ Carlo Pallini

Re: random number generation

himanshu256114-Jul-09 21:13

himanshu2561

14-Jul-09 21:13

Hi Use Random class like

Random r = new Random();

givya wrote:
in my application i need to provide a default password if the user forgets the password

IMO ,If possible try to provide forgot password functionality like [Hint Question or Alternate Email]...

himanshu

Re: random number generation

givya15-Jul-09 2:27

givya

15-Jul-09 2:27

I gave the following code to generate the random string(searched it on internet).
private string RandomString(int size, bool lowerCase)
{

StringBuilder builder = new StringBuilder();
Random random = new Random();
char ch;
for (int i = 0; i < size; i++)
{
ch = Convert.ToChar(Convert.ToInt32(Math.Floor(26 * random.NextDouble() + 65)));
builder.Append(ch);
}
if (lowerCase)
return builder.ToString().ToLower();
return builder.ToString();
}

Bt its giving the following error:

A using namespace directive can only be applied to namespaces; 'System.Text.StringBuilder' is a type not a namespace

I hav used this also: "using System.Text.StringBuilder;"

Pls help

Need help.

mjawadkhatri14-Jul-09 20:56

mjawadkhatri

14-Jul-09 20:56

Hi.
i get system date in this format "mm/dd/yyyy" like "07/15/2009" now i want to change date format like this "15-JUL-2009"
how can i do??

thanks in Advance

jawad khatri

Re: Need help.

SeMartens14-Jul-09 21:01

SeMartens

14-Jul-09 21:01

Hi,

take a look at MSDN: http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx[^]

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: Need help.

K030614-Jul-09 21:07

K0306

14-Jul-09 21:07

Try this

            DateTime dt = DateTime.Now;
            MessageBox.Show(dt.ToString("dd/MMM/yyyy"));
            <pre> 

<div class="ForumSig">Regards,
Karthik K...</div>

Last Visit: 31-Dec-99 18:00 Last Update: 18-Apr-24 18:08

Refresh

ᐊ Prev 1...4701 4702 4703 470447054706 4707 4708 4709 4710 Next ᐅ

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