Hai , I used gridview for student list , and export it to pdf. But the 2nd column is not need to export. I make the gridview's 2'nd column visible false. [CODE] GrdStudent.Columns[2].Visible = false; [/CODE] But pdf file contain this column. Can you help me to solve it. Regards, sreevidya

Member Avatar
Member Avatar
+0 forum 6

Hi, I have 2 tables tbl_class & tbl_Divisions. structure: tbl_class tbl_Divisions tbl_class_division ---------- ------------- ------------------- class_Id (pk) division_Id(pk) class_division_id(pk) class_name division_name class_Id(fk) division_Id(fk) In my application I want to select division_Id,division_name by passing more than one class_id. if I pass 3 class_Id's , I want to get only those divisions that are common to all the 3 classes. How can i written a query for that. I used join query , but I got all the divisions the 3 classes have. Thanks in advance.

Member Avatar
Member Avatar
+0 forum 3

Hi, I have a listbox with databinding . It has more then 15 items . And I need to auto scroll to the selected item may be item 10 in the code file I used a jQuery like <script type="text/javascript" language="javascript"> function LstFocus() { $('#<%= LstBoxClasType.ClientID %>').find(':selected').filter(':first').focus().attr("selected", true); } </script> But it work in mozilla firefox only and not not work in IE. How can I do that ? Thanks in advance.

Member Avatar
+0 forum 0

Hi, I just need to get all the months or monthid between 2 dates like '02/04/2012' and '08/07/2013'. I search it for a long time. But i get only the date difference. Can i get this in asp.net. regards, sreevidya

Member Avatar
Member Avatar
+0 forum 3

hai , I need to get the monthnames between 2 dates such as 01-04-2012 & 30-03-2013 . Can you help me to get it. Thanks in advance, sreevidya

Member Avatar
Member Avatar
+0 forum 2

Hai , I have a table Student_transport_Details having columns : UserId DesignatonId StartDate Enddate I need to get records for a particular month. Can i retrieve records by passing MonthId [between 1 -12]. Thanks in advance

Member Avatar
Member Avatar
+0 forum 14

Hai , I have 2 tables 1. [B]Transport_Details[/B] having columns user_id FareStageId StartDate EndDate and 2. [B]Route_Fee[/B] having columns FareStageId monthId fees I need to get a monthwise list by passing monthid. My problem is that , if start date and enddate of a user are 02-08-2011 and 20-02-2012 and I need to get the list of 4th month , but this user also listed. Query I used is: [CODE]select Transport_Details.User_Id, Route_Fee.Fee, from Transport_Details join Route_Fee on Transport_Details.Bus_Route_Fare_Stage_Id=Route_Fee.Bus_Route_Fare_Stage_Id where Route_Fee.Month=4 [/CODE] Can i get the list of those users , the monthid between startdate and enddate. Thanks in advance.

Member Avatar
Member Avatar
+0 forum 5

Hai , I have 2 tables 1. [B]Transport_Details [/B]having columns user_id FareStageId StartDate EndDate and 2. [B]Route_Fee [/B]having columns FareStageId monthId fees I need to get a monthwise list by passing monthid. But my problem is that , if start date and enddate of a user are 02-08-2011 and 20-02-2012 and I need to get the list of 4th month , this user also listed. Query I used is: [ICODE]select Transport_Details.User_Id, Route_Fee.Fee, from Transport_Details join Route_Fee on Transport_Details.Bus_Route_Fare_Stage_Id=Route_Fee.Bus_Route_Fare_Stage_Id where Route_Fee.Month=4[/ICODE] Can i get the list of those users , the monthid between startdate and enddate. Thanks in advance.

Member Avatar
Member Avatar
+0 forum 1

Hai, I Have an sp like this: [CODE]ALTER procedure [dbo].[SP_ClassInsertion] @ClassType varchar(50), @ClassTypeId varchar(50), @ClassName varchar(50), @SchoolId varchar(50), @ClassID varchar(50), @BatchId varchar(50), @Userid uniqueidentifier, @ClassCategoryId varchar(50), @SchoolClassCategoryId varchar(50) as declare @STATUS int begin if exists(select Class_Id from SCH_Class where Class_Name=@ClassName and School_Id=@SchoolId and Is_Valid=1) begin set @STATUS=0 end else begin insert into SCH_Class (Class_Id,Class_Type_Id,Batch_Id,School_Id,Class_Name,Created_Date,Updated_Date,Created_By,Updated_By,Is_Valid) values (@ClassID,@ClassTypeId,@BatchId,@SchoolId,@ClassName,GetDate(),GetDate(),@Userid,@Userid,1) set @STATUS=1 return @STATUS end [/CODE] Can u please help me to execute this sp and get the return value from it. Regards, sreevidya

Member Avatar
Member Avatar
+0 forum 7

Hai , I have gris fro student listing. And I need to export this list to pdf. But i get the error msg like: Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled. Details: Error parsing near '%PDF-1.4 %??3 0 obj '. The code i used is: [ICODE] protected void lnkStudentPDF_Click(object sender, EventArgs e) { SchoolCommon ObjCommon = new SchoolCommon(); try { GrdStudent.AllowPaging = false; DataTable dt = (ViewState["StudentList"]) as DataTable; …

Member Avatar
Member Avatar
+0 forum 1

Hai , I have a gridview containing datalist in it.In the datalist i placed 2 labels. My problem is that the content of the datalist not placed within a gridview row cell. The design and css used is: [CODE] <ItemTemplate> <td> <asp:DataList ID="DlistItem" runat="server" RepeatDirection="Horizontal"> <ItemTemplate> <div class="datalisthead"> <div style="padding-left: 20px; padding-top: 1px;"> <asp:Label ID="LblStaff" runat="server" Text='<%#Bind("Class") %>'></asp:Label> <br /> <asp:Label ID="LblSubject" runat="server" Text='<%#Bind("Subject_Name") %>'></asp:Label> </div> </div> </ItemTemplate> </asp:DataList> </td> </ItemTemplate> [/CODE] [CODE].datalisthead { width:150px; height:auto; border-right:1px; border-right-color:Black; border-right-style:solid; }[/CODE] Thanks in advance, Sreevidya

Member Avatar
Member Avatar
+0 forum 2

Hi, I Need to implement transaction with two databases. I used LINQ for one database and normal connection for other. The code I used in Buiseness Layer like: [CODE] using (TransactionScope scope = new TransactionScope()) { try { DataContext ObjSchool = new DataContext(); MEMLiB ObjMemberships = new MEMLiB(); ObjSchool.SCH_Students.InsertOnSubmit(ObjSCH_Student); ObjSchool.SubmitChanges(); if(ObjMembership.MEM_NO!=null) ObjMemberships.Fn_Insert_Membership(ObjMembership); scope.Complete(); return true; } catch (Exception Ex) { string StrError = Ex.Message; return false; } }[/CODE] but, even if some exeptions in second insertion , first insertion occured. How can i fix this problem. Thanks in advance, Sreevidya

Member Avatar
+0 forum 0

hai , I used LINQ in application. I want to perform batch update. For that i used the code as: [CODE] int[] istudentId = new int[]; int j = 0; for (int i = 0; i < GrdStudent.Rows.Count; i++) { if ((GrdStudent.Rows[i].FindControl("chkSelect") as CheckBox).Checked) { istudentId[j] = ObjStudent.Student_Id; j++; } } DataContext ctx = new DataContext(); ctx.ExecuteCommand("update SCH_Student_Promotion_Master set Class_Id='" + DdlClassTo.SelectedValue + "' where Student_Id in('" + istudentId + "')", "", ""); [/CODE] but i got some Error like: Conversion failed when converting the varchar value 'System.Int32[]' to data type int. Thanks in advance Sreevidya

Member Avatar
Member Avatar
+0 forum 1

hai, I used FCKEditor in my Application. But when i browse the server any time i get a error window. And the Error as follows: The resource cannot be found. Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly. Requested URL: /SchoolAdmin/fckeditor/editor/dialog/~/fckeditor/ How Can I fix this problem. Thanks in Advance, Sreevidya

Member Avatar
+0 forum 0

Hai, I used FCK Editor -FredCK.FCKeditorV2.dll on my aspx page. But neednt Some of the toolbars . Can I remove from this editor. Thanks in Advance, Sreevidya

Member Avatar
Member Avatar
+0 forum 1

hai, I have a datalist that contain image button control and i bind images from folder to it. I need to get image slide show when clicking on an image. How can I implement it. Thanks in advance, sreevidya.

Member Avatar
Member Avatar
+0 forum 3

Hai, I used a table for generating grade for students. for thati used the fields: UpperBound[int] LowerBound[int] Grade [varchar(50)] I have some datas such as : UpperBound LowerBound Grade 61 70 D 71 80 C 81 90 B I sent the value 80.09 to Stored procedure. Stored procedure something like this: [CODE]select * from SCH_Grade_Master where SCH_Grade_Master.Lbound<=80.09 and SCH_Grade_Master.Ubound>=80.09 [/CODE] But no result get for values like 80.09, 70.08 etc but get results for 81.02 79.00 etc Can u help me to solve this. Thanks in advance, Sreevidya

Member Avatar
Member Avatar
+0 forum 2

hai I have a grid that include paging and i created pagesize drop down for page sizing. I use PreRender event for displaying this pagerrow even if the row count not exeeds the pagesize. My problem is, in pager row the page index also dispalyed with page size dropdown as '1'. Can i hide it or any other solution for this problem. Thanks in Advance, Sreevidya

Member Avatar
Member Avatar
+0 forum 2

hai, I want an expression for all alphabets and some special characters like . - ' etc. I use an expression like ^[-_'.,A-Za-z]* but it doesnt contain '. can i get a correct expression for this. Thanks in advance Sreevidya

Member Avatar
Member Avatar
+0 forum 1

Hi I add an additional headerrow for pagesizing. The additional row is added on GrdRemarkNature_RowCreated event. Code I used is: [CODE] GridViewRow row = new GridViewRow(0, -1, DataControlRowType.Header, DataControlRowState.Normal); row.ID = RowId; Table t = (Table)GrdRemarkNature.Controls[0]; TableCell cell = new TableHeaderCell(); cell.ColumnSpan = 10; // ******** Literal oLit = new Literal(); oLit.Text = "Page Size: "; cell.Style["padding-left"] = "600px"; cell.Controls.Add(new LiteralControl("Page Size:")); cell.Controls.Add(ddl); row.Cells.Add(cell); t.Rows.AddAt(0, row);[/CODE] can i get this row after databind. Thanks in advance, Sreevidya

Member Avatar
Member Avatar
+0 forum 1

hi, i want to create a custom gridview control with paging, sorting and filtering. I tried a lot of for it , but didnt get it correctly. Can you give me the code for it. thanks in advance, sreevidya

Member Avatar
+0 forum 0

hai, I used gridview pager for page sizing. But I have more than 15 web pages that are also needed page sizing. how can i create a class for this purpose and access it. The code I used is: [CODE] protected void GrdStudent_RowCreated(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.Pager) { DropDownList ddl = new DropDownList(); //adds variants of pager size ddl.Items.Add("5"); ddl.Items.Add("10"); ddl.Items.Add("15"); ddl.AutoPostBack = true; //selects item due to the GridView current page size ListItem li = ddl.Items.FindByText(GrdStudent.PageSize.ToString()); if (li != null) ddl.SelectedIndex = ddl.Items.IndexOf(li); ddl.SelectedIndexChanged += new EventHandler(ddl_SelectedIndexChanged); //adds dropdownlist in the additional cell to the …

Member Avatar
Member Avatar
+0 forum 3

hi how can i subtract a date from other.

Member Avatar
Member Avatar
+0 forum 3

Hi, How can I delete duplicate records from a table in a single query. Thanks in advance.

Member Avatar
Member Avatar
+0 forum 6

Hi, I have a dropdown list in the headerrow of a gridview. When submiting data to the database, how can i check the value is selected or not from the dropdown list using javascript. Thanks in advance.

Member Avatar
Member Avatar
+0 forum 7

hi, what is the use of server.mappath(). what is the return value of this method. Thanks in advance.

Member Avatar
Member Avatar
+0 forum 5

Hi, I used the confirmation in a page when one of the ultrawebgridcell updated.I used the following code. [code] private void MessageBox(string msg) { Label lbl = new Label(); lbl.Text = "<script language='javascript'>" + Environment.NewLine + "window.confirm('" + msg + "')</script>"; Page.Controls.Add(lbl); } protected void uwgSelected_UpdateCell(object sender, CellEventArgs e) { MessageBox("Continue or Not"); empDtls.employeedetails(0, dEmpId, sName, sGender, dtDOB, 0, "", 0, 0, 0, 0, 0, 0, 0, iDesgnId, dtime, 0, ideptId, 0, 0, "", "", "", "", 0, "",0); cvselected.fCVSelected(0, 0, iCVId, srefNo, 0, dtime, dtime, "", 0, dtime, "", "",dEmpId); }[/code] I want to gte the result of confirmation …

Member Avatar
Member Avatar
+0 forum 1

Hi, I have a need to insert images to the database. I tried it using the following code: [code]if ((file1.PostedFile != null) && (file1.PostedFile.ContentLength > 0)) { // Get the filename. byte[] fileData = null; string fn = System.IO.Path.GetFileName(file1.PostedFile.FileName); try { // Access the file stream and begin the upload. Store the file in a memory byte array. Stream MyStream = file1.PostedFile.InputStream; long iLength = MyStream.Length; fileData = new byte[(int)MyStream.Length]; MyStream.Read(fileData, 0, (int)MyStream.Length); MyStream.Close(); clsConns obj1=new clsConns(); obj1.insertProducts(txtPname.Text,txtCat.Text,int.Parse(txtQty.Text),int.Parse(txtPri.Text),fileData); } catch (Exception excep) { Response.Write(excep.ToString()); } }[/code] But some invalid byte values are stored on the database. I used Visual studio2005 …

Member Avatar
Member Avatar
+0 forum 2

Hi, I have web page containing 4 ImageButtons for get new id,delete a record,edit the record and save a record.The three of them worked correctly. But when clicking on the save button, a message of microsoft internet exolorer displayed like this: The Web Page you are Viewing is trying to close the window. Do you want to close the window? If I click on 'No', the Save button Works its function. What is the reason for it? How can i overcome this problem? Hope you can help me. Thanks in advance.

Member Avatar
Member Avatar
+0 forum 6

Hi, I stored a file in the folder taht selected using file upload control. When I tried to view this content from that folder I got an error like this. Cannot find the C:\Documents and settings\Terapc\LocalSettings\temporary Internet Files\Content.IE5\6AJ9DNHZ\name.txt file Do you want to create a new file? The code I used to view this file is: [code=asp.net]if (file.Exists) { Response.Clear(); Response.AddHeader("Content-Disposition", "attachment; filename=" + file.Name); Response.AddHeader("Content-Length", file.Length.ToString()); Response.ContentType = "application/octet-stream"; Response.WriteFile(file.FullName); Response.End(); } else { MsgBox1.alert("The file does not exist"); }[/code] Hope you can help me. Thanks in advance.

Member Avatar
Member Avatar
+0 forum 1

The End.