Comments by Deepak_Sharma_

Deepak_Sharma_ 15-Oct-13 2:02am View

Dispose SqlDataAdapter object after use. Put it inside using block:

using(daobj = new SqlDataAdapter(cmdobj))
{
daobj.Fill(dt);
}

Deepak_Sharma_ 16-Feb-13 1:50am View

One should always refer to the documentation provided by the payment gateway API they are using like https://developer.paypal.com/ for PayPal

Deepak_Sharma_ 8-Sep-12 3:00am View

Why are you storing connection string in a text file instead of app.config. Which is more secure and manageable.

Deepak_Sharma_ 7-Sep-12 9:09am View

Ya, you can assign ID to the Button using its btnSubmit.Name property but it should work even without it

Deepak_Sharma_ 8-Aug-12 15:28pm View

Hi, how can we increase this limit ?

Deepak_Sharma_ 7-Jun-12 4:35am View

other sites are working fine.. thus port 80 is configured properly

Deepak_Sharma_ 29-May-12 7:14am View

Put a breakpoint on foreach () line and see step by step if strTreeValue contains a value

Deepak_Sharma_ 28-May-12 6:15am View

Are you getting any error?

Deepak_Sharma_ 23-May-12 4:27am View

What is the error you are getting. Please explain it. Click on Improve question and improve your question

Deepak_Sharma_ 23-May-12 1:29am View

Hi,
Its opening in my browser.
Try opening it by typing the url

Deepak_Sharma_ 16-May-12 7:06am View

Its a good answer!

Deepak_Sharma_ 10-May-12 2:37am View

Go to last url above and in the refresh() function try to put your logic to refresh page in your preferred time

Deepak_Sharma_ 10-May-12 2:11am View

Subject of this question is saying opposite of what you have written in the description.
What you want?
SQL Server to MS Access OR MS Access to SQL Server

Deepak_Sharma_ 9-May-12 8:33am View

Not clear what you want!

Deepak_Sharma_ 9-May-12 8:13am View

Yes, it will create folder inside installation folder at any path selected by the user. Like if you added folder named "NewFolder", it will be created in C:/MySetup/NewFolder

Deepak_Sharma_ 27-Apr-12 6:32am View

Hi,
In the first link you will find tile image on the home page for article listing.
Here is a site that has a Tile interface
http://india.msteched.com
You can go through it.

Deepak_Sharma_ 27-Apr-12 2:08am View

Thanks for sharing. I will try to be there!

Deepak_Sharma_ 27-Apr-12 2:05am View

No, what's that?

Deepak_Sharma_ 27-Apr-12 1:50am View

Thanks!

Deepak_Sharma_ 27-Apr-12 1:32am View

Have you set Mask property of the MaskedTextBox?

Deepak_Sharma_ 26-Apr-12 13:35pm View

Do you want to import bookmarks from Google Chrome?

Deepak_Sharma_ 26-Apr-12 8:44am View

What is the error you are getting in the code?

Deepak_Sharma_ 26-Apr-12 5:15am View

You should click on the green button "Accept Solution" if it helped you

Deepak_Sharma_ 26-Apr-12 4:58am View

You can use SqlCommand.ExecuteScalar():

string constring = ConfigurationManager.ConnectionStrings["ConString2"].ToString();
SqlConnection connection = new SqlConnection(constring);
SqlCommand cmd = new SqlCommand("SELECT ServerProperty('edition') AS 'SQL Server Instance'", connection);
connection.Open();
string InstanceName = string.Empty;
if (cmd.ExecuteScalar() != null)
{
InstanceName = cmd.ExecuteScalar().ToString();
}
connection.Close();

Deepak_Sharma_ 26-Apr-12 1:52am View

Hi,

If you have more than one SQL Server instances installed on your machine, you have to decide on which instance you want to log in. Like if you have two instances one for SQL Express 2005 and one for SQL Express 2008 you have to decide which one you want to use.

It is possible to use IP address but still you have to give the instance name you want to log in like "127.0.0.1\\SQLEXPRESS1"

Deepak_Sharma_ 25-Apr-12 4:23am View

There is no Windows Login Control, above solution is about using ASP.NET Login control

Deepak_Sharma_ 22-Apr-12 14:33pm View

Hi,
I have updated the answer hava a look.

Deepak_Sharma_ 20-Apr-12 2:03am View

Its a Windows application or Web application

Deepak_Sharma_ 19-Apr-12 3:09am View

Four or more words or letters?

Deepak_Sharma_ 18-Apr-12 6:44am View

Then you have to store this information either in the database or in a text file.

One more thing why not you store these information in App.Config file. Store your connection string in <connectionstrings> and other settings in <appsettings>

Deepak_Sharma_ 17-Apr-12 8:03am View

Yes because you have to apply your own logic for what you want to extract from the text. Like "Product ID" will start where this heading "------" ends.

Deepak_Sharma_ 16-Apr-12 6:29am View

The simplest way to create a CSS class is to define it inside head tag like :

<style type="text/css">
.GridStyle
{
background-color:Teal;
}
</style>

Now you can use CssClass="GridStyle" in your GridView

Comments by Deepak_Sharma_ (Top 32 by date)