Comments by ankur789 (Top 86 by date)

This will not give the recored in same row. The resut will be shown in two rows.
I wants result in one row

Sir incorrect syntax near pivot

incorrect syntax near pivot

one by one

Table1
-------------
ID Name
1 A
2 B
3 C


Table2
--------
ID Name
1 Z
I need to insert data from Table1 to Table2 and I can use following sytax for the same:-

INSERT INTO Table2(Id, Name) SELECT Id, Name FROM Table1
However, In my case duplicate Ids might exist in Table2 (In my case Its Just "1") and I dont want to copy that again as that would throw an error.

I can write something like this:-

IF NOT EXISTS(SELECT 1 FROM Table2 WHERE Id=1)
INSERT INTO Table2 (Id, name) SELECT Id, name FROM Table1
ELSE
INSERT INTO Table2 (Id, name) SELECT Id, name FROM Table1 WHERE Table1.Id<>1

select CustomerA.sendername,CustomerA.sendermobileno,CustomerA.sendtoname,customerb.name,customerb.mobileno from CustomerA join customerB on customerA.id=customerB.id

sir output is in grid

and sir my complete database is in the sql server 2000 through which i manage other databases like library ,mess mang etc so i only added certain tables in my previous database and continuous my work

this is also an unwanted condition and i never find such like a problem so i do not understand why this condition occurs

what is your advice to do

sir now you understood what i want ,now sir what i do for such a answer

date1 date2 hkey
07/11/2013 10/11/2013 1
10/11/2013 11/11/2013 2
15/11/2013 17/11/2013 3
this is my table

now when i have a form which has two datetime pickers
now i select in both 09/11/2013
so now i want to check is in my table there is a range for 09/11/2013
yes i have the range which is
07/11/2013 10/11/2013 1
so the answer will be this range from my query then what is the query so that i found such a answer

sir what exactly i want is now in updated ques please help me in such a matter,

i m trying to got my answer but failed,

while the answer should be
07/11/2013
10/11/2013

because 9 is in this range

sir i select 09/11/2013
then your query will be
select date1 from h_leave
where (date1 between '2013/11/09' and '2013/11/09')
union all
select date2 from h_leave
where (date2 between '2013/11/09' and '2013/11/09')


but please check in my table there is a row between this range the row consists 07/11/2013 as date1 and 10/11/2013 as date2

but fromyour query the answer i got as null

sir same answer i found
date1
07/11/2013
10/11/2013
15/11/2013

sir my other code for omr sheet working module in visual studio 2005
so i want to read barcode from omr sheet through a particular button with my omr sheet module.so i want to use visual studio 2005

in visual studio 2010it takes 4 to 5 seconds

in visual studio 2005 it takes 108 second

sir i already use get barcode from image but it works in visualstudio 2010 but in the visual studio the code take 108 seconds to get barcode which is too delay

while in visual studio code takes 4 to 5 seconds so i want other reference
i am using the reference
http://www.codeproject.com/Articles/42852/Reading-Barcodes-from-an-Image-III

above comment is for rollno1

sir in my table i have 300(100+100+100)maxmarks and 200(60+70+70)obtmarks
i want the output given in my ques.
i do'nt understand how i do it ,am i use case or anyother

first link i referred but there is a problem because i am using vb as default language so
HttpContext.Current("key") = me.textbox1.text

shows an error as
cannot be indexed beacause it has no default value

sir AT client side it is already in dd/MM/yyyy format

sir i have a table in which i have student roll no and image .
how can i get image on selecting stud_roll_no

yes sir i am implemented same way but at the code when debug today date is fetch only

sir now in the text box date is fetching but onle today date is fetch when i change the date from the calendern extender the changedate is displayed in the texbox but while debug the code message box shows today date only

but while debug my code in the message box MsgBox(txt_frmdate.Text)
value i find is blank

yes sir in text box date is showing

</td>
<td style="width: 100px">
</td>
<td style="width: 100px">
</td>
</tr>
<tr>
<td style="width: 100px">
<asp:Label id="Label3" runat="server" Font-Bold="True" Font-Names="Arial" Font-Size="Larger"
ForeColor="Black" Text="Phone No" Width="176px"></td>
<td style="width: 100px">
<asp:TextBox id="txt_p_no" runat="server" Width="128px">
</td>

</tr>
<tr>
<td style="width: 100px">
<asp:Label id="Label4" runat="server" Font-Bold="True" Font-Names="Arial" Font-Size="Larger"
ForeColor="Black" Text="Course" Width="176px"></td>
<td style="width: 100px">
<asp:TextBox id="txt_course" runat="server" Width="128px">
</td>
<td style="width: 100px">
<asp:Label id="Label7" runat="server" Font-Bold="True" Font-Names="Arial" Font-Size="Larger"
ForeColor="Black" Text="Student Type" Width="120px"></td>
<td style="width: 100px">
<asp:TextBox id="txt_stud_type" runat="server" Width="128px">
</td>
</tr>
<tr>
<td style="width: 100px; height: 26px">
<asp:Label id="Label5" runat="server" Font-Bold="True" Font-Names="Arial" Font-Size="Larger"
ForeColor="Black" Text="Branch" Width="120px"></td>
<td style="width: 100px; height: 26px">
<asp:TextBox id="txt_branch" runat="server" Width="128px">
</td>
<td style="width: 100px; height: 26px">
<asp:Label id="Label6" runat="server" Font-Bold="True" Font-Names="Arial" Font-Size="Larger"
ForeColor="Black" Text="Batch" Width="120px"></td>
<td style="width: 100px; height: 26px">
<asp:TextBox id="txt_batch" runat="server" Width="128px">
</td>
</tr>
</table>
<br />
<table style="width: 264px; height: 24px;" id="TABLE1" önclick="return TABLE1_onclick()">
<tr>
<td colspan="3" style="height: 20px; width: 107px;">
<asp:Label id="Label8" runat="server" Font-Bold="True" Font-Names="Arial" Font-Size="X-Large"
ForeColor="Maroon" Text="Leave Reason" Width="176px"></td>
</tr>
<tr>
<td colspan="3" style="height: 6px; width: 107px; text-align: left;" align="left">
<asp:Label id="Label9" runat="server" Font-Bold="True" Font-Names="Arial" Font-Size="Larger"
ForeColor="Black" Text="Why" Width="128px"></td>
<td colspan="3" style="height: 6px">
<asp:TextBox id="txt_why" runat="server" Width="560px">

</td>
</tr>
<tr>
<td colspan="3" style="height: 1px; width: 107px; text-align: left;" align="left">
<asp:Label id="Label10" runat="server" Font-Bold="True" Font-Names="Arial" Font-Size="Larger"
ForeColor="Black" Text="Where" Width="120px"><br />
</td>
<td colspan="1" style="height: 1px">
<asp:TextBox id="txt_where" runat="server" Width="192px"><br />
</td>
<td colspan="1" style="width: 3px; height: 1px">
<asp:Label id="Label11" runat="server" Font-Bold="True" Font-Names="Arial" Font-Size="Larger"
ForeColor="Black" Text=

complete page is




<%@ Page Language="VB" MasterPageFile="~/MasterPage2.master" AutoEventWireup="false" CodeFile="Student Application.aspx.vb" Inherits="Student_Application" title="Untitled Page" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<asp:Content ID="Content1" ContentPlaceHolderID="studPlaceHolder1" Runat="Server">
<script language="javascript" type="text/javascript">
// <!CDATA[

function TABLE1_onclick() {

}

// ]]>
</script>

<table style="width: 464px; border-top-style: none; border-right-style: none; border-left-style: none;">
<tr>
<td style="width: 85px; height: 22px;">
</td>
<td style="width: 100px; height: 22px;">
<asp:Label id="lb_active" runat="server" Font-Bold="True" Font-Names="Arial" Font-Size="Larger"
ForeColor="Maroon" Text="Student is not Active" Visible="False" Width="160px"><asp:Label id="lb_empty" runat="server" Font-Bold="True" Font-Names="Arial" Font-Size="Larger"
ForeColor="Maroon" Text="Roll No Fields ca'nt Leave Empty" Visible="False" Width="272px"></td>
<td style="width: 100px; height: 22px">
<asp:Label ID="lb_sub" runat="server" Font-Bold="True" Font-Names="Arial" Font-Size="Larger"
ForeColor="Maroon" Text="Request Has Been Submitted" Visible="False" Width="192px"></td>
</tr>
<tr>
<td style="width: 85px; height: 20px">
<asp:Label id="lb_stud_roll_no" runat="server" Font-Bold="True" Font-Names="Arial"
Font-Size="Larger" ForeColor="Black" Text="Student Roll No" Width="176px"></td>
<td style="width: 100px; height: 20px">
<asp:TextBox id="txt_stud_roll_no" runat="server" BorderStyle="Inset" Width="256px" Height="32px" OnTextChanged="txt_stud_roll_no_TextChanged"></td>
<td colspan="2" style="height: 20px; width: 142px;">
 <asp:Button id="btn_get" runat="server" BackColor="Black" BorderStyle="None" OnClick="btn_get_Click"
Text="Get Record" Width="136px" Height="24px" Font-Bold="True" ForeColor="#E0E0E0" /></td>
</tr>
</table>
<br />
<table>
<tr>
<td style="width: 100px; height: 26px;">
<asp:Label id="Label1" runat="server" Font-Bold="True" Font-Names="Arial" Font-Size="Larger"
ForeColor="Black" Text="Student Name" Width="176px"></td>
<td style="width: 100px; height: 26px;">
<asp:TextBox id="txt_stud_name" runat="server" Width="128px">
</td>
<td style="width: 100px; height: 26px;">
</td>
<td style="width: 100px; height: 26px;">
</td>
<td colspan="2" rowspan="5">
                     <asp:Image
ID="img_stud" runat="server" Height="40px" Width="24px" />
                       
  
                       
     
</td>
</tr>
<tr>
<td style="width: 100px">
<asp:Label id="Label2" runat="server" Font-Bold="True" Font-Names="Arial" Font-Size="Larger"
ForeColor="Black" Text="Father Name" Width="176px"></td>
<td style="width: 100px">
<asp:TextBox id="txt_father_name" runat="server" Width="128px">
<

<asp:TextBox ID="txt_frmdate" runat="server" Width="152px" ReadOnly="True">
<cc1:calendarextender id="CalendarExtender1" TargetControlID="txt_frmdate" Format="dd/MM/yyyy" runat="server">

sir in the web page toolbox there is no datetimepicker
sir while i am working in window application i am always using datetimepiker but in web no datetime picker is there in the toolbox so i am using calender extender with textbox

yes Tadit sir exactly you are right i am doing as you think
sir please help me

sir now blank date i found while debug but in the form i already select the date which is display in textbox

sir same problem is also find in the
Dim dt1 As DateTime
dt1 = DateTime.ParseExact(Me.txt_frmdate.Text, "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture)

thank u sir your answer is really helpful for me

sir question is that how can manage two transaction if both are performs same time even if no difference in the seconds

sir i make a auto suggest box with using java script tha auto suggestion box is working properly but when i select the value from a list of values and that selected value i want to fetch in a variable in my .vb page ,how can i redirect this selected value in the variable

thanx

date1 and date2 is the datetime type field

i use it but find no row

sir i run my site in 3 computers first one is the server 2 others are client
my first page is login
page
but when i put url with any other page in the client computer it is also open directly

Protected Sub b_next_Click(ByVal sender As Object, ByVal e As System.EventArgs)
If Me.dl_course.SelectedIndex = 0 And Me.dl_branch.SelectedIndex = 0 And Me.dl_batch.SelectedIndex = 0 And Me.dl_sem.SelectedIndex = 0 Then
MsgBox("You have not choose right value") here i use <scriptlanguage=""javascript"">alert('You have not choose right value');</script>
Else
Session("course") = Me.dl_course.SelectedIndex
Session("branch") = Me.dl_branch.SelectedIndex
Session("batch") = Me.dl_batch.SelectedIndex
Session("sem") = Me.dl_sem.SelectedIndex
Response.Redirect("studinstructions.aspx")
End If
End Sub

sir i use single quote double quote and without quote also but not working

sir i use java script code is
<script language=""javascript"">alert('You have not choose right value');</script>
but it give error like does not parsing at <script language ja>

sory sir but i am not shouting sir

not working sir

have u code of it

how can i do it sir

error shows incorrect syntax near with

sir i donot understand this

only these four type record
at id 1=excelent
at id 2=good
at id 3=average
at id 4=poor

i want to answer such like
Excellent good Average Poor

it gives result like
id score performance
1 30 excellent
2 15 good

But i want sir
excelent good
30 15

sir it is just like row to column format

here is a problem that when i imports system .linq package then this package is not found in the memory of visual studio 2005

no sir problem is that when i click enter key then values add in the list box .after text change the list box is not populated on the basis of text change of textbox

i want to add such like when i write anku in text box then all the name having string anku populate in the listbox on textbox text change the values automatically change in the list box according to text box string

thanks ma'am ,
But mam one problem is also here.
tell me how this query works means how this query fetch the values

complete summary sir
if possible then coloumn wise

mam here is a problem that i m not doing the selection on the basis of first coloumn let us consider the condition
a b c d
1.0 1.0
now the answer comes as 1.0 occurs 2 times but the query will not give right answer

sir then what query can i use .
i am using count with select but not find such a result i wanr

i want the answer for asp dot with vb as default language it using c# sir

Yes Sir grid view is on the window form and i get the data in it by uploading an excel file in the grid view.

sir i want to check in the database that is there any duplicate value in the database on the basis of datagrid view id field

sir i am using vb as default language so please give me solution according to that

thankx it really help me

Sir these links also give the solution with .cs (c#) dotnet.
But with vb.net problem is as it is.

while i m using vb as a default language then how can i rediect two textbox values to another page

sir i m using vb as default language

sir when i use row 1 then i find an error
out of index

Thank You

sir is it possible to fetch the ip without hosting

Sir how can i do it with student id

Sir
these
year and dob is in datagridview and i used vb.net


is there any way to put date time picker in the datagrid view coloumn.
or
i want to make validation that these columns in the data grid view not take any other value except of type "MM/DD/YYYY"

Sir
these
year and dob is in datagridview and i used vb.net


is there any way to put date time picker in the datagrid view coloumn.
or
i want to make validation that these columns in the data grid view not take any other value except of type "MM/DD/YYYY"

so please tell me about to send the message at a mobile phone

i want to send the message at the mobile phone not at email

i Want only the latest single row in the entries
please provide sql query for it

i have a form designed in vb.net , in this form in one text field i give ∂ sign but when i see in my database the sign changes and become ? is there any solution of such a problem