Search results for query: *

My xsd: <xs:element name="UDAS"> <xs:complexType> <xs:sequence> <xs:element minOccurs="2" maxOccurs="unbounded" name="UDA"> <xs:complexType> <xs:sequence>...

I want to add java script function. The following code works - if I put that on page load event. If I put the same code in Button_click event - the message does not pop up. Page.ClientScript.RegisterClientScriptBlock(Me.GetType(), "myAlert", "alert('Record added');", True) If this helps, I...

I am getting ' Missing parameter value' error. I will appreciate any guidance / help to fix this error. My code: Private Sub setParameters() ' Create report instance. This is the class added to your project ' when you added the report to the project Dim report As New...

I am getting warnings when I am compiling my package: Warning(70,17): PLW-07204: conversion away from column type may result in sub-optimal query plan. The errors are on these lines: sysdate >= (oh.latest_ship_date+70) and sysdate <= (oh.latest_ship_date+120) How can I fix these?. Thanks in...

I have a drop down box with none, name, email,phone. If the user clicks Email, it should show label enter email and text box to enter email with validator. Same thing with Phone or name. I have never done this in ASP.net. Any suggestions will be appreciated.

I am asked to create confidential fraud complaint form which will show unique identifier number on the form. How do I create this on page load event. This is the first time I am assigned a project like this. Any help, is appreciated.

I have two list views which has scroll bars. I want to sync the two list views so that when one list view's scroll bar is used (to scroll), it scrolls the other list view as well so that they are in sync. Any idea how to acheive this in VB.net

I have a table with following columns: Item, Unit_Price, List_price, Start_date, End_date, Int_ind. In my query – I have to show Current month sale. (The difference between start and end date should be 15 or more days) In another query – I have to show next month sale. (The difference between...

Need to upload data from excel/csv file into SQL Server database using VB.net. Any ideas how this can be done? Any help would be appreciated?

I am trying to store the result of this query: Select Max(Cookie_ID) From CookieLeadSource into a variable in VB. Any ideas on how to do this?

I am looking to display items in a list view to be display sequentially. ABC DEF GHI Currently, it display the values like: ABC DEF GHI How can I do this?

Hi, I am new to VB.net and I am trying to create a stand-alone VB.net application. Right now, I am trying to achieve this: I created a list box. Based on value chosen from the list box, another list box needs to be populated (i have the database set up in sql server) Any suggestions on how...

Hi, I want to create a computed column which concatenates other int column values. Ex. The table has these columns: ID int (computed Column), ContentTypeID int, MatchTypeID int If the values for ContentTypeID, MatchTypeID are: ContentTypeID, MatchTypeID 1 2 Then ID column...

I have this requirement: Page Page No: AccountType 1 PrimaryPersonalInfoAddress 2 PrimaryPersonalInfoIdentification 3 PrimaryPersonalInfoEmployment 4 FinancialInfoPersonalW8/W9 5 FinancialInfoPersonalTrading...

Hi, I have a table which is as follows: Month, Description, Language, Total 2009-01, Median Deposit, English, 2081.16 2009-01, Average Deposits, English, 191996.25 2009-01, Subsequent Deposits, Chinese, 2000 and so on for every month I want to assign a unique value to each month...

I want to insert into a temp table on My-SQL db from SQL server db. Any idea on how to do it? I tried the following but I get a syntax error. INSERT INTO OPENQUERY(MetaQuotes, 'SELECT cAccount FROM MetaQuotes_VelocityLive.#A') select cAccount From #A1 Where dLastLogon = '01/01/1900'

I want to get the day as 2 digits. For example if I do this: Select day(getdate()) It returns 1 Whereas I want it to return 01 Any idea on how can this be done. Thanks in advance!

Hi, I am not sure on the syntax of using table alias with NoLock condition. The query I tried is as follows: Select U.Login, EMAIL From MetaQuotes_VelocityDemo.mt4_users NoLock AS U LEFT JOIN MetaQuotes_VelocityDemo.mt4_Trades NoLock AS T ON (U.Login = T.Login) I even tried this: Select...

The columns that I am interested in a table are: Deal_No. Deal_Date If I have to count the Deal_No. for every min(In Deal_Date), how can this be done?

Hi, I have a date time field in a table, and based on this field, I want to get the data for the last 5 hours. Any idea on how to accomplish this? Any help would be appreciated. Thanks!