First of all you should have a flag field on your users table which determines which user are online. On my databases this field I name it as "logged" with the type of bit and then on the time when the user is logged to the application then this field will be updated to true and on the time when he is loged out then will be false. Since you have this flag on your users table it's very easy to know which users are online. Regards :)

Qendro

I totally agree with You my friend...I also think that is very frustrating for the user to prevent from "Show Desktop" feature...

Qendro

There are two ways: 1)from the main form's property window MinimizeBox to set the property false 2)on load event of the main form put these two lines of code:

this.WindowState = FormWindowState.Maximized;
this.MinimizeBox = false;

Regards

Qendro

Try this:

private void SendEmail(string from, string to, string subject, string body)
{
SmtpClient client = new SmtpClient("smtp.gmail.com", 587);
client.DeliveryMethod = SmtpDeliveryMethod.Network;
client.Credentials = new NetworkCredential("emailaddress", "password");
client.EnableSsl = true;

     string\[\] emails = to.Split(';');
     foreach(string s in emails)
     {
         if(s != string.Empty)
              client.Send(from, s, subject, body);
     }

}

Since i didn't watch where is your mistake, I had the method already written and just paste it here ;) Hope it will work for U too

Qendro

to do this I think you should do the following:

DatRow dr = dsCustomerDataset.Customers.NewCustomerRow();
dr[0] = "";
dr[1] = "";
dsCustomerDataset.Customers.AcceptChanges();

then since you fill the binding source with your data set when you use the bindingSource.MoveLast() method it will fill your controls with empty data row which you'll add. hope this will help you!

Qendro

Hi I am working in sql 2000 database and I want to retrieve a select statement and generate an xml. Everything goes perfect except the fact that I can't add a general root for the entire result from dhe generated xml. My code is like this:

SELECT FirstName , LastName
FROM Employees
FOR XML AUTO, ELEMENTS

and the result for this is

<Employees>
<FirstName>Nancy</FirstName>
<LastName>Davolio</LastName>
</Employees>
<Employees>
<FirstName>Andrew</FirstName>
<LastName>Fuller</LastName>
</Employees>
<Employees>
<FirstName>Janet</FirstName>
<LastName>Leverling</LastName>
</Employees>
<Employees>
<FirstName>Margaret</FirstName>
<LastName>Peacock</LastName>
</Employees>

but what I want is that this xml to look like this

<Table1>
<Employees>
<FirstName>Nancy</FirstName>
<LastName>Davolio</LastName>
</Employees>
<Employees>
<FirstName>Andrew</FirstName>
<LastName>Fuller</LastName>
</Employees>
<Employees>
<FirstName>Janet</FirstName>
<LastName>Leverling</LastName>
</Employees>
<Employees>
<FirstName>Margaret</FirstName>
<LastName>Peacock</LastName>
</Employees>
</Table1>

thanks for any advice. p.s. I meantioning again that im workin in sql 2000

Qendro

i tried this and it worked:

private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
e.CellStyle.BackColor = Color.Red;
if (i % 2 == 0)
{
e.CellStyle.BackColor = Color.Blue;
}
}
}

Qendro

did you try this:

for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
dataGridView1.BackgroundColor = Color.Red;
if (i % 2 == 0)
{
dataGridView1.BackgroundColor = Color.Blue;
}
}

Qendro

its not nessesary to do it by writitng code because the checkboxlist has a build in property MultiColumn to set it TRUE

Qendro

the caracters are 1500011600190121KLM090034557908K0000000000000098 so these caracters are builded as barcode on different way in my application rather than on an application that I downloaded it as a demo that uses also IDAutomation(CODE 128).

Qendro

On an application that uses ID Automation logic building barcodes the same caracters passed on application are represented deifferent on another application, why could be that problem regards!

Qendro

thanks a lot! It was the perfect example for my example

Qendro

i have a procedure in SQL Server which takes a sum of a column between two values and the ID of the partner but how should I call that procedure on a button click event and populate that sum in a textbox by giving as an argument of the values from tree comboboxes which are the two values and the partner. here is the procedure create procedure pvShuma ( @PartneriID int, @XhiroPrej int, @XhiroDeri int ) as select sum(Hyrje) from dbo.tblXhiro where NrXhiro between @XhiroPrej and @XhiroDeri and PartneriID = @PartneriID thanks for any advice!

Qendro

Could You be more specific and tell me where to write Combobox1.Value because in my code I wrote Combobox1.ValueMember = "PartneriID" which I think is the appropriate thing in this case.My problem is that when I click on the Save button it saves all the values through the parameters exept the PersoniID which is represeted by this combobox. Thank You for your reply and I would be thankful if You put me in a correct road with this problem. :)

Qendro

hello to everyone I'm trying to store an ID of a person from a table which is related to another so I wrote a peace of code that takes the names of persons from that table and expandes them on a combobox but when I click on a Save button it does not take the ID of a person to store it on a table which is related. Here is my code: Private Sub frmXhirojare_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim ds As New DataSet Dim conn As SqlConnection = New SqlConnection("Data Source=.;Initial Catalog=dbHyrjaXhirove;Integrated Security=True") Dim selection As String = "SELECT PartneriID, Emri FROM tblPartneret" Dim dataadapteri As SqlDataAdapter = New SqlDataAdapter(selection, conn) dataadapteri.MissingSchemaAction = MissingSchemaAction.AddWithKey dataadapteri.Fill(ds, "tblXhiro") ComboBox1.DataSource = ds.Tables("tblXhiro") ComboBox1.ValueMember = "PartneriID" ComboBox1.DisplayMember = "Emri" End Sub I would be thankful to everyone who takes a minute from his time to explain it to me why when I click to the Save button it does not take the PartneriID in this case and store it on related table.

Qendro

Hi everyone...Can anyone of you help with this task because I started an application that supports audio and media format but I don't know how can I use OpendDialog to place a song on a ListBox... best wishes

Qendro

if you want to import System sounds like Asterisk,Beep,Hand and others you should import the namespace System.Media but if you want to add a project that plays any kind of sound formats you can use a DirectX component called Quartz.dll which is part of Windows MediaPlayer and Windows Operating system.This file you can find in this path: C:\WINDOWS\system32.Open the Visual Studio Command Line and type the following command:[WindowsDir]/tlbimp quartz.dll /out:QuartzTypeLib.dll.The [WindowsDir] is where your instalation of operating system is(in most cases C:\).I hope I helped you cause I had the same problem and should digging a lot to find a way to play sound formats.Best wishes! :)

Qendro