|
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.
|
|
|
|
|
this link is not working.
|
|
|
|
|
Hi all,
I am working on Medical transcription voice file format conversion. I need a help on This voice file (.DSS, .DSS2) to WMA or WAV file format conversion. Anybody have an idea feel free to post or share with me.
Thanks in Advance.
pandu
|
|
|
|
|
Hello, I just want to know if its possible to include the delimiter in the string output??
For example:
char[] delim = new char[] {';', ' '};
and the output:
for(int
x=0;
x<5;
x++)
Is there a way without using regex class?
|
|
|
|
|
See String.Split method.
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
I think you didn't understand what i mean..What i really want to say is if for example i have a semi-colon which is a delimiter, is it possible to still include the semicolon to the splitted string?
For example:
string str = "for(int x=0; x<5; x++) Console.WriteLine("Hello");
in the above example, i want to split the string using the delimiter semi-colon, but at the same time i want it to be included in the splitted string.
For example, instead of this output:
for(int
x=0
x<5
c++)
I want this kind of output:
for(int
x=0;
x<5;
x++)
If you'll notice the semicolon, which is a delimiter is also included in my desired output...Is this possible?
|
|
|
|
|
Good luck with for ( int x = 0 ; x < 5 ; x++ )
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.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
