Click here to Skip to main content
The default search term operator is AND.

You can use brackets, AND, OR, and NOT to improve your search. For example: C# AND NOT(VB or SQL)

A query of a single * will return everything, filtered by any filters.

Filter examples:
Search by Author  author:"author name"
Filter by tag  tag:C# or tag:(C++ or Java)
Wildcard search  use "?" or "*" eg. gr?d or gr*
  
467 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


Page 1 of 10
Page Size: 10 · 25 · 50

Author filtered by: Member 8054539 [x]
how to get the below output by Member 8054539
Question 14 May 2013   license: CPOL
My query as follows select fa.facname,f.bfid,b.class,b.examdate from bthfac f,batch b,faculty fa where month(b.examdate)= '11' and year(b.examdate)= '2012' and b.bthid=f.bthid and fa.facname = 'MADHAVAN'when i execute the above query output as follows;Facname Bfid class ...
C#
Question 14 May 2013   license: CPOL
Allotment table as follows in Ms access database Sdate Period Staff 14/5/2013 1 TR 14/5/2013 2 MD 15/5/2013 1 SG 15/5/2013 2 GV from the above Allotment table, i want the output as follows in ms access database Sdate ...
C#
Question 14 May 2013   license: CPOL
My query as follows; SELECT F.facname, BA.examdate, FD.bfid, FD.rate FROM faculty F JOIN bthfac B ON F.facid = B.facid JOIN facfeedback FD ON FD.bfid = B.bfid JOIN batch BA ON BA.bthid = B.bthid...
C#
Question 14 May 2013   license: CPOL
Query as follows; select Sch_Date,session,Faculty_Code from Tb_SCh_TIme_Table where course = 'cl2'; when i execute the above query,output as follows in Ms access...
C#
Question 13 May 2013   license: CPOL
Tb_Sch_Time_Table table records as follows in Ms Access Database Sch_Date Session Faculty_Code Course4/15/2013 1 DM CL24/15/2013 2 VRV CL24/16/2013 1 VRV CL24/16/2013 2 AKR CL24/17/2013 1 GS CL24/17/2013 2 VRV ...
C#
Question 13 May 2013   license: CPOL
In Tb_Sch_Time_Table records as follows in ms access databaseSch_Date Session Faculty_Code Course4/15/2013 1 DM CL24/15/2013 2 VRV CL24/16/2013 1 VRV CL24/16/2013 2 AKR CL24/17/2013 1 GS CL24/17/2013 2 VRV ...
C#
Question 13 May 2013   license: CPOL
Tb_Sch_Time_Table records as follows in MS access database. Faculty_Code Sch_Date Session CAN 4/15/2013 3 VB 4/15/2013 4 AKR 4/16/2013 3 CAN 4/16/2013 4 VB 4/17/2013 3 UNNI 4/17/2013 4 CAN 4/18/2013 3 UNNI ...
C#
Question 13 May 2013   license: CPOL
Faculty table records as follows:- Facid Faculty 1 MADHAVAN 2 Sekar 3 John 4 vinoth 5 Ramesh Batch table records as follows Bthid Examdate 1 14/9/2011 2 24/10/2011 3 9/12/2011 4...
SQL-Server
Question 12 May 2013   license: CPOL
My code as follows;i show button i written the below code as follows; sql = "SELECT distinct fa.facname,r.rate,f.bthid,CASE WHEN r.rate = '1' THEN '100' WHEN r.rate = '2' THEN '75' WHEN r.rate = '3' THEN '50' WHEN r.rate = '4' THEN '25' ELSE '0' END AS TranslatedRate FROM bthfac AS...
C#
Question 12 May 2013   license: CPOL
select distinct fa.facname,r.rate,f.bfid,b.examdate from bthfac f,batch b,faculty fa,facfeedback r where month(b.examdate)= '9' and year(b.examdate)= '2011' and b.bthid=f.bthid and r.bfid = f.bfid and fa.facname = 'MADHAVAN' when i exeucte the above query i get the below output as...
C#
Question 12 May 2013   license: CPOL
Faculty table as follows; Facid Faculty 1 Sekar2 Vinoth3 Ramesh Bthfac table as follows; Bfid Bthid Facid 1 1 1,22 2 2,33 3 1,3 Facfeedback table as follows Bfid Rate1 Excellent2 Good3 Fair Batch table as follows Bthid Examdate 1...
C#
Question 12 May 2013   license: CPOL
Faculty table as follows; Facid Faculty 1 Sekar 2 Vinoth 3 Ramesh Bthfac table as follows; Bfid Bthid Facid 1 1 1,2 2 2 2,3 3 3 1,3 Facfeedback table as follows Bfid ...
C#
Question 12 May 2013   license: CPOL
Gridview record as follows; Facname Rate Gopi Excellent Sekar Good Ravi Fair Ram Poorthe above record is in gridview,for the above record i want to display in chart.for that how can i do using asp.net with C#please send any...
C#
Question 10 May 2013   license: CPOL
student table Studid Bfid Rate A 1 Good B 2 Fair C 3 ExcellentBatch tableBfid Class 1 EFA 2 MFA 3 COC Code as follows;sql = "Select studid,Bfid,Rate from student";dr =...
C#
Question 8 May 2013   license: CPOL
My code as follows; In page load code as follows; sql = "Select Distinct FacName from Faculty"; try { dr = scon.ReadSql(sql); ListBox1.DataSource = dr; ListBox1.DataTextField = "FacName"; ListBox1.DataBind(); ...
C#
Question 7 May 2013   license: CPOL
I want to use Switch Case in asp.net with C#. for that how can i do using C#.Please help me.Regards,Narasiman P.
C#
Question 7 May 2013   license: CPOL
VB Code as follows; Select Case rs2(0) Case 1 factot1 = factot1 + 100 Case 2 factot1 = factot1 + 75 Case 3 factot1 = factot1...
C#
Question 7 May 2013   license: CPOL
Run mode screen as follows; i have one list box and one drop down list.in list box all the student name will display from the database in the drop down list year will display.in the run mode user select the student name from the listbox.if the use did not select the...
C#
Question 7 May 2013   license: CPOL
Run mode screen as follows; i have one list box as follows; in the Listbox all the faculty name will be displayed. R Ramesh S Suresh V Vignesh R Kumar S Senthil I have one button called Generate Chart Design page code as follows; In page load...
C#
Question 6 May 2013   license: CPOL
Result page code as follows; In result page in page load code as follows; protected void Page_Load(object sender, EventArgs e) { try { Int32 Avg; Avg =...
C#
Question 6 May 2013   license: CPOL
Session["UserName"] = txtuser.Text.ToString().Trim(); Session["StudName"] = TxtName.Text.ToString().Trim(); Session["StudID"] = TxtStudID.Text.ToString().Trim(); I know how to remove sessions using Session.clear(). But I want to remove the session...
C#
Question 6 May 2013   license: CPOL
My query as follows; select Distinct Faculty_Name = (select top 1 facname from faculty f where facid = bfid and FacName = 'G. SEKHAR' and FacName 'null'), Rating = (case rate when '1' then 'Excellent' when '2' then 'Good' when '3' then 'Fair' when '4' then 'Poor' when '0' then 'Not...
C#
Question 6 May 2013   license: CPOL
My query as follows; select Distinct Faculty_Name = (select top 1 facname from faculty where facid = bfid), Rating = (case rate when '1' then 'Excellent' when '2' then 'Good' when '3' then 'Fair' when '4' then 'Poor' when '0' then 'Not Applicable' end) from facfeedback when i ...
C#
Question 6 May 2013   license: CPOL
Result screen page as follows; protected void BtnReExam_Click(object sender, EventArgs e) { Int32 Avg; Avg = Convert.ToInt32(Session["Avg"]); if (Avg
C#ASP.NET
Question 5 May 2013   license: CPOL
i tried but it is not working. Result Screen as follows; Label1 you are scored 80% of marks Label2 sorry you are failed you have to attend the reexam again. Login screen as follows; studentid textbox1 studentname textbox2 i am writing the code in...
C#
Question 5 May 2013   license: CPOL
in asp.net in the toolbox how to get the chart control for that how can i do?please help me how can i do?i want Chart control in the toolbox.i install the mshart.exe and download it.after download it and open my project in the toolbox chart control is not coming?for that...
C#
Question 4 May 2013   license: CPOL
Login screen as follows; Student id textbox1 student name textbox2Result screen as follows; Your are passed congrultions marks is 80% Next Candidate (Button) if the student pass next candidate can attend the examif suppose student is fail...
C#
Question 3 May 2013   license: CPOL
select Faculty_Name = (select top 1 facname from faculty where facid = bfid), Rating = (case rate when '1' then 'Excellent' when '2' then 'Good' when '3' then 'Fair' when '4' then 'Poor' when '0' then 'Not Applicable' end) from facfeedback using my above query output as follows;...
C#
Question 3 May 2013   license: CPOL
select Faculty_Name = (select top 1 facname from faculty where facid = bfid), Rating = (case rate when '1' then 'Excellent' when '2' then 'Good' when '3' then 'Fair' when '4' then 'Poor' when '0' then 'Not Applicable' end) from facfeedback using my above query output as follows; ...
C#
Question 3 May 2013   license: CPOL
passing the database value using session and redirect to another page. My code as follows; SQl = "Select Bthid from startexec"; Dr = SCon.ReadSql(SQl); BthID = Convert.ToInt64(TxtBthNo.Text.ToString().Trim()); Session["Bthid"] = BthID; ...
C#
Question 3 May 2013   license: CPOL
Database as follows; Bthid bigint (Datatype in the Database) Startexec table (Records as follows) Bthid 718 I am passing the Bthid the database value from Startexec table using session and redirect to another page. My code as follows; SQl =...
C#
Question 3 May 2013   license: CPOL
code as follows; SQl = "Select Bthid from startexec"; Dr = SCon.ReadSql(SQl); string Bthid = Convert.ToInt16(Session["BthID"].ToString()); Response.Redirect("Instruction.aspx"); In database Bthid datatype is bigint when i run shows error as follows Cannot implicitly...
C#
Question 3 May 2013   license: CPOL
how to Pass the value from the database using session and redirect to another page startexec Table as follows; QpName BthID REO 718 batch table as follows; Bthid Bthno Course Attender 718 B84 REO SJ Design screen as follows; Batch No...
C#
Question 2 May 2013   license: CPOL
Batch Details screen as follows; Batch id textbox1 Course Dropdownlist1 Question Paper Dropdownlist2 Batch Date Calendar Then i have Button called GOin that button i want to pass the Batchid and Course using session and redirect to Instructor...
C#
Question 2 May 2013   license: CPOL
My design as follows; Student id textbox1 in the run mode as follows; Student id textbox1 and show (Button).in the run mode if the user did not enter the student id and click the show button want to show the message please enter the student id.for that how can i...
C#
Question 1 May 2013   license: CPOL
Note it is web application. Studetn id txt_student(textbox) Show (Button) label2 (in the lable2 student name to be displayed) i want to display the student name in the label2. when i click the show button the output will display in the Gridview. Show Button code as...
C#
Question 1 May 2013   license: CPOL
Query as follows; SELECT S.Marks,S.QPName,B.Class,B.BthNo,B.Batchdate,B.Attender FROM STUDDET S,Batch B where S.BthId = B.BthId and S.StudId = '252'when i execute the above query ouput as follows;Marks QPName Class BthNo Batchdate Attender 56 REO MFA ...
C#
Question 1 May 2013   license: CPOL
Studetn id txt_student(textbox) Show (Button) Label4 i want to display the student name in the label2.when i click the show button the output will display in the Gridview.Show Button code as follows;SQl = "SELECT S.StudetnName,S.Marks,...
C#
Question 1 May 2013   license: CPOL
SELECT S.Marks,S.QPName,B.Class,B.BthNo,B.Batchdate,B.Attender FROM STUDDET S,Batch B where S.BthId = B.BthId and S.StudId = '55334'when i execute the above query output as follows;Marks QpName Class Bthno Batchdate Attender56 REO_2011 REO B120RE 2011-09-26...
C#
Question 1 May 2013   license: CPOL
My code as follows;string str = "Select count(*) from Student where studid=@studid;";SqlCommand cmd = new SqlCommand(str, SCon.Con);cmd.Parameters.AddWithValue("studid", (int)txt_Studid.Text.Trim);int count = (int)cmd.ExecuteScalar();when i run the above code shows error as...
C#
Question 1 May 2013   license: CPOL
Note it is web application. Validating the student id is exists in database or not for that code as follows; SCon.Con.Open(); string str = "Select count(*) from Studdet where studid = " + txt_Studid.Text.ToString() + ""; SqlCommand cmd = new SqlCommand(str, SCon.Con); ...
C#
Question 30 Apr 2013   license: CPOL
i am validating whether the user enters in the textbox1 student id is there in the database or not. for that code as follows; SCon.Con.Open(); string str = "Select count(*) from Studdet where studid = '" + txt_Studid.Text.ToString() + "'"; SqlCommand cmd =...
C#
Question 30 Apr 2013   license: CPOL
Studdet table as follows; Studid StudName Marks QpName Bthid AnswerID 32468 VENKATA 70 SAC 625 10861 32468 VENKATA 88 REO 616 10715 44258 RAJ 100 AFF 71 1136 44258 RAJ 80 PSCRB 78 1241 44258 ...
SQL-Server
Question 30 Apr 2013   license: CPOL
My code as follows; private SqlDataCon SCon = new SqlDataCon(); private SqlCommand cmd; SCon.Con.Open(); string str = "Select count(*) from Studdet where studid = '" + txt_Studid.Text.ToString() + "'"; SqlCommand cmd = new SqlCommand(str,...
C#
Question 30 Apr 2013   license: CPOL
Student table as follows; studentid studentname marks Qpname 1 Ram 70 MFA 1 Ram 80 TCF 1 Ram 80 AFF 1 Ram 80 PH2 2 Sam 70 MFA 2 Sam 80 ...
C#
Validate the student id by Member 8054539
Question 29 Apr 2013   license: CPOL
Database as follows; Student id 1 2 3 4 5 6 Table name Student. My design as follows; Student id Textbox1 In run mode when i enter the Student id, i want to validate whether that student id in the Student table or not. if user wrongly enter the...
C#
Question 28 Apr 2013   license: CPOL
Store procedure code as follows; set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGOALTER procedure [dbo].[OH_BatchWise_Collection_Report_Presea](@BatchId varchar(10))asbegindeclare @SNo int, @stud_name varchar(100), @stud_id varchar(100), @CrBillNo...
C#
Question 27 Apr 2013   license: CPOL
I have two tables in my database Coupon table id (int) Name (nvarchar(max)) NoofUses (int) CouponUse Table id(int) Couponid(int) CreateDate(datetime) Whenever a user clicks on a coupon an entry goes into the CouponUse table containing that Coupon's idNow...
C#
Question 25 Apr 2013   license: CPOL
i am converting the Gridview data into Excel for that code as follows; i have two button as follows Generate (Button) And Export (Button).when i click the Generate button the data will be displayed into the Gridview.Then when i click the Export button the Gridview data will be...
C#
Question 25 Apr 2013   license: CPOL
in the payment type should be displayed in to DD instead of Demand Draft in the output My code as follows; set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER procedure [dbo].[OH_BatchWise_Collection_Report](@BatchId varchar(10))asbegindeclare @SNo int, ...
C#
Page 1 of 10
1 2 3 4 5 6 7 8 9 10
First · Prev · Next · Last


Advertise | Privacy | Mobile
Web03 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid