Hi, i have uploaded my site to web server goddady.com i have a button to download dyanmically generated excel file.This button is ajax enabled.....When i am click on this button it will popup a message like "That assembly does not allow partially trusted callers" This is my web.config file Code: ( xml ) 1. 2. 3. 4. 5. 6. 7. 8.
9. 10.
13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27.
Hi i have a user control consists of a text box and an ajax calender extender. i need an option to change the format of date and applying css,after dragging this to aspx page using properties of usercontrol. How can i do this?
I have developed a windows applicaion in C#.I want to install this app in 10 system on the network.But i want to use same database( MS access) for application.I have a connection string in app config This is my original database path how can access this database from other system on the network please write the connection string in appconfig for other system?
Hi I have a table named StudentResult UserID School Semester Grade Campus Status 1 School1 Summer 10 Campus1 Accepted 2 School1 Summer 10 Campus1 Accepted 3 School1 Summer 10 Campus1 Rejected 4 School1 Summer 10 Campus1 Rejected 5 School1 FALL 10 Campus1 Accepted 6 School1 Summer 12 Campus1 Accepted 7 School1 Summer 12 Campus1 Rejected 8 School1 Summer 12 Campus1 Accepted 9 School1 Summer 12 Campus1 Rejected 10 School1 Summer 12 Campus1 Accepted 11 School1 FALL 12 Campus1 Rejected 12 School1 FALL 12 Campus1 Accepted 13 School1 FALL 11 Campus1 Rejected 14 School1 FALL 11 Campus1 Accepted 15 School1 FALL 11 Campus1 Accepted 16 School1 Summer 11 Campus1 Rejected 17 School1 Summer 11 Campus1 Accepted 18 School1 Summer 11 Campus1 Accepted I want to take the number of accepted and rejected users from the above table as the result table below.I want to consider grade,Campus and semester for taking count and the result should be like result table.Please help me to write Query for this. I am using SQL server2000. as database School Semester Grade Campus NoofAccepted NoofRejected School1 Summer 10 Campus1 2 2 School1 Fall 10 Campus1 1 0 School1 Summer 11 Campus1 2 1 School1 Fall 11 Campus1 2 1 School1 Summer 12 Campus1 3 2 School1 Fall 12 Campus1 1 1 Thanx
Hi I have 3 tables in my database. Students , SessionTable and Campus. Table campus have two fields CampusId and CampusName and SessionTable have two fields SessionId and Sessioname and the tble student have12 fields they are studentId,Name,DOB,Grade,Phone,City, campus1,Session1, campus2,Session2, campus3,Session3 I want tao take all the rows of following fields from tables STUDENTNAME,STUDENTID,DOB,GRADE,PHONE,CITY,Campus.CAMPUSNAME AS CAMPUS1,SessionTable.SESSIONNAME AS SESSION1,CAMPUS.CAMPUSNAME AS CAMPUS2,SessionTable.SESSIONNAME AS SESSION2,CAMPUS.CAMPUSNAME AS CAMPUS3,SessionTable.SESSIONNAME AS SESSION3 I wrote a query like this . But does not takes all the rows from Database SELECT Students.StudentID, CampusList_1.Name As Campus1, CampusList_2.Name As Campus2 , CampusList_3.Name As Campus3, Students.Session1,Students.Session2,Students.Session3,Students.StudentName as FirstName,Students.StudentLastName as LastName, Students.DateOfBirth, Students.Street,Students.AppartmentNo,Students.City, Students.State, Students.ZipCode, Students.Phone, Students.ParentFirstName, Students.ParentLastName, Students.SSN, Students.SchoolYear, Students.Semester, iif(Students.Sibling,'Yes','No')as Sibling,iif(Students.Accepted,'Yes','No')as Accepted,iif(Students.Waitlisted,'Yes','No')As Waitlisted ,Students.ApplicationDate,Students.CurrentSchool,Students.AltenatePhone From ((( Students LEFT JOIN CampusList AS CampusList_1 ON Students.Campus1 = CampusList_1.CampusID) LEFT JOIN CampusList AS CampusList_2 ON Students.Campus2 = CampusList_2.CampusID) LEFT JOIN CampusList AS CampusList_3 ON Students.Campus3 = CampusList_3.CampusID )LEFT JOIN SessionTable ON SessionTable.SessionId=Students.Session1 LEFT JOIN SessionTable ON SessionTable.SessionId=Students.Session2 LEFT JOIN SessionTable ON SessionTable.SessionId=Students.Session3 Pls help me on this issue..........
I have a datatable named EmployeeDT. I am using hastable to store data. I want to to take an employeeID of EmployeeName from data table When i select Employee name in the combobox and add to HashTable. But i am Binding only EmployeeName.So how can i get Emplyee Id to add to Hash Table? I am binding data to combobox using this method foreach(DataRow drow in EmployeeDT.Rows) { cboemployee1.Items.Add(drow["Name"].ToString().Replace("\"","\'")); cboemployee2.Items.Add(drow["Name"].ToString().Replace("\"","\'")); cboemployee3.Items.Add(drow["Name"].ToString().Replace("\"","\'")); } From this code how can i add key to the hash table
I have a datatable named EmployeeDT. I am using hastable to store data. I want to to take an employeeID of EmployeeName from data table When i select Employee name in the combobox and add to HashTable. I am binding data to combobox using this method foreach(DataRow drow in EmployeeDT.Rows) { cboemployee1.Items.Add(drow["Name"].ToString().Replace("\"","\'")); cboemployee2.Items.Add(drow["Name"].ToString().Replace("\"","\'")); cboemployee3.Items.Add(drow["Name"].ToString().Replace("\"","\'")); } From this code how can i add key to the hash table...
Pls help me to correct this query? SELECT Day.Name,iff(Morning,'Yes','No')+','+iff(Afternoon,'Yes','No')+','+ iff(Evening,'Yes','No') as Session3 FROM Session INNER JOIN Day ON Session.SessionID= Day.SessionID
Hi I have 3 columns in my table. They are Yes\No filelds. If the row is Yes i want to take the header name of the column.in the below example if morning is yes i want to take Morning in datagrid eg: if Morning Evening Afternoon Yes No YES Yes Yes No No Yes Yes in the above example in first row Morning and Afternoon is True. I want to retieve this to a Datagrid column Named Session.. i want to retrieve the above data to Session column . in the case of first row i want to show like this in datagrid column Session Morning, Evening Please help me to write Query and code
Hi I have 3 columns in my table. They are Yes\No filelds. If the row is Yes i want to take the header name of the column.in the below example if morning is yes i want to take Morning in datagrid eg: if Morning Evening Afternoon Yes No YES Yes Yes No No Yes Yes in the above example in first row Morning and Afternoon is True. I want to retieve this to a Datagrid column Named Session.. i want to retrieve the above data to Session column . in the case of first row i want to show like this in datagrid column Session Morning, Evening Please help me to write Query and code
Hi, I want to delete data from datbase by entering a year in text box. If the there no data then i want to show "the selected date does not exist". How can i do this? pls help me? Please write code here........................
Hi, I want to delete data from datbase by entering a year in text box. If the there no data then i want to show "the selected date does not exist". How can i do this? pls help me? Please write code here........................
i have a datagrid and its column name is Session. I have a table in that 3 fields are there.They are Morning ,Evening,and Afternoon.They are checkboxes.These fields are saved as YES/NO in database.I want to retrieve data from database to datagrid in a single cell like Morning ,Evening,Afternoon .........I want to retrieve ColumnHeader in table instead of checkbox if u need more clarification pls ask me?
Hi, i want to append or seperarated by semicolon DATA in a datagrid cell from multiple tables pls help me with code and QUERY?
Hi, i have 3 seesons in my database ,Morning Evening, And Afternoon.they are checkboxin database means YES/NO...........I have a datagrid inthat i have a field like Session In session column i want to retrieve data from database according to the data in DB. if morning and evening is checked it shows like MORNING,EVENING Please help me regarding this issue?
Hi, i am working in windows application of C# i am using hash table. i want to add data to hash table from datatable named DTSchool. I have a school name in combobox. when iselect school in combo it takes the curresponding SchoolID from the datatable i want to know how to write code for that. i wrote like this List.Add(SchoolDT.Rows[cboSchool.SelectedIndex]["SchoolID"],cboSchool.Text.ToString()); .But it is not taking value from datatable.Please help me regarding this problem?
Hi, i am working in windows application of C# i am using hash table. i want to add data to hash table from datatable named DTSchool. I have a school name in combobox. when iselect school in combo it takes the curresponding SchoolID from the datatable i want to know how to write code for that. i wrote like this List.Add(SchoolDT.Rows[cboSchool.SelectedIndex]["SchoolID"],cboSchool.Text.ToString()); .But it is not taking value from datatable.Please help me regarding this problem?
Hi, i am working in windows application of C# i am using hash table. i want to add data to hash table from datatable named DTSchool. I have a school name in combobox. when iselect school in combo it takes the curresponding SchoolID from the datatable i want to know how to write code for that. i wrote like this List.Add(SchoolDT.Rows[cboSchool.SelectedIndex]["SchoolID"],cboSchool.Text.ToString()); .But it is not taking value from datatable.Please help me regarding this problem?
can any one pls help me to underline the headding of my print page.i wrote a code like this..i dont know how to write code for underline. public void DrawHeading(Graphics g,string heading,string family,float size,string header) { Font font = new System.Drawing.Font(family,size); SolidBrush ForeBrush = new SolidBrush(Color.Black); g.DrawString(heading+ " - "+header,font,ForeBrush,40,20); }
I have an application in C# which should be installed on 10 machines.. I would like a way to make sure that they do not install on more than that. I would like to give them a way to activate each terminal. Since all terminals will be sharing a DataBase ,maybe we can have a verification process that asks them to input an activation code.Can any one help me regarding this?