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 Replies
I have a datalist bound to a sql source having two columns: Name and Description. The datalist contains a "Show Description" link as follows on clicking on which it calls the javascript which shows the description div.
[Code]....
The asp.net page source for itemtemplate of the datalist is as follows.The problem is that since the div id "Description" is applicable to multiple records, no matter I click on whichever "show details" link, the description of first record in the datalist is shwon and hidden since its the first div encountred by the javascript. In other words, I want a way to show/hide the description of each record in datalist indivigdually.
[Code]....
Problem: I have two pages. Page1 and Page2. When I Click Page1_Button it redirects to Page2 with a Querystring value. In Page2 I do some processing and click save button. My database will get updated and at the same time when I do this my Page1 should also get updated with new values from database. I have a function in Page1 that does this. So my question is How do I call this function in page1 without loosing the previous data on page1 by forcing it to reload? Or in other words Is it possible to call a codebehind function of one page from codebehind of another page without loosing the data or loading the entire page?
View 5 Replies 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 on a page a gridview that can be filtered with one text box. I set up the gridview to show select and wanted to then connect a details view so that when you selected a row the entire details would show up. When I run it I get this error. Data keys must be specified on GridView 'GridView1' before the selected data keys can be retrieved. Use the DataKeyNames property to specify data keys.
<%@ Page language="C#" masterpagefile="MainContent.master" title="Electrical Storage" EnableEventValidation="false" %>
<asp:Content id="Content1" runat="server" contentplaceholderid="Content">
<div id="Rightside">
<h2>Search Electrical Storage
</h2>
<li><a href="EStorageResultsAll.aspx">View All Files</a></li>
<li>Specify Projects to View</li>
<br />
<br />
<form>
Search: <asp:TextBox id="Search" runat="server"></asp:TextBox>
(% is wildcard)<br /><br />
<asp:Button runat="server" Text="Search" id="Button1"
PostBackUrl="electrical_storage.aspx" Height="26px" BackColor="#000066" ForeColor="White" Width="129px"></asp:Button>
<br />
<hr />
<asp:GridView id="GridView1" runat="server" AutoGenerateColumns="False" BackColor="#CCCCCC" BorderColor="#999999" BorderStyle="Solid" BorderWidth="3px" CellPadding="4" CellSpacing="2" DataSourceID="AccessDataSource1" ForeColor="Black" Width="820px" AllowSorting="True">
<RowStyle BackColor="White" />
<Columns>
<asp:commandfield ShowSelectButton="True">
</asp:commandfield>
<asp:boundfield DataField="CoID" HeaderText="Co ID" SortExpression="CoID">
</asp:boundfield>
<asp:boundfield DataField="ProjClass" HeaderText="Project Class" SortExpression="ProjClass">
</asp:boundfield>
<asp:boundfield DataField="Project" HeaderText="Project" SortExpression="Project">
</asp:boundfield>
<asp:boundfield DataField="FileName" HeaderText="File Name" SortExpression="FileName">
</asp:boundfield>
<asp:boundfield DataField="FileAddInfo" HeaderText="File Add Info" SortExpression="FileAddInfo" Visible="False">
</asp:boundfield>
<asp:boundfield DataField="FileNumber" HeaderText="File Number" SortExpression="FileNumber" Visible="False">
</asp:boundfield>
<asp:boundfield DataField="BoxNumber" HeaderText="Box Number" SortExpression="BoxNumber" Visible="False">
</asp:boundfield>
<asp:boundfield DataField="Location" HeaderText="Location" SortExpression="Location" Visible="False">
</asp:boundfield>
</Columns>
<FooterStyle BackColor="#CCCCCC" />
<PagerStyle BackColor="#CCCCCC" ForeColor="Black" HorizontalAlign="Left" />
<SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#000066" Font-Bold="True" ForeColor="White" />
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="\Elec1DATABASEStorageElectricalFilesBook.mdb" SelectCommand="SELECT [CoID], [ProjClass], [Project], [FileName], [FileAddInfo], [FileNumber], [BoxNumber], [Location] FROM [FilesWithLocation]
WHERE (([CoID] LIKE '%' + ? + '%') OR ([ProjClass] LIKE '%' + ? + '%') OR ([Project] LIKE '%' + ? + '%')OR ([FileName] LIKE '%' + ? + '%')OR ([FileAddInfo] LIKE '%' + ? + '%')OR ([BoxNumber] LIKE '%' + ? + '%'))">
<SelectParameters>
<asp:controlparameter ControlID="Search" Name="CoID" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="ProjClass" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="Project" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="FileName" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="FileAddInfo" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="FileNumber" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="BoxNumber" PropertyName="Text" Type="String" />
</SelectParameters>
</asp:AccessDataSource>
<asp:AccessDataSource id="AccessDataSource2" runat="server" DataFile="\Elec1DATABASEStorageElectricalFilesBook.mdb" SelectCommand="SELECT * FROM [FilesWithLocation] WHERE ([SearchString] = ?)">
<SelectParameters>
<asp:controlparameter ControlID="GridView1" Name="SearchString" PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:AccessDataSource>
<asp:DetailsView id="DetailsView1" runat="server" AutoGenerateRows="False" DataSourceID="AccessDataSource2" Height="50px" Width="442px">
<Fields>
<asp:boundfield DataField="CoID" HeaderText="Company ID" SortExpression="CoID">
</asp:boundfield>
<asp:boundfield DataField="ProjClass" HeaderText="Project Class" SortExpression="ProjClass">
</asp:boundfield>
<asp:boundfield DataField="Project" HeaderText="Project" SortExpression="Project">
</asp:boundfield>
<asp:boundfield DataField="FileName" HeaderText="File Name" SortExpression="FileName">
</asp:boundfield>
<asp:boundfield DataField="FileAddInfo" HeaderText="File Additional Info" SortExpression="FileAddInfo">
</asp:boundfield>
<asp:boundfield DataField="PeriodBegin" DataFormatString="{0:d}" HeaderText="Period Begin" SortExpression="PeriodBegin">
</asp:boundfield>
<asp:boundfield DataField="PeriodEnd" DataFormatString="{0:d}" HeaderText="Period End" SortExpression="PeriodEnd">
</asp:boundfield>
<asp:boundfield DataField="FileType" HeaderText="File Type" SortExpression="FileType">
</asp:boundfield>
<asp:boundfield DataField="FileNumber" HeaderText="File Number" SortExpression="FileNumber">
</asp:boundfield>
<asp:boundfield DataField="BoxNumber" HeaderText="Box Number" SortExpression="BoxNumber">
</asp:boundfield>
<asp:boundfield DataField="SearchString" HeaderText="Search String" ReadOnly="True" SortExpression="SearchString">
</asp:boundfield>
<asp:boundfield DataField="Location" HeaderText="Location" SortExpression="Location">
</asp:boundfield>
</Fields>
</asp:DetailsView>
</form>
</div>
</asp:Content>
<asp:Content id="Content2" runat="server" contentplaceholderid="head">
<style type="text/css">
table {
width: 820px;
}
.gridview {
width: 820px;
position: fixed;
}
</style>
</asp:Content>
I have a gridview control with a details column. I want the user to click details and it give me a pop-up showing details of the particular row. Any idea on how to do this using JQuery?? Looking for an example with code..
View 1 RepliesI have a details view that appears when record is selected in a GridView. Can this details view be opened in it's own modal window that would allow me to use the full event model?
View 3 RepliesI need to get client stats for browser (not full long description but short names, generally firefox,ie6,ie7,ie8,safari,chrome,opera and mozilla). Client resolution and OS ie. Windows Vista, Ubuntu .
View 1 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 RepliesHow do i display the flash banner first and then the home page details using javascript. I need load the flash first and then display the home page.
View 1 RepliesI 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
}
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>
I have a gridview displaying all employees. Upon selecting an employee, I'd like to open a new page or window that would display all of the information for that employee with the option to edit/delete/update. Once this transaction is complete, return to previous page with gridview of all employees. ((language I'm usings is VB))
<asp:TemplateField Visible="true" headertext="Select">
<ItemTemplate>
<asp:HiddenField ID="hdID01" runat="server" Value='<%# Eval ("PersonnelID") %>' />
</ItemTemplate>
[Code]....
I want to develop an interactive website in ASP.Net and what I mean by interactive is that it has a back-end application to provide real-time logic (which does not follow HTTP's model of Request/Response) and eventually it is provided with dynamic *.aspx pages with an SQL Server database.
And how would the components go together (as a design and as a communication mechanism) to have a scalable application?
EDIT: Ok, the story is as you know, we all are tending to get something more vital than HTTP model, I want my back-end application to be persistent working in real-time, for example, It would have some constant-intervals to do some queries on the database.
The design as I picture it is a server (holding an ASP.Net website, the back-end application and the database), the design may get more hybrid with time. The website is the interactive interface for the users, the website needs (sometimes) intensive calculations and queries which better be handled by the back-end application, then the application delivers the website the info to be wrapped and formatted as HTML markup to be returned the user eventually.
I have a very huge Asp.Net application using Asp.net 3.5 with aournd 3000 pages. Now we need to integrate some Silverlight controls in it. For e.g we need to change the dashborad to incorporate new SL UX. My question is that easy to use these 2 technologies i.e. Asp.Net and SL and both have different projects. Will that be difficult for us to communicate with each of these web applications and SL Application. We are in the middle of making a decision as to how to integrate SL in our exisiting application.
Keep in mind that its out of the question that we can shift the whole application to SL. We must have to stick to asp.net 3.5 or 4
Is there a way to load an Excel document in a web page and communicate with the excel control using code behind? (JavaScript or Asp.NET) ?
View 1 RepliesHow do I create a Inbox so that users can commnuicate in asp.net What controls do I need.I am ok with the Databse part of this project. But the design part is confusing I am using Visula web developer 2010. Not using ajax and silverlight. just asp.net This is my first asp.net project.
View 6 RepliesHow to communicate with applications which build in lets say SAP,Java,Ruby or any other technology through web services
View 3 RepliesI have a datalistÂ
<asp:DataList ID="ddlist_rooms" runat="server" RepeatColumns="1" RepeatLayout="Table">
<ItemTemplate>
<div>
<h3><span class="roomtype"><%# Eval("room_type") %></span>
</h3> </div>
<div><span class="rid" style="visibility: hidden"><%# Eval("id") %></span></div>
[Code] ...
In the above structure room information has been loaded now when I click on book now then I want to access the roomid room price to send it next panel.
I just want to know that how it is possible to access other values using jquery...
I'm currently developing a website using ASP.NET MVC.I need this website to communicate with an external API using HTTP Post.
I'm unsure whether I should be coding this up in ASP.NET to perform the http post requet and read the response, or whether I should be coding this up in a c# class.It seems when developing a site, you have the option to chose either for many scenarios.
I am new to .net and i'm stuck with the following issue.
I have a windows GUI application and i need to communicate with a firewall using HTTPS protocol. I did some search on google and the results retrieved showed to use HTTPWebRequest and HTTPWebResponse objects.
But does this objects us HTTP protocal or does it work for HTTPS also. also is SSL required for HTTPS protocol. For SSL we need some security certificate. How to retrieve that certificate. Will a certificate need to available in each client machine
