Re: Need to add 1 to a cache value - C# Discussion Boards

humayunlalzad13-Jun-10 3:01

13-Jun-10 3:01

connectionString1 = @"
            server = .\sqlexpress;
            integrated security = true;
            database = C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\NORTHWND.MDF;
user instance = true";

connectionString2 =  @"
            server = .\sqlexpress;
            integrated security = true;
            database = northwind";

connectionString1 is working fine and connectionString2 is giving the message "Cannot open database northiwnd. login failed for user XYZ".
Can someone tell me whats the difference

Re: Connection string

Abhinav S13-Jun-10 3:27

Abhinav S

13-Jun-10 3:27

humayunlalzad wrote:
atabase = C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\NORTHWND.MDF;user instance = true";

humayunlalzad wrote:
database = northwind";

The difference lies in the user instance = true part of the sql.
Read about user instances here.

My signature "sucks" today

Re: Connection string

humayunlalzad13-Jun-10 3:51

humayunlalzad

13-Jun-10 3:51

@"
            server = .\sqlexpress;
            integrated security = true;
            database = northwind;
            user instance = true";

I am sorry I should have mentioned before hand, that even the above string with "user instance = true" added is not working

crystal report and list<>

reza assar12-Jun-10 21:39

reza assar

12-Jun-10 21:39

hi all
i have an win application form suppose to show some reports in CrystalReportView i have no idea how to assign a list<> of class to MyCrystalReport

   public Form1()
{
    InitializeComponent();
    StdList = new List<studants>();
    StdList.Add(new studants("1", "1", 1));
    StdList.Add(new studants("2", "2", 2));
    StdList.Add(new studants("3", "3", 3));
    StdList.Add(new studants("4", "4", 4));
    StdList.Add(new studants("5", "5", 5));
}

private void Form1_Load(object sender, EventArgs e)
{
    CrystalReport1 cr = new CrystalReport1();
    cr.SetDataSource(StdList);
    crystalReportViewer1.ReportSource = cr;
}

but i have not assigned any table with CrystalReport1 it`s all because of i have not any dataset or database or ... and i do not know how to assign add or assign a list<> of objects to my crytalReport Project (CrystalReport1) how can i assign it and work on it

i should definitely use list<>
please help me!!!!!!!!!!

Re: crystal report and list

Mycroft Holmes13-Jun-10 19:55

Mycroft Holmes

13-Jun-10 19:55

Does CR support List<> as a datasource? I have not used that POS in a few years but I doubt it has moved that fast.

I suggest you do some research on the Business Object web site.

Never underestimate the power of human stupidity
RAH

Need to add 1 to a cache value

Randall Hall12-Jun-10 18:07

Randall Hall

12-Jun-10 18:07

I have a label called lblsite that I'm trying to give a value from a cached value.

protected void Page_Load(object sender, System.EventArgs e)<br />
    {<br />
        lblsite.Text = (Cache("locid") + 1);<br />
    }

The "locid" is set on the previous page.

protected void btnaddaddress_Click(object sender, System.EventArgs e)<br />
    {<br />
       Cache["locid"] = gvaddressmax.SelectedRow.Cells[0].Text;<br />
       Response.Redirect("btnaddaddress.aspx");<br />
    }

However, the lblsite.Text = (Cache("locid") + 1); gives me the following error and results in a null value.

'System.Web.Caching.Cache' is a Type, but being used like a variable

How can I get this to work?

Re: Need to add 1 to a cache value

Dan Mos12-Jun-10 18:21

Dan Mos

12-Jun-10 18:21

You should have posted in the asp forum. Anyway, I think it's the parenthesis.

try (Cache)("locid") +1;

even better

(yourType)((Cache)("locid")) +1;

You did not mentioned what you stored in the previous page.

Just an irritated, ranting son of ... an IT guy.
At your trolling services

Re: Need to add 1 to a cache value

Pete O'Hanlon13-Jun-10 4:44

Pete O'Hanlon

13-Jun-10 4:44

Randall Hall wrote:
(Cache("locid") + 1)

This is the problem. Cache provides indexer access to object values, so you need to extract the value back out before you attempt to work with it. Try changing this instead to:

int value;
if (int.TryParse(Cache["locid"], out value))
{
  lblsite.Text = ++value;
}

"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

Tab Control with Exit Button

royk12312-Jun-10 10:04

royk123

12-Jun-10 10:04

Hi,

I'm interested in adding a small exit button to the top part of the active Tab Page (like the one in the IE's Tabs), in order to enable users to close tabs more easily.

I'd appreciate any info on how to acomplish this (probably involves owner drawn tab control + more), or if anyone has already implemented such Tab Contol/Tab Page - a link to it...

tnx

roy

Re: Tab Control with Exit Button

Dan Mos12-Jun-10 16:18

Dan Mos

12-Jun-10 16:18

I assume Winforms so here is one of the many results here on CP:
link1

Search is the key
Smile | :)

Just an irritated, ranting son of ... an IT guy.
At your trolling services

Re: Tab Control with Exit Button

royk12313-Jun-10 2:09

royk123

13-Jun-10 2:09

Exactly what i was looking 4..

Tnx
Roy

Re: Tab Control with Exit Button

Amar Chaudhary12-Jun-10 17:09

Amar Chaudhary

12-Jun-10 17:09

If its web you may look forward to coolite [^]toolkit.

My Startup!!!!

Profile@Elance - feedback available too

Setting Datagridview combobox column value to null.

priyamtheone12-Jun-10 6:14

priyamtheone

12-Jun-10 6:14

There's an editable datagridview populated from a table say tblItems. Among the columns of the datagridview there's a combobox column named 'Category'. This column is populated by the respective 'Category' column of tblItems. Now in the 'Category' column of the datagridview I want to set the value of a certain cell to Null programmatically. Suppose when I press keyboard Delete button over the cell or some other button on the form, the value of the cell becomes Null. Datagridview.keydown event isn't working as when the cell is selected the focus is actually on the editingcontrol of the cell and not the datagridview. Also the combobox editingcontrol doesn't have any 'SelectedIndex' property that can be set to -1. Any idea plz? Regards.

Re: Setting Datagridview combobox column value to null.

Mycroft Holmes12-Jun-10 15:53

Mycroft Holmes

12-Jun-10 15:53

Add an item to your list in position 0 with a value 0 and a label of string.empty.
Set the selected index to 0.
Deal with the 0 value on the way out, when you write to the database.

Never underestimate the power of human stupidity
RAH

Re: Setting Datagridview combobox column value to null. [modified]

priyamtheone14-Jun-10 5:43

priyamtheone

14-Jun-10 5:43

The thing is, the EditingControl property of the grid and the e.Control property in the EditingControlShowing event handler are both type Control, because they have to be able to refer to any control. If you're currently editing a combo box column though, you know that the actual object is type ComboBox (to be more precise, type DataGridViewComboBoxEditingControl) so you have to cast it as that type in order to access members of that type. This is the case no matter what objects you're dealing with: you must have a reference of the correct type to access members of that type. E.g.

ComboBox cbx = (ComboBox)myDataGridView.EditingControl;

cbx.SelectedIndex = -1;

modified on Monday, June 14, 2010 12:11 PM

Re: Setting Datagridview combobox column value to null.

Mycroft Holmes14-Jun-10 12:10

Mycroft Holmes

14-Jun-10 12:10

You missed the point, this is all about managing your data not the control. The control does not deal with null so supply an alternative. It is your data, decide how you can do this, I would add a default data item into the underlying dataset and use that as the null substitue.

Never underestimate the power of human stupidity
RAH

Accessing CheckBox on row in Datagridview

Smith#12-Jun-10 4:09

Smith#

12-Jun-10 4:09

Why on earth it's so difficult to find a sample on the web for this topic? Nobody has ever tried putting a checkbox on a datagridview on a winform? Or my search is wrong? This thread's subject has been my search key. Gettin nothin.

What's wrong with the below code?

<br />
      DataGridViewCheckBoxCell chk = (DataGridViewCheckBoxCell)dataGridView1.Rows[0].Cells[0];<br />
      if (chk.Selected)<br />
      {<br />
          MessageBox.Show("Selected!");<br />
       }<br />

It's always checking the "cells" selected state. I want to know if the check box has been selected(Checked!) or not.
Yes, I added column 0 to be a DataGridViewCheckBoxCell.

Anybody can help?

Re: Accessing CheckBox on row in Datagridview

dan!sh 12-Jun-10 4:25

dan!sh

12-Jun-10 4:25

The Value property would give the checked state of the cell. Smile | :)

BTW, instead of casting, you can use as keyword along with the null check.

Re: Accessing CheckBox on row in Datagridview

Smith#12-Jun-10 4:49

Smith#

12-Jun-10 4:49

How do I access it's value? The below attempt is successfuly throwing a cast exception.

<br />
  if (CheckState.Checked == (CheckState)dataGridView1.Rows[0].Cells[0].Value)<br />
                {<br />
                    MessageBox.Show("ok");<br />
                }<br />

Re: Accessing CheckBox on row in Datagridview

Luc Pattyn12-Jun-10 5:01

Luc Pattyn

12-Jun-10 5:01

so look at dataGridView1.Rows[0].Cells[0].Value.ToString() to discover what might be wrong.
everything responds well to ToString(), except null of course.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read formatted code with indentation, so please use PRE tags for code snippets.

I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).

Re: Accessing CheckBox on row in Datagridview

Smith#12-Jun-10 5:24

Smith#

12-Jun-10 5:24

Something's troubling. It requires me to "check" the checkbox at least once before checking it's VALUE to stop it from whining.
If I call

<br />
 dataGridView1.Rows[0].Cells[0].Value.ToString()<br />

straight, without touching the grid, it's throwing NULL object exception.

Re: Accessing CheckBox on row in Datagridview

Luc Pattyn12-Jun-10 5:40

Luc Pattyn

12-Jun-10 5:40

Smith# wrote:
It requires me to "check" the checkbox at least once before checking it's VALUE

Not quite. There must be many ways to make Value hold an appropriate value, or to overcome a possible null.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read formatted code with indentation, so please use PRE tags for code snippets.

I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).

Re: Accessing CheckBox on row in Datagridview

dan!sh 12-Jun-10 5:07

dan!sh

12-Jun-10 5:07

The property Value will have value as true or false. Try casting that to boolean.

Re: Accessing CheckBox on row in Datagridview

Smith#12-Jun-10 5:25

Smith#

12-Jun-10 5:25

Please check my reply to Luc.

Re: Accessing CheckBox on row in Datagridview

Dr.Walt Fair, PE12-Jun-10 6:04

Dr.Walt Fair, PE

12-Jun-10 6:04

Essentially .Value can have 3 values in the case of a CheckBox: true, false and null. Whenever you deal with DataGridView cell values, you need to check for null. Whether it's a CheckBox cell or not, accessing a null is bad.

CQ de W5ALT

Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software

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