|
Hi
I want to create sqldatasource without using wizard in ASP.
please tell me the code of creating sqldatasource and the code of setting connectionstring of that?
|
|
|
|
|
What do you mean??
create an object of SqlConnection.
Get SqlCommand object to run a command.
Read basic books on DataBase Connectivity. Its easy and essential. 
|
|
|
|
|
you know that we can use sqldatasource in Toolbox of ASP when we want to build a websit.
This way we use wizard of ASP.
Now i don't want to use wizard.
I want to create sqldatasource in ASP code( .cs ).
what is the code of it?
|
|
|
|
|
Yes.. but in real life, we cant rely on wizards.
Believe me, to make a good foundation, it is always better to avoid wizards. Wizards are only for time saving purpose.
Read some articles , books whatever to do your job.
|
|
|
|
|
farokhian wrote: I want to create sqldatasource without using wizard in ASP.
Crate SQLConnection.
Use SQLCommand
Execute Command
Here is an good reference for you 
Using ADO.NET for beginners[^]
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
I add one button for each row in a gridview, then some process will be carried out by cliking the button,
first of all, the selected row should be identified by clicking the button, but I do not know which function should be used?
thank you for your help in advance!
|
|
|
|
|
|
You can use RowCommandEvent like this. e.Command name give thename of your button you gave in aspx. Now do whatever you want to do.
You can also use RowdataBound event.
protected void gvCardFeesRReport_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
switch (e.CommandName)
{
case "First":
gvCardFeesRReport.PageIndex = 0;
break;
case "Prev":
if (gvCardFeesRReport.PageIndex > 0)
gvCardFeesRReport.PageIndex = gvCardFeesRReport.PageIndex - 1;
break;
case "Next":
if (gvCardFeesRReport.PageIndex < gvCardFeesRReport.PageCount - 1)
gvCardFeesRReport.PageIndex = gvCardFeesRReport.PageIndex + 1;
break;
case "Last":
gvCardFeesRReport.PageIndex = gvCardFeesRReport.PageCount - 1;
break;
}
}
catch (System.Threading.ThreadAbortException)
{
}
Inderjeet Kaur
Sr. Software Engg
|
|
|
|
|
I use the following functions for providing file download, but I found once this function is executed, then the fontsize of the whole page become automatically very big. but if I delete "Response.End();", then everything is fine, anyone can tell me why? thanks!
Response.ContentType = "pdf/doc/exe/chm";
Response.AppendHeader("Content-Disposition", "attachment; filename=" + str_download_file_name_full);
Response.TransmitFile(Server.MapPath("~/downloadfiles/" + str_download_file_name_full));
Response.End();
modified on Sunday, August 30, 2009 1:08 PM
|
|
|
|
|
Try to download in a Popup rather than main page.
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
thanks, your suggestion may solve this problem, but I did not intend to do so.
by the way, one quesition: if I do not use Response.end(), what is the potential problem caused?
|
|
|
|
|
Well,
Response.End will force the Response to end even if there might be a large no of lines being executed after that.
It is better to use Response.Clear before download and Response.End after transmitting the file.
|
|
|
|
|
Hi Friends,
Can it possible to disable or hide HTML view sources of any web page ?? I think this way it can protect my page data to crawled.. Please help me ..
|
|
|
|
|
basantakumar wrote: Can it possible to disable or hide HTML view sources of any web page ??
No you can't .
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
No. it is not possible, as the entire html should be downloaded to the client browser to render content.
If you want to protect your client logic there are two way out :
1. You render everything within an object(might be Flash / silverlight) so that the actual validation logic or web service calls cant be found by the user easily.
2. You can open your website in a new window, with addressbar, statusbar, toolbar etc hidden... Also hide the context menu, so that the normal user cant find the html source very easily. This is done by most of the banking sites. Just add the code :
document.oncontextmenu = function(){
return false;
}
To hide the context menu.
I think this helps you. ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
Good Answer Abhishek !
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
|
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.
|
|
|
|
|
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>
Чесноков
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
