Row should be bold in SSRS - ASP.NET Discussion Boards

First Prev Next

Re: Database searching

ProtoBytes28-Dec-09 12:33

ProtoBytes

28-Dec-09 12:33

Okay I think I understand what you are asking.

What is wrong with my code why can I get the LINQ to work when the user only selects one and not the other?

Well, I think The problem is the 'if' logic or the 'SelectData' method logic depending how you look at it.

I would make the logic smarter and have values substituted if they are not in range of the query.

-or-

Modify the 'SelectData' method to account for different data dependencies.

~TheArch

Re: Database searching

sv_vasja28-Dec-09 21:19

sv_vasja

28-Dec-09 21:19

Thank you for your reply. The problem is i get an exception whenever i request the two querystrings and one of them has a null value...

Re: Database searching [Null Values]

ProtoBytes29-Dec-09 3:27

ProtoBytes

29-Dec-09 3:27

Correct! You will need to supply either corrective logic, or correct the data values before they are passed.

IE:

//corrective logic...
MyMethod(String s1, String s2) 
{
  //Modify the data before it get's passed...
  if(s1 == null)
   s1 = '';
  if(s2 == null)
   s2 = '';

  //Modify the LINQ query...
  if(s1 == null && s2 == null)
   //LINQ for double null
  else if(s1 != null && s2 != null)
   //LINQ for s1 and s2
  else if(s1 != null && s2 == null)
   //LINQ for s1 and no s2
  else if(s1 == null && s2 != null)
   //LINQ for no s1 and s2
}

as you can see the second method is more complicated. However you could also dynamically build the LINQ query and have the LINQ run correctly for any situation.

~TheArch

Re: Database searching [Null Values]

sv_vasja29-Dec-09 21:35

sv_vasja

29-Dec-09 21:35

Yes i agree with the

if(s1 == null)
  s1 = '';
 if(s2 == null)
  s2 = '';

but its like 20 values and i tough there is something smarter than this...i would probably use it.
Thanks!

Re: Database searching [Null Values]

ProtoBytes30-Dec-09 3:30

ProtoBytes

30-Dec-09 3:30

Well the example only lists the two values.

If there are many values the dynamic LINQ would still do this, just build the query for the values you do have.

Another way to do it might be to change the input to the LINQ method to take an array.

static void myLINQ(String[] s)
{
  for(int i=0;i<s.Count;i++)
  {
    if(s[i] == null)
      s[i] = "";
  }

  //Then build the LINQ dynamically...
}

There are several example here on The Code Project on Dynamic LINQ:

Dynamic LINQ Queries[^]

Google friendly search:

Dynamic LINq c# site:codeproject.com

Online Update Issue!

Sr...Frank27-Dec-09 23:54

Sr...Frank

27-Dec-09 23:54

Hi,

I was working on a desktop application basically it’s a product now the programming part is over and I have created MSI for this product.
So product and setup both parts are ready but now I have one issue with online updates for this product. I am planning to create a web service for online updates but I would like to know your thoughts as you guys are experienced.
I have used VisualStudio2008, language C# and setup and deployment project.
Please let me know, how to integrate it with setup and deployment project or with programming part or if any other right way for online updates.

Thanks

Re: Online Update Issue!

Sr...Frank28-Dec-09 4:53

Sr...Frank

28-Dec-09 4:53

Updates should be download automatically from server.Please let me know how to implement it.

Row should be bold in SSRS

siddisagar27-Dec-09 20:27

siddisagar

27-Dec-09 20:27

Hi Team,

I want to show one row as bold in my SSRS report. That row is static always but it can change the row no. Ex some times it may come in second sometimes it may come in 5th. but the row is constant always this needs to show in bold

So how to handle this problem

Thanks

Re: Row should be bold in SSRS

sashidhar27-Dec-09 21:27

sashidhar

27-Dec-09 21:27

Hi,

What Is the condition? for the row to show as bold..!
Make use of iif Loop ..!
in the expression of the row font..!
way to do it..!
right click on the row go to properties go to font
and write the expression..
check this lnk for expressions
http://msdn.microsoft.com/en-us/library/ms157328.aspx[^]

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

Re: Row should be bold in SSRS

siddisagar27-Dec-09 23:58

siddisagar

27-Dec-09 23:58

Thx it is working for me

Re: Row should be bold in SSRS

sashidhar28-Dec-09 0:13

sashidhar

28-Dec-09 0:13

Its Ok Any Time..! Thumbs Up | :thumbsup:

But Dont forget to mark it as answer if it helps u.! $Shucks | :-\$

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

How to check cookies are enable or disable in borwser

Samarjeet Singh@india27-Dec-09 20:12

Samarjeet Singh@india

27-Dec-09 20:12

Hi all,
If the client borwser is cookies disable then i want to show a message to client plz enable ur cookies.......
for this i am writing this code but it is not working

<script language="javascript" type="text/javascript">

function detect()
{
if(navigator.cookieEnabled)

{
alert('Your browser has cookies enabled.');
}
else
{
alert('Your browser has cookies disabled.');
}

}

</script></head>

<body onload="detect();"></body>

Thanks a lot........

Re: How to check cookies are enable or disable in borwser

Abhishek Sur27-Dec-09 20:23

Abhishek Sur

27-Dec-09 20:23

Just store a cookie and try to retrieve it using javascript. If proper value is retrieved, you will find cookie is enabled. Wink | ;)

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Re: How to check cookies are enable or disable in borwser

Samarjeet Singh@india27-Dec-09 20:57

Samarjeet Singh@india

27-Dec-09 20:57

Thnks for Replying ........
I am using IE and also block all cookies but
allways answer is ........"cookies found" by fallowing code

if (!IsPostBack)
{
Response.Cookies["test"].Value = "Samar";
Response.Cookies["test"].Expires = DateTime.Now.AddYears(30);

if (Request.Cookies["test"] == null)
Response .Write ("No cookie found");
else
Response .Write ("cookies found");

}
if I used gmail then message is comming that plz enable ur cookies ?
while according previois code it means cookis is creaing ?

then what is exat answer cookies is enable or disable ?

Re: How to check cookies are enable or disable in borwser

Abhishek Sur27-Dec-09 21:32

Abhishek Sur

27-Dec-09 21:32

Did you try redirecting the page, and find cookies from another page ?

Say in your page1 you place :
Response.Cookies["test"] = "Samar";

In page2 you try to retrieve it using :
if(Request.Cookies["test"] == null)
Response.Write("No cookie found");

During the login process, Gmail actually redirects to more than one page before going to actual Gmail Console. So it is easier to them to understand if cookie is actually enabled or not.

I think if you do like this in your login process, you can easily detect this. Smile | :)

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Windows7 API Code Pack

Simplify Code Using NDepend
Basics of Bing Search API using .NET

Re: How to check cookies are enable or disable in borwser

Samarjeet Singh@india27-Dec-09 22:02

Samarjeet Singh@india

27-Dec-09 22:02

Yes ..........Dear I have done according to you

in first page button clic event I M writng this .....

Response.Cookies["test"].Value = "Samar";
Response.Redirect("Default2.aspx");

and second page form load event

if (Request.Cookies["test"] == null)
Response.Write("No cookie found");
else
Response.Write("cookie found");

I have disabled the cookie but it is still showing "Cookies found"

Note-- I M using IE.

Re: How to check cookies are enable or disable in borwser

Abhishek Sur27-Dec-09 22:11

Abhishek Sur

27-Dec-09 22:11

I think this means cookie is not disabled properly in your browser. If the cookie could be read, then browser didnt prevent it to store cookie properly.

Also try in other browser and try publishing the application in IIS.
D'Oh! | :doh:

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Windows7 API Code Pack

Simplify Code Using NDepend
Basics of Bing Search API using .NET

Re: How to check cookies are enable or disable in borwser

Samarjeet Singh@india27-Dec-09 22:35

Samarjeet Singh@india

27-Dec-09 22:35

Yes it is Working in Mozilla but not in IE6
How can we check it IE6.........Thnks.......

Re: How to check cookies are enable or disable in borwser

geeeeeeeetha27-Dec-09 23:34

geeeeeeeetha

27-Dec-09 23:34

try this one

Request.Browser.Cookies

Re: How to check cookies are enable or disable in borwser

Samarjeet Singh@india28-Dec-09 1:04

Samarjeet Singh@india

28-Dec-09 1:04

I thing it is for ur borwser supports cookies or not but not for cookies enable or disable

Re: How to check cookies are enable or disable in borwser

Abhishek Sur28-Dec-09 4:45

Abhishek Sur

28-Dec-09 4:45

I dont know.. But if you can still access the data with Cookies disabled, I think this would be the problem of security in the browser itself which allows the server to read cookies, even if it is disabled.

I think it is always better not to rely on data in Cookies. I wonder how the client browser behaves and even clients can delete cookies any time.
Wink | ;)

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Windows7 API Code Pack

Simplify Code Using NDepend
Basics of Bing Search API using .NET

GridView SelectedIndex error:'Index out of range'

MATTXtwo27-Dec-09 17:35

MATTXtwo

27-Dec-09 17:35

my Page contain a gridview with a sqldatasource that have a parameter programatically set value

after sqldatasource run a select statement to bind data

i need to have a selectedindex of row for select button

but it gets me error of index out of range

I have done checking..

it seems to me that this gridview get the selectedindex value after twice postback

let say i click on index 1

another click on index 2

the result is selectedindex = 1

that's the problem

Re: GridView SelectedIndex error:'Index out of range'

Rock Star.28-Dec-09 4:53

Rock Star.

28-Dec-09 4:53

Index for Datagrid starts from 0.
Put your code here so you can get more help.

Rock Star

how to count the column value

Fired.Fish.Gmail27-Dec-09 14:55

Fired.Fish.Gmail

27-Dec-09 14:55

The table has columns batch_id, task_id, seq.
One batch_id has several task_id and one task_id can have several seq.

task_id can be A, B, C or others.
I need to write a sql command that can get a table:

count(task_id when task_id = value1), count (task_id when task_id = value2),...

Can anyone help me that how to change the column value to be a column? Frown | :(

Re: how to count the column value

meeram39527-Dec-09 19:22

meeram395

27-Dec-09 19:22

This is not relating to ASP.Net. Post the query in proper forum.

Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

Last Visit: 31-Dec-99 18:00 Last Update: 4-May-24 4:04

Refresh

ᐊ Prev 1...1192 1193 1194 119511961197 1198 1199 1200 1201 Next ᐅ

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