Comments by Hari Krishna Prasad Inakoti

Hari Krishna Prasad Inakoti 15-May-14 6:47am View

public void PrintWebControl(Control ctrl, string Script)
{
StringWriter stringWrite = new StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite);
if (ctrl is WebControl)
{
Unit w = new Unit(100, UnitType.Percentage); ((WebControl)ctrl).Width = w;
}
Page pg = new Page();
pg.EnableEventValidation = false;
if (Script != string.Empty)
{
pg.ClientScript.RegisterStartupScript(pg.GetType(), "PrintJavaScript", Script);
}
HtmlForm frm = new HtmlForm();
pg.Controls.Add(frm);
frm.Attributes.Add("runat", "server");
frm.Controls.Add(ctrl);
pg.DesignerInitialize();
pg.RenderControl(htmlWrite);
string strHTML = stringWrite.ToString();
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Write(strHTML);
HttpContext.Current.Response.Write("<script>window.print();</script>");
// HttpContext.Current.Response.End();

}

Hari Krishna Prasad Inakoti 11-Mar-14 4:51am View

Hi Swarup,
I want solution for server side not in client side .

Thanks

Hari Krishna Prasad Inakoti 11-Mar-14 1:26am View

Hi Arun,
It will accept -(Hypen) and .(dot) also?

Hari Krishna Prasad Inakoti 6-Nov-13 8:34am View

i did like that only but it was working same.No changes

Hari Krishna Prasad Inakoti 5-Nov-13 8:41am View

Hi thatraja,
Iam getting same result only. No changes in my report

Hari Krishna Prasad Inakoti 5-Nov-13 8:17am View

i want selected class aswellas all classes information

Hari Krishna Prasad Inakoti 24-Oct-13 10:28am View

Dear thatraja,
I have tried this code also. It is not working.

Hari Krishna Prasad Inakoti 19-Jul-13 6:24am View

@Sampath,
Second link is for pdf only.I need Odt

Hari Krishna Prasad Inakoti 14-May-13 5:20am View

@Kumar,
Iam not using datepicker am using JQueryFullCalendar

Hari Krishna Prasad Inakoti 9-May-13 6:52am View

@SukantaDey,
actually i dnt want sunday in my fullcalendar.That is not datepicker

Hari Krishna Prasad Inakoti 22-Apr-13 1:27am View

Deleted

@navin,
what is the use of this link

Hari Krishna Prasad Inakoti 18-Apr-13 7:53am View

@V.
i'm getting error like this.
Unable to cast object of type 'System.Web.UI.WebControls.GridView' to type 'System.Web.UI.WebControls.LinkButton'.

Hari Krishna Prasad Inakoti 18-Apr-13 6:21am View

hi Maciej,
i got struck at edit button click event .After edit i need to update that values with same button

Hari Krishna Prasad Inakoti 11-Apr-13 11:30am View

@Deenuji,
First i need to save gridview data in XML File

Hari Krishna Prasad Inakoti 22-Mar-13 2:55am View

thanq all.
Actually i want it is in jquery.Already i'm using this function only

Hari Krishna Prasad Inakoti 7-Mar-13 0:41am View

Thanq Jameel Moideen

Hari Krishna Prasad Inakoti 22-Feb-13 7:47am View

sorry @sisirp88,
It is not working

Hari Krishna Prasad Inakoti 7-Feb-13 2:22am View

:D

Hari Krishna Prasad Inakoti 4-Feb-13 0:37am View

yes

Hari Krishna Prasad Inakoti 3-Feb-13 13:24pm View

@Abhinav itz not working.

Hari Krishna Prasad Inakoti 28-Jan-13 1:37am View

@Renju,
I don't want google search engine.I want search like that only.I want output with my pages only(internal).

Hari Krishna Prasad Inakoti 23-Jan-13 6:38am View

hi thanq for ur answer.
Already i used this code.I want code in single line.

Hari Krishna Prasad Inakoti 9-Jan-13 7:46am View

@Joe_i
i saved that checkbox values like yes/no only.I want to show if value is yes in that time checkboxes are checked.how to bind that values to girdview

Hari Krishna Prasad Inakoti 9-Jan-13 7:16am View

I want to check that value from database.
Any way thank you for your comment.

Hari Krishna Prasad Inakoti 4-Jan-13 8:15am View

Thanq Prasanthi

Hari Krishna Prasad Inakoti 4-Jan-13 7:03am View

i can't understand .Please explain briefly

Hari Krishna Prasad Inakoti 31-Dec-12 6:09am View

@KiranKumar Roy,
I wrote that code in pageload .That code only working for print.Remaining all r as usual.

Hari Krishna Prasad Inakoti 21-Dec-12 6:25am View

yes

Hari Krishna Prasad Inakoti 21-Dec-12 4:07am View

thanq ashish.But i have publickeytoken error in my website

Hari Krishna Prasad Inakoti 14-Dec-12 1:14am View

@ryanb31,
can we count how many number of browsers we opened in the system(PC).?

Hari Krishna Prasad Inakoti 14-Dec-12 1:11am View

Hi ryanb31,
If i open my web site and click on ctrl+n new window open with same url.I don't want like that i want default page.Can we do like that?

Hari Krishna Prasad Inakoti 11-Dec-12 7:53am View

can u give the code?.I'm new one of .net

Hari Krishna Prasad Inakoti 11-Dec-12 7:35am View

how?
can u explain?

Hari Krishna Prasad Inakoti 7-Dec-12 2:43am View

can u explain briefly?

Hari Krishna Prasad Inakoti 6-Dec-12 3:51am View

I got solution here.Thanq for reply

Hari Krishna Prasad Inakoti 6-Dec-12 3:36am View

It is not working?

Hari Krishna Prasad Inakoti 3-Dec-12 0:54am View

Hi Krunal,
I'm not using script.If it is not possible in ado.net.I want it is in Stored Procedure atleast

Hari Krishna Prasad Inakoti 2-Dec-12 23:58pm View

hi,
u can save that remarks value is null.In that time u'll get null values in list view.Otherwise it will display like blank.

Hari Krishna Prasad Inakoti 30-Nov-12 6:20am View

I'm using single table only

Hari Krishna Prasad Inakoti 28-Nov-12 6:20am View

rowediting

Hari Krishna Prasad Inakoti 28-Nov-12 5:50am View

auto genaration only

Hari Krishna Prasad Inakoti 22-Nov-12 2:34am View

See below code:

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
<script language="javascript" type="text/javascript">
function state()
{
var select=new Array("-Select-");
var jammu=new Array("-Select-","Srinagar","Kathua","Doda","Kishtwar","Poonch","Rajouri");
var punjab=new Array("-Select-","Ludhiana","Amritsar","Bathinda","Firozpur");
var andhrapradesh=new Array("-Select-","Adilabad","Anantapur","Chittoor","YSR Cuddaph","East Godavari",
"Guntur","Hyderabad","Karimnagar","Khammam","Krishna","Kurnool","Mahbubnagar","Medak","Nalgonda",
"Shri Potti Sriramulu Nellore","Nizamabad ","Prakasam","Rangareddi","Srikakulam","Visakhapatnam","Vizianagaram","Warangal ","West Godavari");
var tamilnadu=new Array("-Select-","Chennai","Coimbatore","Cuddalore","Dharmapuri","Dindigul","Erode","Kancheepuram","Kanyakumari","Karur","Krishnagiri","Madurai","Nagapattinam","Namakkal","Nilgiris","Perambalur","Pudukkottai","Ramanathapuram ","Salem","Sivaganga","Thanjavur","Theni","Thiruvallur","Thiruvarur","Thoothukudi","Tiruchirappalli","Tirunelveli","Tiruvannamalai","Vellore","Villupuram","Virudhunagar");
var karnataka=new Array("-Select-","Bangalore","Mangalore","Mysore","Darwad");
var i,j;
var selectedBoxValue=document.getElementById('<%=ddlstate.ClientID%>').value;
var stateLength=eval(selectedBoxValue).length;
var selectcityvalue=document.getElementById('<%=ddlcity.ClientID%>').value;
var citylength=eval(document.getElementById('<%=ddlcity.ClientID%>')).length;
document.getElementById("ddlcity").options.length = 0;
for(i=0;i

Hari Krishna Prasad Inakoti 21-Nov-12 1:39am View

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
<script language="javascript" type="text/javascript">
function state()
{
var select=new Array("-Select-");
var jammu=new Array("-Select-","Srinagar","Kathua","Doda","Kishtwar","Poonch","Rajouri");
var punjab=new Array("-Select-","Ludhiana","Amritsar","Bathinda","Firozpur");
var andhrapradesh=new Array("-Select-","Adilabad","Anantapur","Chittoor","YSR Cuddaph","East Godavari",
"Guntur","Hyderabad","Karimnagar","Khammam","Krishna","Kurnool","Mahbubnagar","Medak","Nalgonda",
"Shri Potti Sriramulu Nellore","Nizamabad ","Prakasam","Rangareddi","Srikakulam","Visakhapatnam","Vizianagaram","Warangal ","West Godavari");
var tamilnadu=new Array("-Select-","Chennai","Coimbatore","Cuddalore","Dharmapuri","Dindigul","Erode","Kancheepuram","Kanyakumari","Karur","Krishnagiri","Madurai","Nagapattinam","Namakkal","Nilgiris","Perambalur","Pudukkottai","Ramanathapuram ","Salem","Sivaganga","Thanjavur","Theni","Thiruvallur","Thiruvarur","Thoothukudi","Tiruchirappalli","Tirunelveli","Tiruvannamalai","Vellore","Villupuram","Virudhunagar");
var karnataka=new Array("-Select-","Bangalore","Mangalore","Mysore","Darwad");
var i,j;
var selectedBoxValue=document.getElementById('<%=ddlstate.ClientID%>').value;
var stateLength=eval(selectedBoxValue).length;
var selectcityvalue=document.getElementById('<%=ddlcity.ClientID%>').value;
var citylength=eval(document.getElementById('<%=ddlcity.ClientID%>')).length;
document.getElementById("ddlcity").options.length = 0;
for(i=0;i

Hari Krishna Prasad Inakoti 21-Nov-12 1:38am View

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
<script language="javascript" type="text/javascript">
function state()
{
var select=new Array("-Select-");
var jammu=new Array("-Select-","Srinagar","Kathua","Doda","Kishtwar","Poonch","Rajouri");
var punjab=new Array("-Select-","Ludhiana","Amritsar","Bathinda","Firozpur");
var andhrapradesh=new Array("-Select-","Adilabad","Anantapur","Chittoor","YSR Cuddaph","East Godavari",
"Guntur","Hyderabad","Karimnagar","Khammam","Krishna","Kurnool","Mahbubnagar","Medak","Nalgonda",
"Shri Potti Sriramulu Nellore","Nizamabad ","Prakasam","Rangareddi","Srikakulam","Visakhapatnam","Vizianagaram","Warangal ","West Godavari");
var tamilnadu=new Array("-Select-","Chennai","Coimbatore","Cuddalore","Dharmapuri","Dindigul","Erode","Kancheepuram","Kanyakumari","Karur","Krishnagiri","Madurai","Nagapattinam","Namakkal","Nilgiris","Perambalur","Pudukkottai","Ramanathapuram ","Salem","Sivaganga","Thanjavur","Theni","Thiruvallur","Thiruvarur","Thoothukudi","Tiruchirappalli","Tirunelveli","Tiruvannamalai","Vellore","Villupuram","Virudhunagar");
var karnataka=new Array("-Select-","Bangalore","Mangalore","Mysore","Darwad");
var i,j;
var selectedBoxValue=document.getElementById('<%=ddlstate.ClientID%>').value;
var stateLength=eval(selectedBoxValue).length;
var selectcityvalue=document.getElementById('<%=ddlcity.ClientID%>').value;
var citylength=eval(document.getElementById('<%=ddlcity.ClientID%>')).length;
document.getElementById("ddlcity").options.length = 0;
for(i=0;i

Hari Krishna Prasad Inakoti 21-Nov-12 1:36am View

Hi ryanb31,
If i select in State drop down list i want to save that state's entire city's list into database with that state name.

Hari Krishna Prasad Inakoti 7-Nov-12 6:52am View

Thanq very much .Nice Reply

Hari Krishna Prasad Inakoti 1-Nov-12 10:45am View

Thanq Nelek i forgot add the code in this question

Hari Krishna Prasad Inakoti 1-Nov-12 7:59am View

i want it using filesystem object

Hari Krishna Prasad Inakoti 18-Oct-12 1:55am View

hi manak chand,
i want jquery code for slideshow.In both sites they r showing only sites not code.

Hari Krishna Prasad Inakoti 15-Oct-12 0:43am View

can you give example for server side controls?it is working in html control but it is not working in server side controls

Hari Krishna Prasad Inakoti 12-Oct-12 9:41am View

Thanq for ur response.I got it in my function only.

Hari Krishna Prasad Inakoti 1-Oct-12 1:41am View

Hi Tadit,
it is also not working.

Hari Krishna Prasad Inakoti 27-Sep-12 2:12am View

Hi Tadit Dash,
Please check my code
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>Untitled Page</title>
<%--Scenario1--%>
<script language="javascript" type="text/javascript">
function filepath(txtval) {
document.getElementById("txtpath").value= txtval.value;
// Clear Fileupload
var textpath=document.getElementsByName('<%=UploadFile.UniqueID%>')[0];
textpath.value="";
var textpath2= textpath.cloneNode(false);
textpath2.onchange= textpath.onchange;
textpath.parentNode.replaceChild(textpath2,textpath);
}
// right click and control click disabled
// function enablecopypaste(ex){
// var message = "Cntrl key/ Right Click Option Enabled";
// // Condition to check mouse right click / Ctrl key press
// if (ex.which == 0 || ex.button == 1) {
// alert(message);
// return false;
// }
// }
</script>
<%--for size
<style type="text/css" >
.size1{width:627px}
</style>--%>

</head>
<body>
<form id="form1" runat="server">
<div>
<%--<asp:FileUpload ID="UploadFile" runat="server" onchange="filepath(this)" CssClass="size1" Width="627px"/><br />--%>
<asp:FileUpload ID="UploadFile" runat="server" OnChange="filepath(this)" Width="610px" /><br />
<asp:TextBox ID="txtpath" runat="server" Width="521px">
<%-- onKeyDown="return enablecopypaste(event)" onMouseDown="return enablecopypaste(event)">--%>
<br />
</div>
</form>

</body>
</html>

Hari Krishna Prasad Inakoti 21-Sep-12 8:33am View

ok Thanq.I dnt want exactly any older version of IE also ok.

Hari Krishna Prasad Inakoti 21-Sep-12 8:26am View

Now not possible to solve my problem?

Hari Krishna Prasad Inakoti 21-Sep-12 8:01am View

ok amith.i joined in this company last week only.they r given this task actually i dnt knw javascript.thats y i'm getting trouble.

Hari Krishna Prasad Inakoti 21-Sep-12 7:57am View

Thanq Amith,can u solve my prblm plz

Hari Krishna Prasad Inakoti 21-Sep-12 7:47am View

Hari Krishna Prasad Inakoti 21-Sep-12 7:37am View

i did like that but it is not checking popup blocker

Hari Krishna Prasad Inakoti 21-Sep-12 7:07am View

i understood but where we can assign ie version for popup?

Hari Krishna Prasad Inakoti 21-Sep-12 6:04am View

where i'll add this condition? can u help to me plz?
i dnt knw full pledged javascript.

Hari Krishna Prasad Inakoti 21-Sep-12 4:54am View

yes amith

Hari Krishna Prasad Inakoti 21-Sep-12 4:36am View

no errors Amit.But it is not check if condition ,directly goes to else condition only.

Hari Krishna Prasad Inakoti 21-Sep-12 3:29am View

directly window open without alert

Hari Krishna Prasad Inakoti 21-Sep-12 3:04am View

but it is not working in Internet explorer.I want to check in internet explorer

Hari Krishna Prasad Inakoti 20-Sep-12 5:27am View

already i got answer.but it is not working in older versions.

Hari Krishna Prasad Inakoti 20-Sep-12 5:21am View

i recently joined in this job.they r giving this task.plz can u give brief idea about that

Hari Krishna Prasad Inakoti 20-Sep-12 5:11am View

can u tell how can we use local host.if possible plz post complete code

Hari Krishna Prasad Inakoti 20-Sep-12 4:45am View

but as per my requirement i wasnt to blocker in ie 5 to 8 versions.

Hari Krishna Prasad Inakoti 20-Sep-12 3:55am View

yes,i want to check popblocker is enabled or disable only.i'm using same code for mozilla my code is working properly.but ie 8 not support with my code.i can't understand.

Hari Krishna Prasad Inakoti 20-Sep-12 3:43am View

directly window open without alert

Hari Krishna Prasad Inakoti 20-Sep-12 3:43am View

i did like that.but result same

Hari Krishna Prasad Inakoti 20-Sep-12 3:40am View

alert("Error: While Launching New Window...nYour browser maybe blocking up Popup windows. nn Please check your Popup Blocker Settings");.

i didn't get alert message in my ie browser it is working in other browsers.

Hari Krishna Prasad Inakoti 20-Sep-12 3:35am View

this is also not working in my browser(Internet explorer 8)

Hari Krishna Prasad Inakoti 18-Sep-12 6:01am View

yes,i checked .but is is also not working.

Hari Krishna Prasad Inakoti 17-Sep-12 9:28am View

i want javascript code.i know this settings.as for my requirement i can identify using javascript that popup block is opened or not.

Hari Krishna Prasad Inakoti 17-Sep-12 9:17am View

i searched already.After search only i post this question.I tried google code but it is showing message always same if i changed internet explorer popup settings also.that code is not working.

Hari Krishna Prasad Inakoti 12-Sep-12 6:41am View

ok.i'll try ur code after that i'll mark ur answer if it is working.

Hari Krishna Prasad Inakoti 12-Sep-12 5:58am View

Thanq Arul

Hari Krishna Prasad Inakoti 12-Sep-12 5:57am View

itz ok...

Hari Krishna Prasad Inakoti 12-Sep-12 3:29am View

if we using like ur format values are update in table?

Hari Krishna Prasad Inakoti 14-May-12 3:26am View

thanq sandeep

Hari Krishna Prasad Inakoti 13-Apr-12 0:14am View

thanq nadixx

Hari Krishna Prasad Inakoti 11-Apr-12 7:18am View

thanq Mark Nischalke.
Wish u the same...

Hari Krishna Prasad Inakoti 11-Apr-12 2:42am View

same prblm

Hari Krishna Prasad Inakoti 11-Apr-12 2:14am View

I got error this error message uma shankar.

the method or operation is not implemented.

private bool IsPasswordsEqual(string p, string p_2)
{
throw new NotImplementedException();

}

Hari Krishna Prasad Inakoti 11-Apr-12 2:07am View

i got error at !IsPasswordsEqual

Hari Krishna Prasad Inakoti 11-Apr-12 1:47am View

it is not working uma shankar

Hari Krishna Prasad Inakoti 11-Apr-12 1:37am View

iam using windows application dude..

Hari Krishna Prasad Inakoti 29-Mar-12 12:28pm View

i didn't use dal dude.

Hari Krishna Prasad Inakoti 27-Mar-12 13:32pm View

i'm new one of .net dude.please tell to me.

Hari Krishna Prasad Inakoti 14-Mar-12 1:21am View

Deleted

this code for what?
is this code save the data in database?

Hari Krishna Prasad Inakoti 14-Mar-12 1:06am View

Table table = new Table();
table.ID = "tbl_dy";
DropDownList ddl = new DropDownList();

Page.Form.Controls.Add(table);
if (!IsPostBack)
{
for (int i = 1; i < 3; i++)
{
TableRow row = new TableRow();
TableCell cell = new TableCell();
Label lbl = new Label();
lbl.ID = "lbl_'" + i + "'";
if (i == 1)
{
lbl.Text = "Name";
}
else { lbl.Text = "Salary"; }
cell.Controls.Add(new LiteralControl(" "));
TextBox txt = new TextBox();
txt.ID="txt_'"+i+"'";
cell.Controls.Add(new LiteralControl("<br/>"));
cell.Controls.Add(lbl);
cell.Controls.Add(txt);
row.Cells.Add(cell);
table.Rows.Add(row);
}
TableRow row1 = new TableRow();
TableCell cell1 = new TableCell();
Label lbl1 = new Label();
lbl1.ID = "lbl_gender";
lbl1.Text = "Gender";

ddl.Width = 180;
ddl.Height = 25;
ddl.ID = "ddl_gender";
ddl.Items.Add("Select");
ddl.Items.Add("Male");
ddl.Items.Add("Female");
cell1.Controls.Add(lbl1);
cell1.Controls.Add(new LiteralControl(" "));
cell1.Controls.Add(ddl);
row1.Cells.Add(cell1);
table.Rows.Add(row1);
}
}

Hari Krishna Prasad Inakoti 14-Mar-12 1:06am View

Table table = new Table();
table.ID = "tbl_dy";
DropDownList ddl = new DropDownList();

Page.Form.Controls.Add(table);
if (!IsPostBack)
{
for (int i = 1; i < 3; i++)
{
TableRow row = new TableRow();
TableCell cell = new TableCell();
Label lbl = new Label();
lbl.ID = "lbl_'" + i + "'";
if (i == 1)
{
lbl.Text = "Name";
}
else { lbl.Text = "Salary"; }
cell.Controls.Add(new LiteralControl(" "));
TextBox txt = new TextBox();
txt.ID="txt_'"+i+"'";
cell.Controls.Add(new LiteralControl("<br/>"));
cell.Controls.Add(lbl);
cell.Controls.Add(txt);
row.Cells.Add(cell);
table.Rows.Add(row);
}
TableRow row1 = new TableRow();
TableCell cell1 = new TableCell();
Label lbl1 = new Label();
lbl1.ID = "lbl_gender";
lbl1.Text = "Gender";

ddl.Width = 180;
ddl.Height = 25;
ddl.ID = "ddl_gender";
ddl.Items.Add("Select");
ddl.Items.Add("Male");
ddl.Items.Add("Female");
cell1.Controls.Add(lbl1);
cell1.Controls.Add(new LiteralControl(" "));
cell1.Controls.Add(ddl);
row1.Cells.Add(cell1);
table.Rows.Add(row1);
}
}

Hari Krishna Prasad Inakoti 10-Mar-12 11:00am View

ok,but i'm using c# with asp.net

Hari Krishna Prasad Inakoti 23-Dec-11 4:42am View

ok thanq for ur valuable suggestion ...
I know using database how to retrieve values.......

Hari Krishna Prasad Inakoti 23-Dec-11 4:23am View

how to apply to dropdownlist

Hari Krishna Prasad Inakoti 23-Dec-11 4:14am View

i know this code but i want some academic years in dropdownlist.How many items i can add?

Hari Krishna Prasad Inakoti 23-Dec-11 4:12am View

Hi Thatraja
How to add years in dropdownlist?

Hari Krishna Prasad Inakoti 23-Dec-11 4:07am View

Adding years in dropdownlist (2010-2011) like

Hari Krishna Prasad Inakoti 23-Dec-11 4:05am View

i know how to add dynamically but i want how to add years?

Hari Krishna Prasad Inakoti 18-Dec-11 2:09am View

1 stud1 ganeshGhattu CSE B-TECH I A I Cash Tution Fee 5345353.00 10000.00 5335353.00 Due
4 stud1 ganeshGhattu CSE B-TECH I A I Cash Tution Fee 5345353.00 5345353.00 0.00 Paid

Hari Krishna Prasad Inakoti 18-Dec-11 1:54am View

itz show in query correct.But in crystal report it shows each row printed multiple times.

Hari Krishna Prasad Inakoti 18-Dec-11 1:32am View

I'm using this query:

SELECT f.feeid,
f.studentid,
( s.first_name + last_name )AS studentname,
b.branchname,
c.coursename,
y.yearname,
se.sectionname,
sem.semester,
f.paymentmode,
f.typeoffee,
f.nameofthebank,
f.totalfee,
f.t otalpaidfee,
f.balancefee,
f.feestatus
FROM studentfeedetails1 f
inner join studentdetails s
ON s.studentid = f.studentid
inner join branchdetails b
ON b.branchcode = s.branchcode
inner join coursedetails c
ON c.coursecode = s.coursecode
inner join year_table y
ON y.yearid = s.yearid
inner join semester_table sem
ON sem.semesterid = s.semesterid
inner join section_table se
ON se.sectionid = s.sectionid
WHERE b.branchname = 'CSE'
AND c.coursename = 'B-TECH'
AND y.yearname = 'I'
AND sem.semester = 'I'
AND se.sectionname = 'A'
AND f.typeoffee = 'Tution Fee

Hari Krishna Prasad Inakoti 18-Dec-11 1:30am View

i applied that properties but itz not working.i'm using innerjoin for 4 tables

Hari Krishna Prasad Inakoti 18-Dec-11 1:16am View

itz not working...

Hari Krishna Prasad Inakoti 15-Dec-11 4:51am View

Thanq

Hari Krishna Prasad Inakoti 15-Dec-11 4:37am View

varchar(12)

Hari Krishna Prasad Inakoti 28-Nov-11 8:21am View

plz send that link plz

Hari Krishna Prasad Inakoti 28-Nov-11 3:22am View

yes

Hari Krishna Prasad Inakoti 28-Nov-11 2:32am View

that is copy & paste problem

Hari Krishna Prasad Inakoti 28-Nov-11 2:30am View

yes itz working.

Hari Krishna Prasad Inakoti 23-Nov-11 23:09pm View

yes

Hari Krishna Prasad Inakoti 17-Nov-11 1:49am View

yes dude

Hari Krishna Prasad Inakoti 14-Nov-11 6:20am View

it's ok in case i'l take february month sometimes 29 or 28 in that time problem occured.

Hari Krishna Prasad Inakoti 14-Nov-11 1:20am View

count only

Hari Krishna Prasad Inakoti 13-Nov-11 23:22pm View

i got this error workDaysEveryMonth.
The name 'workDaysEveryMonth' does not exist in the current context

Hari Krishna Prasad Inakoti 11-Nov-11 1:35am View

Web

Hari Krishna Prasad Inakoti 9-Nov-11 0:46am View

Thanks dude.But i want every month working days automatically.How can i write that logic plz help me.

Hari Krishna Prasad Inakoti 9-Nov-11 0:36am View

I want No of Working Days in month excluding sundays not in between 2days.

Hari Krishna Prasad Inakoti 28-Oct-11 9:15am View

means webpage

Hari Krishna Prasad Inakoti 28-Oct-11 6:43am View

Deleted

private void btnattendancelist_Click(object sender, EventArgs e)
{ da = new SqlDataAdapter("select EmployeeId,(FirstNAme+LastName)as EmployeeName from EmployeeDetail", con);
da.Fill(ds, "EmployeeDetail");
dataGridView2.DataSource = ds.Tables["EmployeeDetail"];
int count = ds.Tables["EmployeeDetail"].Columns.Count;

for (int i = count, j = 1; i <= (31 + count - 1); i++, j++)
{
DataGridViewCheckBoxColumn cl = new DataGridViewCheckBoxColumn();
cl.Name = "label" + i;
cl.HeaderText = j.ToString();
cl.Width = 25;
dataGridView2.Columns.Add(cl);
}

Hari Krishna Prasad Inakoti 28-Oct-11 6:42am View

Deleted

Previously i wrote this code in C#.

private void btnattendancelist_Click(object sender, EventArgs e)
{
label_msg.Visible = true;
dataGridView2.Visible = true;
btnsetholiday.Visible = true;
da = new SqlDataAdapter("select EmployeeId,(FirstNAme+LastName)as EmployeeName from EmployeeDetail", con);
da.Fill(ds, "EmployeeDetail");
dataGridView2.DataSource = ds.Tables["EmployeeDetail"];
int count = ds.Tables["EmployeeDetail"].Columns.Count;

for (int i = count, j = 1; i <= (31 + count - 1); i++, j++)
{
DataGridViewCheckBoxColumn cl = new DataGridViewCheckBoxColumn();
cl.Name = "label" + i;
cl.HeaderText = j.ToString();
cl.Width = 25;
dataGridView2.Columns.Add(cl);
}
}

Hari Krishna Prasad Inakoti 27-Oct-11 8:56am View

Deleted

i'm not write code.I know designing only.

Hari Krishna Prasad Inakoti 27-Oct-11 8:42am View

Deleted

itz not working dude

Hari Krishna Prasad Inakoti 17-Oct-11 6:05am View

I want all fields

Hari Krishna Prasad Inakoti 17-Oct-11 5:55am View

cmd = new SqlCommand("select Course,Branch,Year,Semister,ExamType,MonthofAppear,YearofAppear from ExamEntry group by Course,Branch,Year,Semister,ExamType,MonthofAppear,YearofAppear", con);

Hari Krishna Prasad Inakoti 17-Oct-11 5:44am View

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace StudentDetails
{
public partial class StudentDetails : Form
{
//SqlConnection con = new SqlConnection("Password=123;Persist Security Info=True;User ID=sa;Initial Catalog=C M S;Data Source=NITHYANANDAM");
SqlConnection con = new SqlConnection("Password=123;Persist Security Info=True;User ID=sa;Initial Catalog=C M S;Data Source=SHIRISHAJALLU");
SqlDataAdapter da,da1;
SqlDataReader dr;
SqlCommand cmd;
DataSet ds;
String Cb="empty";
string rcfu = string.Empty;
public StudentDetails()
{
InitializeComponent();
}

private void StudentDetails_Load(object sender, EventArgs e)
{
combofill();
groupfill();
groupBox1.Visible = false;
dgvstudentwise.Visible = false;
dgvsmemo.Visible = false;
btnsave.Visible = false;
}
private void combofill()
{
if (con.State == 0)
{
con.Open();
}
cmd = new SqlCommand("select Course,Branch,Year,Semister,ExamType,MonthofAppear,YearofAppear from ExamEntry group by Course,Branch,Year,Semister,ExamType,MonthofAppear,YearofAppear", con);
dr = cmd.ExecuteReader();
while (dr.Read())
{
cmbcourse.Items.Add(dr.GetString(0));
cmbbranch.Items.Add(dr.GetString(1));
cmbyear.Items.Add(dr.GetString(2));
cmbsem.Items.Add(dr.GetString(3));
cmbexamtype.Items.Add(dr.GetString(4));
cmbmonthofappear.Items.Add(dr.GetString(5));
cmbyearofappear.Items.Add(dr.GetString(6));

}

dr.Close();
con.Close();

}

private void btnclose_Click(object sender, EventArgs e)
{
this.Close();
}
private void btnsubmit_Click(object sender, EventArgs e)
{
dgvsmemo.Visible = true;
btnsave.Visible = true;
btnsearchstudentwise.Visible = true;
dgvsmemo.Columns.Clear();
DataGridViewCheckBoxColumn cl = new DataGridViewCheckBoxColumn();
cl.Name = "CertificatesReceivedFromUniversity" ;
cl.HeaderText = "CertificatesReceivedFromUniversity";
cl.Width = 80;
dgvsmemo.Columns.Add(cl);
dgvsmemo.Columns[0].DefaultCellStyle.BackColor = Color.White;
con.Open();
da = new SqlDataAdapter("Select StudentID,SName as StudentName,Course,Branch,Year,Semister,ExamType,MonthofAppear,YearofAppear from ExamEntry where Course='" + cmbcourse.Text + "' and Branch='" + cmbbranch.Text + "' and Year='" + cmbyear.Text + "' and Semister='" + cmbsem.Text + "' and ExamType='" + cmbexamtype.Text + "' and MonthofAppear='" + cmbmonthofappear.Text + "' and YearofAppear='" + cmbyearofappear.Text + "'", con);
ds = new DataSet();
ds.Tables.Clear();
da.Fill(ds, "ExamEntry");
dgvsmemo.DataSource = ds.Tables["ExamEntry"];

con.Close();
}
private void cmbcourse_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmbcourse.Text == "MCA")
{

}
}
private void clear()
{
cmbcourse.Text = "";
cmbbranch.Text = "";
cmbyear.Text = "";
cmbsem.Text = "";
cmbexamtype.Text = "";
cmbmonthofappear.Text = "";
cmbyear

Hari Krishna Prasad Inakoti 17-Oct-11 5:44am View

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace StudentDetails
{
public partial class StudentDetails : Form
{
//SqlConnection con = new SqlConnection("Password=123;Persist Security Info=True;User ID=sa;Initial Catalog=C M S;Data Source=NITHYANANDAM");
SqlConnection con = new SqlConnection("Password=123;Persist Security Info=True;User ID=sa;Initial Catalog=C M S;Data Source=SHIRISHAJALLU");
SqlDataAdapter da,da1;
SqlDataReader dr;
SqlCommand cmd;
DataSet ds;
String Cb="empty";
string rcfu = string.Empty;
public StudentDetails()
{
InitializeComponent();
}

private void StudentDetails_Load(object sender, EventArgs e)
{
combofill();
groupfill();
groupBox1.Visible = false;
dgvstudentwise.Visible = false;
dgvsmemo.Visible = false;
btnsave.Visible = false;
}
private void combofill()
{
if (con.State == 0)
{
con.Open();
}
cmd = new SqlCommand("select Course,Branch,Year,Semister,ExamType,MonthofAppear,YearofAppear from ExamEntry group by Course,Branch,Year,Semister,ExamType,MonthofAppear,YearofAppear", con);
dr = cmd.ExecuteReader();
while (dr.Read())
{
cmbcourse.Items.Add(dr.GetString(0));
cmbbranch.Items.Add(dr.GetString(1));
cmbyear.Items.Add(dr.GetString(2));
cmbsem.Items.Add(dr.GetString(3));
cmbexamtype.Items.Add(dr.GetString(4));
cmbmonthofappear.Items.Add(dr.GetString(5));
cmbyearofappear.Items.Add(dr.GetString(6));

}

dr.Close();
con.Close();

}

private void btnclose_Click(object sender, EventArgs e)
{
this.Close();
}
private void btnsubmit_Click(object sender, EventArgs e)
{
dgvsmemo.Visible = true;
btnsave.Visible = true;
btnsearchstudentwise.Visible = true;
dgvsmemo.Columns.Clear();
DataGridViewCheckBoxColumn cl = new DataGridViewCheckBoxColumn();
cl.Name = "CertificatesReceivedFromUniversity" ;
cl.HeaderText = "CertificatesReceivedFromUniversity";
cl.Width = 80;
dgvsmemo.Columns.Add(cl);
dgvsmemo.Columns[0].DefaultCellStyle.BackColor = Color.White;
con.Open();
da = new SqlDataAdapter("Select StudentID,SName as StudentName,Course,Branch,Year,Semister,ExamType,MonthofAppear,YearofAppear from ExamEntry where Course='" + cmbcourse.Text + "' and Branch='" + cmbbranch.Text + "' and Year='" + cmbyear.Text + "' and Semister='" + cmbsem.Text + "' and ExamType='" + cmbexamtype.Text + "' and MonthofAppear='" + cmbmonthofappear.Text + "' and YearofAppear='" + cmbyearofappear.Text + "'", con);
ds = new DataSet();
ds.Tables.Clear();
da.Fill(ds, "ExamEntry");
dgvsmemo.DataSource = ds.Tables["ExamEntry"];

con.Close();
}
private void cmbcourse_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmbcourse.Text == "MCA")
{

}
}
private void clear()
{
cmbcourse.Text = "";
cmbbranch.Text = "";
cmbyear.Text = "";
cmbsem.Text = "";
cmbexamtype.Text = "";
cmbmonthofappear.Text = "";
cmbyear

Hari Krishna Prasad Inakoti 30-Sep-11 1:44am View

Deleted

no genarate button is working.I did not write code in show report in Excel button.Please solve my problem.I am eagerly waiting for reply.

Hari Krishna Prasad Inakoti 30-Sep-11 1:42am View

Deleted

where i will write this code?

Hari Krishna Prasad Inakoti 30-Sep-11 1:33am View

Cannot implicitly convert type 'float' to 'int'. An explicit conversion exists (are you missing a cast?)
i got this error.

Hari Krishna Prasad Inakoti 23-Sep-11 5:38am View

Actually i'm using datetime picker in form.cs
while inserting sql query like " '"dtpname.text"' ", is working and values inserted into sql database.
But, the same form while updating with future date is not working, It's saying that ""The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated."".

Hari Krishna Prasad Inakoti 22-Sep-11 9:32am View

i'm using this format dd-MM-yy(Indian format)only.i gave future date of this month only .

Comments by Hari Krishna Prasad Inakoti (Top 134 by date)