ASP.NET

Re: Datagrid bound column value in datagrid textbox..(I hope this time i will get..)

6-Jul-07 1:21

please correct your subject

Regards,

Satips. Rose | [Rose]

InsDev6-Jul-07 1:36

InsDev

6-Jul-07 1:36

Check out your nulldisplaytext property of the bound column.Could be problem occure for this.

Devjit

Re: Datagrid bound column value in datagrid textbox..(I hope this time i will get..)

Member 38798816-Jul-07 1:55

Member 3879881

6-Jul-07 1:55

Ya i checd those cells it are empty only...,
But not getting proper answer...,

Regards,
Magi

Error in dgresult.rows

n_gchaitra6-Jul-07 1:07

n_gchaitra

6-Jul-07 1:07

I am using the following code to export data from datagrid to excel. but I am geting the error in dgresult.rows which says. what is the reason for this.
Error 20 'rows' is not a member of 'System.Web.UI.WebControls.DataGrid'

Private Sub ExportGridToExcel()
Dim Excel As Object = CreateObject("Excel.Application")

If Excel Is Nothing Then
MsgBox("Excel is not installed on this machine. This operation requires MS Excel to be installed on this machine.", MsgBoxStyle.Critical)
Return
End If

'Make Excel visible
Excel.Visible = True

'Initialize Excel Sheet
With Excel
.SheetsInNewWorkbook = 1
.Workbooks.Add()
.Worksheets(1).Select()

'Add header row to Excel Sheet by copying column headers from the Datagrid

Dim Col As DataGridViewColumn
Dim i As Integer = 1
For Each Col In dgresult.Columns
.Cells(1, i).Value = Col.HeaderText
i += 1
Next

'Add data to excel sheet by looping through the rows in the datagrid

i = 2
Dim RowItem As DataGridViewRow
Dim Cell As DataGridViewCell
For Each RowItem In dgresult.rows
Dim j As Integer = 1
For Each Cell In RowItem.Cells
.Cells(i, j).Value = Cell.Value
j += 1
Next
i += 1
Next
End With

Excel.Quit()
System.Runtime.InteropServices.Marshal.ReleaseComObject(Excel)
Excel = Nothing
MsgBox("Export to Excel Complete", MsgBoxStyle.Information)
End Sub

Chaitra N

Re: Error in dgresult.rows

kubben6-Jul-07 2:02

kubben

6-Jul-07 2:02

With the datagrid on the web it is items not rows. It is different then the windows datagrid.

sample from microsoft help:

Dim item As DataGridItem
        For Each item In  ItemsGrid.Items
            Label1.Text &= "<br>" & item.Cells(0).Text & _
                        " " & item.Cells(1).Text & _
                        " " & item.Cells(2).Text
        Next item

Ben

InitializeCulture()': no suitable method found to override : only problem with master page

srinandan..6-Jul-07 1:03

srinandan..

6-Jul-07 1:03

Hi All

I am having a master page contains dropdownlist to select the language.
when write the following method just below the

public partial class Sign_in : System.Web.UI.MasterPage<br />
{<br />
  protected override void InitializeCulture()<br />
    {<br />
        string culture = Request.Form["cmbCulture"];<br />
        if (string.IsNullOrEmpty(culture))<br />
            culture = "Auto";<br />
        //Use this<br />
        UICulture = culture;<br />
        Culture = culture;<br />
        //OR This<br />
        if (culture != "Auto")<br />
        {<br />
            System.Globalization.CultureInfo ci = new System.Globalization.CultureInfo(culture);<br />
            System.Threading.Thread.CurrentThread.CurrentCulture = ci;<br />
            System.Threading.Thread.CurrentThread.CurrentUICulture = ci;<br />
        }<br />
<br />
        base.InitializeCulture();<br />
    }<br />
<br />
  protected void Page_Load(object sender, EventArgs e)<br />
    {}<br />
<br />
}<br />

following error occur only with he master page:
'Sign_in.InitializeCulture()': no suitable method found to override
while same process is working in aspx page.

Thanks in advance..

Regards,
Sri..

rating.

suparichit6-Jul-07 0:54

6-Jul-07 0:54

how to code to rate forum in asp.net using c# and its design.

harika

Sathesh Sakthivel6-Jul-07 0:56

6-Jul-07 0:56

we cannot do your homework.

Regards,

Satips. Rose | [Rose]

Christian Graus6-Jul-07 1:01

Christian Graus

6-Jul-07 1:01

I doubt this is homework, homework askers usually type in a comprehensive question, exactly as it was assigned to them.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Sathesh Sakthivel6-Jul-07 1:08

6-Jul-07 1:08

Exactly CG.

Regards,

Satips. Rose | [Rose]

Christian Graus6-Jul-07 1:00

Christian Graus

6-Jul-07 1:00

It's really pretty simple - you want to allow people to make a rating, you want to store each rating with the person who did it, so they cannot rate twice, and you need to count them.

Which bit are you stuck on ?

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

suparichit6-Jul-07 1:41

6-Jul-07 1:41

thanks..i have stored my rate in database
------------------------------------------

x = rbtnRating.SelectedItem.ToString();
switch (x)
{
case "Excellent":
strRate = "5";
break;
case "Good":
strRate = "4";
break;
case "Average":
strRate = "3";
break;
case "Bad":
strRate = "2";
break;
case "Terrible":
strRate = "1";
break;
}
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["KMSConnectionString"]);
con.Open();
string str = "insert into Rating(Rate,Authorname,Replies,QId) values('" + strRate + "','" + btnName.Text + "','" + lblReply.Text + "' ,'" + btnSno.Text + "' )";
SqlCommand cmd = new SqlCommand(str, con);
cmd.ExecuteNonQuery();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(str, con);
da.Fill(ds);

but in retriving the database
------------------------------

SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["KMSConnectionString"]);
con.Open();
string sto = "select rate from rating where Authorname='" + btnName + "'";
DataSet ds1 = new DataSet();
SqlCommand com = new SqlCommand(sto, con);
String str3 = com.ExecuteNonQuery().ToString();

SqlDataAdapter da1 = new SqlDataAdapter(sto, con);
da1.Fill(ds1);
int countC = ds1.Tables[0].Rows.Count;
if (countC != 0)
{
for (int j = 0; j < countC; j++)
{

str3 += str3;

total = ((Convert.ToInt16(str3)) / (5 * countC));//here is my problem
}
}
Label1.Text = total.ToString();

harika

Sathesh Sakthivel6-Jul-07 1:45

6-Jul-07 1:45

what problem it says?

Regards,

Satips. Rose | [Rose]

suparichit6-Jul-07 2:07

how to retrive file from database

6-Jul-07 2:07

thers is a problem in binding the data to the label.could u please check the retriving code rating.

harika

suparichit6-Jul-07 0:52

Re: how to retrive file from database

6-Jul-07 0:52

code to download file from sqlserver in asp.net using c#

harika

Sathesh Sakthivel6-Jul-07 0:55