rishabh - Page 2 - Developer IT

Can Anyone explain why NULL is used in this query?

- by Rishabh Ohri

Also what will be the scenarios where this query is used select * from TableA where exists (select null from TableB where TableB.Col1=TableA.Col1)

how to calculate total days from starting date to end date in c#,.net?

i m making a project in which i have to calculate total number of days from starting date to ending date which are inserted in text box by user at run time in asp.net c#.i have to do this on button_click event.how to do this? i tried this- protected void TextBox14_TextChanged(object sender, EventArgs e) { // get date from first text box DateTime dold = Convert.ToDateTime(TextBox1.Text); DateTime dnew = Convert.ToDateTime(TextBox14.Text); TimeSpan daydif = (dnew - dold); double dayd = daydif.TotalDays; Label27.Text = dayd.ToString(); }

Read the article

how to get external variable value in dtsx package.

- by Rishabh

Hi, I am executing .dtsx package from c#, it was executing fine, if i am passing one variable value from c# code then how can i get it on .dtsx package for my ole db source query. Here is my c# code. string file = @"D:\CYNCZFuzzy\CYNCZFuzzy\Contact.dtsx"; package = app.LoadPackage(file, null); Variables vars = package.Variables; vars["User::parentContactID"].Value = 1028203; pkgResults = package.Execute(); string result = pkgResults.ToString(); I need this 1028203 value on my ole db source query, here my query. select cr.MasterContactID as ParentContactID, c.ID,C.FirstName, C.MiddleName, c.LastName, c.ID as FieldID from Contact c inner join ContactRelation cr on cr.SlaveContactID = c.ID where RelationshipID = 1 AND cr.MasterContactID = ? what I should write on ? for getting 1028203 value from c# page. Thanks in advance...

Read the article

how to connect j2me application with gtalk

- by Rishabh

Hi, I have created a login page on mobile. after login with google username and password, i want connect it with g-talk. I need to see my all gtalk contacts on mobile application. How I authenticate and get contacts here, Is there any web service url for user authentication ? Please help me!

Read the article

Taking backup of data in a table.

- by Rishabh Ohri

Hi All, Is there some way to backup the data in a table in sql server by using sql scripts. Note: I dont want to take the backup of the whole database. And later on restore the same data back in case of any failure. Please suggest some solution.

Read the article

Javascript error in Setting focus to a textbox inside a lightbox(Overlay) window.

- by Rishabh Ohri

Hi All, I have a textbox, a button and a "AdvancedSearch" link on my aspx page. On page load, the focus is set to the textbox. On click of the "AdvancedSearch" link, a lightbox(overlay) window will be opened. I want to set focus to a textbox present within this lightbox window. I am using javascript to achieve this. The code looks somewhat like this: if( element.type != "hidden" && element.style.display != "none" && !element.disabled ) { element.focus(); return; } when the lightbox window loads, i get a javascript error - "Can't move focus to the control because it is invisible, not enabled, or of a type that does not accept the focus" Any idea why this error is thrown and why it is not able to set focus to the textbox in the lightbox window? Thanks, Rishab.

Read the article

Can anyone explain me about this SQL Query

- by Rishabh Ohri

Select Null as Empty from (select * from TblMetaData)

Read the article

Getting Build Errors in Program to Change Button Name When Clicked

- by Rishabh

Imports System Imports System.Windows.Forms Class MyButtonClass Inherits Form Private mrButton As Button Public Sub MyButtonClass() mrButton = New Button() mrButton.Text = "Click me " mrButton.Click += New System.EventHandler(MyButtonClickEventHandler) Me.Controls.Add(mrButton) End Sub Shared Sub Main() Application.Run(New MyButtonClass()) End Sub Private Sub MyButtonClickEventHandler(ByVal sender As Object, ByVal e As EventArgs) mrButton.Text = "You clicked me!" End Sub End Class

Read the article

How to give "Share with" option while opening documents in iphone mail

- by rishabh

So I've been going through the "Document Interaction Programming Topics for iOS". I've been able to achieve the "Open with myapp" option through Mail, was wondering how can I change the option to "Share with myapp" depending upon the file types specified? This is what I've tried: <key>CFBundleDocumentTypes</key> <array> <dict> <key>CFBundleTypeName</key> <string>Document</string> <key>LSHandlerRank</key> <string>Alternate</string> <key>CFBundleTypeRole</key> <string>Owner</string> <key>LSItemContentTypes</key> <array> <string>public.data</string> </array> </dict> </array>

Developer IT