I am trying to get a function to work in VB ASP 2010 that would retrieve all articles in my sqldatabase. The problem is the return syntax of this function results in an error.
Code:
[code]....
I have always continued to keep all of my code in codebehind that I would need to be secure, and don't make any calls to my database with javascript out of concern that a hacker could see the strconnection, username, ect. Is there a highly secure way to communicate with an sqldatabase with Javascript, or should I continue to do things the way I have done them?
View 3 Repliesi need the northwind databse. i dont have it in the database where i can find it and who to add it to my database in sql server so can i c it in the combo box off the database
View 1 RepliesHow to read xls file data and store in sqldatabase...
View 1 RepliesWhat backend c# code should I use to post data (i.e., First Name, Last Name) to sql database? Here is the web form code, below:
[Code]....
Here is the backend c# code, below:
[Code]....
I do my new website in Sqlserver2005,But when i upload it at that time DataBase Related page display Database error. In this site without Database page open. So give me reply I also add my database in hosting side How to attach my database in my asp.net website , when i upload this.
View 1 RepliesI have a asp.net MVC based website. Now I am storing various articles and each article has a unique id attached with it.
In the article table, I have created a Views column, with default value zero.
Now I wanted to know what is the best way to implement ViewCounter for each article individually.
My sqldatabase is inputting NULL instead of the information from my form. Form is collecting different names and multiple phone numbers for each. names, addresses, zip codes are going in as entered on form but phone numbers are not they are going in as NULL. Columns are set as header is Cell, nvarchar, Length is 15 and I have setup as I did other columns. code for my form is (i have removed some lines that are working as expected)
[Code]....
i wants to insert below all the data in a sql table called studentbackup in a single field called descfield and retrive the information
through parsing.
<?xml version="1.0" encoding="ISO-8859-1"?><studentbkup>
<studMstrDetails version = "0">
<row>
<studId>101</studId>
<studNo>Mar-10-1</studNo>
<enrolldate>20100322</enrolldate>
<title>1</title>
<initial>A</initial>
<firstName>Joseph</firstName>
<lastName>Ambrose</lastName>
<sex>1</sex>
<dob>19000101</dob>
<qualification>BE</qualification>
<college>JJ</college>
<courseId>101</courseId>
Anyone have any good articles on creating user sections? I've been finding some stuff that is rather dated for asp 2.0, I'd like to find some stuff that is 4.0.
View 1 RepliesI would like to make a website where you can type in the url [URL] and the webpage will retrieve the article and display it in the articles view.
How would I best go about doing this?
Would I use a SQL database? Xml files? Text Files?
Possible Duplicate:
MVC Learning Resources
I am assigned to a project in which ASP.NET MVC is widely used. I am new to it; can you provide me nice resources to learn it quickly?
I'm currently doing some work involving optimization of session-related code. The code I work on uses a state server approach in a web farm environment. I want to deeply understand what happens session-wise when a request occurs on the server.
Fast, Scalable, and Secure Session State Management for Your Web Applications Underpinnings of the Session State Implementation in ASP.NET - msdn.microsoft.com/en-us/library/aa479041.aspx (I can't post more than two links as I am a new SO user)
I am in process of building a website using asp.net and c# which fetches the new articles posted on various websites and posting those in one place. So basically, I am looking for a javascript which can keep on checking for new articles on various sites,and if it finds a new article then it will fetch it and post it on my website with comments at the bottom.e.g.If a new article is posted on cnbc.com then that article must be fetched and posted on my website with comments "courtesy:cnbc.com"
View 7 RepliesHow can i make proper search result for example if i have one article now it have different tag like my article is related to asp.net ..in that article i am adding some tag like asp.net, database.user will come and click on that tag and related article will be come for example user click on asp.net tag then al related article will be come.
View 1 RepliesI would like show top active users in my Index page. How I can get most active users who insert new articles , and wrote comments?
How I can get latest 10 records in table A?
I am looking details on the internal working of asp.net architecture. The topics need to include the following:
Asp.Net Thread/Application Pools
HttpRuntime
HttpApplication - When and how it is set up.How HttpContext is set up
How objects can passed along the pipeline using HttpContext.Current.Items
Why does modification of static variables requires locks in ASP.NET(advanced)IIS 7 Integration Mode
I am using the following code in my master page:
<% Html.RenderAction("RecentArticles","Article"); %>
where the RecentArticles Action (in ArticleController) is :
[ChildActionOnly]
public ActionResult RecentArticles()
{
var viewData = articleRepository.GetRecentArticles(3);
return PartialView(viewData);
}
and the code in my RecentArticles.ascx partial view: <li class="title"><span><%= Html.ActionLink(article.Title, "ViewArticle", new { controller = "Article", id = article.ArticleID, path = article.Path })%></span></li>
The problem is that all the links of the articles (which is built in the partial view) lead to the same url- "~/Article/ViewArticle" . I want each title link to lead to the specific article with the parameters like I'm setting in the partial view.
I'm an ASP.NET newbie, but not so new at programming in general.
I'm creating a commercial website, and I want to allow an admin to add new articles (an article consists of text, images and various properties such as category).
I am trying to decide the optimal Modus Operandi. This site is commercial, so SEO is a major consideration. This means that I want each url to be "unique". That is, if someone navigates to an article about raccoons, he should be redirected to [URL]. This means - I can't have one page that loads the appropriate article dynamically a-la AJAX (gotta use deep-linking)
So how exactly do I do this? suppose the admin entered his text, uploaded the images and set the article properties. I create a new subfolder, save the images to the server (I understand that saving images to a DB is a big no-no), their addresses in a DB, and the content itself to the DB. But now what?
How do I go about creating the actual page?
Is there a function for creating a new aspx file? then what about its corresponding cs file? Or is it unwise to use aspx? Maybe plain html? but then how does it work with my site's master page? Or maybe just create another copy of a general aspx file which is populated with an article according to a parameter?
I have sqldatabase tables.I am reading table data and putting in a tabconatiner(wth tabs containing textbox, checkbox etc) specific to a client. If a client has more than one row i want to iterate through the rows and read each row data. Basically I want to use a button-click to read the next row data at put it in the tabs and so on. I used sqldatareader and a while loop.I can read the data but while loop iterates through the rows and show the last row data / i want to use a button to go to the next row and show data.
SqlDatareader reader=null;
reader=cmd.ExecuteReader();
while(reader.Read())
{
txtboxName.Text=reader["Name"].ToString();
}
protected button_Click(Object sender,EventsArgs e)
{
//I want to read row data in this button click
}
I am looking details on the internal working of asp.net architecture. The topics need to include the following:
Asp.Net Thread/Application Pools HttpRuntime HttpApplication - When and how it is set up How HttpContext is set up How objects can passed along the pipeline using HttpContext.Current.Items Why does modification of static variables requires locks in ASP.NET (advanced)IIS 7 Integration Mode
I have used session to the creation of user and led them to the edit page ..But how do I retrieve my userID off from the session, or are there other ways to retrieve userID from?
View 3 RepliesI want to retrieve MAC ID of all users who are visiting to my website. How can I do this ?
Is it possible to retrieve MAC ID on Web
ADO.NET and have a query about reading a unique data value from a table.
PHP Code:
<%@ Page Title="" Language="C#" MasterPageFile="~/Dorknozzle.master" AutoEventWireup="true" CodeFile="BlogEntry.aspx.cs" Inherits="BlogEntry" %>
<%@ Import Namespace = "System.Data.SqlClient" %>
[code]...
I'm building a website using ASP.NET and SQL Server, and I use
SELECT PK FROM Table WHERE PK = @@identity
My question is which is better and more reliable to retrieve the last inserted PK for multiuser website, using @@identity or using this:
SELECT MAX(PK) FROM Table WHERE PK = Session ("UserID")