Search results for query: *

Simple question. In Microsoft SQL Server Management Studio Express SQL Server 2005, I haven't figured out how to use the menus to open and modify objects. In Enterprise Manager I could give focus to a table and use ALT - A - O - A to open all rows in that table. In 2005, I have to use a right...

I'm using System.Data.Odbc to open an Excel file (excelConn = New OdbcConnection("Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=" & sFileName & ";DefaultDir=" & sDirectory & ";")) and am having no trouble opening the file, and reading each row via an OdbcDataReader, but for some...

OK, I've got a Gridview that contains Users and their info; FirstName, LastName, .... It also contains "Last Login", a date. When "Last Login" is null, "1/1/0001 12:00:00 AM" is showing up. I understand that this is happening because a VB date can never really be "Nothing", but is instead set...

Is there a way to say "IF A1 is Bold THEN 'It's Bold' ELSE 'It's Not Bold'". Obviously the Excel Formula would look something like =IF(A1.font = "BOLD", "It's Bold", "It's Not Bold")It's the ".font = "BOLD" part that I'm not sure how to do. Thanks a lot.

I'm passing myVariable into a stored procedure. Inside my stored procedure I want to store myVariable into MyTable.myField. MyTable.myField has a default value. If myVariable is null, I want to use myField's DEFAULT value. The following code doesn't work UPDATE MyTable SET myField =...

I have a table "MyTable", with 1 field "MyField" of type VARCHAR(27). Say I've forgotten the length of MyField and I want to use T-SQL to get it. I want "SELECT XXXX FROM MyTable" to return one record with one field, 27. What does "XXXX" need to be? Thanks, and have a great day.

I'm dynamically creating a table with rows of 4 different statuses. I'm using an asp:table and adding rows programmatically. Like this (generically)TableCell tc = new TableCell(); tc.Text = "1"; TableRow tr = new TableRow(); tr.Cells.Add(tc); tblMyTable.Rows.Add(tr);What I'm going to write is...

I can set a panels ScrollBars property to Vertical, to show only a vertical scrollbar, and Auto, to show scrollbars (vertical and horizontal) only when necessary. Is there a way to get a panel to scroll vertically, but not horizontally, and only when necessary? Sort of like a combination of...

I can set a panels ScrollBars property to Vertical, to show only a vertical scrollbar, and Auto, to show scrollbars (vertical and horizontal) only when necessary. Is there a way to get a panel to scroll vertically, but not horizontally, and only when necessary? Sort of like a combination of...

OK, I've yet to find a definitive answer as to why style="height:100%" doesn't work on a table inside a cell to fill the height of the entire cell. In fact, everything I read seems to tell me it should. I'm trying to get Table1 and Table2 to be the same height. So here's my code:<table...

Sometimes Multiviews can get confusing in design mode of VS2005 since there's only a thin bar separating each of the views. Is there a way in VS2005 to temporarily hide Views in design mode? Thanks, and have a great day!

Is there a way to get the ClientID of a RadioButton in a RadioButtonList? Or is the ClientID of a radiobutton in a RadioButtonList always the Client ID of the the RadioButtonList + "_" + the RadioButtons index? Thanks for your time, and have a great day!

I've got a page that (though part of an application) is stand-alone in that when a user is finished with the page and submits the information it saves the data, and returns to its original state. It's got 56 radio buttons (in pairs), 31 textboxes, and 5 dropdownlists. When the user is finished...

In all of the web applications I write I make many calls to a SQL database, often in one postback. When I make these calls in multiple functions, they always start the same wayPrivate Function MyFunction() As Boolean Dim sSSQL As String = "" Dim sqlConn As SqlConnection Dim sqlCmd...

Alright, I've got an application with Items and SubItems (generic names). I want a user to be able to be able to select an Item in a dropdownlist, which then without posting back gives them an option to select a SubItem from another dropdownlist. To this point I've been filling the Item...

I'm having the same problem as the user in thread855-1063340, but he seemed to figure his problem out. I'm closing SQLConnections, but when I go to my Microsoft SQL Server, Management, Current Activity, Process Info, the 2 processes I opened are shown with a status of sleeping. I know .Close...

I'm trying to use a case statement to return a specific value.CASE myField WHEN NULL THEN 'FieldIsNull' WHEN 'A' THEN 'AValue' WHEN 'B' THEN 'BValue' ELSE 'NotListed' ENDOf course when myField is NULL I'm getting 'NotListed' because of the inability to compare NULL. Is there a way to do this...

I'm having trouble with "Wrap Text". I have a cell which has "Wrap text" checked in the alignment section of "Format" and most of the time it wraps find and auto-expands the height of the row it is in. But, sometimes it wraps without auto-expanding the row. After messing with it I realize...

I'm trying to change the widths of columns in an ASP:Table but I can't figure out how. I've used the following code. Private Sub FillShiftSchedule() Dim sSQL As String Dim adoxConn As SqlConnection Dim adoxCmd As SqlCommand Dim adoxReader As SqlDataReader Try Dim...

I have a page with a lot of tables and subtables in it. Part of the basic structure is this<TABLE id="tbl1" style="Z-INDEX: 101; LEFT: 8px; POSITION: absolute; TOP: 8px" cellSpacing="0" cellPadding="0" width="100%" border="0"> <TR> <TD id="MyTD1">Stuff1</TD> <TD...