Search results for query: *

What's the recommended best practice for data validation? Is asp.net validation controls enough or should I also create validation in sql stored procedures? What do you guys think? I was discussing this with a co-worker, and feel that asp.net controls should be enough and would be easier to...

I have an asp:table in a webpartzone that contains a textbox and button and an asp:gridview in another webpartzone. When the user inputs data in the textbox and clicks the button, it inserts into an sql table. The gridview displays data in the sql table. The gridview is using an...

When creating a setup/deployment installer for an asp.net application can options be added to allow users to choose the back-end database and based on the selection use a certain connection string for the web.config file. How do distributed applications setup the back end database? Or must...

I received a backup of a db with .bak extenstion. I'm trying to restore it on my local computer. Could anyone tell me the steps of setting this up. I've tried from query analyzer's master run the following command: restore database bt from disk = 'c:\BolTrab_28.10.2005.bak' But this...

I trying to add up values of a column based on whether another column has a date entered as such: SELECT P.Plant , ISNULL(SUM(CASE WHEN F.dt_Sign BETWEEN '01/01/00'AND '12/31/00' THEN M.AppvdAmount END), 0) AS CurrentTotal , ISNULL(SUM(CASE WHEN F.dt_Sign BETWEEN '01/01/00' AND...

I have a dataset that returns multiple tables. Some of these tables have the same column names. I'm trying to bind the columns to itemtemplate of datalist. How can I tell it to bind Table1 ColumnA instead of Table3 ColumnA? I've played with the Container.DataItem but can't get it to work...

I have a multi dimensional array of textboxes, arrTxtBx(37, 3), and data populated in a datatable, dtResult. For each row in datatable if 1st column is DbNull it'll return "0" for the 1st set of 3 textboxes, if 1st column in not Dbnull it'll return columns 3, 4, 5 as text for the 3 textboxes...

I have a dropdownlist with list of names and am trying to allow users to select multiple items and submit form. OnClick, it will delete the selected items from the database. I've tried deleting using the 'WHERE ABC IN (1,2,3)' in the stored procedure. But ABC column is integer and I can only...

I have a dropdownlist with list of names and am trying to allow users to select multiple items and submit form. OnClick, it will delete the selected items from the database. I've tried deleting using the 'WHERE ABC IN (1,2,3)' in the stored procedure. But ABC column is integer and I can only...

I'm trying to datagrid buttoncolumn of images show a popup window when clicked. I can create it when using the traditional pushbutton, but once I change the button to an image error results as follows: "InvalidCastException: Specified cast is not valid." for line: "Dim deleteButton As...

I'm trying to format the output of one of the fields as follows: SELECT EEEMPN, EENAME, TIATIM, (SUBSTRING(TIATIM, 4, 2) + '/' + SUBSTRING(TIATIM, 6, 2) + '/2005') AS NewDate I'm trying to display the fourth column so that it get two digits from the 1st substring, add a '/', two digits from...

Can I get the current directory that the web page is located in with javascript or html. I've created the same function in asp.net user controls but need to recreate it in html/javascript. Can anyone point me in the right direction? Thanks for any input.

How can I display an image dynamically based on certain criteria. For example, <img src="../image/<% =Image%>.jpg/> Will display the image of the Image() Function returned results. Can I pass a parameter 'x' in the <img src="../image/<% =Image(x)%>.jpg/> And do if..else in the Image()...

I'm looking for a free stock quotes and charts that I can incorporate into my website. I used to use stockpoint but they've been taken over by marketwatch that now charges a fee. Does anyone know who still offers this service free?

can i have a asp:button to view/open a file in the browser. I can do it with a hyperlink, but i'm trying to do it with a button but can't figure out how. Any help?

Can I prevent the image menu from showing when the mouse rollovers an image. My site has a lot of pictures on them and I don't like it when the menu keeps showing. It sometimes covers the logos.

I have a webform displaying txtboxes in currency format. User may want to modify data. But if they modify some data but not the textboxes with currency format, the stored procedure treats the values as a string because of the $ and commas. How can I have the parameters of the stored...

I'm creating a printer friendly page that has a top menu, left side menu and a main section as follows: <div id=topmenu> <table> <tr> <td>TopMenu here</td> </tr> </table> </div> <table> <tr> <div id=sidemenu><td>SideMenu here</td></div> <td>MainSection here</> </tr> </table> I have a...

I have an datatable that loads the different values of textboxes on page load. Each row being a record for db. Users could then change/modify values of textboxes and click button to update record. Upon button onclick, it will check the page load datatable to see if record (row) has values...

I'm trying to pass a datatable to a sub to perform some actions. I've got something to this sort: Function dtFeedbackLoad() Dim dt As DataTable = New DataTable("Feedback") Dim dr0, dr1, dr2 As DataRow Dim Id As DataColumn = New DataColumn("Id") Dim Recv As DataColumn = New...