ASP.NET

27-Apr-07 1:02

I want to keep each feild in particular width. How should I do this.
I set width property , but not working

Deepml27-Apr-07 1:05

Deepml

27-Apr-07 1:05

Set width of ItemStyle,
<ItemStyle Width="10px"></ItemStyle>

A kamath27-Apr-07 1:10

27-Apr-07 1:10

Thanks.It is not working

Chetan Ranpariya27-Apr-07 1:52

27-Apr-07 1:52

Hi,

Can u tell us exactly how u r setting the width of columns in the datagrid?

Thanks and Regards,
Chetan Ranpariya

A kamath27-Apr-07 1:56

27-Apr-07 1:56

The text has come to the width which I set now but the column width has not changed.

Chetan Ranpariya27-Apr-07 2:00

27-Apr-07 2:00

Hi,

Not getting the problem.
You want your columns to be with fixed width or u want them to be resize as per the length of content?

Thanks and Regards,
Chetan Ranpariya

A kamath27-Apr-07 2:03

27-Apr-07 2:03

I have a description column in my data grid. In the datagrid I don't want to show full description. only I want to show full description in details view.

Chetan Ranpariya27-Apr-07 2:08

27-Apr-07 2:08

Hi,

Then you should explicitly trim you description value coming from the database. This you can do in the ItemDataBound event of the datagrid.

private void dg_ItemDataBound(object sender, DatagridItemEventArgs e)
{
if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType ==
ListItemType.AlternateItem)
{
if(e.Item.Cells[2].Text.Legth > 50)
{
e.Item.Cells[2].Text=e.Item.Cells[2].Text.Substring(0, 49) + "...";
}
}
}

Here column 2 in the datagrid is bound to the description field of the datasource.

I hope this will help you.

Thanks and Regards,
Chetan Ranpariya

A kamath27-Apr-07 2:34

27-Apr-07 2:34

Thanks, I am very new to this field can u help me if I am giving this in codebehind and should I do anything in source code(Template feild).

Chetan Ranpariya29-Apr-07 20:03

29-Apr-07 20:03

Hi,

Put this is in codebehind and replace "private" with "public" and u have to do one thing in the .aspx file.

set "OnItemDataBound" property of datagrid to "dg_ItemDataBound".

I hope this will help you.

Thanks and Regards,
Chetan Ranpariya

A kamath30-Apr-07 1:40

How to export crystal report to excel in asp.net 1.0

30-Apr-07 1:40

Thanks

Deepml27-Apr-07 0:55

Deepml

27-Apr-07 0:55

How to export crystal report to excel in asp.net 1.0?
Is there any built in functionality to export it in excel.

Thanks in advance,

Re: How to export crystal report to excel in asp.net 1.0

varshavmane27-Apr-07 4:28

varshavmane

27-Apr-07 4:28

Try this On Export Button Click Event:

// Declare variables and get the export options.
ExportOptions exportOpts = new ExportOptions();
ExcelFormatOptions excelFormatOpts = new ExcelFormatOptions ();
DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
exportOpts = orpt.ExportOptions;
// Set the excel format options.
excelFormatOpts.ExcelUseConstantColumnWidth = true;
exportOpts.ExportFormatType = ExportFormatType.Excel;
exportOpts.FormatOptions = excelFormatOpts;
// Set the disk file options and export.
exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;
diskOpts.DiskFileName = fname;
exportOpts.DestinationOptions = diskOpts;
orpt.Export ();

Hope this helps u...

how to insert one table data from one database to oher database

Sophia Rekhi27-Apr-07 0:27

Sophia Rekhi

27-Apr-07 0:27

Hi all,

i want to know that,

How to insert one table records from one database to another table in other database using webservices in vb.net or C#.

ex: databse name: PRS1
table name: sample1
|
|
databse name :PRS2
table name : sample2

Re: how to insert one table data from one database to oher database

Mayank Parmar27-Apr-07 20:41

Mayank Parmar

27-Apr-07 20:41

I don't know why you want to use webservice.
But easy way is to use Datatable to store Temporarily data.
This can work if both databases are on same domain.

I use free sqlhepler class to connect with database.
------------------------------------------------------------------------------
string sql="Select user_id,name from user_master";
DataTable dt = SqlHelper.ExecuteDatatable(SqlHelper.ConnectionStringfordatabase1, CommandType.Text, sql);
foreach (DataRow dr in dt.Rows)
{
sql = "Inser into user_master (user_id,name) values('" + dr["user_id"] + "','" + dr["name"] + "')";
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringfordatabase2, CommandType.Text, sql);
}
------------------------------------------------------------------------------

Regards,
Mayank Parmar
Senior Software Engineer
Amba Tech
Gandhinagar, India

connection in chat window

saravanan0526-Apr-07 23:57

saravanan05

26-Apr-07 23:57

hi friends

i did chat window.how to connect other systems

can u help me???

DropDownList Problem

Tarik Guney26-Apr-07 23:50

26-Apr-07 23:50

Hey guys i have a little problem to be needed to solve..

I have a accessdatasource and dropdownlist and i binded them to eachother. After i change the selected index on dropdownlist,after postback the selected index wont come as i choose. The first index is coming as a default selected index after every postback...

what should i do to pass over it?

Mayank Parmar26-Apr-07 23:58

Mayank Parmar

26-Apr-07 23:58

I hope you have given datasource to dropdown in
----------------------------------
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
dropdown.datasource=dc;
dropdown.databind;
dropdown.datatextfield=dtf;
dropdown.datavaluefield=dvf;
}
}

Regards,
Mayank Parmar
Senior Software Engineer
Amba Tech
Gandhinagar, India

ritu432127-Apr-07 0:00

ritu4321

27-Apr-07 0:00

set autopostback=true

Tarik Guney27-Apr-07 2:47

27-Apr-07 2:47

I did but the problem is still appearing ... and there is another way besides coding ?

Tarik Guney27-Apr-07 2:58

27-Apr-07 2:58

Thanks it seems gonna work Smile | :)

Tarik Guney27-Apr-07 3:42

27-Apr-07 3:42

it didnt work ?