Re: Difference B/w 3 types of Lines. - C# Discussion Boards

Hello,
I'm working on Windows application c#
i have form1 which contain data gridview to view the content of table from sql database.
i've enabled edit, delete in the gridview, and then i've added two queries one for update and the other for delete through MyDataSet1.xsd page.
now after updating and/or deleting any record i wanna click on a button to confirm user that the operation done. but i don't know how to save updating or deleting!!

any help guys?

You can use DataSet by these step

1) Fill the table in DataSet from SqlDataAdapter.

2) Assign DataSource to dataSet. DefaultViewManager

E.g: dgv.DataSource = ds.DefaultViewManager

3) GetChanges
DataSet dsMyChanges = ds.GetChanges();

-Binh

could you please give me an example? coz i didn't get the idea

I don't have time to write full example to you. I extracted some code in my project. Hope that you can get my point. If you have questions, add my skype nick: binh_vu54321
1) Fill the table in DataSet from SqlDataAdapter.
private DataTable dtGetMPNs = new DataTable();
private DataSet dsGetMPNs = new DataSet();

if(dsGetMPNs.Tables.Contains("GetMPNs"))
dsGetMPNs.Tables["GetMPNs"].Clear();
daGetMPNs.Fill(dsGetMPNs,"GetMPNs");

2) Assign DataSource to dataSet. DefaultViewManager
dgvMPNs.DataSource = dsGetMPNs.DefaultViewManager;
dgvMPNs.DataSource = dsGetMPNs.Tables["GetMPNs"];

3) GetChanges
In Save change functions
DataSet dsMyChanges = dsGetMPNs.GetChanges();
if (dsMyChanges != null)
{
for (int i = 0; i < dsMyChanges.Tables["GetMPNs"].Rows.Count; i++)
{

}
}

Hi..
i have to draw three types of lines
- Constant Line
- Linear Line
- Quadratic Line.
Whats the difference between these three types of line.

i have draw the simple line by doing this.

OnPaint()<br />
{<br />
     Graphics g;<br />
     g = this.CreateGraphics();<br />
     g.DrawLine(Pens.Red, 10,10,30,30);<br />
 }

If sumone know plz reply..

I just spent ages working this out: GOOGLE.
Try typing "Constant line" into the search box - oh, look, "constant line graph" could that be one?
Then try "Linear line" - my, it's clever this, "linear line grapH" is a sugestion!
Perhaps "Quadratic line" - WOW! That was soooooo difficult! OMG | :OMG:

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

"Rumour has it that if you play Microsoft CDs backwards you will hear Satanic messages.Worse still, is that if you play them forwards they will install Windows"

I think they're not three kinds of lines. They are three expression for graph. Constant line is a point , linear line is a straight line, and quadratic line is a parabol.

well ok.. u mean that if user wana draw the linear line it will be a straight line and if the user wana draw a constant line it will be only a point and nothing else? is it? and the third one that is parabola..and it means that in which ever direction the mouse is moved it should draw parabola..?? will u plz tell em i right or not?
Actualy sumone told me this..

constant — This distribution will place an equal amount of paint at each pixel within the airbrush’s radius.

linear — This distribution will place a linearly decreasing amount of paint at each pixel as you move away from the center point. So at the center point, you will have full intensity of paint, whereas at radius pixels away from the center, no paint will be put on the canvas.

quadratic — This distribution will place a quadratically decreasing amount of paint at each pixel as you move away from the center point (i.e., the amount of paint used as you move away from the center decreases with the square of the distance). So, as with the linear distribution, the center point will have full paint intensity, whereas at radius pixels away from the center, almost no paint will be put on the canvas. There can be multiple ways to write the quadratic distribution. (Note: Your quadratic function should at least satisfy the property that when the distance x from the center of the circle is zero, the value of your function is "1", when the distance x is halfway to the radius, the value of your function is "1/4", and when the distance x is greater than or equal to the radius of your brush, the value of your function should be zero.)

i realy dnt understand these three points especially the last one..like how will decrease the intensity of the color..?? what i know is that v have a pen and assign sum color to it. like
Pen myPen = new Pen(Color.Red);
then how i will decrease the intensity of this color..??

Sorry, maybe I'm wrong because I just guest that. Actually, I cann't search any article about that. So sorry

All painting should be handled by the Paint handler, which has a PainEventArgs parameter, yielding a ready made Graphics. Creating your own Graphics does not make sense as it is expenive, slow, and needs a Dispose() call.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

sory it was not in OnPaint() i just type the code and write it by mistake. its in MouseMove(). so thats y i create the graphics object in that function thats all.. but my question is still there.. actually i have to make a program in which user can draw linear line, constant line and quadratic line on mouse movement by clicking right or left buttons.. i dnt exactly know the difference between them..

Hi All,

I have to write a code for refreshing multiple databases at a time. The steps which it has to perform for refreshing databases are :

1. Source Server database backup.
2. Target Server database backup.
3. Capture user information.
3. Terminate active DB user .
4. Restore Database on target.
5. Drop existing user.
6. Re-create users.
7. Map users to the logins.

Can i write a stored procedure in c # itself to make this happen? If yes, please let me know how.

Thanks,
Vikas

vikas da

Are you talking about taking a backup of the database ?

Everything you specified is possible in stored procs ... Just to clarify, if you have Source and Target databases in the same instance of SQL server.

Create statements to in a single batch and make a stored procedure. Compile that in Master and access each database from there .
Big Grin | :-D

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

You can write store procedure in C# with Managed Code and after that you have to deploy dll to server

If you want to use CLR stored procedure, I have already wrote few for you. Check out these articles :

Working with CLR Objects in SQL Server 2005 or Higher: Part I[^]

Working with CLR Objects in SQL Server 2005 or Above Part 2[^]

I think from here you will find what is required to do. Cool | :cool:

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Thanks everybody ... I will try to implement with stored proc .. Smile | :)

Have a nice time ...

vikas da

hi dudes,
i want to copy a table from an access database to another table on another access database in windows application using c#,what is the best solution,i dont want my application to hang while copying the data;i've tried reading record by record by a simple oledbcommand execute way,but it would take a long time,i have a lot of records in source database,how can i do the copy by using dataset?is using dataset the best solution? how? how can i relate a progress bar to that? i've seen a class named sqlbulk which works for sql databases that copies a large amount of data between tables or databases,but my database is access.i will be thankful for those who do me a favor and give me an answer.

Don't use DataSet. Work with a reader and iterate all the rows and insert into target database. Do this in a separate thread, so that your application won't hang.

Best wishes,
Navaneeth

Just to add to this, use a progress bar as well, so that the user can tell the app is still working. (Always use a progress bar if the app is going to do anything that takes over two seconds is a good general rule).

Nothing will speed the process up noticably, particularly if the two databases are on separate machines.

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

"Rumour has it that if you play Microsoft CDs backwards you will hear Satanic messages.Worse still, is that if you play them forwards they will install Windows"

thank u both of my friends for ur answer,both of the answered gave me a pointer,but how can i relate copying data to a progress bar?

I need some help with a project im making it is pretty much a file archive system. It has the files in a single text file the file data is enclosed inside a head and a foot to identify it. which looks like this:

##:START:(FILENAME):(FILEDESTINATION):(FILESIZE):##
<CONTENT OF FILE HERE>
##:END--:(FILENAME):(FILEDESTINATION):(FILESIZE):##

the unpacker looks through the files and reads that data between the head and the foot and writes it into the destination directory it works for plain text files fine but when it comes to Executables the extracted file doesnt run and it has no icon anymore. Im using Encoding.Default to read and write all the data. Is there something im missing i think its possibly that the Encoding isn't quite right. When i open the exe in notepad and click save as it says its ANSI but that doesnt exist as a encoding type in Encoding.* would this be the problem?

fuze wrote:
Im using Encoding.Default to read and write all the data.

Then you're not using the proper file methods to reading and writing binary data. You're treating everything as a text file, even the executables. You should be using the Binary Reader/Writer.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

hi
i have wcf service host
and i keep all my clients callback in a list
is it possible to send this call back to one client so he will use the other client callback function

I want to know a serious problem: in my searches about storing data I find that I can store it in : XML Schema, or databases: SQLite, or any other db etc.
I want to store some int 's into a XMLS to be able to use them after I restarted the app.
My actual problem is: It is possible to store inside the actual app?
I don't want to store outside that app,in some sort of file.
thx.

OR a better question: How to store some data INSIDE running app, and then after restarting that app, the data remain there and be accessible ?