|
Something like this:
using System.Data.OleDb;
.
.
.
void FillList()
{
OleDbConnection conn = new OleDbConnection("connection string"))
OleDbCommand cmd = new OleDbCommand("SELECT * FROM TableName;", conn))
OleDbDataReader rdr = cmd.ExecuteReader();
while(rdr.Read())
{
ListViewItem item = new ListViewItem();
item.Text = ((int) rdr["MemberNumber"]).ToString();
item.SubItems.Add((string) rdr["FirstName"]);
item.SubItems.Add((string) rdr["LastName"]);
listView.Items.Add(item);
}
rdr.Close();
} What you are doing is initializing a data reader with the resultset from the SELECT query. For every record, you add an item to the list view, with the member number on the first column, and then the first name and last name.
I've left out all error checking, such as in case the connection couldn't be openned, or the some of the fields were null. But that's the general idea.
Don't forget to check the docs to learn more.
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
Thanks alot Luis. That was a big help.
I am having some trouble opening the connection string. Im getting a runtime error declaring that it is set to close. Ive tried a bunch of things but cant seem to get it.
If you have any thoughts there id appreciate it. Thanks again.
|
|
|
|
|
Oops, I forgot:
conn.Open(); should go after declaring the connection, before creating the command object.
If you have trouble with the connection string, for an Access database it is "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb; . Check here[^] for more information.
Good luck!
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
I'm performing a conversion of a VB6 app to C#. The VB6 app used CRC32 for hashcode checksum generation for files.
Results generation between CRC32 (C#) vs. CRC32 (VB6) appear to be inconsistent for the same physical file:
VB6 calls: CalculateFile(<file spec string>)
This returns a large negative integer whose hex equivalent is different from the C# result
C# calls:
I tried ComputeHash(FileStream object) and ComputeHash(<byte array>)
(C# results consistent for both methods)
(I suspect probably because in VB6 the decimal number result is converted to hex after CRC does its thing, whereas the C# CRC seems to convert byte-by-byte and returns a hex).
Since this is a conversion with an installed base, we can't have old checksums compared against new results for the same file. Why does "old" CRC return a large negative decimal and "new" CRC return a byte array that converts to hex?
Not being well versed in byte/hex/decimal conversions, anybody know where I might be going wrong?
Thanks in advance.
Phil
|
|
|
|
|
If a number is not unsigned, the first bit represents if it is negative or not. Try converting that number to an unsigned type, and see if they are the same.
Congratulations on moving to C#, by the way Are you doing it by hand ? If .NET will convert VB6 to VB.NET, there are some great VB.NET -> C# converters out there. I will only accept jobs where I'm allowed to move to C#, so I've used it a bit with good success.
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
Hi,
Do any of you have a good example of accessing a WebService over SSL.
I have done most of the research, it keeps failing saying it as
-------------------
The request failed with HTTP status 403: Forbidden.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Net.WebException: The request failed with HTTP status 403: Forbidden.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[WebException: The request failed with HTTP status 403: Forbidden.]
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +1296
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +218
testapp.helloworld.Service1.HelloWorld()
testapp.WebForm1.Page_Load(Object sender, EventArgs e)
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
---
I have installed the client certificate on my client browser and adding this certificate into ClientCertificates collection before calling the WebService.
We are using Entrust Certificate.
Thanks in advance.
Regards,
Anand Chida
|
|
|
|
|
if your IIS server has a good certificate installed, there is no purpouse to set the certificate client side.
But should work as it works non https too
|
|
|
|
|
Tell me how many would be willing to buy a product for 10$.
Here is the Link ... www.speechtoolscenter.com
There are no links for buying yet. i hope they will add a link soon.
this product reads( word,text,html) file, user can record their own commands.
and much more...
|
|
|
|
|
I wouldn't buy a damn thing from someone who is too cheap to buy advertising space!
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I want to know a question from you that i want to apply a timer between my code. you help me please.
means that for example i have two lines of code let say.
console.writeline("hello1);
console.writeline("hello2);
Now i wana to do that after 10 seconds console.writeline("hello2) executes(not every 10 sec).
console.writeline("hello1);;
//timer of 10 sec//
console.writeline("hello2);
Means that when console.writeline("hello1) then after 10 sec console.writeline("hello2) should be executed..
Please help me ,, i m very near to my destiny.
with regards
Ishtiaq Ahmed
|
|
|
|
|
<br />
maybe this will help<br />
<br />
console.writeline("hello1);<br />
System.Timers.Timer t1 = new System.Timers.Timer();<br />
t1.Interval = 10000;<br />
t1.Elapsed += new System.Timers.ElapsedEventHandler(ont1);<br />
t1.AutoReset = true;<br />
t1.Enabled = true;
and define the ont1 event handler:
public static void ont1(object sender, System.Timers.ElapsedEventArgs e)<br />
{<br />
console.writeline("hello2);<br />
}
there are no facts, only interpretations
|
|
|
|
|
sit this i have checked..its hapeening every 10 sec.but i need to do is that it should be executed 1ce after 10 sec.
i.e
eg when i cliked on button which have two message box,then after first messagebox ,second messagebox appears after 10 sec....in this case
t1.Elapsed += new System.Timers.ElapsedEventHandler(ont1);
if i remove '+' then it can be possible but it cant.
so i need to execute like this way
|
|
|
|
|
Im sorry to say this, but your problem might be that you dont understand how the timer works, maybe due to some problems with the English language.
You should start looking up words you dont understand (like Timer.Enabled) instead of simply hacking in the lines.
ENABLED is used to activate or deactivate the timer, though most of the time Stop() and Start() are the better choices.
If you disable the timer (i.e. Timer.Stop() ) after the first elapsed-event, the timer will not "tick" again.
Cheers
Sid
|
|
|
|
|
You're not very specific about what your looking for, but you might want to try:
console.writeline("hello1");
Thread.Sleep(10000);
console.writeline("hello2");
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
it simple.
let say i have button on my form,,,,and i have two messageboxes on my button click..i need to do that when ever i click my button,1st message box appears and 2nd message box appears after 10 sec .
|
|
|
|
|
I want to know a question from you that i want to apply a timer between my code.ca you help me please.
means that for example i have two lines of code let say.
Method1();
Method2();
Now i wana to do that after 10 seconds the Method2 executes(not every 10 sec).
Method1();
//timer of 10 sec//
Method2();
Means that when Method1 then after 10 sec Method2 should be executed..
Please help me ,, i m very near to my destiny.
with regards
Ishtiaq Ahmed
|
|
|
|
|
include the file System.Threading and use the statement Thread.Sleep(10000); //thats 10,000 milliseconds or 10 seconds
- Nik
Shardool Karnik
Lead Software Engineer
Compass Technologies, Inc.
http://www.compasstec.com
|
|
|
|
|
I want to know a question from you that i want to apply a timer between my code.ca you help me please.
means that for example i have two lines of code let say.
Method1();
Method2();
Now i wana to do that after 10 seconds the Method2 occurs(not every 10 sec).
Method1();
//timer of 10 sec//
Method2();
Means that when Method1 occurs then after 10 sec Method2() should be executed..
Please help me
with regards
Ishtiaq Ahmed
|
|
|
|
|
Hi,
I would like to force a change to the short date format in the time regional settings when i run my application. How can this be done?
Thanks for any help.
Regards,
Stephen
|
|
|
|
|
Not a good idea at all. Changing the setting system wide will affect other applications running on the system at the same time. This is usually not tolerated by users and is HIGHLY discouraged.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
You could try changing the region for your application. But don't do it for the entire system.
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
About three weeks ago I started the laborious task of teaching myself C# .NET....having zero OOP experience has made the process fairly difficult. I am building a small systems management application “mostly as a learning experience” and I’m stuck on two issues. First, I can’t figure out how to add a NT logon name/account to Active Directory…I can add pre-windows users, but that’s it. Second, I’m trying to control directory/folder security permissions; but again, I’m stuck. I’ve tried to implement the FileIOPermission class, but it doesn’t seem to apply to directories/folders.
I appreciate your help,
Thanks,
Mark
|
|
|
|
|
How do I place a link label on a datagrid column?
|
|
|
|
|
Hi all,
I have a ServicedComponent derived class which has a private local variable. When a method of that class is called and I try to assign a passed parameter to the local variable, it doesn't. The local variable continues to have its original value.
What am I doing wrong? Or what configuration steps should I be taking that I am missing in order to make it work?
Here is the sample program.
using System;
using System.Data;
using System.Data.SqlClient;
using System.EnterpriseServices;
using System.Runtime.CompilerServices;
namespace test02
{
///
/// Summary description for Trx.
///
[Transaction(TransactionOption.Required, Isolation = TransactionIsolationLevel.Serializable)]
public class Trx : ServicedComponent
{
SqlConnection _conn;
SqlDataReader _rdr;
int _i = 45;
string _connstr = "Integrated Security=SSPI; Persist Security Info=False;Data Source=TMC092; Packet Size=4096;Initial Catalog=pubs;";
public Trx()
{
}
[AutoComplete(true)]
public void execute(int i)
{
_i = i;
useDataset();
}
private void useDataset()
{
_conn = new SqlConnection(_connstr);
SqlCommand selectCMD = new SqlCommand("SELECT au_id, au_lname FROM authors", _conn);
selectCMD.CommandTimeout = 30;
SqlDataAdapter custDA = new SqlDataAdapter();
custDA.SelectCommand = selectCMD;
_conn.Open();
DataSet custDS = new DataSet();
custDA.Fill(custDS, "Customers");
foreach(DataRow r in custDS.Tables[0].Rows)
{
Console.WriteLine(r[0]);
}
_conn.Close();
}
}
}
The calling function is simply:
static void someMethod()
{
try
{
Trx tx = new Trx();
tx.execute(78);
}
catch(Exception e)
{
Console.Write(e.Message);
}
}
from within another class.
The local variable _i shows its value as zero, not 45, not 78, but zero. What's going on?
Thanks for all help.
|
|
|
|
|
I have created a windows service and would like to print some pdfs. I have the code written which basically print the pdf by first putting it on a clipboard and then printing it, but the problem is the pdfs will not print. Under task manager, I can see Acrobat running. I know windows service run in a different environment and there is a way that I can make it talk to the dsektop. I just don't know how to do it. Can someone help me? Thanks for your time.
|
|
|
|