Search results for query: *

I had an app that worked fine at work, but when I moved it to my home computer the session stopped working. Found that my firewall was the issue, turned it off and everything worked fine. Give it a try.

I didn't see much difference between 2002 and 2003. 2005 was a big step though. Many more controls available and provide much faster development with a lot less code.

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...

The application would be given away to allow users to install. I want to allow a few installation steps for the user as possible, so forget the sql server. Don't wanna deal with the security. With Access for example, it would create a new mdb file, with no security settings. How can I have...

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...

Yes I have sql server installed on my local computer. I was emailed the bak file and moved the file to my C drive. I then ran the above command.

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...

Sorry for taking so long, had to work on another project. I've used: <%# DataBinder.Eval(ds, "Tables[<table name>].DefaultView.[0].<ColumnName") %> But this returns the firstrow of the datatable for every record in the list. It doesn't read through each row.

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...

You mean declaring the dataset within the aspx page. I would rather not do that, as all my code will be in a codebehind. As in my previous posting, it's already directing to the correct table. Just need to figure out how to reference the column now.

k, getting closer. The following: <%# Container.DataItem("Tables(FunChi7).DefaultView.[0].Hourly") %> returns: Tables(FunChi7).DefaultView.[0].Hourly is neither a DataColumn nor a DataRelation for table FunChi7. but at least it's recognizing the table. Just need the syntax to pinpoint the...

I've tried the above but it returns 'ds' is not declared. Also tried: <%# DataBinder.Eval(Container.DataItem, "Tables(FunChi7).DefaultView.[0].Hourly") %> but returns 'System.Data.DataRowView' does not contain a property with the name Tables. Am I missing something here? Thanks

could you elaborate please. Are you talking about picking the column after you created a dataset via visual studio designer? I created the dataset via code: Codebehind: Dim cmd as new sqlcommand("sproc1", conn) Dim da as new sqldataapdapter(cmd) Dim ds as dataset da.Fill(ds) Dim cmd2 as new...

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...

you need to import system.data.sqlclient instead of odbc

LFCfan, That's exactly what I'm trying to do. I didn't try it out, but looking at the code it should work. I actually figured out a solution using a slightly different method. Instead of a key/value table I added another hidden textbox to each array of textboxes. It would then match the...

Sorry, wasn't specific enough. If Select Case CInt(dtResult.Rows(i)(1).ToString) Case 1 Then need to fill 1st set of textboxes: {txtHrFoundry, txtTpFoundry, txtSlFoundry} Case 3 Then fill 2nd set of textboxes: {txtHrMold, txtTpMold, txtSlMold} The case #...

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...

SQLSister Haven't tried it yet, only took a brief look, but it looks like this is exactly what I'm looking for. Thanks