ASP.NET

dates in datagrid..........,

6-Jul-07 1:41

Get it[^]

Regards,

Satips. Rose | [Rose]

HemMagesh6-Jul-07 1:23

HemMagesh

6-Jul-07 1:23

Hi i am displaying my records in datagrid...,
In that one month data's are displaying with the date...,
Now,Except those dates anyother date will be there in that month...,
It also want to show...,

Example:

june month have 30 days...,

But in my table,i have 1 to 22 date and 25 to 30 date records...,
It will be display using query...,
Remaining 23 to 24 dates also want to show in that datagrid ...,
How to do that...,
Plz tell me...,

-- modified at 7:28 Friday 6th July, 2007

Magesh

Re: dates in datagrid..........,

InsDev6-Jul-07 1:53

InsDev

6-Jul-07 1:53

Just u have to write sql query that if the day has no any record that day should have blank record. that will solve your problem.

Devjit

Datagrid bound column value in datagrid textbox..(I hope this time i will get..) [modified]

Member 38798816-Jul-07 1:12

Member 3879881

6-Jul-07 1:12

I hope this time i will get the solution for this probs...,

I am trying to display my datagrid bound column cell value in datagrid textbox place...,
So i used this following code...,

For Each fillgrdregtextbox As DataGridItem In dgrdmain1.Items
Dim AppRgHrs As TextBox = CType(fillgrdregtextbox.FindControl("txtAppRgHrs"), TextBox)
Dim AppOtHrs As TextBox = CType(fillgrdregtextbox.FindControl("txtAppOtHrs"), TextBox)
If fillgrdregtextbox.Cells(25).Text <> "" Then
AppRgHrs.Text = Val(fillgrdregtextbox.Cells(25).Text)
AppOtHrs.Text = Val(fillgrdregtextbox.Cells(26).Text)
ElseIf fillgrdregtextbox.Cells(27).Text <> "" Then
AppRgHrs.Text = Val(fillgrdregtextbox.Cells(27).Text)
AppOtHrs.Text = Val(fillgrdregtextbox.Cells(28).Text)Else
AppRgHrs.Text = 0
AppOtHrs.Text = 0
End If
Next

In this that first if condition is working...,
But that elseif is not working...,
Instead of that i am getting 0 on there...,

If its not possible plz tell me some other way to do that...,

Advance thanks...,

-- modified at 7:24 Friday 6th July, 2007

-- modified at 7:25 Friday 6th July, 2007

Regards,
Magi

Re: I hope this time i will get.........,

Sathesh Sakthivel6-Jul-07 1:21

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