Search:

Hi,

Here is the stored procedure (MSSQL 2005)


create procedure [dbo].[NotWorking] (@wellchemlist_xml ntext)
as

create table #selwell (well_id int)
-- Load parameter into an XML document

Hi,

I would like to have access to the importNode() method of the XML dom, which is only available with MSXML 6.0 and IXMLDOMDocument3.

If I create an XML DOM object using


var dom1 = new...

Thanks olivthill2, but this will not work because SPECIAL_CODE is a column of LOOKUP_VALUES and not PERSON.

Hi all:



UPDATE PERSON SET HISPANIC_FLAG =
(
SELECT CASE WHEN SPECIAL_CODE = 'H' THEN 'Y' ELSE 'N' END
FROM PERSON PER
LEFT JOIN LOOKUP_VALUES VAL ON (PER.ETHNIC_CODE =...

foreach (ListViewItem item in listView1)
{
MessageBox.Show(item.Text);
foreach (ListViewSubItem subitem in item.SubItems)
{
MessageBox.Show(subitem.Text);
}
}

Try using the Tag property

http://msdn2.microsoft.com/en-us/library/system.windows.forms.treenode.tag.aspx

TreeNode.Tag Property
Gets or sets the object that contains data about the tree...

Use the ViewState to store objects between postback e.g.

public MyClass SomeProperty
{
get { return ViewState["SomeProperty"] as MyClass; }
set { ViewState["SomeProperty"] = value; }
}

1.how do i control the position of a control inside a cell ?

For a table cell use valign for vertical alignment, align for horizontal alignment. For valign the values can be...

What about the 2nd case though, where 2 different functions are called when I close the window?



window.onunload = unloadFunc;
top.window.onunload = unloadFunc2;


In IE7, both of them...

Hi,

I was testing some code in IE7 with framesets and got a strange bug. If you only have one window open and do the following,



window.onunload = unloadFunc;
top.window.onunload =...

Hi,

I am trying to make my ASP.NET pages compliant with the W3C standards. Some of the pages have lists of items which can be initially empty. I am using asp:ListBox, which renders as a <SELECT>....

Hi, I'm trying to make a custom server control that has a collection property called Items with the tag being <Items>. This is similar to <Columns> in asp:DataGrid. I am using visual studio 2005.
...

Hi,

I have an application that has 2 navigation menus that can be shown or hidden when buttons are clicked. Each menu is in a separate frame in a frameset document. If one menu is shown and the...

Can someone help me out with this quickly pls.
i have this code but it gives the error on this line

Private Sub CustomValidator1_ServerValidate(ByVal _
source As System.Object, ByVal args As _...

Hi,

I have a process that copies about 2,000,000 records from a non-relational database and inserts them into a relational database. This means I have to generate PK ids for many of the records...

SQLCompare

http://www.red-gate.com/products/SQL_Compare/index.htm

I am having a forms authentication login problem on a website. The authentication cookie seems to expire very quickly although I have told it to be a persistent cookie by giving the setting the 2nd...

Hi, I have a question

Is there any way, using the Session object, w/o checking any of the keys, to tell if the timeout has expired?

e.g. How do they do things like if you click on a button and...

<asp:datagrid id="dgResults" runat="server" CssClass="ControlText" Width="95%" SortCommand="dgResults_Sort" AllowSorting="True"></asp:datagrid>

Public Sub dgResults_Sort(ByVal sender As...

Are you using Server.MapPath("mypdf.pdf");

You can dynamically add attributes in Page_Load and then it should apply the styles to Firefox and Netscape.



private void Page_Load(object sender, System.EventArgs e)
{
// Add a style...

Are you calling FormsAuthentication.Logout on your 'Logout' button?

SELECT * FROM orders o
inner join Customers c
on o.custID = c.custID
where c.custName = selectedname

When you load an assembly using Assembly.LoadFrom how do you free it from memory when you are done? Is this done by the GC or is there an explicit method that will do this?

Well looks like this helps. Call Save() instead of WriteXml()

Pathetic!!!!



public void Save()
{
string projxml = proj.GetXml();
string replaceStr = "", leftStr = "", rightStr =...