C# Discussion Boards - CodeProject

Re: Add new control from one Form to another Form but how?

16-Nov-08 23:47

hi,

how to add control like button from one Form to another Form at runtime?

i have tried this one :

Form2 objForm2 = new Form2();<br />
           objForm2.Controls.Add(this.button3);

i think button3 add on Form2 with successfully but.......new added control "button3" not shown on Form2 why?

Simon P Stevens16-Nov-08 23:54

Re: Add new control from one Form to another Form but how?

16-Nov-08 23:54

A GUI control can't appear on two forms at the same time.

Just like you can't have the same button appear twice on one form. A GUI control has only 1 visual representation at a time. If you want two buttons you need to create 2 buttons, not try and use the same button twice.

(You can create 2 buttons and attach them both to the same event handlers if you want them to call the same code)

Simon

zeeShan anSari17-Nov-08 0:05

Re: Add new control from one Form to another Form but how?

17-Nov-08 0:05

i used following code:

frmTimetablePopup objfrmTimetablePopup = (frmTimetablePopup)Application.OpenForms["frmTimetablePopup"];<br />
                DataGridView grd = new DataGridView();<br />
                grd.Name = "grd";<br />
                grd.Location = new Point(310, 300);<br />
                grd.Size = new System.Drawing.Size(600, 600);<br />
                DataGridViewTextBoxColumn grdCol = new DataGridViewTextBoxColumn();<br />
                grdCol.HeaderText = "Days";<br />
                grdCol.Name = "Col1";<br />
                grdCol.Width = 50;<br />
                grdCol.DefaultCellStyle.BackColor = Color.CornflowerBlue;<br />
                grd.Columns.Add(grdCol);<br />
                objfrmTimetablePopup.Controls.Add(grd);

but fail ........

Simon P Stevens17-Nov-08 0:14

Re: Add new control from one Form to another Form but how?

17-Nov-08 0:14

You're code works fine for me. You're setting the location to 310,300. Is this off the edge of your form.

grd.Location = new Point(310, 300);

Try setting it to 0,0 instead.

Simon

zeeShan anSari17-Nov-08 0:24

Re: Add new control from one Form to another Form but how?

17-Nov-08 0:24

believe me it's does not work.......
objfrmTimetablePopup.Controls.Add(grd);
after run the above coding.......objfrmTimetablePopup contains the "grd" but where ? i don't know Confused | :confused:

Simon P Stevens17-Nov-08 0:31

Re: Add new control from one Form to another Form but how?

17-Nov-08 0:31

zeeShan anSari wrote:
believe me it's does not work.......

Well the code is fine and it works fine for me, so it is something you are doing wrong somewhere else.

zeeShan anSari wrote:
objfrmTimetablePopup contains the "grd" but where ? i don't know

I just gave you a suggestion:

I wrote:

You're setting the location to 310,300. Is this off the edge of your form. Try setting it to 0,0 instead.

Have you tried that?
Did it work?
What happened?

Simon

zeeShan anSari17-Nov-08 0:52

Re: Add new control from one Form to another Form but how?

17-Nov-08 0:52

i obey your order as
grd.Size = new System.Drawing.Size(0,0);

and i also check foreach (Control ctr in objfrmTimetablePopup.Controls)
{
MessageBox.Show(ctr.Name);
}
than messagebox show "grd" name also...........but grd not shown

zeeShan anSari17-Nov-08 0:59

Dispalying data in word document

17-Nov-08 0:59

i found problem is here

 private void btnRoomT_Click(object sender, EventArgs e)<br />
        {<br />
<br />
            frmTimetablePopup objfrmTimetablePopup = new frmTimetablePopup();<br />
            GUIUtility.CompileRooms();<br />
            objfrmTimetablePopup.ShowDialog();<br />
<br />
        }

if i put this code objfrmTimetablePopup.ShowDialog(); on

GUIUtility.CompileRooms();<br />

method than objfrmTimetablePopup show grid .........

sram1516-Nov-08 23:23

sram15

16-Nov-08 23:23

Hi,

here is my code
protected void btn_Click(object sender, EventArgs e)
{
con = new SqlConnection("user id=mak;pwd=mak;initial catalog=Smskwik;data source=AMEDALA");

da= new SqlDataAdapter("select * from Tbl_Country where Country_Id="+txt_id.Text+"",con);

ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}

here am displaying result in gridview but i want to display this output in word document in a table formatl.
Please help me regarding this.

Thank you

Simon P Stevens16-Nov-08 23:35

16-Nov-08 23:35

You need to read up on how to control word.

Here's some links to get you started.
Understanding the Word Object Model[^]

Visual Studio Tools for Office (VSTO)(home page)[^]

Getting started in VSTO[^]

Simon

sram1517-Nov-08 19:37

sram15

17-Nov-08 19:37

Thank you for reply.
That is for window application.but i need for web application.Actually i dont have much idea about concept.
Please help me regarding this

Thank you.

Simon P Stevens17-Nov-08 21:42

17-Nov-08 21:42

Ok, what I assume you want to do then is create a word document dynamically and allow the user to download it. You will still probably need to use VSTO to create the word document. You will need to have word installed on the server (which by the way I don't think is supported by MS).

Why do you want to make it available as a word document? This ties your users to MS. What if one of your users doesn't have word? You would probably be better going for a more universal document format like PDF. There are plenty of commercial and free PDF libraries available for .net

You need to ask in the asp.net forum for how to go about doing making the created document available for download.

Simon

sivaddrahcir11-Feb-09 8:43

sivaddrahcir

11-Feb-09 8:43

Sorry I know I am late to the thread, but I was just starting to look into document automation related topics on the server side and had some additions to make:

If we are talking about Word 2003 or 2007 documents and working with cached data (from a data source), the ServerDocument class is worth investigating (doesn't require Office on the server):
Accessing Data in Documents on the Server[^]. The how-tos and walkthroughs here all refer to workbooks but I think it applies to Word also.

If we are talking about Office 2007 (or later), then the Open XML format of documents comes into play. Check out the Open XML Format SDK 2.0[^] for more information. Here is an example of how to change the text in a table for a document: http://msdn.microsoft.com/en-us/library/cc850835(office.14).aspx[^].

Blog:
http://windowsclientdevelopment.spaces.live.com
FAQs:
http://windowspresentationfoundation.wikispaces.com
http://windowsmobile.wikispaces.com
http://vsto.wikispaces.com

Max Value

Zeyad Jalil16-Nov-08 22:34

Zeyad Jalil

16-Nov-08 22:34

Hi All,,

I want to get a Max value from a table and increment it by 1,, such as

if the max value is 1/50, It will be 2/50, but the problem how to get it from a db.

thanks all,,

Simon P Stevens16-Nov-08 22:51

16-Nov-08 22:51

You can use the SQL keyword MAX

SELECT     MAX(ColumnName) AS ExpressionName
FROM         TableName

Simon

Zeyad Jalil16-Nov-08 22:56

Zeyad Jalil

16-Nov-08 22:56

but it is a string and when get the max return the wrong max;;

I have a 2 value in a databas

9/50
10/50

when get the max return 9/50, but it is a wrong max,,,
I want way to return 10/50 ,

Simon P Stevens16-Nov-08 23:22

16-Nov-08 23:22

Ahh. Well that's because as a string "9/50" comes after "10/50" because when you interpret it as a string, "9" is higher than "1".

I don't think there is an easy way of doing this in SQL.

Personally, I think your data type is wrong. If it's a numeric value you should be using some form of numeric data type, not a string.

If you can't change the data type, then it could be rather tricky. You would have to write a function that first split the string at the '/' sign and extracted the first half (This could be done with CHARINDEX[^] and SUBSTRING[^]. Possibly something like this: SUBSTRING(ColumnName, 0, CHARINDEX('/', ColumnName)), then converted the string to a number (Possibly using CAST or CONVERT[^]). Then you could return the MAX value of this function.

SELECT     MAX(CAST(SUBSTRING(ColumnName, 0, CHARINDEX('/', ColumnName)) AS Integer)) AS ExpressionName
FROM         TableName

It's not quick though. I tested it on a table with only 10 rows in it, and it's quite slow. If you've got any significant amount of data to process it will take a long time.

Consider adding an extra Integer column to the table to store just the numeric component. This can then be pre set when the row is created or changed, so when you need to read the data you don't have to calculate it every time.

Simon

Last row insrted into database?

HosamAly17-Nov-08 2:56

HosamAly

17-Nov-08 2:56

If you could, I'd suggest updating your existing data to make it all two-digits (or even three). For example:

UPDATE YourTable
   SET YourField = '0'+YourField
 WHERE LENGTH(YourField) = 4;

Of course, this wouldn't work if you have single-digit numbers after the slash. In that case, you'll need to modify the condition of the update (and you'll probably want to update the numbers after the slash too).

Once done, your MAX statement will give you correct output.

By the way, such questions are more suitable to the "SQL and Database" message board.

My LinkedIn Profile

Zeyad Jalil16-Nov-08 22:13

Zeyad Jalil

16-Nov-08 22:13

hi all,,,

I want to Know what is the last row inserted into a table in a database.

I use "select last_insertd_row from last_insrted_rows where table_nam=:t_name"

but i have a problem,, please help me.

thanks all

Re: Last row insrted into database?

Simon P Stevens16-Nov-08 23:02

Re: Last row insrted into database?

16-Nov-08 23:02

zead wrote:
I use "select last_insertd_row from last_insrted_rows where table_nam=:t_name"

I don't know where you got this from but it is garbage.

SQL server doesn't store this kind of information. You need to track the inserted rows yourself.

Try reading these articles:
http://sqlserver2000.databases.aspfaq.com/can-sql-server-tell-me-which-row-was-inserted-most-recently.html[^]

http://databases.aspfaq.com/general/how-do-i-get-the-identity/autonumber-value-for-the-row-i-inserted.html[^]

http://blog.sqlauthority.com/2007/03/25/sql-server-identity-vs-scope_identity-vs-ident_current-retrieve-last-inserted-identity-of-record/[^]

Also, You'll probably get better responses if you ask in the SQL forum[^].

Simon

Samer Aburabie17-Nov-08 11:13

Samer Aburabie

17-Nov-08 11:13

Hi ...
Usually you mark the records in a table with an incremented sequence field or a time stamp field(including hh:mm:ss) this way you can easly get the last inserted record ...

Hope that helped ...

Sincerely Samer Abu Rabie

Note: Please remember to rate this post to help others whom reading it.

DataGridView....

zeeShan anSari16-Nov-08 21:38