Re: Transferring items from a listbox to a string variable - C# Discussion Boards

sravsk15-Dec-09 21:12

15-Dec-09 21:12

Hi
{
using (SqlCeConnection ceConn = new SqlCeConnection("Data Source=" + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase)) + "\\Northwind.sdf; Persist Security Info=False"))
{

ceConn.Open();

SqlCeException was unhandled
There was an error parsing the query. [ Token line number = 1, Token line offset = 61, Token in error =)]

I don't know why, this line did not give an error just 5 minutes ago, I erased new codes and still it gives an error

what should I do?

sravanthi veerisetti

Re: SQL querying problem

Nicholas Butler6-Nov-09 2:00

Nicholas Butler

6-Nov-09 2:00

You should probably also read this:

SQL Injection Attacks and Some Tips on How to Prevent Them[^]

Nick

----------------------------------
Be excellent to each other Smile | :)

Re: SQL querying problem

Calla6-Nov-09 2:36

Calla

6-Nov-09 2:36

Maybe you're screwing up the SQL if you add '" + TextBox1 + "' instead of '" + TextBox1.Text + "'

Re: SQL querying problem

Emmet_Brown6-Nov-09 3:15

Emmet_Brown

6-Nov-09 3:15

Thank y'all Big Grin | :-D

Re: SQL querying problem

Md. Marufuzzaman6-Nov-09 7:09

Md. Marufuzzaman

6-Nov-09 7:09

Try the following......

Function:

<PRE>
string strSqlQuery= "SELECT Name FROM Students WHERE Id LIKE '" + TextBox1 + "%'";

object retValue;
            try
            {
                  ObjSqlCommand = new SqlCommand(strSqlQuery, ObjSqlConnection);
                  ObjSqlConnection.Open();
                  retValue = ObjSqlCommand.ExecuteScalar();

            }
            catch (Exception ex)
            {
                  return (object)ex.Message.ToString();
            }
            finally
            {
                  ObjSqlConnection.Close();
                  ObjSqlCommand = null;
                  ObjSqlConnection= null;
                  strSqlQuery = null;

            }
   return retValue;
</PRE>

Thanks
Md. Marufuzzaman

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you.

I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

Transferring items from a listbox to a string variable [modified]

gamer11276-Nov-09 0:34

gamer1127

6-Nov-09 0:34

Hello. I'm having a little problem transferring all the items in the listbox to a string variable. All the items in the listbox are also string type so i don't have any problems about data types. I tried to use array of string type variable but when i transfer them using a for..loop statement it gets a run-time error that the index was out of bounds. How will I resolve that? How can i store all the items into a variable without selecting them? I used the listbox as a control for outputs.

this is the code:

for (int a = 0; a < lstBoxRequests.Items.Count; a++)
                {
                    string[] passedRequests = new string[a];

                    passedRequests[a] = Convert.ToString(lstBoxRequests.Items[a]);

                    MessageBox.Show(passedRequests[a]);
                }

modified on Friday, November 6, 2009 6:41 AM

Re: Transferring items from a listbox to a string variable

Covean6-Nov-09 1:03

Covean

6-Nov-09 1:03

Try this:

string[] passedRequests = new string[lstBoxRequests.Items.Count];
for (int a = 0; a < lstBoxRequests.Items.Count; a++)
                {
                    

                    passedRequests[a] = Convert.ToString(lstBoxRequests.Items[a]);

                    MessageBox.Show(passedRequests[a]);
                }

Greetings
Covean

Re: Transferring items from a listbox to a string variable

Eddy Vluggen6-Nov-09 1:14

Eddy Vluggen

6-Nov-09 1:14

How manu elements are there in your array? And how many elements would the loop go through?

If your array holds 10 items, then a for-next loop will go from either 1 to 10 or from 0 to 9. Your loop goes 11 times, starting at passedRequest[0] and moving on to passedRequst[10], generating an "index out of bounds". That means that the number between the [] is smaller or larger then the number of items in the array Smile | :)

for (int a = 0; a < lstBoxRequests.Items.Count -1; a++)

Next item is that you're reinitializing the array on each loop. That means that the entire Array is created anew, with a new maximum-upperbound of "a". You'd prolly want a maximum number in the array that corresponds to the number of items in the combobox. That would come to something like this;

int itemCount = lstBoxRequests.Items.Count -1;
string[] passedRequests = new string[itemCount];
for (int a = 0; a < itemCount; a++)
{
    passedRequests[a] = Convert.ToString(lstBoxRequests.Items[a]);

There are easier ways to enumerate through the items, but I'll leave that to the next poster Smile | :)

I are Troll Suspicious | :suss:

Re: Transferring items from a listbox to a string variable

V.6-Nov-09 1:27

6-Nov-09 1:27

I think you'll miss one item with this code.

Eddy Vluggen wrote:
for (int a = 0; a < lstBoxRequests.Items.Count -1; a++)

or do this:

for (int a = 0; a <= lstBoxRequests.Items.Count -1; a++)

or this:

for (int a = 0; a < lstBoxRequests.Items.Count; a++)

V.

Stop smoking so you can: Enjoy longer the money you save.
Moviereview Archive

Re: Transferring items from a listbox to a string variable

Covean6-Nov-09 1:29

Covean

6-Nov-09 1:29

for (int a = 0; a < lstBoxRequests.Items.Count; a++)

Is right, your loop:

for (int a = 0; a < lstBoxRequests.Items.Count - 1; a++)

is wrong it leaves one item alone!

General:

for(int loop=0; loop < count; loop++) or for(int loop=0; loop <= count -1; loop++)!

His problem was the following:

for (int a = 0; a < lstBoxRequests.Items.Count; a++)
                {
                    string[] passedRequests = new string[a];

                    passedRequests[a] = Convert.ToString(lstBoxRequests.Items[a]);   <---- this causes the out of array, because passedRequests.length = a but passedRequests[a] is wrong !!!

                    MessageBox.Show(passedRequests[a]);
                }

Edit: Second problem was the creation of the string array in the loop.

Greetings
Covean

Re: Transferring items from a listbox to a string variable

Eddy Vluggen6-Nov-09 2:12

Eddy Vluggen

6-Nov-09 2:12

Covean wrote:
or (int a = 0; a < lstBoxRequests.Items.Count - 1; a++)
is wrong it leaves one item alone!

You're right, I was wrong. I've been looking at these too much;

for(int x = 0; x <= bla.Count - 1; x++)

Notice that the check has an equals-sign. The current project that I'm working has both styles mixed throughout the code. In VB6 Smile | :)

I are Troll Suspicious | :suss:

Re: Transferring items from a listbox to a string variable

V.6-Nov-09 2:18

6-Nov-09 2:18

Eddy Vluggen wrote:
In VB6

that explains it Big Grin | :-D

V.

Stop smoking so you can: Enjoy longer the money you save.
Moviereview Archive

Drag rectangle using mouse in C#

lexical16-Nov-09 0:31

lexical1

6-Nov-09 0:31

Hi..if sumone knows how to do it plz help i m a beginner in C#.
i have made the reactangle don't know how to drag it with the help of mouse and redraw it where i release the mouse button..

private void Shapes_Paint(object sender, PaintEventArgs e)<br />
      {<br />
            if (Square.Checked == true)<br />
            {<br />
                e.Graphics.DrawRectangle(Pens.Red, 180, 80, 80, 80);<br />
             }<br />
             if (Triangle.Checked == true)<br />
             {<br />
                  e.Graphics.DrawPolygon(Pens.Red, new Point[] {  <br />
                  new Point   (300, 150), new Point(400, 250), new Point<br />
                  (200, 250) });<br />
             }<br />
      }

if i click mouse buton while the mouse is on top of the square, and then holds the mouse button down and drags the mouse, then the square will be dragged by the mouse:

1. As the square is being dragged, the mouse pointer should
remain over the same point on the square as it was when the
mouse was initially clicked. As the mouse is moving, the
square should move continuously with the mouse.
2. If the user clicks the left mouse button with the mouse
outside of the square and then drags the mouse, the square
should not move, even if the mouse is dragged over the
square.

Re: Drag rectangle using mouse in C#

Luc Pattyn6-Nov-09 3:18

Luc Pattyn

6-Nov-09 3:18

Hi,

this is the scheme; items marked OPT are optional (they show the object in a different style while dragging):

1) add class members to keep track of rect position, hit position, ...
OPT: provide a bool "dragging"

2) inside MouseDown:
store mouse position
calculate and store hit position (the point going to be dragged around)
OPT: set dragging true and call Invalidate()

3) inside MouseMove:
calculate and store new rect position
call Invalidate()

4) inside Paint:
draw rectangle based on stored rect position (do NOT use Control.MousePosition)
OPT: the way it is drawn (color, line thickness, ...) may depend on dragging

5) inside MouseUp:
OPT: set dragging false and call Invalidate()

Smile | :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Re: Drag rectangle using mouse in C#

lexical18-Nov-09 21:35

lexical1

8-Nov-09 21:35

Hi..!!
i understand the above points but don't know how to add class members and how to calculate the positions and store them..

what i know is that i have to use 'e' like e.X, e.Y but don't know the proper way for this..

can sumone help me plzz....

Re: Drag rectangle using mouse in C#

Luc Pattyn8-Nov-09 23:10

Luc Pattyn

8-Nov-09 23:10

hina123tariq wrote:
don't know how to add class members

yes you do. Inside a class, but not inside any method, add lines such as private int mouseX;

hina123tariq wrote:
how to calculate the positions

some positions may be absolute (i.e. top left of the screen is 0,0); most positions are relative to their container (i.e. top left of the Control or Form is 0,0). Hence what it takes most often is one addition or one subtraction. Make a little drawing to help yourself.

Smile | :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Javascript Compatible text from c# text

mmdullah6-Nov-09 0:24

mmdullah

6-Nov-09 0:24

Hi all,
I need to send some text from c# to javascript.
So how can I format it so that compatible it will be compatible to javascript.

the c# text includes tab, newline ,', ", \,/,// and other special characters

Re: Javascript Compatible text from c# text

Curtis Schlak.6-Nov-09 10:51

Curtis Schlak.

6-Nov-09 10:51

Take a look at http://www.json.org[^].

"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty

Minimize to tray bar [modified]

Ronni Marker5-Nov-09 22:14

Ronni Marker

5-Nov-09 22:14

Hi all,
writing a small app that reads a registry setting and based on the content on that, should either show the form or hide it in the tray bar.

RegistryKey masterKey = Registry.LocalMachine.CreateSubKey("SOFTWARE\\Policies\\OTM");
if (masterKey != null)
{
    if (masterKey.GetValue("Serial").ToString().Length == 36)
    {
        textBox1.Text = masterKey.GetValue("Serial").ToString();
        textBox1.Enabled = false;
        this.Hide();
    }
    else
    {
        textBox1.Enabled = true;
        this.StartPosition = FormStartPosition.CenterScreen;
        this.WindowState = FormWindowState.Normal;
        this.Show();
    }
}

unfortunately the window always stays open. Anyone who have a quick tip to what Im missing?

I tried to include this.WindowState = FormWindowState.Minimized;, but that just minimized to app, but didnt hide ~~it in the tray bar.~~ - sorry writing error here. Meant didnt hide the form at all. At best it gets to be minimized in the lower left corner.

modified on Friday, November 6, 2009 4:27 AM

Message Closed

5-Nov-09 22:20

stancrm

5-Nov-09 22:20

Message Closed

modified 23-Nov-14 7:20am.

Re: Minimize to tray bar

Ronni Marker5-Nov-09 22:26

Ronni Marker

5-Nov-09 22:26

sorry i didnt mean the tray bay, but it is shown minimized in the left corner just above the traybar ifi i force the app to start minimized.

ShowInTaskbar is already set to false.

Re: Minimize to tray bar

Ronni Marker5-Nov-09 22:37

Ronni Marker

5-Nov-09 22:37

Did a small change

RegistryKey masterKey = Registry.LocalMachine.CreateSubKey("SOFTWARE\\Policies\\OTM");
if (masterKey != null)
{
    if (masterKey.GetValue("Serial").ToString().Length == 36)
    {
        textBox1.Text = masterKey.GetValue("Serial").ToString();
        textBox1.Enabled = false;
        this.WindowState = FormWindowState.Minimized;
        this.Hide();
    }
    else
    {
        textBox1.Enabled = true;
        this.StartPosition = FormStartPosition.CenterScreen;
        this.WindowState = FormWindowState.Normal;
        this.Show();
    }
}

plus included this:

private void Form1_Resize(object sender, EventArgs e)
{
    if (WindowState == FormWindowState.Minimized)
    {
        Hide();
    }
}

It is far from beautiful but it works for now...

System.Security.RightsManagement

Joe Rozario5-Nov-09 21:52

Joe Rozario

5-Nov-09 21:52

Dear friends,

is there some one worked with

"System.Security.RightsManagement" i think we can develop a IRM application using these namespace...

i do not know how to work with

i want to set policy for a file

all the policy i want to set is availble in

"System.Security.RightsManagement.ContentRight" class

give me some link ... i could not find useful llinks

thank You

joe.I

Textbox-formatting value using databinding

jogisarge5-Nov-09 21:04

jogisarge

5-Nov-09 21:04

hello @all,

i use this code to format number values in a textbox:

tbxProzentwert1.DataBindings.Add("Text", bs, "prozentwert1", true, System.Windows.Forms.DataSourceUpdateMode.OnValidation, null, "#0.00#");

I have no other Validation-Formatting in my prog.

So the value will be formatted like
1 -> 1.00
0 -> 0.00
1.4 -> 1.40
thats ok.

But if i write a character or leave the value blank, the focus will stick to the field.
Now i have to put a 0 or any number i it to leave the textbox ...

Is it possible to write a 0 to the value if the value can not be formated ?

Bye jo

How I Show MessegeBox in ClassFile in C#.net

Vikash Yadav5-Nov-09 20:23

Vikash Yadav

5-Nov-09 20:23

Hi,

I Add New Class in My Solution For Use Some Functions in Other Forms.

If i Use this Code

public static void RefreshUserList()
{

dtTableUserList = new DataTable();

try
{
dtTableUserList.Rows.Clear();
string cmd = "select * from tblLogin order by UserName";
da = new OleDbDataAdapter(cmd, con);
con.Open();
da.Fill(dtTableUserList);
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}

}

here ERROR is in
MessageBox.Show(ex.Message);

How i show messegebox in class

Thanks & Regards

Form :-
Vikash Yadav
Mob : 9210907172

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