Comments by U_Hanisa - CodeProject

U_Hanisa 16-Oct-14 17:47pm View

Hye ChauhanAjay..please help me now. I'm copy this coding to my notebook. But when I debug, the query for the date become like this ""SELECT Row_Number() OVER(ORDER BY b.Date) AS ROWNUMBER, a.Name, b.MatricNo, b.Date, b.KaunselingID, b.Status " _
& "FROM DbStudent.dbo.SMP01_Personal AS a " _
& "INNER JOIN dbo.Kaunseling AS b ON a.MatricNo = b.MatricNo " _
& "WHERE Status = '2' And Date >= '1/8/2014' AND Date <= '31/8/2014'". Do you understand, so my query cannot read at sql server 'The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value.' I don't know what is the problem because at my computer,it can run.

U_Hanisa 16-Oct-14 17:43pm View

Hye ChauhanAjay..please help me now. I'm copy this coding to my notebook. But when I debug, the query for the date become like this ""SELECT Row_Number() OVER(ORDER BY b.Date) AS ROWNUMBER, a.Name, b.MatricNo, b.Date, b.KaunselingID, b.Status " _
& "FROM DbStudent.dbo.SMP01_Personal AS a " _
& "INNER JOIN dbo.Kaunseling AS b ON a.MatricNo = b.MatricNo " _
& "WHERE Status = '2' And Date >= '1/8/2014' AND Date <= '31/8/2014'". Do you understand, so my query cannot read at sql server 'The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value.' I don't know what is the problem because at my computer,it can run.

U_Hanisa 14-Oct-14 22:33pm View

TQ. ^_^

U_Hanisa 13-Oct-14 4:41am View

Thank you. I'm a beginner of VB.Net, so I clueless about the coding. Can you give me the examples?

U_Hanisa 13-Oct-14 3:56am View

Please check my updated code

U_Hanisa 13-Oct-14 2:53am View

Sorry..actually I don't know how to setting value to the textbox. I want to pass UserID from gridview at difference form to textbox at login form

U_Hanisa 12-Oct-14 21:10pm View

Excuse me, I'm using VB.Net. When I type mpModalDemo.Show(), it getting error. Then, when I run, I have error 'The data source does not support server-side data paging.' at 'gvDemo.DataSource = cmd.ExecuteReader();
gvDemo.DataBind();' even I changed the gv's name

U_Hanisa 9-Oct-14 3:36am View

Yes, you maybe right. But the problem here, I want to call the login popup after I click buttonfield. I try to use ajaxToolkit but it still doesn't help at all. Please check my updated gridview asp

U_Hanisa 9-Oct-14 3:27am View

Where is your Button1,sorry my screen cannot run. Then the code behind for popup_Click, where is the object. I can't get it. TQ :)

U_Hanisa 8-Oct-14 20:10pm View

Can I use this code to call popup login from gv_RowCommand?

U_Hanisa 8-Oct-14 20:09pm View

But here,I want to call the popup login fron gv_CommandRow

U_Hanisa 8-Oct-14 0:01am View

Can you teach me how to do popup login without using Ajax Control Tollkit

U_Hanisa 1-Oct-14 0:52am View

Yea,you're right. But when I debug, the new error popup 'Specified cast is not valid'. Sorry, because I don't know how to fix the error.

U_Hanisa 1-Oct-14 0:17am View

Yes,the table is exists in database and it belongs to dbo.

U_Hanisa 30-Sep-14 22:04pm View

Yes!! Thank you very much. Actually, i'm an internship student and I afraid to ask staffs around me. Thanks again. :)

U_Hanisa 30-Sep-14 21:53pm View

sql server

U_Hanisa 30-Sep-14 21:47pm View

Sorry..i'm still new in asp.net. My value is "8"

U_Hanisa 30-Sep-14 21:35pm View

What do you mean. For example 'August'?

U_Hanisa 30-Sep-14 21:30pm View

I don't know how to use try catch block. If you don't mind,can you help me? I want the data display in grid view based on the status and month that I select at cmbMonth.

U_Hanisa 30-Sep-14 21:18pm View

Thank you. One more thing, how about if I add the status at 'WHERE' query, please check my updated code. Because after I select month at cmbMonth, it didn't diplay any of data in gridview

U_Hanisa 30-Sep-14 3:20am View

Please check my updated code

U_Hanisa 30-Sep-14 3:13am View

Yes,it working.

U_Hanisa 30-Sep-14 3:08am View

I don't know how to correct this problem,please help me. I'd debug my code,but when I change the cmbMonth, it doesn't effect the data grid view.

U_Hanisa 30-Sep-14 2:50am View

Your coding before is correct. But when I want to change the month, for example 'August', the gridview doesn't change the data

U_Hanisa 30-Sep-14 2:31am View

Excuse me. The coding that you give me was right. But when I change to Month = 'August', it doesn't change.

U_Hanisa 30-Sep-14 2:08am View

Thank you :)

U_Hanisa 30-Sep-14 1:06am View

Thank you. One more thing..I want when I open that screen, the cmbMonth will show the current month automatically. So I don't need to choose.

U_Hanisa 30-Sep-14 0:53am View

Hello..I"m sorry. I need to change my code so that I don't use hard code. Can you help me? I don't want to declare the year to '2014',but current year. So do month.

U_Hanisa 29-Sep-14 21:26pm View

Thank you very much, it works!! :)

U_Hanisa 29-Sep-14 21:03pm View

This is the error when I run 'Could not load file or assembly 'AjaxMin, Version=4.97.4951.28478, Culture=neutral, PublicKeyToken=21ef50ce11b5d80f' or one of its dependencies. The system cannot find the file specified. '

U_Hanisa 29-Sep-14 3:05am View

one more thing,i'm using vb,not c#

U_Hanisa 29-Sep-14 3:01am View

It still the same. It display the same error.

U_Hanisa 28-Sep-14 22:02pm View

Please check my updated question

U_Hanisa 25-Sep-14 4:38am View

I don't set Session("strID") anywhere, and when I use breakpoint, the Session("strID") didn't give the value. Haha, you're right. So what I'm going to do?

U_Hanisa 25-Sep-14 4:01am View

Ok sorry. Actually, I don't really get what do you mean.
-First, I know what a breakpoint and how to set it.
-Second, I don't have any try/catch blocks because I don't know.
-Third, I'd update my question with btnSave HTML
-Fourth, the saving status doesn't work and didn't change in the database.
-Session("strID") is empty because ID is changing depends on user choice.
And for your information,I'm still an amateur in programming. I'm learning now.

U_Hanisa 25-Sep-14 3:36am View

How could I know if I ask the question here. It's ok if it hard to you to help me. My english is not very good, so I'm sorry because I don't know how to explain to you. Thank you too. You showed me that you're hot tempered^^

U_Hanisa 25-Sep-14 3:35am View

Deleted

How could I know if I ask the question here. It's ok if it hard to you to help me. My english is not very good, so I'm sorry because I don't know how to explain to you. Thank you too. You showed me that you're hot tempered^^

U_Hanisa 25-Sep-14 3:23am View

Oh, I see. My btnSave is Sub Update actually. The value of Session("strID") = "" is when I select one of ID in gridview. After I click cmdSelect in gridviw,it will display the data at the screen then I click btnSave to change the status to '3'. Now, the problem is when I click btnSave(Sub Update), status doesn't change at database, and the data still display in the gridview. Do you get what I mean?

U_Hanisa 25-Sep-14 2:55am View

btnSave is Sub Update. Pls check my updated question. I don't understand what are you trying to say.

U_Hanisa 25-Sep-14 2:53am View

Can you please check my new question, TQ. :)
'http://www.codeproject.com/Questions/822923/How-to-update-two-table-in-asp-net'

U_Hanisa 25-Sep-14 2:33am View

Yes, that is my problem. I don't know what error in my coding. But when I click btnSave, it doesn't remove from the gridview. Can you help me?

U_Hanisa 24-Sep-14 23:58pm View

I got my solution's answer,thanks for helping^^

U_Hanisa 24-Sep-14 21:52pm View

SELECT Row_Number() OVER(ORDER BY a.Date) AS ROWNUMBER, a.MatricNo, b.Name, b.Faculty, a.Date, a.KaunselingID, b.TelNo, " _
& "c.Officer " _
& "FROM KaunselingPL AS a " _
& "INNER JOIN DbStudent..Personal AS b ON a.MatricNo = b.MatricNo " _
& "INNER JOIN KaunselingDT AS c ON a.KaunselingID = c.KaunselingID " _
& "WHERE (a.Status = '2')

U_Hanisa 24-Sep-14 21:35pm View

At first respose.writestatement, the value is empty(""). At second response.writestatement, the value is same as sql query. I want to tell you that when it through 'If (dbread.HasRows()) Then', the value is false. So it skip to do the dbread. Do you get what I mean?

U_Hanisa 24-Sep-14 20:21pm View

Oh ok, sorry for the mistake. I had debug my system, it still didn't display anything.

U_Hanisa 24-Sep-14 4:25am View

Excuse me, what happen?

U_Hanisa 23-Sep-14 23:33pm View

Deleted

Sorry,I don't understand what are you trying to say. Can you give me an exmple

U_Hanisa 23-Sep-14 23:21pm View

What the difference? By the way, this "Dim NoMatrik As String = gvSenSemak.DataKeys(CurrentRowIndex).Value", (CurrentRowIndex) is not declared.

U_Hanisa 23-Sep-14 22:42pm View

Please check my updated solution,TQ^^

U_Hanisa 23-Sep-14 21:36pm View

Excuse me, ChauhanAjay. Last time u teach me how to call data based on drop down list. Now,when I select one of the data from gridview rowCommand, it didn't display at my page. All of my data in gridview, when I select that data I want to update the status from '2' to '3'. Can you help me?

U_Hanisa 23-Sep-14 4:10am View

My status at data list in database is all '2'

U_Hanisa 23-Sep-14 3:03am View

oh yes,it's correct, and this value exists in the database. But when I use catch block, it go false when through 'If (dbread.HasRows()) Then'

U_Hanisa 23-Sep-14 2:00am View

Yes. but I don't understand what do you mean by the value against "a.MatricNo" field in the where condition

U_Hanisa 22-Sep-14 22:58pm View

I try using the try catch block in my code. At 'If (dbread.HasRows()) Then', it false. So it do not read the data. By the way, I don't understand what do you mean.

U_Hanisa 22-Sep-14 22:41pm View

"Response.Write(ex.Message.ToString());"
What 'Message' do you mean, I don't understand

U_Hanisa 22-Sep-14 22:35pm View

No. When I click select button in gridview, it don't display any data.

U_Hanisa 22-Sep-14 22:16pm View

When I click the select button on Matric No, the writing in gridview becomes larger

U_Hanisa 22-Sep-14 22:08pm View

The writing becomes larger

U_Hanisa 22-Sep-14 21:51pm View

Matric No

U_Hanisa 22-Sep-14 21:33pm View

At 'Me.lblName.Text = dbread("Name")', it display error (No data exists for the row/column)

U_Hanisa 22-Sep-14 21:23pm View

Yes, you right. It basing MatricNo

U_Hanisa 22-Sep-14 20:12pm View

When I debug,it shows error 'No data exists for the row/column'

U_Hanisa 22-Sep-14 0:52am View

Deleted

It says 'No data exists for the row/column.' But I have fill the data and also the gridview

U_Hanisa 21-Sep-14 23:46pm View

Yes, you right. And when I click select button on row2, it will display data related to row2.

U_Hanisa 21-Sep-14 22:07pm View

So what would I do to display all list data in grid view, then when I click button 'Select' on certain row data, it will display that information. Did you get what I mean.

U_Hanisa 17-Sep-14 0:16am View

I got it, thank you :)

U_Hanisa 17-Sep-14 0:05am View

yes, it is in the same folder

U_Hanisa 16-Sep-14 22:42pm View

This is the error
"Server Error in '/' Application.
The resource cannot be found.
Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.
Requested URL: /frmLogin.aspx"
I'm not using '/' in my code behind. I also don't know why it cannot run

U_Hanisa 15-Sep-14 0:45am View

Yeay!!!! I got it!!! Thank you very much!! For a week I try to solve this problem. thank you, thank you, thank you......:D

U_Hanisa 15-Sep-14 0:32am View

What do you mean? For example? I've state at my updated code

U_Hanisa 15-Sep-14 0:08am View

My system run after I change the monthName = "August". If I write monthName = Me.cmbMonth.SelectedValue, it will display only "No Record"

U_Hanisa 14-Sep-14 23:29pm View

May I know 103 is stand for what?

U_Hanisa 14-Sep-14 23:20pm View

'15/09/2014'..my query work. It just when I run,it display no record

U_Hanisa 14-Sep-14 23:19pm View

TABLE b
KaunselingID varchar(20)
MatricNo nvarchar(20)
Date smalldatetime

TABLE a
Name nvarchar(60)

*Sorry..I don't know how to show you the table design

U_Hanisa 14-Sep-14 22:56pm View

Date

U_Hanisa 14-Sep-14 22:51pm View

Yes, of course I have. My Date is like '2014-08-18 00:00:00'

U_Hanisa 14-Sep-14 21:36pm View

I don't know what do you mean, but I've update my coding. Can you please check for me?

U_Hanisa 14-Sep-14 20:31pm View

Sorry..it still the same. May I know..do I need to change anything in source too?

U_Hanisa 11-Sep-14 4:48am View

Please check my updated solution

U_Hanisa 11-Sep-14 4:42am View

ouhh..I see..but when I run it, it still didn't display anything. Look at my updated solution

U_Hanisa 11-Sep-14 3:54am View

No no..I mean I don't want to state the day, not like above

U_Hanisa 11-Sep-14 3:47am View

Ok. How if I don't want to state the day, like this ("01-") ?

U_Hanisa 11-Sep-14 3:43am View

So you mean 01 is for the day. But here my drop down is like September, but my date will display 01-09-2014. You get me, right?

U_Hanisa 11-Sep-14 3:26am View

Convert.ToDateTime((Convert.ToString("01-") & monthName) + "-" + year).Month

**I have error at ("01-"). May I know what is it meaning?

U_Hanisa 11-Sep-14 2:53am View

It still don't display anything. Huwarghh..I feel want to cry, I want to give up. I hate prgramming :'(

U_Hanisa 11-Sep-14 0:22am View

What do you mean by 'datevalue' and 'timevalue'? Is it '2014-08-20 00:00:00'

U_Hanisa 11-Sep-14 0:19am View

Deleted

What do you mean by 'datevalue' and 'timevalue'? Is it '2014-08-20 00:00:00'

U_Hanisa 10-Sep-14 23:45pm View

Do I need to change anything at my source(gridview)?

U_Hanisa 10-Sep-14 23:26pm View

I use SQL Server. The problem is when I write the query, the word 'DATE' is error. I don't know why.

U_Hanisa 10-Sep-14 23:02pm View

No, I mean 'DATENAME(MONTH, DATE)', this DATE

U_Hanisa 10-Sep-14 22:41pm View

The query is correct,but only DATE is wrong.

U_Hanisa 10-Sep-14 22:31pm View

It still the same. Do you mean "WHERE DATENAME(MONTH, DATE) = '" & monthName & "'", I must type 'DATENAME(MONTH, DATE)' too? Is it correct?

U_Hanisa 10-Sep-14 22:09pm View

January

U_Hanisa 10-Sep-14 20:40pm View

Thank you..I'd update my coding. By the way, how to load the details that link with the month that I select. Can you please check for me, because it still cannot run. The gridview didn't display anything.

U_Hanisa 10-Sep-14 2:47am View

What do you mean by BETWEEN {0} and {1}? Sorry,I don't get it

U_Hanisa 10-Sep-14 1:07am View

The LoadList called when everytime I change the Month. I've tried the SQL query but it's wrong. I did it because I copy from another forum. I actually don't know either it's right or wrong.

U_Hanisa 10-Sep-14 0:52am View

No, it doesn't work. That's why I ask the question here.

U_Hanisa 10-Sep-14 0:21am View

This is my last coding
Sub LoadList()

'---LOAD LIST---
dbconn = New OleDb.OleDbConnection(strCon)
dbconn.Open()

sql = "SELECT [column1], [column2] FROM [table] WHERE Date = '"& Me.cmbMonth.SelectedValue"

dbcomm = New OleDbCommand(sql, dbconn)
Dim da As OleDb.OleDbDataAdapter
da = New OleDbDataAdapter(dbcomm)
Dim ds As DataSet
ds = New DataSet
da.Fill(ds, "[table]")
gvList.DataSource = ds.Tables("[table]")
gvList.DataBind()

dbconn.Close()
dbconn = Nothing
End Sub

Do I need to change anything in source too?

U_Hanisa 10-Sep-14 0:20am View

Deleted

This is my last coding
Sub LoadList()

'---LOAD LIST---
dbconn = New OleDb.OleDbConnection(strCon)
dbconn.Open()

sql = "SELECT [column1], [column2] FROM [table] WHERE Date = '"& Me.cmbMonth.SelectedValue"

dbcomm = New OleDbCommand(sql, dbconn)
Dim da As OleDb.OleDbDataAdapter
da = New OleDbDataAdapter(dbcomm)
Dim ds As DataSet
ds = New DataSet
da.Fill(ds, "[table]")
gvList.DataSource = ds.Tables("[table]")
gvList.DataBind()

dbconn.Close()
dbconn = Nothing
End Sub

Do I need to change anything in source too?

U_Hanisa 9-Sep-14 22:35pm View

I did it before. But my selected value is Month while my data is the whole date. What should I write to display the date and the rest of data with only choosing a Month

Comments by U_Hanisa (Top 100 by date)