|
thank you v much. Now indeed is blinking on pin 7 with command property RtsEnable. very nice.
But now I want to make a matrix of LEDs, dancing.
What I should use? a Demultiplexer CI? I have a 74159 Demultiplexer.In theory it should work + a ULN 2003. It is a easy another way? I need advice.
The Idea is like this: How can I ramify the number of pins to send data to (let's say 80 led's, or 15 steppers(5wire)) a lot of pins and the fv at that I can send the bit information not to be minimize dramatically?
thanks.
|
|
|
|
|
Glad to hear it works!
I'm not a hardware engineer - but I have worked with H/W designers for long enough to have a good idea what they are talking about, so here goes:
Running a large number of LEDs is going to be a problem. Several in fact:
1) Each LED consumes power, and the serial port is not going to give you too much of that! That is one of the reasons USB was designed - it provides 500mA, loads more than RS232. You will need external power very soon, or you will risk damaging your PC. Each LED consumes from 20mA on up, so just 25 is the limit for USB!
2) A 74159 is not realy going to work: it uses four inputs to drive one of 16 outputs. If you want to drive lots of outputs, why not look at putting a PIC or similar in there, and interfacing it to the serial port as a serial port? You can then provide the external power from a main adapter or battery, and do what you like with the LEDs. You would also get an introduction to the wonderful world of microcontrollers! And probably, assembler, though C is available for PICs. It is a lot more flexible that way!
3) You would need to look at MAX232 or similar chip to do the +12/-12V RS232 to +5V logic of ICs whatever you use, or the ICs are all going to die very quickly...
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
|
|
|
|
|
yes the plan is like you said .
I have already a PIC18F4550 PDIP and I intend to program it (maybe some insights on what testing board I should use? the best that there is ) and the cheap one  + the ability of programming with it the older pic 16f84 that I have in stock also;but not necessary.
But my concern is after I program the pic (the18f one) and I have 40 inputs to fill in from the Led matrix, + the external source (an atx will suffice) how I can fill the gap between pic and those 40 inputs? I need something that I can use to fulfill the 40 outputs, no?
or the better way, without pic , I wish to command DIRECT from serial port, to be able to play a little with that matrix and after I am satisfied with the pattern I like THEN I will write it into the pic and use it like a stand alone product.
thanks.
|
|
|
|
|
I can't help you with testing boards (I used breadboard for little tests and "proper" PCB for bigger things, as I had H/W designers available to steal bits from) 
I think your best bet at this point is to start looking at PIC tutorials - Google will find plenty - and working from there, or my advice will probably start introducing problems such as lack of de-couplers, wrong resistor values, etc. PIC experts will be able to help you better I think. It's a good processor range, though.
But, in overview, I would have something like this:
PC communicates to your PCB via RS232
PCB has external power supply
PCB interfaces to PC via MAX232
MAX interfaces to PIC via TTL
PIC interfaces to LEDs via buffer IC from the vast 74xxx range
The PIC software can be told to turn on /of LED individually as required. When you have a pattern you like, programm it directly into the PIC.
Don't forget the buffer chips, to reduce the power loading on the PIC and (potentially) expand the number of driven LED's as required.
Strongly suggest you socket everything on the PCB as it is a lot easer to change than cutting dead chips out and fitting new ones!
Good luck - let me know how it goes!
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
|
|
|
|
|
well i have a textfile that has a bunch of usernames and passwords in them.
they are in this format:
username:password
username2:password2
username3:password3
etc.
now i want to put each of these into a listview, with each login being on a new row.
for example username is in listview1.subitems[0] and the password is in listview1.subitems[1].
then the next account is the same, but on a new line.
im not too sure in how to do this.
i can only seem to get one of the accounts to go into it.
i want each on a new row.
|
|
|
|
|
StreamReader sr = new StreamReader("File.txt");
string line = sr.ReadLine();
while(line != null)//loop through each line until end of file
{
if(line.Contains(":"))
{
string[] parts = line.Split(':');//you may want to validate unless your certain the input is perfect
//now parts will contain username at index[0] and password at index[1]
//so you can add both to a new line in your listview
}
line = sr.ReadLine();//read in the next line, without you will be in endless loop
}
sr.Close();
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
Hi all,
I'm using multiple check boxes. Now i need is to store the multi selected checkbox in a single field of table. Help me with sample code plz.
thanks in advance...
Elizabeth..........
|
|
|
|
|
Not a chance, this is a really bad data design. Store each checkbox result in it's own field. If not your next post will be how to get multiple values from 1 field, and the one after would be how to query that field.
DON'T DO IT.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
i know its bad data but i need it....
|
|
|
|
|
No you need to change your data design, if it is not your decision you need to go argue with whoever has made the decision. You do should not conform to this design unless you can ABSOLUTELY guarantee that the data will NEVER, ever be used. If this is the case then why are you storing the data.
What possible valid reason could you have for storing data in this style.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I agree you should never do this. Though it can be done as I also have posted on a other reply. You really should only do it as a last resort...
Fight tooth and nail, try not to do it.
|
|
|
|
|
Well, here's[^] one very valid situation - I've seen this used in numerous event management systems, and it's a good way to keep recurring sequences in a reasonable amount of memory.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Well Pete ya got me there, I may even have a use for it in a current requirement. However I got an excellent laugh when looking at that artcle and trying to equate it to this post. I will modify my statement to 99% of the time this is just plain wrong.
Additionally the support costs downstream for this type of data storage is going to be extreme. Try explaining that article to a junior support developer.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I must admit, it was the only case I could think of where it was justified (and I racked my brain for maybe 20 seconds).
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
It really all depends on several things but this should be the simplest way of breaking it down.
You would have to first order the check boxes with a system.
Example:
checkbox 1
checkbox 2
checkbox 3 checkbox 4
checkbox 5
checkbox 6
checkbox 7 checkbox 8
So as you see first you would have to visually see an order for the checkboxes.
This order can not change when you go thru your logic.
Next you return back to the good ole days and still used binary standard.
for each box in sequence you assign a 1 or a 0 to based off of if they are checked or not.
Now you parse your string accordingly to read each checkboxes value and you combine each check boxes value when writing the string to the sql server.
example (Continue):
Checkbox 1 = checked
Checkbox 2 = not checked
Checkbox 3 = checked
Checkbox 4 = checked
Checkbox 5 = not checked
Checkbox 6 = checked
Checkbox 7 = checked
Checkbox 8 = checked
Using the standard of 1 = Checked and 0 = Not Checked
you would have something like this to store the value to sql server:
string sqlvalueforfield = checkbox1.checked.tostring()+checkbox2.checked.tostring()+checkbox3.checked.tostring()+checkbox4.checked.tostring()+checkbox5.checked.tostring()+checkbox6.checked.tostring()+checkbox7.checked.tostring()+checkbox8.checked.tostring()
then to retrieve the value back to the form
checkbox3.checked = Cint(sqlvalueforfield.Substring(3,1))
let me know if this helps....
|
|
|
|
|
Hey you beat me to the punch 
var question = (_2b || !(_2b));
|
|
|
|
|
YEA I win. now if I could get help on my issue of retreiving a image from sql server....
but anyway... PLEASE Understand Really bad idea.
|
|
|
|
|
While technically possible, this is a REALLY bad idea.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Provided, your checkboxlist always looks the same, i.e. it has the same number of checkboxes and they are indexed the same way, if you use a varchar field to store a string of numbers, something like "101100101",
you can then use a stringbuilder to create your string iterating through the collection of your checkboxes.
If the checkbox is checked, set the value to one and zero if it's unchecked.
I do agree that this is not the greatest of designs, but it might just make do.
Another way to do it would be to use an Xml field (provided your using Sql Server), and store the values in there.
var question = (_2b || !(_2b));
|
|
|
|
|
I have done this in the past and I don't see anything wrong with it provided the data values are directly related to one another.
[Serializable(), Flags()]
public enum DayBitFlag
{
None = 0,
Sunday = 1,
Monday = 2,
Tuesday = 4,
Wednesday = 8,
Thursday = 16,
Friday = 32,
Saturday = 64
}
Then create a class that inherits CheckBox, something like this:
public class DayCheckBox : CheckBox
{
private DayBitFlag _dayValue;
public DayBitFlag DayValue
{
get { return _dayValue; }
set { _dayValue = value; }
}
}
I am sure you can work the rest out from here.
Adam
|
|
|
|
|
Thank u 
|
|
|
|
|
I am able to store my pictures into the sql server using the following code:
private void pictureBox3_DoubleClick(object sender, EventArgs e)
{
intASUserListSelectedIndex = lbxAssistSuiteUserList.SelectedIndex;
bool FoundUser = false;
FileDialog fldlg = new OpenFileDialog();
//specify your own initial directory
if (lbxAssistSuiteUserList.SelectedIndex > -1)
{
try
{
fldlg.InitialDirectory = @":C\";
//this will allow only those\ file extensions to be added
fldlg.Filter = "Image File (*.jpg;*.bmp;*.gif)|*.jpg;*.bmp;*.gif|(*.gif)|*.gif|(*.jpg)|*.jpg|(*.jpeg)|*.jpeg|(*.bmp)|*.bmp|(*.wmf)|*.wmf|(*.png)|*.png";
//fldlg.ShowDialog();
if (fldlg.ShowDialog() == DialogResult.OK)
{
imagename = fldlg.FileName;
Bitmap newimg = new Bitmap(imagename);
pictureBox3.SizeMode = PictureBoxSizeMode.Zoom;
pictureBox3.Image =(Image)newimg;
//pictureBox3.Image = System.Drawing.Image.FromFile(openFileDialog1.FileName);
pictureBox3.Refresh();
//Update the SQL Tables.
lbxAssistSuiteUserList.SelectedIndex = intASUserListSelectedIndex;
btnUpdateAssistUsers_Click(sender, e);
lbxAssistSuiteUserList.SelectedIndex = intASUserListSelectedIndex;
updatedata();
}
fldlg = null;
lbxAssistSuiteUserList.SelectedIndex = intASUserListSelectedIndex;
}
catch (System.ArgumentException ae)
{
imagename = " ";
MessageBox.Show(ae.Message.ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
}
private void updatedata()
{
bool FoundMe = false;
int UserIndex = -1;
//use filestream object to read the image.
//read to the full length of image to a byte array.
//add this byte as an oracle parameter and insert it into database.
try
{
//proceed only when the image has a valid path
if (imagename != "")
{
FileStream fs;
fs = new FileStream(@imagename, FileMode.Open, FileAccess.Read);
//a byte array to read the image
byte[] picbyte = new byte[fs.Length];
fs.Read(picbyte, 0, System.Convert.ToInt32(fs.Length));
fs.Close();
//open the database using odp.net and insert the data
string connstr = WhatIsMyConnectionString;
SqlConnection conn = new SqlConnection(connstr);
conn.Open();
//Find the index
for (i = 0; i < ApplicationUsersArray.Count; i++)
{
if (((DomainUsersClass)ApplicationUsersArray[i]).WindowsLogonName == lbxAssistSuiteUserList.Items[lbxAssistSuiteUserList.SelectedIndex].ToString())
{
FoundMe = true;
break;
}
}
if (FoundMe = true)
{
UserIndex = Convert.ToInt32(((DomainUsersClass)ApplicationUsersArray[i]).Index);
}
else
{
MessageBox.Show("We have a serious problem. This should Never Happen. \n The Array did not find the correct users to grab their index for the Picture. \n The Application will now quit.");
Application.Exit();
Application.ExitThread();
}
string query;
query = "insert into tblApplicationUsersPic(id_image,pic) values(" +
UserIndex.ToString() + "," + " @pic)";
SqlParameter picparameter = new SqlParameter();
picparameter.SqlDbType = SqlDbType.Image;
picparameter.ParameterName = "pic";
picparameter.Value = picbyte;
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.Add(picparameter);
cmd.ExecuteNonQuery();
if (FoundMe = true)
{
SQLUpdate(WhatIsMyConnectionString, "tblApplicationUsers", "tblApplicationUsersPic_idx = (Select idx_tblApplicationUserPic from tblApplicationUsersPic where id_image = '" + UserIndex.ToString() + "') ","delflag = 0 and idx_tblApplicationUsers = '" + UserIndex.ToString() + "' ");
//UserIndex = Convert.ToInt32(((DomainUsersClass)ApplicationUsersArray[i]).Index);
}
MessageBox.Show("Image Added");
cmd.Dispose();
conn.Close();
conn.Dispose();
Connection();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Connection()
{
//connect to the database and table
//selecting all the columns
//adding the name column alone to the combobox
try
{
string connstr = WhatIsMyConnectionString;
SqlConnection conn = new SqlConnection(connstr);
conn.Open();
empadap1 = new SqlDataAdapter();
empadap1.SelectCommand = new SqlCommand("SELECT * FROM tblApplicationUsersPic", conn);
dset = new DataSet("dset");
empadap1.Fill(dset);
DataTable dtable;
dtable = dset.Tables[0];
comboBox1.Items.Clear();
foreach (DataRow drow in dtable.Rows)
{
comboBox1.Items.Add(drow[0].ToString());
comboBox1.SelectedIndex = 0;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
But I am unable to retreive the picture from the Sql Server.
Here is my current code to retreive the picture, it keeps erroring saying I do not have something defined and when I define it it still does not work....
Here is the code I use to retreive the image from the database.
//Picture of the User
DataTable dataTable = dset.Tables[0];
if (pictureBox3.Image != null)
{
pictureBox3.Image.Dispose();
}
for (i = 0; i < ApplicationUsersArray.Count; i++)
{
if (((DomainUsersClass)ApplicationUsersArray[i]).WindowsLogonName == lbxAssistSuiteUserList.Items[lbxAssistSuiteUserList.SelectedIndex])
{
break;
}
}
if (((DomainUsersClass)ApplicationUsersArray[i]).PicIndex != "0" || ((DomainUsersClass)ApplicationUsersArray[i]).PicIndex != "")
{
try
{
//using filestream object write the column as bytes and store it as an image
FileStream FS1 = new FileStream("image.jpg", FileMode.Create);
foreach (DataRow dataRow in dataTable.Rows)
{
//if (dataRow[0].ToString() ==
byte[] blob = (byte[])dataRow[1];
FS1.Write(blob, 0, blob.Length);
FS1.Close();
FS1 = null;
pictureBox3.Image = Image.FromFile("image.jpg");
pictureBox3.SizeMode = PictureBoxSizeMode.Zoom;
pictureBox3.Refresh();
}
}
catch
{
MessageBox.Show("Picture retrival Error");
ErrorLogWriter("We have a issue with retreiving the picture stored in the sql server table.");
}
}
|
|
|
|
|
It might help is you gave the error message (in full) simply saying that "it says something is not defined" doesn't help us to pin down the problem.
What is it that you have not defined?
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
I need a formula to calculate the difference in Hours and Minutes between two times.
Example: Table name = attandance and the fields that need to be calculated are:
[timein] = 1:15 PM
[timeout] = 1:44 PM.
I need the formula create a calculated field which equals 0:29.
I know the fomula that makes this work in Access (=HoursAndMinutes([Shipped]-[Picked]) but I need to write a Crystal report.
Thanks In Advance
|
|
|
|
|
I think that you will be wanting this.
<a href="http://weblogs.sqlteam.com/jeffs/archive/2007/08/29/SQL-Dates-and-Times.aspx">http://weblogs.sqlteam.com/jeffs/archive/2007/08/29/SQL-Dates-and-Times.aspx</a>[<a href="http://weblogs.sqlteam.com/jeffs/archive/2007/08/29/SQL-Dates-and-Times.aspx" target="_blank" title="New Window">^</a>]
From my limited knowledge crystal uses sql language and I believe this will explain how to subtract the 2 time stamps as a date time stamp...
The other way to go about this is to substring the field seperating the hours and minutes into variables and manually do the subtraction into the result.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
