Comments by ChauhanAjay

ChauhanAjay 23-Feb-20 0:54am View

Kindly try the below link and it should help
https://www.eternussolutions.com/2015/03/31/data-import-simplified-excel-to-sql-using-stored-procedure/

ChauhanAjay 27-Nov-19 17:12pm View

Deleted

have a look at this link https://www.webslesson.info/2016/03/read-excel-data-and-insert-into-mysql-database-using-php.html

ChauhanAjay 15-Aug-19 19:22pm View

Have a look at the following url
https://stackoverflow.com/questions/83152/reading-pdf-documents-in-net

ChauhanAjay 27-Dec-18 0:42am View

Try the below link hope it helps
http://www.vbforums.com/showthread.php?544231-RESOLVED-2005-Get-Email-Address-from-Active-Directory

ChauhanAjay 27-Dec-18 0:34am View

Correct your query from "select * form defter" to "select * from defter" and check

ChauhanAjay 27-Dec-18 0:32am View

Check the below link, hope this helps
https://stackoverflow.com/questions/5825165/javascript-alert-showmessage-from-asp-net-code-behind/5827956

ChauhanAjay 17-Dec-18 17:51pm View

Read the file line by line and skip the line which does not have your variables. Then split the line at vbTab. Hope this helps.

ChauhanAjay 17-Dec-18 17:13pm View

Hope the below link helps.
https://www.codeproject.com/Articles/44274/%2FArticles%2F44274%2FTranspose-a-DataTable-using-C

ChauhanAjay 17-Dec-18 16:54pm View

Read the whole file in one variable and then split it at the vbTab. In this case you will have an array of all your values then you can use the array and get the values of different variables. Hope this helps.

ChauhanAjay 16-Dec-18 17:50pm View

Hope the below link helps
https://stackoverflow.com/questions/3117121/reading-and-writing-value-from-a-textfile-by-using-vbscript-code

ChauhanAjay 13-Dec-18 23:12pm View

Please check if the empid exists in your table or not. If it does not exists then insert the data.

ChauhanAjay 7-May-17 19:47pm View

change your query to "Select count(*) from dbtable WHERE uname like '%"+textbox1.text.toString()+"%'". If the result of the query is greater than zero show your message box.

ChauhanAjay 3-May-17 19:25pm View

You could try creating a temporary table with data from "fakeimages" and "store_images". Retrieve the data then display your images randomly

ChauhanAjay 3-May-17 18:29pm View

Deleted

Just add target=_blank in your hyperlink tag and that should open it in a new browser window or tab.

ChauhanAjay 20-Apr-17 1:24am View

You will need to write an ajax script onchange event of the first textbox to get the data from the database and fill your second textbox.

ChauhanAjay 11-Sep-16 18:14pm View

I have tested the code and and then pasted it here I don't know why it missed the php tag. Anyway I have added the php tag.

ChauhanAjay 8-Sep-16 23:48pm View

You are welcome

ChauhanAjay 8-Sep-16 22:43pm View

Change the code from
If Not IsDBNull(readerSQL.Item("shipping_start_date")) Then
woStartDate = readerSQL.Item("shipping_start_date")
End If
to

If Not IsDBNull(readerSQL.Item("StartDate")) Then
woStartDate = readerSQL.Item("StartDate")
End If

ChauhanAjay 29-Aug-16 21:00pm View

http://www.codeproject.com/Questions/224585/how-to-call-stored-procedure-in-asp-net-csharp-cod

hope this helps

ChauhanAjay 29-Aug-16 18:50pm View

Deleted

Just try the below link so that you can convert the same in c#
http://stackoverflow.com/questions/1260952/how-to-execute-a-stored-procedure-within-c-sharp-program

ChauhanAjay 27-Jul-16 7:41am View

try this url
http://www.codeproject.com/Tips/1011531/Using-jQuery-DataTables-with-Server-Side-Processin

Hope it helps

ChauhanAjay 9-Sep-15 1:35am View

try the below link
http://stackoverflow.com/questions/16087560/codeigniter-grab-value-from-dropdown-pass-to-controller

ChauhanAjay 7-Sep-15 23:26pm View

x is just a variable you can change it to whatever you want to.
Dim TagAdd As String = CType(control.FindControl("ddlTagAdd"), DropDownList).SelectedItem.Value

The above line should work

ChauhanAjay 7-Sep-15 22:57pm View

Dim x As String = CType(control.FindControl("ddlTagAdd"), DropDownList).SelectedValue.ToString();

ChauhanAjay 7-Sep-15 22:40pm View

Just go through the link and hope it helps
http://www.iis.net/learn/application-frameworks/install-and-configure-php-applications-on-iis/install-wordpress-on-iis

ChauhanAjay 7-Sep-15 22:35pm View

try using the below code
Dim TagAdd As DropDownList = CType(control.FindControl("ddlTagAdd"))
Dim x as String = TagAdd.SelectedValue.ToString();

ChauhanAjay 7-Sep-15 22:14pm View

Change the following line from
<asp:DropDownList ID="TagAdd" runat="server" AutoPostBack="True"
DataTextField="TagAdd" DataValueField="TagAdd">
to
<asp:DropDownList ID="ddlTagAdd" runat="server" AutoPostBack="True"
DataTextField="TagAdd" DataValueField="TagAdd">

ChauhanAjay 30-Aug-15 0:18am View

have a look at the below link hope it helps

http://stratosprovatopoulos.com/web-development/mysql/pivot-a-table-in-mysql/

ChauhanAjay 6-Aug-15 5:26am View

updated the answer with a query.

ChauhanAjay 6-Aug-15 5:20am View

Deleted

updated the answer with a query.

ChauhanAjay 25-Nov-14 5:28am View

Try adding like below
rs.addnew
rs("t1_Name")=request.form("text1")
rs("t2_Name")=request.form("text2")
rs.update

In your asp page

ChauhanAjay 17-Oct-14 3:00am View

You are not having the values for from_date and to_date. Either remove from insert statement or add them in the select statement.

ChauhanAjay 10-Oct-14 13:34pm View

Does your register table and the cart table have any kind of relationship i.e., do they any columns which are common in them.

ChauhanAjay 10-Oct-14 13:28pm View

Please check the rad combo box sample it has the c# as well as the vb code.

ChauhanAjay 8-Oct-14 22:22pm View

can you please put your updated code here.

ChauhanAjay 8-Oct-14 21:44pm View

Try adding the try catch block in the code and check for any kind of exceptions.

ChauhanAjay 30-Sep-14 22:19pm View

Don't be afraid of asking the staff around for help because they are the best person's to help you as they can see your screen and what you are doing there.

ChauhanAjay 30-Sep-14 22:11pm View

As for the try catch block please read this http://msdn.microsoft.com/en-us/library/fk6t46tz.aspx
and learn using try catch block.

ChauhanAjay 30-Sep-14 22:08pm View

I hope your problem is resolved.

ChauhanAjay 30-Sep-14 21:55pm View

Can you execute the following query in sql server management studio. I hope you understand sql sever management studio where we execute queries in sql server.
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 convert(datetime, Date, 103) >= '1/8/2014' AND convert(datetime, Date, 103) <= '31/8/2014'

and let me know the result.

ChauhanAjay 30-Sep-14 21:49pm View

what is the database you are using

ChauhanAjay 30-Sep-14 21:40pm View

You have two things in the combobox once is the text which you see from outside and the other is the value which is used for internal coding purpose. One you select outside is "August" but the one you use in the coding part according to your html should be "8". Now can you tell me what is the value Me.cmbMonth.SelectedValue.

ChauhanAjay 30-Sep-14 21:32pm View

What is the value of "monthName" when you select the month from the cmbMonth

ChauhanAjay 30-Sep-14 21:23pm View

First of all let the query display the data then you can think of adding whatever you want. Have you found out why the query is not displaying the data.
Have you used the try catch block in your code in case there is a problem in your query it will help you to fix your query.

ChauhanAjay 30-Sep-14 12:10pm View

In page_load method add the following lines and then check
If Not IsPostBack
Me.cmbMonth.SelectedValue = DateTime.Now.Month
End If

ChauhanAjay 30-Sep-14 3:24am View

I have moved this line smtpClient.DeliveryMethod = SmtpDeliveryMethod.Network; above
smtpClient.Credentials = new System.Net.NetworkCredential("eruoghene507@gmail.com", "this is fun");

Kindly check now as it has worked for me.

ChauhanAjay 30-Sep-14 3:17am View

can you update your code with all the changes, which include the html part as well.

ChauhanAjay 30-Sep-14 3:11am View

Was it working before making the code changes.

ChauhanAjay 30-Sep-14 3:00am View

Kindly debug the code you should be able to solve it.

ChauhanAjay 30-Sep-14 2:58am View

Request you kindly accept the answer as solved.

ChauhanAjay 30-Sep-14 2:43am View

I don't get what you say can kindly explain.

ChauhanAjay 30-Sep-14 1:11am View

Just set the value of your cmbMonth to this in the page load event

cmbMonth.SelectedValue = DateTime.Now.Month;
DateTime.Now.Month will give you the value for current month.

ChauhanAjay 30-Sep-14 0:59am View

Change this line from
Dim year As Integer = 2014
to
Dim year As Integer = DateTime.Now.Year;

Here DateTime.Now.Year will give you the current year.
For example if the year is 2014 then it will return 2014 and if it is 2015 then it will return 2015. Try this and let me know.

ChauhanAjay 29-Sep-14 23:02pm View

Can you kindly accept the answer and mark it as solved.

ChauhanAjay 29-Sep-14 22:38pm View

Can you accept the answer as solved if it has helped.

ChauhanAjay 29-Sep-14 21:55pm View

Kindly check the image link below and let me know if you don't see a dialog box as described in the image.
http://steppic.com/preview/73f44db94b64926fddc70a8839f21078.png

ChauhanAjay 29-Sep-14 21:43pm View

are you sure it didn't work? because i tried the code myself and then only have given you the answer.

ChauhanAjay 27-Sep-14 1:43am View

From the code above you create a folder with name of the student and store his/her image in that folder. Now you will have store the path in the database and use a image field to display them back on the gridview.

ChauhanAjay 26-Sep-14 12:29pm View

1. First of all your update statement is wrong. The update statement would be something like this "update tablename set columnname=value where idcolumn = idvalue".

2. You are using a variable with the name "i" I don't find any declaration of that variable.

ChauhanAjay 26-Sep-14 10:03am View

I have put the above lines in the solution can you kindly accept the solution as solved.

Thanks.

ChauhanAjay 25-Sep-14 23:55pm View

You could use it this way
Category Name :
in your html portion of the page.

To display your category name. In the similar manner you can use the method to display other items too.

Hope I understood your question in a correct manner.

ChauhanAjay 25-Sep-14 7:44am View

Sorry for the first link. there is another link I have added kindly check and hope it helps.

ChauhanAjay 25-Sep-14 6:18am View

Check this link for the error
http://www.codeproject.com/Questions/583412/BothplusDataSourceplusandplusDataSourceIDplusarepl

Hope it helps

ChauhanAjay 25-Sep-14 2:11am View

Thanks MuhammadUSman1

ChauhanAjay 25-Sep-14 0:48am View

I already provided the solution in your last question http://www.codeproject.com/Questions/821864/Im-using-below-code-for-keypress-searching-in-grid?arn=0

ChauhanAjay 24-Sep-14 23:26pm View

Try to trim the values and check.

ChauhanAjay 24-Sep-14 22:42pm View

You could use the exit for if the condition is satisfied. Sorry for my last comment I misunderstood the code for c#.

ChauhanAjay 24-Sep-14 22:36pm View

Deleted

Try using the break statement inside your if condition.

ChauhanAjay 24-Sep-14 22:01pm View

None of your datatextfield or datafield match with the names in your query. Are you sure you are able view data on the gridview and not getting any errors.

ChauhanAjay 24-Sep-14 21:42pm View

You could use any one of the two apporaches below
Approach 1:

You could take a backup of the database on the source and restore it in the destination computer.

Approach 2:
In sql server you have an option to copy database from one sql server to the other sql server you can use this method too.

ChauhanAjay 24-Sep-14 21:39pm View

Can I have the query which populates the gridview?

ChauhanAjay 24-Sep-14 21:07pm View

Check the updated code. I have two response.write statements in the code. When you click the button the response.write statement will print the values of the variables matricNo and sql on the browser can you send me both the values.

ChauhanAjay 24-Sep-14 21:03pm View

Does it say something like this "Index was out of range error" when you click the button.

ChauhanAjay 24-Sep-14 4:35am View

Where did this "Dim NoMatrik As String = gvSenSemak.DataKeys(CurrentRowIndex).Value" cum from i did not observer it earlier. It is not a part of the code which you have have pasted.

ChauhanAjay 24-Sep-14 0:05am View

what does "resequence();" method do?

ChauhanAjay 23-Sep-14 23:26pm View

Sorry for the mistake. Copied CurrentRowIndex for some other answer and pasted it here. I have changed it to "index" is the row index of the gridview which we are using in our current code.

ChauhanAjay 23-Sep-14 23:23pm View

I have update the solution with the code kindly test and let me know the result.

ChauhanAjay 23-Sep-14 23:09pm View

Change this from
<asp:ButtonField DataTextField="MatricNo" CommandName="cmdSelect" HeaderText="Matric No" meta:resourcekey="ButtonFieldResource1" HeaderStyle-Width="15%" >

<asp:ButtonField DataTextField="Name" HeaderText="Name" HeaderStyle-Width="32%">

TO

<asp:ButtonField DataTextField="MatricNo" CommandName="cmdSelect" HeaderText="Matric No" meta:resourcekey="ButtonFieldResource1" HeaderStyle-Width="15%" />

<asp:ButtonField DataTextField="Name" HeaderText="Name" HeaderStyle-Width="32%" />

Please check the updated solution.
Try it out and let me know the result.

ChauhanAjay 23-Sep-14 23:03pm View

can you kindly update your code here.

ChauhanAjay 23-Sep-14 22:24pm View

Can we have the code of your .aspx page which contains the gridview?

ChauhanAjay 23-Sep-14 17:53pm View

echo $sql; // add this line to your code below your sql query in check.php And let me know the result

ChauhanAjay 23-Sep-14 14:01pm View

Can you echo your select query in the variable $sql in check.php if all the values are correct or not?
for example you have used a variable $tbl is it being replaced with the value "bruger" or not.

ChauhanAjay 23-Sep-14 5:14am View

Change the below from
commandargument="<%#Eval("Id")%>"
To
commandargument='<%#Eval("Id")%>'

and it should work properly.

ChauhanAjay 23-Sep-14 4:51am View

Can you kindly accept the answer as solved if it has helped you.

ChauhanAjay 23-Sep-14 3:10am View

Check if the status of that id you have selected from the front end is 2 or not in the database.
For example you have click a select button and the id you are getting is '1' now check if the status for that id '1' is 2 or not.
You will only be able to view the data if the status '2'. May be you are trying to check for id where the status value is not 2 in the database.

ChauhanAjay 23-Sep-14 2:47am View

this is the where condition
a.MatricNo='"& row.Cells(0).Text &"'" correct.

what is the value of row.Cells(0).Text and if this value exists in the database table from the column MatricNo

ChauhanAjay 23-Sep-14 1:30am View

Request your to kindly accept the answer as solved.

ChauhanAjay 22-Sep-14 23:27pm View

What wrong with the answer?
Please anybody down voting, can you place a reason here so that I can improve on my answer or may not even answer until I am 100% sure.

ChauhanAjay 22-Sep-14 23:04pm View

do you know how to debug the code?

ChauhanAjay 22-Sep-14 22:42pm View

if there is any exception it will write the exception on the browser.

ChauhanAjay 22-Sep-14 22:39pm View

Can you debug and check the query what is the value against "a.MatricNo" field in the where condition and let me know if that is the correct value or not.

ChauhanAjay 22-Sep-14 22:32pm View

What about the result are you able to get the correct result.
I am not sure why the writing becomes larger.

ChauhanAjay 22-Sep-14 22:09pm View

I dont understand what you are trying to say

ChauhanAjay 22-Sep-14 21:39pm View

What are we talking about webforms or winforms?

ChauhanAjay 22-Sep-14 21:37pm View

What is the name of the column for MatricNo in the gridview.

ChauhanAjay 22-Sep-14 21:26pm View

Can you try using the try catch block in your code so that it displays the error and may be we can get closer to your problem.

ChauhanAjay 22-Sep-14 21:23pm View

You are using a file config.php in check.php what does it contain?
Are config.php and tilslut.php the same i.e., both contain the same content?
Why haven't you included the session_start() in the check.php page?

ChauhanAjay 22-Sep-14 21:15pm View

Basing on which value do you want to display the result. For example I thought that basing on MatricNo you are going to display the values of each row. But when you have run the query you say you don't find any records.

ChauhanAjay 22-Sep-14 13:13pm View

So you do all the checking in the login.aspx.cs page correct. Then you could use a session to store the username of the logged in member and then you could assign the session value to the label2.text. Hope this helps.

ChauhanAjay 22-Sep-14 13:11pm View

I understand that gridview is in asp.net so I have chosen an asp.net example or am I confused between webforms and windows forms. Can you kindly guide me.

ChauhanAjay 22-Sep-14 13:03pm View

The page_load event in which page is it?

ChauhanAjay 22-Sep-14 12:57pm View

TextBox1.Text was just a sample. Please use the name of the textbox in which you collect the username from the user.

What is the name of the page where you written the above code.

ChauhanAjay 22-Sep-14 12:41pm View

He has gone wrong there I suppose. He should have put the textbox value instead of the label value. After retrieving the data he should have populated the text.

ChauhanAjay 22-Sep-14 5:00am View

I have given that solution basing on Mohi Uddin's script.

ChauhanAjay 22-Sep-14 4:19am View

Try adding this to your textbox in asp.net ' ClientIDMode="Static"'. JQuery can then recognize your textbox. Kindly try and let me know the result.

ChauhanAjay 22-Sep-14 3:20am View

Can you kindly add a try catch block in your button click event and check what is the exact error message.

Suggestion:- While coding please don't forget to add try catch block.

ChauhanAjay 22-Sep-14 2:20am View

Sorry I dont understand what you want to say.

ChauhanAjay 21-Sep-14 23:53pm View

Try changing your query from

sql = "SELECT 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')"

To

sql = "SELECT 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' and a.MatricNo='"& index.ToString() &"')"

Try the above query and let me know the result.

ChauhanAjay 21-Sep-14 23:38pm View

You mean to say that if you have a "Select" button on row1 then when you click on the select button it should display the data related to that row "row1". Kindly let me know if I have understood your problem in a correct manner, if not kindly correct me.

ChauhanAjay 21-Sep-14 19:21pm View

request you kindly accept the answer as solved.

ChauhanAjay 21-Sep-14 9:29am View

request you to kindly accept the answer as solved.

ChauhanAjay 21-Sep-14 3:41am View

I like your answer also. +5 for you.

ChauhanAjay 21-Sep-14 1:48am View

Why is the answer downvoted?
Can anybody tell me what is wrong in the answer?

ChauhanAjay 21-Sep-14 1:19am View

Basing on which column will you check for duplicates?

ChauhanAjay 20-Sep-14 0:00am View

Try checking this tutorial
http://www.codeproject.com/Articles/610359/JqGrid-Inline-Editing

May be it helps.

ChauhanAjay 19-Sep-14 2:59am View

Thanks for correcting me I will change that to ID

ChauhanAjay 18-Sep-14 23:23pm View

You want a exact replica of Table1 with a new name Table2?
Do you also want the data from Table1 to Table2?

ChauhanAjay 18-Sep-14 22:56pm View

Have you tried removing the percentage and converting both the values to double or integer and the compare it and change the color.

Hope this helps.

ChauhanAjay 18-Sep-14 21:30pm View

Thanks for the upvote.
Your approach will also work and +5 for that too.

ChauhanAjay 18-Sep-14 12:28pm View

Yes you will have two date picker controls and basing on the selection you can filter your datatable between the date's and bind it back to the datagridview.

ChauhanAjay 18-Sep-14 9:39am View

Please check the updated solution hope it helps.

ChauhanAjay 17-Sep-14 21:47pm View

You don't need to use the "GO" statements just remove the "GO" statement. You may concatinate your query's and then execute them using the cmd.ExecuteNonQuery(). Kindly try out and let me know the result.

ChauhanAjay 17-Sep-14 3:03am View

For whoever has downvoted please provide the reason for the downvote which will help me give a better answer next time.

ChauhanAjay 16-Sep-14 23:04pm View

if you are showing the name of the place in the div tag below the image, then set that value to the alt attribute of the image.

ChauhanAjay 16-Sep-14 13:11pm View

You mean you want to take a backup of the database using c#

ChauhanAjay 16-Sep-14 5:30am View

Have you tried downloading the sample project and going throught it?

ChauhanAjay 15-Sep-14 9:31am View

Deleted

You might not have local SMTP but can't you use gmail smtp or any other smtp.

ChauhanAjay 15-Sep-14 2:25am View

For those who have downvoted the answer kindly write the reason for your downvote so that i can take care for my next answers on the website.

ChauhanAjay 15-Sep-14 0:39am View

Now change the below line to
Dim FirstDate As New DateTime(year, monthNo, 1)
to
Dim FirstDate As New DateTime(year, Convert.ToInt32(Me.cmbMonth.SelectedValue.ToString), 1)

ChauhanAjay 15-Sep-14 0:16am View

can you check what is the value for Me.cmbMonth.SelectedValue.

ChauhanAjay 15-Sep-14 0:05am View

it is going to covert the date in your application to this format 15/09/2014 only in the where condition not the values in the table.

ChauhanAjay 14-Sep-14 23:24pm View

change the sql query from
sql = "SELECT Row_Number() OVER(ORDER BY b.Date) AS ROWNUMBER, a.Name, b.MatricNo, b.Date, b.KaunselingID " _
& "FROM DbStudent.dbo.SMP01_Personal AS a " _
& "INNER JOIN dbo.Kaunseling AS b ON a.MatricNo = b.MatricNo " _
& "WHERE Date >= '"& FirstDate &"' AND Date <= '"& LastDate &"'"
to

sql = "SELECT Row_Number() OVER(ORDER BY b.Date) AS ROWNUMBER, a.Name, b.MatricNo, b.Date, b.KaunselingID " _
& "FROM DbStudent.dbo.SMP01_Personal AS a " _
& "INNER JOIN dbo.Kaunseling AS b ON a.MatricNo = b.MatricNo " _
& "WHERE convert(datetime,Date,103) >= '"& FirstDate &"' AND convert(datetime,Date,103) <= '"& LastDate &"'"

I hope this should solve your problem

ChauhanAjay 14-Sep-14 23:15pm View

Value in the variable firstdate is '15/09/2014' or '09/15/2014'

ChauhanAjay 14-Sep-14 23:01pm View

Deleted

can i have the table design. if the column name is correct then it should work.

ChauhanAjay 14-Sep-14 22:53pm View

what is the name of this column in your table.

ChauhanAjay 14-Sep-14 21:40pm View

The table structure show in the image is for the table name site_config table and the query is related to the users tables. Can I know what is the relationship between these two tables.

ChauhanAjay 14-Sep-14 21:38pm View

I would like to see your table design.
Do you have field named date in any of your tables if not this query will not work.

ChauhanAjay 14-Sep-14 21:23pm View

Can I have your table structure for both the tables.

ChauhanAjay 13-Sep-14 9:54am View

You have mentioned that all the columns in your table are not null. So you will have to put a value in it. If you not entering any value then what are your storing in those columns.

ChauhanAjay 13-Sep-14 8:59am View

Try getting your data in this format
string data = @"[{""ProductId"":""1"",""ProductName"":""Chai""},"
+ @"{""ProductId"":""2"",""ProductName"":""Chang""},"
+ @"{""ProductId"":""3"",""ProductName"":""Aniseed Syrup""}]";
Hope this suggestion helps.

ChauhanAjay 13-Sep-14 4:40am View

Have you checked the values of $_POST["first_name"] and the rest

ChauhanAjay 13-Sep-14 4:06am View

what is the error you received?

ChauhanAjay 12-Sep-14 3:09am View

Why don't you use a dropdown instead of restricting the user from entering a values from 1 to 12.

ChauhanAjay 11-Sep-14 22:38pm View

Is it possible for you to exclude the null categories from your query?

ChauhanAjay 11-Sep-14 6:19am View

are you using windows forms or web forms

ChauhanAjay 11-Sep-14 5:15am View

change that line to
$_SESSION['username'] = $username;
and same goes for password tooo.

ChauhanAjay 11-Sep-14 5:08am View

Change the first query from
select MAX(GroupId) from tbl where GeneralId in ('3','2') Group by GroupId
to
select MAX(GroupId) from tbl where GeneralId in ('50000','10000') Group by GroupId

and the above query should give you the result

ChauhanAjay 11-Sep-14 4:50am View

Change this

sql = "SELECT Row_Number() OVER(ORDER BY a.Date) AS ROWNUMBER, a.Name, b.MatricNo, b.Date, b.KaunselingID " _
& "FROM DbStudent.dbo.Personal AS a " _
& "INNER JOIN dbo.Kaunseling AS b ON a.MatricNo = b.MatricNo " _
& "WHERE Date >= (2014-01-01('" & FirstDate & "')) AND Date <= (2014-12-31('" & LastDate & "'))"

To

sql = "SELECT Row_Number() OVER(ORDER BY a.Date) AS ROWNUMBER, a.Name, b.MatricNo, b.Date, b.KaunselingID " _
& "FROM DbStudent.dbo.Personal AS a " _
& "INNER JOIN dbo.Kaunseling AS b ON a.MatricNo = b.MatricNo " _
& "WHERE Date >= ('" & FirstDate & "') AND Date <= ('" & LastDate & "')"
and let me know the result.

ChauhanAjay 11-Sep-14 4:38am View

basically what they are trying to do there is to get the monthnumber and then build the firstdate and the lastdate.

for example
if you select september then the monthnumber will be 9, firstdate will 01-09-2014 and the lastdate will be 30-09-2014 and you can fetch the data for the dates in between them.

ChauhanAjay 11-Sep-14 3:52am View

You can change the line to
Convert.ToDateTime("01-" & monthName & "-" & year).Month

ChauhanAjay 11-Sep-14 3:44am View

Yes you are correct your date will display 01-09-2014.

ChauhanAjay 11-Sep-14 3:38am View

Here in that line they are trying to build a date like 01-September-2014 and from there get the month number like '09' for September

ChauhanAjay 10-Sep-14 23:52pm View

I thought that Date is the name of the column you are using to compare the dates. You need to put the correct date column in place of DATE or else remove the date condition from your query.

ChauhanAjay 10-Sep-14 23:11pm View

Which database are you using for the application?
I have considered it as sql server and for sql server "DATENAME(MONTH, DATE)" will return the month name of the date which you have supplied.
for example if the date is 09/11/2014 then it will return the month name as September.

ChauhanAjay 10-Sep-14 22:58pm View

Try changing the firstdate to FirstDate.ToString("yyyy-MM-dd") and the lastdate to the same format if you say that the date is wrong

ChauhanAjay 10-Sep-14 22:44pm View

Deleted

What is the database for this application?
Which date is wrong?

ChauhanAjay 10-Sep-14 22:37pm View

Yes you must type that.
After updating the code debug it and copy the value of the variable sql and run it in management studio and see whether it is giving the result or not.

ChauhanAjay 10-Sep-14 22:18pm View

In the code above your monthName variable is assigned to empty.
I hope it should be assigned to the combobox value.
Change the following line
Dim monthName As String = ""
to
Dim monthName As String = Me.cmbMonth.SelectedValue

and query to
sql = "SELECT a.Name, b.MatricNo, b.Date, b.KaunselingID " _
& "FROM DbStudent.dbo.Personal AS a " _
& "INNER JOIN dbo.Kaunseling AS b " _
& "ON a.MatricNo = b.MatricNo " _
& "WHERE DATENAME(MONTH, DATE) = '" & monthName & "'" _
& "AND Date BETWEEN '"& FirstDate &"' AND '"& LastDate &"'"

Try these things and let me know the result

ChauhanAjay 10-Sep-14 22:05pm View

What will be the value of the variable monthName in the query. For example will it Jan or January.

ChauhanAjay 9-Sep-14 5:08am View

Change the function like this.
function findEmployee($fillEmpNumCombo){
$result = mysql_query( "SELECT firstname, lastname FROM Pay_Employee WHERE EmployeeNo='$fillEmpNumCombo'" );
$row = mysql_fetch_array($result);
return $row;
}

ChauhanAjay 9-Sep-14 4:43am View

You will need to return the whole array and not $row[0] or $row[1]. Just return $row.

ChauhanAjay 9-Sep-14 2:09am View

Deleted

tmpCell.Text += "<a href='#' runat="server" önclick='<% album_review();%>' style='height:7px;width:40px;border:outset'>download";

change the above line to the following and then check

tmpCell.Text += "<a href='#' runat='server' onclick='<% album_review();%>' style='height:7px;width:40px;border:outset'>download";

ChauhanAjay 9-Sep-14 2:01am View

You cannot call a server side function from client side link.
Instead of using a client side link you could use a hyperlink button and call its click event.

ChauhanAjay 9-Sep-14 0:32am View

Just check the below link
www.codeproject.com/Tips/669509/How-to-Export-Data-to-Excel-in-VB-NET

It contains the full code to export to excel. Hope it helps.

ChauhanAjay 8-Sep-14 22:53pm View

Did you debug to find out about the error?
On which line do you receive this error?

ChauhanAjay 8-Sep-14 21:07pm View

Please follow the steps below.

1. Make your function return an array with fistname in 0th index and the lastname in the 1st index.
2. Take the value of the array in the php1 file and set the value of 0th index to the firstname textbox and 1st index to the lastname text box.

for example:
Consider the array $arr[0] = "a" and $arr[1]="b" then you will need to
<input type="text" name="firstName" class="password" placeholder="First Name" value="">
<input type="text" name="lastName" class="password" placeholder="Last Name" value="">

Hope the above solution helps.

ChauhanAjay 8-Sep-14 1:47am View

Try this link
http://www.aspsnippets.com/Articles/Dynamically-change-GridView-Row-Background-Color-based-on-condition-in-ASPNet-using-C-and-VBNet.aspx

Hope it helps

ChauhanAjay 7-Sep-14 22:55pm View

Check this link out hope it helps.
http://vivekkalady.blogspot.in/2012/09/Grid-Filter.html

http://www.misfitgeek.com/filtering-an-asp-net-gridview-control-with-jquery/

ChauhanAjay 6-Sep-14 23:41pm View

Is the data not being display 15 records at a time instead of random records.

ChauhanAjay 6-Sep-14 3:10am View

You could use an array list to store the values. Retrieving values from the arraylist is same as an array.

ChauhanAjay 5-Sep-14 22:52pm View

Check this out
http://www.phpeasystep.com/phptu/12.html
http://code.tutsplus.com/tutorials/how-to-create-a-phpmysql-powered-forum-from-scratch--net-10188

ChauhanAjay 5-Sep-14 21:50pm View

Check this url
http://stackoverflow.com/questions/18588029/zend-and-wamp-configuration

ChauhanAjay 5-Sep-14 20:33pm View

What is the error u r getting in your update statement

ChauhanAjay 4-Sep-14 21:59pm View

Deleted

You will have to write the DataListImageGallery_SelectedIndexChanged event and in that event you could populate the DataListImages basing on the gallery id. Hope this helps

ChauhanAjay 3-Sep-14 20:11pm View

Kindly check in the önkeyup o has two dots above it, please change it to normal o.
Change the following line from
<textarea class="required" id="message" name="message" placeholder="Your message" önkeyUp="copyText()" ></textarea>

to

<textarea class="required" id="message" name="message" placeholder="Your message" önkeyUp="copyText()" ></textarea>

Hope this helps

ChauhanAjay 2-Sep-14 13:22pm View

what kind of validations are you looking at?

ChauhanAjay 2-Sep-14 4:12am View

You could been use jquery and ajax too

ChauhanAjay 2-Sep-14 3:37am View

xmlHttp.onreadystatechange=function()
{
if (xmlHttp.readyState==4 && xmlHttp.status==200)
{
//result from the php page if any
}
}

This part is only required if you have to get anything back from the php page.
It was just for checking that the value which you echoed in the php page is returned to your html page or not.

ChauhanAjay 2-Sep-14 3:24am View

It is a good practice to have it so i have put in the form tag. As i have seen in some browsers where the controls dont get displayed if the form tag is not used. Sorry dont remember the browser names.

ChauhanAjay 1-Sep-14 3:15am View

Try this
Declare @SQLQuery as nvarchar(2000)
SET @SQLQuery ='SELECT * from Employee Where (1=1)'
If (@StartDate is not NULL) AND (@EndDate is not NULL)
Set @SQLQuery = @SQLQuery + ' And (JoinDate
BETWEEN '''+ @StartDate +''' AND '''+@EndDate+''')'
Exec (@SQLQuery)

ChauhanAjay 1-Sep-14 1:57am View

No you dont need to change sorry for the misunderstanding.
DropDownList cmb = (DropDownList)sender;
if (cmb.SelectedValue.ToString().Equals("Something")
{
//Do Something
}

The above change should do.

ChauhanAjay 1-Sep-14 0:42am View

Check the below link may be it helps
http://stackoverflow.com/questions/8546180/dlookup-multiple-tables-and-set-textbox-to-result-access-2007

ChauhanAjay 1-Sep-14 0:03am View

Are you using a datatable to bind the data to the grid.

ChauhanAjay 31-Aug-14 22:22pm View

Now you will need to write a query to get the page details from the page access table basing on the role of the user who has logged in.

ChauhanAjay 31-Aug-14 21:07pm View

Does you page access table have any relation with the userlogin or the role table because without any relationship it would be difficult to get the page access details of the user.

ChauhanAjay 30-Aug-14 14:25pm View

you are welcome

ChauhanAjay 30-Aug-14 12:10pm View

Dim dt1 as New DataTable
da1 = New SqlDataAdapter("select Name from City where City.StateId ='" + cmbstate.SelectedValue.ToString() + "'", con)

da1.Fill(dt1)
cmbcity.DataSource = dt1
cmbcity.DisplayMember = "City.Name"
cmbcity.ValueMember = "City.Name"

ChauhanAjay 30-Aug-14 12:02pm View

Dim dt1 as New DataTable
da1 = New SqlDataAdapter("select Name from City where City.StateId ='" + Convert.ToString(cmbstate.SelectedValue) + "'", con)

da1.Fill(dt1)
cmbcity.DataSource = dt1
cmbcity.DisplayMember = "City.Name"
cmbcity.ValueMember = "City.Name"

ChauhanAjay 30-Aug-14 11:47am View

better to change your dataset ds1 to a datatable dt1.

ChauhanAjay 30-Aug-14 11:22am View

on which line do u get the error

ChauhanAjay 29-Aug-14 13:39pm View

where in your code you are populating the sqldatareader

ChauhanAjay 29-Aug-14 11:10am View

check this link http://www.nopcommerce.com/boards/t/1989/500-internal-server-error-with-godaddy-iis7.aspx

Hope it helps

ChauhanAjay 29-Aug-14 11:01am View

can you please mark as solved

ChauhanAjay 29-Aug-14 10:55am View

for($day = 1 ; $day >= 30; $day++) this line is the problem. the condition part in your for loop is wrong. the condition will never be satisfied so it wont go inside.

ChauhanAjay 29-Aug-14 10:54am View

Try this link
http://www.codeproject.com/Articles/2483/Dynamic-Webcam-Image

ChauhanAjay 29-Aug-14 10:06am View

Just have a look at this link
http://www.codeproject.com/Questions/419124/Dropdownlist-in-header-template-of-gridview
hope it is helpful

ChauhanAjay 29-Aug-14 9:57am View

Do you mean that the dropdownlist will be the header in the gridview

ChauhanAjay 29-Aug-14 8:54am View

Try this link.
http://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/sorting-filtering-and-paging-with-the-entity-framework-in-an-asp-net-mvc-application

ChauhanAjay 29-Aug-14 6:40am View

$bwords = aray("admin", "mod");
To
$bwords = array("admin", "mod");

ChauhanAjay 29-Aug-14 6:22am View

Deleted

Which is the 44th line

Comments by ChauhanAjay (Top 200 by date)