16,012,223 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Dave Paras (Top 38 by date)
Dave Paras
7-Jun-12 7:23am
View
Yes, I have read both above link. None of it contains solution for above question.
Please read question carefully, "It can be done by creating Constraint, but is it possible to set Cascade on without drop or recreating foreign key constraint in SQL Server 2008."
I don't want to drop constraint.
Constraints are already there in database, but now i need to Update only "Update Rule" need to set "Cascade"
Dave Paras
17-Apr-12 3:10am
View
Thanks atul for response with code.
Now I'm out of that functionality :)
Dave Paras
20-Dec-11 6:02am
View
Thanks Pramod for mark as answer! :)
Dave Paras
20-Dec-11 5:44am
View
Hi dalak,
Thanks for your time and suggestion.
But it is required to do.
If you have any example using third party tools then please provide it.
Thanks Again.
Dave Paras
6-May-11 2:37am
View
Solution 2 and 3 has been deleted as Table and TR is automatically added.
Dave Paras
22-Apr-11 7:58am
View
Need to convert single column in multiple column.
First Select statement return SIX rows each with single column.
But i want output in
N
Columns. i.e. 2 columns and 3 rows. or 3 columns and 2 rows.
Is it clear?
Dave Paras
22-Apr-11 7:56am
View
What I want is, pass Comma separated string from front hand to back hand(sql server). back hand will convert Comma separated value in to table. That table will directly used to insert data in other table.
All this things is need for save trip from back hand to front hand and vice a versa.
Dave Paras
22-Apr-11 7:44am
View
Yeah I know.
But main prob is that how to create dynamic columns.
Functionality provided in link has already been achieved.
Thanks for ans.
Dave Paras
22-Apr-11 7:19am
View
Output in Single column has been already achieved.
Can you please provide function that can convert at least for 2 columns.
Thanks for your time and answer.
Dave Paras
11-Apr-11 0:22am
View
Can you please provide me code for the scenario you use. (let the user choose to save once he has loaded it to his browser)
I am doing this thing first time. So i don't have much idea of this. I know we can easily do this thing using anchor tag. But we want to use anchor.
Dave Paras
14-Mar-11 8:15am
View
What happens is that, Employee Number is split in to two row! :(
and same way for Employee Name.
I dont want to do that,
label must not be split into multiple row
Dave Paras
9-Mar-11 6:35am
View
Hi Pasan,
But its requirement not to create additional column of Id.
Other reason is that database huge containing more than hundreads of tables, so this change take much time and its not affordable.
So in this context, if you will provide me any solution then it will be really helpful to me.
By the way Thanks for reply.
Dave Paras
27-Feb-11 23:46pm
View
Nice and Sufficient information.
Dave Paras
25-Feb-11 7:30am
View
Add WHERE clause to apply filter.
See below posted answer posted by
Dave Parth
Dave Paras
25-Feb-11 2:25am
View
Thanks for vote mkgoud..
Dave Paras
25-Feb-11 1:52am
View
Currently working on other things.. :)
Dave Paras
24-Feb-11 12:12pm
View
Deleted
Thanks Keith for positive response.
Dave Paras
24-Feb-11 12:06pm
View
Deleted
Keith, Thanks for positive response.
Dave Paras
24-Feb-11 12:05pm
View
Deleted
Thanks for positive response...
Dave Paras
23-Feb-11 23:23pm
View
Thanks Dave
Dave Paras
23-Feb-11 5:15am
View
Thanks Olivier!
Dave Paras
23-Feb-11 5:12am
View
Thanks for your help ..
As soon as I'll got solution, I'll post it.
Dave Paras
23-Feb-11 4:39am
View
:(
Hope So
Dave Paras
23-Feb-11 4:24am
View
First of all thanks for your response.
I have check all three links.
First and last link contains thread that has been start when application start. (Global Level)
But what I want is, Thread should start on click of control, not at application level.
Second link contains window base application.
I have already test thread in window application.
It works fine.
By the way, Thanks for your time...
Dave Paras
23-Feb-11 4:15am
View
As per as my knowledge concern,
This thing can be implement in Window application..
Dave Paras
23-Feb-11 4:14am
View
Can you please tell me using normal application..
Dave Paras
23-Feb-11 4:11am
View
protected void LoadGrid1_Click(object sender, EventArgs e)
{
//Fetch the records by executing query
DataTable dtResult = database.FetchDataTable("Select * from TableName");
//Assign fetched result to Gridview
gv1.DataSource = dtResult;
gv1.DataBind();
}
protected void LoadGrid2_Click(object sender, EventArgs e)
{
//Fetch the records by executing query
DataTable dtResult = database.FetchDataTable("Select * from TableName");
//Assign fetched result to Gridview
gv2.DataSource = dtResult;
gv2.DataBind();
}
Dave Paras
23-Feb-11 4:08am
View
What's happening exactly when you click the button to load data? Is is hanging till the thread finishes
Same thing happen.
- Check that you are not accessing any UI components from the DoWork method.
In do work I'm just inserting record in Database. No more other then this.
Dave Paras
23-Feb-11 3:51am
View
Do you mean constructor as page_load method?
Its web application.
I cant found constructor! :(
So if you mean of constructor by something else, please let me know where I have to initializes it?
Thanks for your time...
Dave Paras
23-Feb-11 3:30am
View
LIKE THESE ???
It will not call DoWork Method, when workerLocal.RunWorkerAsync() executes... :(
----------------------------------------------------------------
BackgroundWorker workerLocal = new System.ComponentModel.BackgroundWorker();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
workerLocal.DoWork += new DoWorkEventHandler(DoWork);
workerLocal.WorkerReportsProgress = false;
workerLocal.WorkerSupportsCancellation = true;
workerLocal.RunWorkerCompleted += new RunWorkerCompletedEventHandler(WorkerCompleted);
}
}
protected void btnStartThread_Click(object sender, EventArgs e)
{
// Calling the DoWork Method Asynchronously
workerLocal.RunWorkerAsync();
}
Dave Paras
20-Feb-11 23:56pm
View
Deleted
Something different than other.. :)
Dave Paras
20-Feb-11 23:55pm
View
Deleted
Something different than other.. :)
Dave Paras
1-Nov-10 10:57am
View
Please post it in English.
Dave Paras
18-Oct-10 2:14am
View
Please ACCEPT this as ANSWER, as it works.
Thanks.
Dave Paras
14-Oct-10 0:36am
View
Alternate to above solution without using variable.
private void txtAmt_TextChanged(object sender, EventArgs e)
{
txtNewSalary.Text = Convert.ToString((txtAmt.Text.Trim() != "" ? Convert.ToDouble(txtAmt.Text) : 0) + (txtOldSalary.Text.Trim() != "" ? Convert.ToDouble(txtOldSalary.Text) : 0));
}
Dave Paras
14-Oct-10 0:31am
View
Here is TextChange event
------------------------
private void txtAmt_TextChanged(object sender, EventArgs e)
{
Double news;
/*(txtAmt.Text.Trim() != "" ? Convert.ToDouble(txtAmt.Text) : 0)
check if OldSalary and txtAmt is not blank, if is it so convert to double else return 0
initially Convert.ToDouble raise error when txtOldsalary does not contain anything, to avoid this use ternary operator.*/
news = (txtAmt.Text.Trim() != "" ? Convert.ToDouble(txtAmt.Text) : 0) + (txtOldSalary.Text.Trim() != "" ? Convert.ToDouble(txtOldSalary.Text) : 0);
txtNewSalary.Text = news.ToString();
}
Dave Paras
13-Oct-10 0:37am
View
steps
----
1. Add three textboxes and button in your form.
2. on button click event paste following code.
---
Double news;
news = Convert.ToDouble(txtAmt.Text) + Convert.ToDouble(txtOldSalary.Text);
txtNewSalary.Text = news.ToString();
---
3. Run program. (F5)
4. Enter 10 in txtAmt textbox
5. Enter 23 in txtOldSalary textbox
6. Click button
7. You'll get result in txtNewSalary textbox, sum of 10 and 23 (33).
Dave Paras
12-Oct-10 9:08am
View
Can you provide sample data you are using in txtAmt and txtOldSalary textbox
Show More