|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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 .........
|
|
|
|
|
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
|
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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[^].
|
|
|
|
|
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,,
|
|
|
|
|
You can use the SQL keyword MAX
SELECT MAX(ColumnName) AS ExpressionName
FROM TableName
Simon
|
|
|
|
|
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 ,
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
|
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.
|
|
|
|
|
Hi,
Can i insert DataGridView in other DataGridView?
|
|
|
|
|
Yes, you can. Try it.
When you're alone in the Dark, Fear will protect you...
|
|
|
|
|
I need to do sth when the scrollbar in a listview is moved.
but I can not find out which event is activated when the scrollbar in the listview is moved.
can anyone give one idea for it?
thanks!
|
|
|
|
|
There isn't one unfortunately.
You could probably do what you want by overriding the window procedure and checking for the WM_VSCROLL[^] message.
Something like this:
public class MyListView : ListView
{
public event EventHandler Scrolled;
private int WM_VSCROLL = 0x115;
protected override void WndProc(ref Message m)
{
if (m.Msg == WM_VSCROLL)
{
OnScrolled();
}
Debug.WriteLine(m);
base.WndProc(ref m);
}
private void OnScrolled()
{
EventHandler localEvent = Scrolled;
if (localEvent != null)
{
localEvent(this, EventArgs.Empty);
}
}
}
Simon
|
|
|
|
|
i need inject a plug to a project
yes that's realy a diffcult problem .i can't get a way to solv it .
i need you point out the key;
for example i want instantiation a object A ,that's object turn to a button on the Main (UI); So how i can do it ?
|
|
|
|
|
Hi,
I have to insert a logo in the excel file which is created using CreateText() method of file stream. After writing XML data in the file, I open the excel to insert a logo at the end. It is opening the excel and pasting the logo perfectly. But the problem is it is not saved properly. I have given my code below.
Excel.Application excelApplication = null;
Excel._Workbook workbook;
excelApplication = new Excel.ApplicationClass();
string fname = "D:\\datapointlogo.bmp";
object missing = System.Reflection.Missing.Value;
excelApplication.Visible = true;
excelApplication.UserControl = true;
workbook = excelApplication.Workbooks.Open(fileName, missing, missing, 5 , missing, missing
, missing, missing, missing, missing, missing, missing, missing, missing, missing);
Excel.Worksheet ThisSheet = (Excel.Worksheet)workbook.Sheets[1];
Excel.Range oRange = (Excel.Range)ThisSheet.Cells[35, 1];
Image oImage = Image.FromFile(fname);
oRange.set_Item(35, 1, oImage);
System.Windows.Forms.Clipboard.SetDataObject(oImage, true);
ThisSheet.Paste(oRange, fname);
workbook.Save();
After opening the excel file, I noticed that, File format for this excel is XMLSpreadsheet. I tried to manually change the file format in the Save As dialog and it worked fine.
Also, Please note that, I don't want to use the following line though it works fine.
workbook.SaveAs(fileName, Excel.XlFileFormat.xlExcel8,
System.Reflection.Missing.Value, System.Reflection.Missing.Value,
System.Reflection.Missing.Value, System.Reflection.Missing.Value,
Excel.XlSaveAsAccessMode.xlNoChange, System.Reflection.Missing.Value, System.Reflection.Missing.Value,
System.Reflection.Missing.Value, System.Reflection.Missing.Value,
System.Reflection.Missing.Value);
I have to change the file format without using SaveAs method. Please help me.
Thanks,
S.Sriram.
modified on Monday, November 17, 2008 4:02 AM
|
|
|
|
|
I'd like to use that line in my in my app, however EXcel give an exception if I specify a fileformat other then missing.
Happy programming!!
|
|
|
|
|