Forum Array

SQL Server :: How To Display Enquiry To Textbox On Web Page

I have an sql scalar function (FN_GET_ENQ_NO()) which returns a unique enquiry no.Now i want to display this enquiry no. to my asp:textbox on web page.I have made all the connection strings to my sql server database. Even i had pulled the data from stored procedures. But clueless in above issue. 

View Answers

Very Similar Questions

SQL Server :: How To Get Notepad All Item In Sql Server Database Table Field
I have one application using Sql server as back end.. in sql server database i have one table which consist two fields.. ItemName and RateI have one notepad file which consist around 700 ItemName with Rate..  So how to get this ItemName and Rate in my Table...

Web Forms :: Masterpage Won't Display Picture If Page Is Not Saved In The Same Folder
i have a master page in a root and some pages in root and works perfectly, but now i need a different folder (secure) and in this folder i have an Admin page but doesnt show icons from master, only the placeholder. If i change the url from .css (url('images/page-bgglare.png') to (url('../images/page-bgglare.png') works the pages inside the folder but doesnt works the pages in root.

SQL Server :: Unable To See Database From Visual Web Developer
I am using Visual Web Developer 2010 Express on a web server. On the same network I have SQL Server 2008 Express installed on an SQL server. I have created a login for my web server in SQL Server like mydomainmywebserver$.In Visual Web Developer when I use Database Explorer to add a connection I am having a problem. I can see my SQLserver in the server name box but I don't any database in the Select a database name box. What is the likely reason for this? Is it an authentication problem in SQLserver?

SQL Reporting :: How To Display Parameter Prompt Area In Web Report Viewer
I tired to create a parameterized report in Report Builder 2.0 with parameters having multiple values fetched from the database. I really liked that feature, which allows me to select the desired records from the dropdown. I uploaded the report in SSRS 2008 and I could view the reports with parameters from the Report Manager of Report server. But when the report is called through the Report Viewer, I didn't get any of the parameters displayed inside the report viewer. The only way I could found is to manually give the dropdowns in the web page and sent that values to report by setting its parameter. But at here I cannot multi-select the values. So I would like to get the exact functionality given through the report manager in the report viewer. get the report parameters in the Report Viewer of ASP.NET?

SQL Server :: Separate Web & Database?
Currently, we have our ASP.NET applications running on windows server 2003.  All of our data resides on an IBM ISeries / AS400.  The 400 people are going to be creating massive new tables with millions of records.  Because of this, I've been asked to look into the idea of putting new ASP.NET pages on the IBM ISeries server.  This server uses APACHE.  I have read that to do this, I will need to use the Mod_Mono Apache module. I would like to come up with a list of benefits and drawbacks to this new idea.  Initially, it seems like this is a bad idea for a few reasons: Security: if a users gets unauthorized access to our local server(s), they will only have access to either DB or web server, not both. Maintainability: Microsoft ASP.NET is easier to implement on a Microsoft Windows Server. Problem Solving: I will have to first determine if an issue is due to the ISeries server, or the Apache server, or the ASP.NET application. This could be countered by saying that I would already have to determine if the issue is due to Windows server, or ASP.NET application.  However I have better experience with troubleshooting on a windows box that I am familiar with. Problem Creating: I could escentially create a problem that not only takes down the web server, but the database as well, and other RPG programs running on the ISeries. Resources: The database server will not have to server my application, it will only have to retrieve the data for it. Drivers: The windows server already contains many drivers and .DLL's that are used... will these even exist on the ISeries? How easy (if even possible) would it be to get them on the ISeries if they dont exist..? A few positive thoughts: The application will reside on the same server as the data, thus, it may be quicker at retrieving data from these millions of records in a table. This was the main point as to why I should look into this possibility. Single point of failure. We no longer have to worry about two servers going down and causing this application to be unavailable...

Web Forms :: How To Export Displayed Content Of Page To Pdf
is it possible to export displayed content of page to pdf.if yes how

Web Forms :: How To Display Sql Datetime Field As Text
how do i display a datefield field e.g.  07/27/2010 08:00:00 as Tuesday, July 27, 2010? (i want the time part but i couldnt find any fucntions that display the date in text mode?) I am creating a SQL procedure and need to read the data back into a gridview in that format.

SQL Reporting :: How To Call An Existing Report In Reportviewer On A Web Page
I am trying to integrate an existing SSRS report in 1. created the report and deployed it. 2. In the web page, have a reportviewer and trying to attach the same report. The report's url is :http://ReportServername/Reports/Pages/Report.aspx?ItemPath=%Clinical+ReportQ: What is my ReportPath and reportServerUrl? Is there something else I need to do? Should I copy over the rdl file to the report server?

Android :: Web View - How To Click Web Link And Display In WebView App
I am trying to add a webview in my app to display a web page. However, every time I click link on the web page, Browser will be launched to display content in that link. I understand it is something about intent but I am still wondering is there any simpler method to ask webview to display link content within its View ?

MVC :: How To Display Portion Of Page Within Another Page
I want to have two pages/views(?) A and B. When a user sees page A, I want to display a section of the B page inside the A page. When the user sees page B, he should see the regular B page. How can I accomplish this?

Web Forms :: Web Page That Allows Multiple Database Row Updates
We currently have a page with a listview control that has textboxes and an update button for each row. Users are able to update the database one row at a time.This is problematic in countries where the internet connections are very slow because a round trip is needed for each row update and this can become impossible to use.We need to create a page which allows multiple row updates so that each round trip is more productive.  There woudl be just one update button on each page and users could enter values into each row.  Clicking the update button would update each changed row of the database.We currently use linq 2 sql.  I would imagine that we could still use this in the above scenario??? Or is there a better data connection methode to use in this scenario.

Web Forms :: Page.IsPostback Versus Page.IsCallback
what the difference is. When will you use each? What Is the good use of IsPostback? Is this for to not loading data from database if Postback occurs to save on performance? It seems to be working for me, I only load data if not IsPostback. Is this correct? Is this because all my postbacks are generated by UpdatePanel? What is a difference between Postback generated by UpdatePanel versus regular Postback? Is the IsCallback true in this case? Should I check it instead? 

SQL Reporting :: Carry Forward Total Of A Page To Next Page
i am on a report in which i need to show the Total of Current Page in page footer then i want to carry forward this total to Next page's Page Header. How can i do it?

Web Forms :: Transfer Data From Gridview Row In Framed Aspx Page To The Other Page
I am not sure if this is possible (I am quite new at stuff but quite experience in VB ) I have managed to do the following, with no problems: I have a framed page, top page has a gridview and seach fields to query an Access database. Each record has 40+ fields The bottom framed page, has some textboxes. Once you do a search on top page (gridview), you are able to select whatever row it is shown. At this stage (when record is selected on top page) using "select" or whatever, I would like to transfer the data from the selected row and put them on the many textboxes on the bottom framed page. I know there are better ways to do this, however on the bottom page, users are able to ammend, add etc additional values, as well as doing some calculations, prior to transfering the info to (yet again) another form, so needs to do it this way as per request from my boss.

Web Forms :: Showing Excel On Web Page?
I want to show Excel objects and its functionality on my web page. Is there any way to do so? I want to show it the way google spreadsheet is.

SQL Server :: Error While Executing A Dynamic Insert Sql Storedprocedure In Sql Server 2005?
assist me rectifying the error in following sql stored procedure? Sql Query:- [Code].... I have created the above Stored Procedure for inserting datas into any table but while I execute the above proceedure its throwing some error.

SQL Reporting :: Cannot Get A Web Page With A Reportviewer Control On It To Display The Report
I realise this is a fairly common question, but I have read this forum, and many other sources - and simply cannot resolve this.I have a website -, hosted by ASPHostCentral. Reporting Services is on my account.service web service URLThe report manager URL is My reports and connection live in a folder called "Matthew McNally".ASPHostCentral setup a user and password, and I can visit both of those sites, enter the username and password, and view the sites. I can upload a test report, and view it in both sites.I cannot get a web page with a reportviewer control on it to display the report - due to the 401 error message. Imports Microsoft.VisualBasic Imports Microsoft.Reporting.WebForms Imports System.Security.Principal Public Class ReportsServerCredentials Public NotInheritable Class ReportServerCredentials Implements IReportServerCredentials [code]...

SQL Server :: Turning 2 Lists, Into 1?
I'm sort of new to ASP.NET. What i've done here is create a list of Newsletters seperated by University newsletters, and Alpha Newsletters. What I have now been asked to do is make these 2 lists into 1 list. I can't figure a Way to do it without designing the database? Does anyone have any ideas? Take these 2 lists and make 1? Using odsNewsletterAlpha and odsNewsletterUni to create 1 list? <h2>University Newsletters</h2> <asp:ListView class="lvUniversity" EnableViewState="true" ItemPlaceholderID="plcItem" DataSourceID="odsNewsletterUni"[code]...

Web Forms :: Turning Off The Autocomplete Feature For A Textbox
One thing I really love about web browsers, is the autocomplete feature they have for different controls, like textboxes in forms.  However, some times users get confused with the dropdown appearing.  So, we would like to be able to disable the autocomplete feature for some textboxes on some of our ASP.NET WebForms pages.  Isn't there a property which controls that?  Or is that done through JavaScript?

Nokia :: E72 Keypad Skip Through Web Page Link To Link
I've tried searching here and on Google, and have found the same question asked a few times but no answers. There is no tab key on the E72 keypad, so can anybody tell me is there an easy way to skip through a web page from link to link (or field to field)?

Display Information In A Textbox When Selecting A Command Button
Hello.. I'm basically new to vb 6.0.. my question is the followingi have to command buttons and when selecting either one of the buttons the information from a database is retrieve and display in a textbox... so far i display the same result when selecting the buttons... mi code is the followingVB Code:While Not rdResultado.EOF         rdResultado.MoveFirst           If nameForm.cmd_pq1.Value = True Then                         nameForm.txt_precio.Text = rdResultado![Price]               ElseIf nameForm.cmd_pq2.Value = True Then                 nameForm.txt_precio.Text = rdResultado![Price]                  End If           rdResultado.MoveNext thanx

Can't Read Remote Web Page From Local Apache/PHP
I'm trying to read the contents of any Web page on another host. I'm finding that... echo file_get_contents( '' ); .... works fine if I upload the PHP script to my Web host, and run it there. But if I run it on my PC, which is running Apache 1.3.33 (Win32) and PHP 5.0.5, then it always times out, and gives me the error message... [error] PHP Warning: file_get_contents( [<a href='function.file-get-contents'>function.file-get-contents</a>]: failed to open stream: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. I get the exact same results using... $fh = fopen( '', 'r' ) or die( $php_errormsg ); while (! feof($fh)) { $page .= fread($fh,1048576); } fclose($fh); echo $page; Anyone know what could cause this to happen?

Calling A Web Page From A Command Button.
I am trying to call a web page from a command button click event base off ofthe user input into a textbox. I have made an Activex doc and it works finecalling the web page but I can not call the Activex doc from a form. Is itpossible to do it this way? I just need to be able to call it from anotherform.Thanks in advance for any help.

HTC Desire :: Share Web Pages Options / Facebook And Friend Stream
I have two options to share web pages, facebook and friend stream. Can someone tell me what the difference is please?

Web Forms :: Remove Bad Code On Html Render Page
Im woking with aspx. And when I view source HTML I saw some code [Code].... I hate it. It's not clear and not validate.  When I working with PHP or ASP, I can get a pure HTML page. But can't with ASP.NET.

MVC :: "System.Web.Mvc.Html.MvcForm" In The Top Of Page / How To Remove This
on my MVC webforms there is a text in the top of the form as "System.Web.Mvc.Html.MvcForm". how can i remove this?

Web Forms :: How To Remove Html Code In A Textbox
i pull out some of the data from sql server 2005 iinto a textbox. but it display the data incluced the html, how to solve this issue?

Web Forms :: How To Retrieve Data Saved In Sql Db Into Checkboxlist
I've used checkboxlist to insert data into the sql database... example... checkboxlist have values 1,2,3,4,5... If is select 1,3 and 5 the values stored in databse will be 1,3,5. Now i want to retrieve those values into similar checkboxlist(1,2,3,4,5), but only 1,3 and 5 saved in db should be selected, 2 and 4 unselected....

Web Forms :: When Clicking On Link Goes To The Bottom Of Page
I am having trouble with a  aspx page that when I click on the link to go to the page it opens/starts at the bottom. I want the page to open at the top like normal pages do.

Web Forms :: How To Avoid Page Flicker When Clicking On A Link
I have noticed that many new modern websites (and templates like themforest templates) are being built without any page flicker.What I mean by page flicker is that when you click on a link the hole screen flicker and then the new page is retrieved and viewed.Here are some examples of these new sites (templates) that do not have any page flicker. I would like to know to make a website like above. I do realize that it must be ajax or javascript. However what I would like is some code.

Web Forms :: Send Mail Through A Html Page?
I want to send mail through a html page. My html page contains a form having ur name,phone,address etc... I want this content to be sent to an email id. I used the following code. [Code].... Its working but the way the form content is being sent is not good. sending the mail (form content) in a nice customized way. I cannot use any technology besides pure html.

Web Page Encoding Issues
I administrate a server with IIS 6 on it running Windows 2003 server. The problem is the person is does the webpages uploads webpages onto the server and when viewing them in the browser you see weird characters. The default encoding used is ISO, so when I change it to UTF-8 the characters go away and it looks normal. Now I know I can have him go into each page and add a meta tag to tell it to use UTF-8 but he has thousands of pages.

Web Forms :: How To Generate HTML Code By Commands From The Code Behind Page
how to generate HTML code from the code behind? I would like to build a form that generate an html code inside a for loop. I will let the user enter the photo name and No. of photos Then I will generate an HTML code like this: <a href="" target="_blank"> <img src="" alt="" width="345" height="247" /> </a> <br /> <a href="" target="_blank"> <img src="" alt="" width="345" height="247" /> </a> <br /> <a href="" target="_blank"> <img src="" alt="" width="345" height="247" /> </a> <br /> depending on the No. of the photos the code will be duplicated in the loop Then I will display the result of the loop in label or in a textarea to let the user copy it any where The problem is that while compiling my code it considers the HTML code as a part of the behind file and gives errors on the single quote, the double quote and on the parentheses 

Lighttpd Hosting Videos :: Cannot Display Page
we have a site, and it hosts videos, we want to serve these videos using lighty, however, we can't seem to get it to work at all, The current setup is Cpanel with Apache so we want Cpanel + Lighty(only for and Apache for everything else, im running lighty on port 8080, we've tried different ports for the sake of trial and error. This is the configuration that we have: # lighttpd configuration file # # use it as a base for lighttpd 1.0.0 and above # # $Id: lighttpd.conf,v 1.7 2004/11/03 22:26:05 weigon Exp $ ############ Options you really have to take care of #################### ## modules to load # at least mod_access and mod_accesslog should be loaded # all other module should only be loaded if really neccesary # - saves some time # - saves memory server.modules = ( # "mod_rewrite", # "mod_redirect", # "mod_alias", "mod_access", # "mod_cml", # "mod_trigger_b4_dl", # "mod_auth", # "mod_status", # "mod_setenv", # "mod_fastcgi", # "mod_proxy", # "mod_simple_vhost", # "mod_evhost", "mod_userdir", # "mod_cgi", # "mod_compress", # "mod_ssi", # "mod_usertrack", # "mod_expire", # "mod_secdownload", # "mod_rrdtool", "mod_accesslog" ) ## a static document-root, for virtual-hosting take look at the ## server.virtual-* options server.document-root = "/home2/x/www/flvideo/" ## where to send error-messages to server.errorlog = "/var/log/lighttpd/error.log" # files to check for if .../ is requested index-file.names = ( "index.php", "index.html", "index.htm", "default.htm" ) ## set the event-handler (read the performance section in the manual) # server.event-handler = "freebsd-kqueue" # needed on OS X # mimetype mapping mimetype.assign = ( ".rpm" => "application/x-rpm", ".pdf" => "application/pdf", ".sig" => "application/pgp-signature", ".spl" => "application/futuresplash", ".class" => "application/octet-stream", ".ps" => "application/postscript", ".torrent" => "application/x-bittorrent", ".dvi" => "application/x-dvi", ".gz" => "application/x-gzip", ".pac" => "application/x-ns-proxy-autoconfig", ".swf" => "application/x-shockwave-flash", ".tar.gz" => "application/x-tgz", ".tgz" => "application/x-tgz", ".tar" => "application/x-tar", ".zip" => "application/zip", ".mp3" => "audio/mpeg", ".m3u" => "audio/x-mpegurl", ".wma" => "audio/x-ms-wma", ".wax" => "audio/x-ms-wax", ".ogg" => "application/ogg", ".wav" => "audio/x-wav", ".gif" => "image/gif", ".jar" => "application/x-java-archive", ".jpg" => "image/jpeg", ".jpeg" => "image/jpeg", ".png" => "image/png", ".xbm" => "image/x-xbitmap", ".xpm" => "image/x-xpixmap", ".xwd" => "image/x-xwindowdump", ".css" => "text/css", ".html" => "text/html", ".htm" => "text/html", ".js" => "text/javascript", ".asc" => "text/plain", ".c" => "text/plain", ".cpp" => "text/plain", ".log" => "text/plain", ".conf" => "text/plain", ".text" => "text/plain", ".txt" => "text/plain", ".dtd" => "text/xml", ".xml" => "text/xml", ".mpeg" => "video/mpeg", ".mpg" => "video/mpeg", ".mov" => "video/quicktime", ".qt" => "video/quicktime", ".avi" => "video/x-msvideo", ".asf" => "video/x-ms-asf", ".asx" => "video/x-ms-asf", ".wmv" => "video/x-ms-wmv", ".bz2" => "application/x-bzip", ".tbz" => "application/x-bzip-compressed-tar", ".tar.bz2" => "application/x-bzip-compressed-tar", # default mime type "" => "application/octet-stream", ) # Use the "Content-Type" extended attribute to obtain mime type if possible mimetype.use-xattr = "enable" ## send a different Server: header ## be nice and keep it at lighttpd server.tag = "lighttpd" #### accesslog module accesslog.filename = "/var/log/lighttpd/access.log" ## deny access the file-extensions # # ~ is for backupfiles from vi, emacs, joe, ... # .inc is often used for code includes which should in general not be part #### accesslog module accesslog.filename = "/var/log/lighttpd/access.log" ## deny access the file-extensions # # ~ is for backupfiles from vi, emacs, joe, ... # .inc is often used for code includes which should in general not be part # of the document-root url.access-deny = ( "~", ".inc" ) $HTTP["url"] =~ ".pdf$" { server.range-requests = "disable" } ## # which extensions should not be handle via static-file transfer # # .php, .pl, .fcgi are most often handled by mod_fastcgi or mod_cgi static-file.exclude-extensions = ( ".php", ".pl", ".fcgi" ) ######### Options that are good to be but not neccesary to be changed ####### ## bind to port (default: 80) server.port = 8080 ## bind to localhost (default: all interfaces) server.bind = "" This is the weird part, if we lynx it will display the html file inside the docroot, if i go on firefox or internet explorer the connection gets reset and internet explorer throws a "cannot display page" error,

Web Forms :: How To Display Default Image When Image Control Link Is Dead
i have a website which has a <IMG> and/or <asp:Image> in it. The user has an option to upload an image. so if the user does upload an image it will be displayed in the stated controls above. but if they don't the control displays its alternative text or an "x" icon. can i just place a default image in it if there is no image reference to it to display?

.NET Pages Run In Web Configuration
in (in .cs file of an .aspx page ) there is no Main() method then how an .aspx page run or  executed ?

Web Forms :: How To Share Master Pages / Ascx Files Across Applications
We are developing a framework which will be shared accross applications. What is the best way to share master pages, user controls accross applications by preventing other developers to modify the master pages and the user controls ? Is the following way suitable one ? Embedding masterpages and the user controls in a dll and using VirtualPathProvider to load the master pages and user controls dynamically. But in this approach developers can not view the design. Is there any other way to convert master pages and user controls to a different format as developers can able to view design?

SQL Server :: Choose The Most Popular Venue?
i have to choose the most popular venueselect max(count(Destination))as popular_venu from bookingthis shows me do i solve this?nothr queriesselect max(count(Departure_time)from bookingwhere Departure_time>12:00:00i got error for both.please help me to sovle

Get Data From Previous Page For Search Function And Display Returned Data Into Gridview
I implemented PreviousPage to get data from previous page for my search function and display the returned data into a gridview. The gridview's allowpaging is enabled, but every time I go to next page, my previous page data is lost... how can I resolve that?

Web Forms :: Display Photo Using URL String?
I have a member site that allows the members to upload their photo to their page. In addition they have a public accessible .aspx page that I would like to have their photo displayed on. Using the method to call the photo associated with the memberID, how do I call the photo in my page? My member's photos are saved in a folder and NOT in a database. Each of the member's photos are automatically saved with a filename that is their "MemberID".png.

Web Forms :: Display Vowels In A Given String?
i want to display vowels and consonants in a given string. i have taken a txtbox and btn if the btn is pressed it has to show vowels and consonants separately.

Web Forms :: Display String Through Keyvalue Pair Using Object
<% if (this._arr_design.Count > 0) { %> <% foreach (Ameronix.Teeone.Models.Design obj_design in this._arr_design) { %> <tr> <td style="width: 254px; height: 27px;"><%= obj_design.name_design.ToString() %> <div class="thumbnails"> <% foreach (System.Collections.Generic.KeyValuePair<int, Ameronix.Teeone.Models.DesignSection> kvp in obj_design.arr_design_section) { %> <div class="thumbnail"><a href="/snapshots/processed/designs/<%= obj_design.id_design %>_<%= kvp.Value.id_design_section %>.jpg" rel="lightbox"><img src="../resources/get_image.aspx?src=/snapshots/processed/designs/<%= obj_design.id_design%>_<%= kvp.Value.id_design_section %>.jpg&width=50&height=50" /></a></div> C# Code................... This code is used to display the snapshots of processed images on the page, but the first images is displayed in the place of second one as well.Not able to sort it ..These images r stored in the SQL table.There is a repeat of image.

SQL Server :: Unable To Correct Data Formats On Host
I created web pages that used an SQL database on my home computer.  That DB allowed me to use data types such as 'date' and 'time'.  But when I transferred my website to a host server, I discovered that its DB does not accept these types.  They only use 'datetime' and 'timestamp'.  I changed the tables in the DB on my computer to conform to the same format as on the host computer.  I also changed the properties to the new data types with the O/R Developer and re-published the website files to the host server. But I keep getting the same error message that states the server does not support 'date' data types whenever I execute a web page that uses that table column.  The C# code states "officetable.StartDate = DateTime.Today;" 

Web Forms :: Date - Validate 2 Types Of Date Formats On One Textbox
i have date validation, how can i validate 2 types of date formats on one textbox. when user enters a date into the textbox, it must accept date such as 01/01/2009 AND 1/1/2009 [Code]....

Web Forms :: Blocking Autocomplate Textbox On Browsers?
I have a bookingwith credit card page in my application and users will enter their crdit card details inside the textboxes. but after they  enter them and post it the browser cache the data and after that in the same textbox, it can be autocomplated.

Web Forms :: Outputcache With Sql DB?
I am using VS2008 with C# to create a web application. I am using output cache to improve performance. There are No of places where I had written  a function to fetch the some records from the database. Now the return of such functions will chage only if some record is added in the sql table or some record is updated. So how we can apply cache in that  so that it can detect that a new record is added and check if that record ios in the cache or not if not then it will refresh the cache.

Web Forms :: Ontextchanged Attribute Of Textbox Not Firing?
I am using the following line is my code and the onTextChanged event is not firing. But when I use the onClick event on the same code, it's firing. textbox1.Attributes.Add("onClick", "SetValue();") But I need to do my calculations only if the value in the textbox is changed not when the user clicks on the textbox.

SQL Server :: Creating A Sequence Using Visual Studio 2010 - Incremental ID
I am have created SQL database by using Visual Studio 2010. I created a table for users. My question is: How can I create an ID that increases automatically? For example, ID starts by 1 and increases 2 - 3 - 4 .......

Web Forms :: Insert Html Tage To Sqlserver Database Through Textbox( 2.0)?
Insert html tage to sqlserver database through textbox Display it lable control

Web Platform Installer And Sql Express Database Setup
I tried to install Amplifeeder today with the Web Platform Installer. When I arrived at the database setup I had to fill out some informations like "db admin user/password" and user username/password. Using SQL Express I do not have any username/password (neither admin or user). How should I be able to install applications with the WPI and SQL Express 2008 ? Basically I had this error while trying to install in the logs: DownloadManager Error: 0 : MS Deploy exception: Microsoft.Web.Deployment.DeploymentClientServerException: The database 'AmpliFeederDB' could not be created. ---> System.Data.SqlClient.SqlException: Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.

Web Forms :: Use Multi Upload File - Get Value In Textboxes
i'm tying to use multi-upload file and also multi-textboxs i want to get value in textboxs how can i get value of textbox's? this is my code in page ASPX [Code].... and this is my code [Code].... Program you well undrstand what i mean. I want to get value of text box for each textboxs.

Web Forms :: BoundField In Gridview Automatically Converts To Textboxes
When using a simple gridview targeting .net 4.0 if i click the edit button twice it converts to BoundFields to textboxes, but in previous version of .net (3.5 and 2.0) nothing happens (eventhough msdn says it suppose to happen). Have anyone seen this issue? Code: <asp:GridView ID="GridView1"   AutoGenerateColumns="False" DataKeyNames="Id" runat="server" onrowediting="GridView1_RowEditing"> <Columns> <asp:BoundField DataField="Id" HeaderText="ID" Visible="False" /> <asp:BoundField DataField="FirstName" HeaderText="First Name" /> <asp:BoundField DataField="LastName" HeaderText="Last Name" /> <asp:TemplateField> <ItemTemplate> <asp:ImageButton ID="imageButton" AlternateText="Edit" CausesValidation="false" CommandName="Edit" runat="server" /> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView> public partial class _Default : System.Web.UI.Page { public class Person { public string FirstName { get; set; } public string LastName { get; set; } [Code....]

Web Forms :: Display Webform On Same Window?
I have option page to my Project which has Status,Issu,HMR,DFG buttons on center of the webform, every page will redirect to another page if you  click on this option buttons,Now i wanted to change this .. I want to split the page keep all options buttons on left of the screen when you click option buttons corresponding web page should open in Right of the screen,how can i do this one.I am working on visual web developer2008(Asp>net3.5)

SQL Server :: The Multi-part Identifier "bad.towho" Could Not Be Bound
I have the following query: select good.fromwho , good.applesdate, good.starttime , good.hungupfromwho from apples good where ( good.type = 1 and good.result = 2 and good.fromwho not inselect bad.towho from apples bad where bad.type = 2 and bad.result = 1 and bad.applesdate >= good.applesdate and bad.starttime > good.starttime ) What I want to be able to do is add to my top selection statement columns from the "bad" table. If I try, it gives me  The multi-part identifier "bad.towho" could not be bound. Is this possible?

SQL Server :: Set Bit Field Default Value?
I am trying to add a bit field with a default value of false to an existing table using VWD 2010 Express. With the allow nulls checkbox turned off and no data in the table, any value I attempt to enter into the default value box (0,(0), ((0)), False) all produce an error when exiting the field. What's the secret?

SQL Server :: How To Know If Field In A Table Is Encrypted Or Not
if field in a sql data table is encrypted or not ??!! like a function that return true or false>>> IsEncrypted()

SQL Server :: Switch Two Field Data?
I pulled a fast one today.  I imported thousands of records and accidentally put the FName in the LName and the LName in the FName.  I don't have a clue how to write a SQL or TSQL that will switch them.  I do have a parameter for the SQL though.  WHERE User - System Import.on ASP.NET because this is my place for help instead of going elsewhere to a more specific type of forum just for SQL.  I do only ASP.NET VB/CS development so this is my home to find all my answers.  (99% of the time).

SQL Server :: Taking Records Out Of Oracle And Putting Them Into A SQL Server?
I was wandering if I can make this faster. I am taking records out of Oracle and putting them into a SQL Server. btw, I am inserting into the Identity column [Code]....

SQL Server :: How To Pass Parameter To PIVOT Query
I tried to develop a dynamic pivot query with following code to avoid hard coding. I can got the 'Q1, Q2, Q3, Q4' dynamically and assigned to @(@quarter. But it cannot be passed to the pivot query. [Code]....

Pass Selected Radiobutton To Insert Parameter SQL Server?
I can do that writing to insert into code. But my manager wants me to use sqldatasource control and it's insert delete update function to work with. My old code was this Code: [code]... after than i pass fieldevent but i don't know how to do it on sqldatasource control.

SQL Server :: Concat String With Parameter In SP
i have a SP [Code].... as you can see from the SP, i need save in some variable because i have to create a dynamic SQL query who select with an "or" or "AND" from web form parametersthe problem is concatenate the SP parameter to my query actually, this SP returns the string : "select * from...." and not the resultset!

SQL Server :: Update String Inside Every Record?
Inside many of my records, I have some HTML - - inside the HTML, I have a particular tag: <code> I'd like to change only that code to: <pre> But I don't want to change any other text inside any records... What sql can I use to do something like this?

SQL Server :: Show 5 Random Record From Table?
i need to show for every refresh of page five categories, every time different how can i do? in SQL do not exist select RND(field)...

SQL Server :: Select Query Based On Two Fileds With Different Column
This is my Table structure:-Table1 Field1        Field2     Age Dean         Chen      20          Janel         Wast       25 ann            Miller      20 I used this select statement  select Field1+' - '+Filed2 from Table1 and i binded this in dropdownlist now on selecting dropdownlist i need to show age in label. so how would be my select statement... to show age base on Filed1 and Filed2

Possible To Copy Display Data From Another Website Page
Is it possible to copy display data from another website page?Display data means ,data that is displayed in page.For example, am alien to this website,but I want to copy data .that is shown in above link page to my website page.

SQL Server :: How To Insert Data Based On Gridview User Value On Row
I have three column comes from database table(Table1) and one column is for entering data for the user let us consider it look like this  ItemNo ItemName Qty  uservalue 001       A               50       20 002       A               20       5 003       B               50   004       C               60      10 005       D               40  006       E               90      15  ........ If its 300 row from database to gridview it will show 50 record with page navigation..What i need is i need to insert data in to database table which gridview row has user value..The output of the another table(Table2) will look like this after insert ItemNo ItemName   uservalue 001       A                    20 002       A                      5   004       C                    10 006       E                    15 

SQL Server :: Cannot Insert The Value NULL Into Column ReviewDate - Table "ProrsumDB.dbo.Review"
I've been working on this project which requires me to insert data into a database. Due to the complexities of the function that I am doing, it is more complex to use SqlDataSource and hence I've used the traditional method of inserting to the database. The codes are as follows: [Code].... I am not too sure why, but even though I've debugged numerous times and the data gets inserted into the database through the form view, I get this error on the page after everything is executed: Cannot insert the value NULL into column 'reviewDate', table 'ProrsumDB.dbo.Review'; column does not allow nulls. INSERT fails. The statement has been terminated. reviewDate wasn't null when I tried and there are no exception thrown.

SQL Server :: How To Select Only One Row From DataSet
My DataSet gives a result like this when i bind to GridView BillNo     BillStation            Amt1         Amt2       Amt3       Amt4 Hyd  1              Hyd                  100              50          50           25  2              Hyd                  100              50          50           25 Bang   2              Bang                500            100        200           50   2              Bang                500            100        200           50 Delhi  3              Delhi                  50              25          50          100  3              Delhi                  50              25          50          100 As the rows from each group is same. I want to display only the first row from each group. [Code]....

Forms Data Controls :: Write XML File From Web Service To Display In Gridview
How would I display the following code into a GridView. First, I need the application to write the xml file somewhere on my harddrive and then I need it to read it to populate a gridview.   protected void Page_Load(object sender, EventArgs e) { var xmlRequest = new XElement("GetTicketAction", new XAttribute(XNamespace.Xmlns + "xsi",[URL] " new XAttribute(XNamespace.Xmlns + "xsd", "[URL]"), new XElement("CompanyName", Setup.Company), new XElement("IntegrationLoginId", Setup.Username ), new XElement("IntegrationPassword", Setup.Password), new XElement("SrServiceRecid", Setup.SrServiceRecid)) .ToString(); var proxy = new MyWebService.integration_io(); var xmlResponse = proxy.ProcessClientAction(xmlRequest); var parsedXmlResponse = XElement.Parse(xmlResponse);......................

SQL Server :: How To Start Identity Column From 001
I want to konw how to start my identity column from 001? [Code].... this does not work as it still takes it froom cause 001 and 1 is the same 

SQL Server :: Set Identity To Primary Key Column?
I have table with around 100 record. Now I want to set identity to primary Key column

SQL Server :: Create IDENTITY ID For Primary Key Column
how can i create IDENTITY ID for primary Key column like this AAAAA AAAAB AAAAC AAAAD AAAAE . ' ' ' AAAA1 AAAA2 AAAA3 AAAA4 . . . . AAABA AAABB AAABC

SQL Server :: Identity Column Reset When Shifting Database To Remote
actually recently we just shifted our website. & now when i try to transfer database from my previous server to new remote server database.all the tables auto increment field is set to 'NO' and there is no primary key anymore.

SQL Server :: Where Is Statement In XML Explicit
I've build a query, but the where statement is doing strange things. First my query: select * from ( SELECT 1 as Tag, null as Parent, row_number() OVER (ORDER BY tblOccasion.ID DESC) AS [tblOccasion!1!rownum], FROM tblOccasionwhere tblOccasion.UserID = @UserName and ((tblOccasion.MerkDesc like '%' + @search + '%')or(tblOccasion.UitvoeringDesc like '%' + @search + '%')or(tblOccasion.UitvoeringDesc like '%' + @search + '%')) ) AS A where a.[tblOccasion!1!rownum] BETWEEN (@startRowIndex) AND (@startRowIndex+@pageSize) order by a.[tblOccasion!1!MerkDesc!Element],a.[tblOccasion!1!TypeDesc!Element],a.[tblOccasion!1!UitvoeringDesc!Element] FOR XML EXPLICIT; But the result should be ordered by Merkdesc, then TypeDesc, and then as last the uitvoeringDesc. So for testing i only used the MerkDesc. The strange thing is that i get the result: BMW BMW BMW Opel Volvo But this was page 1, on page 2 (paging) you got BMW again... so he takes the first 5 rows ore something and then the order. But i like that he first orders it by MerkDesc and then picks the first 5. How can i change that, i can't add a Order by in the inline sql statement i get this error: Msg 1033, Level 15, State 1, Procedure MijnAdvertenties, Line 47 De ORDER BY-component is ongeldig in weergaven, in line functies, afgeleide tabellen en algemene tabelexpressies, tenzij ook TOP of FOR XML is opgegeven.

SQL Server :: Deadlocked Transaction On Lock Resources
I develop an application using LINQ to SQL. Recently I deploy the application on  server and starts performance testing using WAPT for 100 users. Unfortunately, 90 requests are failed while placing an order and only 10 are passed. I analyse and found that for every failed request I got an error "System Exception: Transaction (Process Id 68) was Deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction."

Web Forms :: Way To Highlight Error In 2nd TextBox Like Typing Tutor Application In C Sharp
When I am building my typing tutor application the errors user made I want to show it in RED into his textbox. I created a LIST to have the index values stored but cannot figure it out how to retieve it and make them display as RED COLOR in UserTexbox. [Code]....

SQL Server :: C Sharp - How To Connect To Database
i am writing a simple C# application with sql as my database however i am confused how to connect to my database the details are the following: Server = "BFO-PC3\BFOPC3SQL2000"; Username = "aesadmin"; Password = "adminpw"; Database = "M4200";

MVC :: Datetime Format And Modelstate?
I have textbox on my page as [Code]....

Web Forms :: VB Script To Obtain The Value Of The Textbox On Page Load To Pass To Another Textbox?
I have a text box on page load, loads a text value. I would like on the first instance of the page load for another textbox to equal to this value.  As I have a gridview on the same page to update the textbox value does not get updated.  Essentially, if provide me with a VB script to obtain the value of the textbox on page load to pass to another textbox default value only on the same page.

SQL Server :: Execute Dynamic Query From The Resultset?
I've a resultset that returns some 55 rows which is typically a dynamic query like [Select column_name from table_name where column = condition]. I need to execute this query which is in resultset and insert the value of column_name into another table. I dont get the way as how to make it. Kindly suggest me as how can I execute it.

Web Forms :: Pass A Textbox Value In CommandEventArgs?
I have a search form with a textbox and a button. I was wondering if I can pass easily the value of the textbox into the CommanArgument field of the linkbutton. That would clean up my code nicely :)

Web Forms :: Can't Pass Value From Dropdown To Asp:TextBox
I need to get an asp:TextBox to accept the value of a dropdown list. If I set it up with a standard <input type="text"> box it will accept the value, but because of a dll or code behind it won't pass the value to the next page as an <input>, it'll only accept it as an <asp:TextBox>.  This will accept the value from the dropdown, but won't pass it to the next page: [Code].... I tried the <asp:DropDownList> too but that didn't make a difference.

Web Forms :: Scrolling Text From SQL?
wanted to create some scrolling text on a page dictated from a sql query, in html days i used marquee but this didnt seem to work, and nor do i know how to fit it into a sql query, i was a select query attached to a label would do the job,

Web Forms :: Transferring Data Between Access Database And Sql Database
I want to transfer data from a access table to a sql table. Simple by clicking a button. first off all i set up and OleDbConnection and a SqlConnection in my web.config file. This is the code i use in a b button method for transfer data for 1 tab le. [code]....

Forms Data Controls :: How To Update CheckBox Checked Value To Sql Server Database?\
My Code is as follows: <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataKeyNames="Id" DataSourceID="SqlDataSource1" Height="50px" Style="position: static" Width="125px"> <Fields> <asp:TemplateField HeaderText="Active" SortExpression="Active"> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Bind("Active") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Bind("Active") %>' Style="position: static" />  </EditItemTemplate> <InsertItemTemplate> <asp:CheckBox ID="CheckBox2" runat="server" Checked='<%# Bind("Active") %>' Style="position: static" /> </InsertItemTemplate> </asp:TemplateField> <asp:CommandField ShowInsertButton="True" /> <asp:CommandField ShowEditButton="True" /> </Fields> </asp:DetailsView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NetConnectionString %>" SelectCommand="SELECT [Id], [Active] FROM [HN_RoomMaster]" InsertCommand="INSERT INTO [HN_RoomMaster] ([Active]) VALUES (@Active)" UpdateCommand="UPDATE [HN_RoomMaster] SET [Active] = @Active WHERE [Id] = @original_Id"> <DeleteParameters> <asp:Parameter Name="original_Id" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="Active" Type="String" /> <asp:Parameter Name="original_Id" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="Active" Type="String" /> </InsertParameters> </asp:SqlDataSource> When I click Edit Button the CheckBox gets the value from database and gets ticked.But when I click Update Button, Value ' True ' gets updated to database. But when i try to update the same data the following error message appears near CheckBox: When casting from a number, the value must be number less than infinity.Make sure the source type is convertible to the destination type. I want to update 1 or 2 as value for the field ACTIVE. ie the CheckBox value should be 1 or 2.

Web Forms :: How To Display Image Depending Upon Db Field Value
this is my aspx page code : <a runat="server" id="hlkmail"><img src="../images/send_mail_icon.jpg" alt="" /></a> <a runat="server" id="hlkgallery"><img src="../images/galleryl_icon.jpg" alt="" /></a> this is code behind (aspx.vb) : hlkmail.HRef = "sndmail.aspx?Clientname=" & clientName hlkgallery.HRef = "pgallery.aspx?Clientname=" & clientName above code shows fixed images. i want to display image dynamiccally depending upon the db value. i have a stored proc that returns hasmail ='true/false' and hasgallery='true/false' from database. if true i want to display send_mail_icon.jpg else send_mail_icon_watermark.jpg and gallery_icon else gallery_icon_watermark.jpg. i want to do this in code behind using if loop.

Web Forms :: Display Required Field After Postback?
i have the follwoing textbox. i want it to be a reqiured field so i have used the RequiredFieldValidator. My problem is that i have set an event on the textbox and i need autpostback=true. However, because of this my requeired field valdator doesnt work. is there a way i can get it to work and dispalyed when the user has left it blank and use the autopostback=true.the following is the code i have: [Code]....

Web Forms :: How To Display Column Field In A ListBox Control
i need to display perticular couln field values in a ListBox control. but database is not in local meachine. i know how to configure a ListBox to display values from localdatabase but how to configure to a remote database ?

Web Forms :: DataList: Collecting IDs And TextBox Values At Same Time
 Collecting IDs and TextBox values at same time.I have a datalist with 2 columns of products with a TextBox next to each product so my customer can enter a number in each checkbox (to determine the order sequence when this list of products is printed to the screen). I have a button for my customer to click when she is happy with the sequence chosen for each product and this calls a subroutine within which I need to be able to collect each productID and the number entered into the textbox next to it. This worked perfectly in my old system using Classic ASP and can't understand why it's so difficult to offer the same funtionality in ASP.Net! I have tried various approaches but none of them work in collecting the number entered into the TextBox and the ProdId at the same time. I tried storing the ProductId in the ID of the TextBox in the hope that I could then retrieve both the ProductId and the value of the TextBox for each product when the button is clicked but values of the TextBox ID are values such as 567 or 784 and are set dynamically (these are the productIds). The error I'm getting is as follows: The ID property of a control can only be set using the ID attribute in the tag and a simple value. Example: <asp:Button runat="server" id="Button1" /> and the line containing the error is: <asp:TextBox runat="server" ID='<%# DataBinder.Eval(Container.DataItem, "Prod_ID")%>' Text='<%# DataBinder.Eval(Container.DataItem, "Sequence1")%>'>

Web Forms :: Datalist Displaying Duplicate Data?
Have a look below. I hope its easily understandable. //ASPX Code <asp:DataList ID="DataList1" runat="server"> <ItemTemplate> <%#DisplayReceipts(Eval("Date").ToString(),Eval("MemberName").ToString(),Eval("Amt").ToString()) %> </ItemTemplate>.......... My dataset/datatable/sp returns 8 receipt records for particular accountid. I want to display each receipt (record) as ItemTemplate in DataList (with my desired html layout) hence the code above. But i am getting 36 receipts displayed in datalist with some of them repeated.

Web Forms :: Display The Physical Harddrives Of System?
i need to display the physical harddrives of system in a dropdown & depending on the drive select the folders  subfolder in listbox or some other control in webapplication 

Web Forms :: Accessing UserControl TextBox Null Reference?
I have a .ascx file residing in another page which has a button on it. On click I run a select statement that accesses the textbox for a value. However, it keeps returning a Null Exception Error. I am trying access the textbox and its text through [Code].... I also tried -[Code].... I also tried -[Code].... But none of them work. Please can someone advise me how I find the textbox and then access its text?I have looked round the forums / google and cant find a way of doing this!

How To Handle Exceptions In A 3-tier Web Application - Specifically Sql Database Exceptions
I'm building the standard 3-tier ASP.NET web application but I'm struggling as to where to do certain things - specifically handling exceptions. I've tried to have a look around on the web for some examples but can't find any which go as far as a whole project showing how everything links together. In my data-tier I'm connecting to SQL Server and doing some stuff. I know I need to catch exceptions that could be raised as a result but I'm not sure where to do it. From what I've read I should be doing it in the UI tier but in that case I'm not sure how to ensure that the connection to the database is closed. Is anyone able to clarify how to do this? Also if anyone knows as to where I could find an example 3-tier web application that follows best practices that would be great too.

Display New Information Onto Page
I have an application, which is going to be a draft application, like for a hockey fantasy league. I want to have a live draft, so I've created a background thread which monitors the "transactions" that are happening. My problem is, I need a way to actually display the new information onto the page as I recieve the updates. What would be the best way to go about doing this?

C# - How To Display Windows.Form.MessageBox In Web Application
I want to display my validation error messages in the MessageBox. I have Four TextBoxes and One Button control. When I click the Button Control, the TextBoxes without the text to be shown in the MessageBox. I have almost done this, but the problem is When I click the Button, the MessageBox is opened as a minimized window. So it is difficult for the end user to realize. I want to display the MessageBox to the user when button clicks. Here is my code, In the Button Click Event [code]....

Security :: Display/capture Loginname Value In Textbox?
I have a code here where the loginname will display the computer name.I have another textbox,where i want the same loginname value to be displayed in the textbox.Here's my code : [Code]....

SQL Server :: How To Set A Optional Parameter To NULL
I have got a problem about setting the optional parameter to NULL in sql sp. Initially I set all the parameters null in the sql sp. That's OK. But I would like to set the parameters to Null again if a particular parameter has a value of - 1 by using the "IF ELSE" statement block. However, the problem was that I was unable to set the parameter to NULL in the IF ELSE statement. So please correct my IF  ELSE statement in the store procedure. This is really urgent and important for my project.  spGetMealsByNutritions] @MealTypeID Int, @Gluten Bit = Null, @Dairy Bit = Null, @Egg Bit = Null, @Fish Bit = Null, @Veg Bit = Null, @Pork Bit = Null, @Beef Bit = Null, @Soy Bit = Null, @Sesame Bit = Null [code]...

SQL Server :: Could Not Allocate Space For Object 'dbo.tbl_Notes'
I have an storedprocedure which checks the following scenario: An email will be sent to multiple customers simulataenously. the email addresses are seperated by semi colon. I have to save that mail in  a table and then in the same procedure,  I have to check each email address and whether it is of any customer in the customer table.. If it is of customer, then i have to insert an entry in another notes table. For this i am doing the following operation in Stored procedure: [Code].... the above is the part of storedprocedure i wrote. The problem is I get an error when executing this stroed procedure in  Could not allocate space for object 'dbo.tbl_Notes'.'PK_tbl_Notes' in database 'ProjDB' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. and following that code,  i am executing another SqlBulkCopy operation in front-end .. that returns the following error: System.Data.SqlClient.SqlException: Could not allocate a new page for database 'ProjDB' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

JQuery :: Adjusting Elements Display According To Page Width
I would like to adjust elements displayed on my view depending on the width of the page. Let's say the page width is greater than 800 px, then I would like to display div A + div B (see picture below). But if the page width is less or equal than 600 px,then I would like to display only div A. It has to be dynamic. So If the user resize the window, the div B must be showed or hided.

Display A Page's Elements As Selectable?
I am looking for a way to make all visible objects in a webpage selectable by a visitor. For example, I take google's homepage as source, my php script already gets the homepage, and stores everything in an array. Now I want to show the google homepage with every object (span, div, body, td etc...) selectable. My visitor will select a few objects and then click submit (form post) I do not know how to do this, even after searching dhtml and so ..