|
Hi,
I retrieving the value from Database. While retrieving i am checking for data is null or not. But if is not working properly.
This is my code, tell me if any correction is required
If dr is a datareader then,
if (dr[0].ToString() == null)
{
//code
}
else
{
// code
}
Please help me.
|
|
|
|
|
srikantha_nagaraj wrote: But if is not working properly.
What do you mean by not working Properly. What problem are you getting ?
You can use String.IsNullOrEmpty() Method to implement it.
string S=dr[0].ToString();
if (String.IsNullOrEmpty(S) == true)
{
}
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
Abhijit Jana wrote: dr[0].ToString();
This will fail if value of dr[0] IS NULL.
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Check like this :
if(DBNull.Value.equals(dr[0]))
{
}
else
{
}
This would be better.![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
Handle it in database. While retrieving value use
ISNULL(CULUMNNAME, 0.00) AS NewColumn
Or if you want to handle it at code behind use as told in above replies
Inderjeet Kaur
Sr. Software Engg
|
|
|
|
|
http://download.microsoft.com/download/c/7/a/c7a07f0e-4778-4d73-a163-f873a06b18ed/rounded06.msi[^]
I create a App_Theme\Blue one, add that css and images into that folder.
During the page development after the asp.net controls are started to be added into the content div everything is great. They are styled normally and that can be seen in design view and when the page is run from VS2008.
Themes are enabled in Page section and Blue one is set up.
CSS is linked in the <head> section.
But after several more asp.net controls are added to the content section, the styles are no longer applied when the project is run from VS2008 with ASP.NET Development Server. The css styles are visible only in design view.
Any changes to css file or removal, additions of controls are no longer affected by css rules when you run the page from VS2008.
Only published version run under IIS has valid css styles as they are in design view.
at my wits end.
Чесноков
|
|
|
|
|
are you using cache - headers for your CSS files.
You can try ctrl + F5 to refresh CSS downloads.
I think the CSS is not refreshed properly.
Other than that, if this is not the case check what is the exact response generated in the client browser via View -> Source.
|
|
|
|
|
What are the cache - headers?
I'm using just css file, which is present in web project folder.
The response goes as from VS ASP.NET Development Server
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><meta name="description" content="" /><meta name="keywords" content="" /><title>
</title>
<link href="App_Themes/Blue/blue.css" rel="stylesheet" type="text/css" /><link href="App_Themes/Blue/blue.css" type="text/css" rel="stylesheet" /></head>
<body>
<form name="aspnetForm" method="post" action="Main.aspx" id="aspnetForm" enctype="multipart/form-data">
<div>
<input type="hidden" name="__EVENTTARGET" id="__EVENTTARGET" value="" />
<input type="hidden" name="__EVENTARGUMENT" id="__EVENTARGUMENT" value="" />
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUKMTM2MDEzMDA4MA9kFgJmD2QWAgIDDxYCHgdlbmN0eXBlBRNtdWx0aXBhcnQvZm9ybS1kYXRhZBgBBR5fX0NvbnRyb2xzUmVxdWlyZVBvc3RCYWNrS2V5X18WAgUcY3RsMDAkbG9nc3RhdEdlbmRlckFnZSRjdGwwMQUcY3RsMDAkbG9nc3RhdEdlbmRlckFnZSRjdGwwMzgWQYKxTUw7v0UIfMsne1Lkhwna" />
</div>
<script type="text/javascript">
//<![CDATA[
var theForm = document.forms['aspnetForm'];
if (!theForm) {
theForm = document.aspnetForm;
}
function __doPostBack(eventTarget, eventArgument) {
if (!theForm.onsubmit || (theForm.onsubmit() != false)) {
theForm.__EVENTTARGET.value = eventTarget;
theForm.__EVENTARGUMENT.value = eventArgument;
theForm.submit();
}
}
//]]>
</script>
<div>
<input type="hidden" name="__EVENTVALIDATION" id="__EVENTVALIDATION" value="/wEWBAKsxqLlCQKZ1fCYBgKx84LDBALt4oCSCdqps8GtkX/pqmRsab4onrvpLNhg" />
</div>
<!--
SITE NAME & SLOGAN
-->
<div id="header-container">
<div id="header-left">
SomeSite
</div>
<div id="header-right">
some title</div>
</div>
...
...
</form>
</body>
</html>
Чесноков
|
|
|
|
|
Only thing that comes into my mind is
Chesnokov Yuriy wrote:
Do you have added the CSS manually in your page.
Means in your head section, you dont need to add link if you use theme folders.
Check your page, remove the css line added using link tag.
Hope this would cure the problem.
|
|
|
|
|
But having only Theme property set up, CSS are not linked, it needs to link them either that or by the style sheet property of the page, but that also does not help.
It can be added either manually or from menu, attaching CSS to the page.
Without that link in head section in design view all formating is gone completely, just simple text. But in ASP.NET server the page is all the same with CSS mal-formating as it was with the link in head section. 
It means ASP.NET Development Server keeps its own CSS file?? and it is not affected by any changes.
In the html source the link remains despite it was removed!!!
BTW the link is in the master page. The themes are enabled in both master and content pages. The theme is selected as Blue one in all content pages.
Чесноков
|
|
|
|
|
By all means that is not the cure.
BTW I added Red theme from that web template. It uses all the same css, the difference is in images, they are of redish color.
I added red.css, changed href to red.css in red folder, changed theme to red and all formatting applied properly in ASP.NET Dev Server!
However returning to Blue theme and blue.css produces still the same css error.
Чесноков
|
|
|
|
|
Well, AFAIK, you dont need to add <link tag in the head section if the css is within the respective theme folders.
Just apply the theme and place appropriate css classes on the controls, and you are done. The HTML rendered by ASP.NET would automatically have the appropriate css added to the head section upon request..
Now in your case, I think you didnt placed css files appropriately.
Just forget about the theme, dont apply any theme, and manually add those css in the head section and see what happens with the site.
|
|
|
|
|
|
Just clear the line that you write in the web page head section and apply the theme only. Theme will automatically add link elements to your page. You dont need that to include yourself.
Hope this will help you.
|
|
|
|
|
But without links in head section, CSS styles disappears completely, at least in design view. I never tested it further.
It is ugly to avoid design view of the page with CSS styles applied.
Unless you include stylesheettheme property in the page directive it will not work.
Чесноков
|
|
|
|
|
Hey... Dont worry about the Design View.
I dont see design view for such a long time. Just run your application and see if it outputs properly.
In this way you can also change the html, or CSS style and refresh the browser to see the effect.
Design view always hurts me ... Its not perfect, as even the same page may sometimes appear completely different in different browsers... It is hard to rely on design view.
I suggest you to run the site in different browser to see what exactly the problem with the design.. Dont worry about the design view. Leave it whatever is there. Just the thing is to create most sophisticated design with less html generated. ..
cheers.
|
|
|
|
|
ctrl + F5 you mean running without debugging? it does not work also.
Чесноков
|
|
|
|
|
Hi, I have a quick question.
Can an ASP server control have normal HTML elements? I need to have controls that just run Javascript functions. Or is that what an ASP ajax server control is for?
Shot
Strive to be humble enough to take advice, and confident enough to do something about it.
|
|
|
|
|
roguemat wrote: I need to have controls that just run Javascript functions.
They only you can use HTML Control. You don't not need to use any server side control.
You can also call the javascript function using Server side control too.
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
roguemat wrote: Can an ASP server control have normal HTML elements?
Yes. Actually when you are using ASP.NET server control, its main motive is to generate HTML which is understood by the browser. It generates HTML just which is written in its Render Method. You can easily create a custom web control, and override the render method to generate your own html.
roguemat wrote: I need to have controls that just run Javascript functions.
If you really want to run a javascript, you can directly write this on the page. Or you can use RegisterStartupScript function.. No need to write a server control for that.
roguemat wrote: Or is that what an ASP ajax server control is for?
ASP.NET ajax server controls are those which renders a combination of HTML and Javascript which gives you partial update functionality. If you consider UpdatePanel, it creates a new form element using javascript, copies all the elements(including viewstate) in that form and then submits it, when you call for server. You can use Fiddler to see what is in request when you call server through update panel.
Thus in one word :
You can use ASP.NET server control to create normal HTML, Normal JAVASCRIPT, CSS, HTML etc. (or combination of all). Validators, scriptManager create only javascript in the page while TEXTBOX, DROPDOWN creates only HTML elements.
Hope you got the idea clearly.
|
|
|
|
|
Thanks for the answer.
I think ive misunderstood something. See, what Im looking for is something like a windows forms custom control, but for ASP. Take for example I created a "calculator" control, I want to be able to just drag it onto any asp form in VS. Added to that the calculator must not run postbacks etc(hence why I said html controls on it), and instead, for example, just run a javascript function with the answer.
Thanks
Strive to be humble enough to take advice, and confident enough to do something about it.
|
|
|
|
|
Yes this is cool.
The only thing that you have to do, is to create a custom control and override Render method and create the HTML for you.
This[^] might be helpful
|
|
|
|
|
Hello all,
I want to know, can we insert multiple records at the same time using any method of SqlCommand class?
If this is possible then how can we achieve it?
Thanks,
Nagendra.
|
|
|
|
|
SQLCommand does not tackle this as it is only resposible for passing on the execution statement to the server.
Here [^]is a nice article for doing this.
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Hi You can use BatchUpdate for this
try
{
Craete SQL COmmand Object
cmd.CommandType = CommandType.StoredProcedure;
cmd.UpdatedRowSource = UpdateRowSource.None;
cmd.Parameters.Add("@Param1", SqlDbType.Int, 4, argDt.Columns[0].ColumnName);
cmd.Parameters.Add("@Pram2", SqlDbType.Bit, 5, argDt.Columns[1].ColumnName);
cmd.CommandTimeout = 0;
SqlDataAdapter da = new SqlDataAdapter();
da.InsertCommand = cmd;
da.UpdateBatchSize = 100;
conn.Open();
int recordsInserted = da.Update(argDt);
conn.Close();
}
Inderjeet Kaur
Sr. Software Engg
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
