When I move those panels from the table to outside the table they are seen in code - so I obviously can't put them in that spot.What is the preferred method to have optional columns in table/repeaters?
i am unable to handle jquery accordian. I want to bind it to ta database. I wanted that the user shuld be able to enter the values in a text box through an admin panel which i shoud make for him and those values should be displayed in the accordion panel through the database but........... I am unable to connect and show daabse values in accordian.. don't know whether my connection is not ok or my technique is wrong can anyone help me in this regard??
Here is the code for making the connection..
protected void Page_Load(object sender, EventArgs e)// Create a connection to the "DatabaseAccordian" SQL database located on the // local computer. { SqlConnection myConnection = new SqlConnection("server=localhost;" +"database=DatabaseAccordian;Trusted_Connection=Yes");// Connect to the SQL database using a SQL SELECT query to get all // the data from the "AccordianEvent" table. SqlDataAdapter myCommand = new SqlDataAdapter("SELECT * " +" from AccordianEvent", myConnection);// Create and fill a DataSet. myCommand.Fill(ds); {DataSet ds = new DataSet();if (ds != null)// Bind MyDataList to the DataSet. MyDataList is the ID for // the DataList control in the HTML section of the page. MyDataList.DataSource = ds; MyDataList.DataBind(); } else Response.Write("<p>No customer selected</p>");}
this code is compiled code with no syntax error.
if there is any other thing needed to be done for making the connecion.
<div id="accordion"> <h3 style="color: Black"> <a href="#">News & Announcements</a></h3> <div> <p> 23rd March will be a holiday </p> </div> <h3 style="color: ThreeDDarkShadow;"> <a href="#">Events</a></h3> <div id="divEvents"> </div> </div>
so I got the following page - student listed with 6 buttons to indicate a lunch choice. Clicking the button will update the DB immediately - so a postback happens and lots of screen flicker.
Where do I put update panels in this messy repeater in order to make just a row "redraw"? I broke the code into two parts so you can see the StudentRepeater in the second code window.Also - note that the lunch counts in the labels on the left will also update from the DB. Does that go in it's own update panel?
I have an excel sheet with 2 tabs and has data in those 2 sheets(sheet1, sheet2) which correspond to different tables in the same database. This excel sheet gets updated daily, I am wiriting a console app( which will later be a batch build). I have to insert the data from the excel sheet to corresponding tables (table1, table2,table3) in database when i run it and and also if the table has the same data already present it should ignore and if there are any modifications done the data it should update the table. I know we can do this using ado.net or LINQ, I am a little new to database based programming .
Since these table are on two different boxes and 2 different versions, I am getting error message that tables cant be compared because they have different schema's.Schema's are the same but they are on different machines and different servers. What is a work around it?
I am trying to transfer some tables and stored procedures from SQL Server 2005 to Express 2008. I have tried using Management studio, but it isn't working....
how to connect the two tables of the sql server 2008 databse in C#.
in this there are two tables
1) Tour header(id, name, city, destination)
2) Tour Detail(id, tour id, day no, title,description,images)in this id of tour header and tour id of tour header will be same.now i want to retrieve the data on the basis of when id==tour id.how can we can run the query of two tables.
I have an C# ASP application I am writing that needs to have the capability to import a generated excel or a comma delineated sheet each day. A clerk will have this job each morning so it doesn't need to be automated. My problem in trying to understand the solution to this is that the 1 sheet contains loan information, including customer information all in the same sheet. I would like to send certain columns to update information in the loan table and send other information to update the customer table. I need it to create relationships when new loans appear in the spreadsheet.
I am using bulk insert concept to export the data from dat file to tables(Two tables). I am using the temporary table for to do the calculation and insertion to two tables. My problem is whenever I selecting the temp table data after the execution of bulk insertion , the order is changing .I need to get the order as it is in file order(csv,dat,txt).
If VS 2008 and VWD 2008 are both installed on the same machine, will they both use the same Projects folder to keep my projects in?If so, can I open the projects and run them interchangeably with VS2008 and VWD 2008? This is the folder that is located at " User>Documents>Visual Studio 2008>Projects
Have two collapsible panels on my page. When I open the top one (which has a panel and txtbox/label controls) it doesn't push down the other collapsible panel. It just covers it.
Atm panel 6 isnt below panel 4, panels 4 - 5 - 7 are all in the correct place. not sure how to get panel six to sit under panel 4 and to the left of panel 7.
Is it possible to use an UpdatePanel that has like a few text boxes, and a search button, and then perhaps another UpdatePanel that has a gridview in it to return the results of what was searched. When the user clicks search it hides the boxes, and displays the gridview. Can I do this with UpdatePanels? I am using c# for my coding. Or should I be doing this another way?
They all appear left aligned. I've tried setting the body tag to text-align:center, making divs around and in the main panel, but I can't get it to work. Here is my CSS code:
I need to have a server log that will help to determine the number of items entered into the db and where those items are entered, without having query each table. It should be able to give me the average monthly volume of items input in SQL.
Can this be done using Sql Triggers or any other alternative?
I have to make sure that if I use trigger as the alternative I should have only one table to be updated with all the details of the Updates/Inserts being inserted into the Trigger table after the insertion into the original table.
Below given are some of the create table statements that I have for which I need to have a server log of the updates & inserts.
How do I capture other events in an asp.net textbox on a webpage in more of a way in which a windows app does? For example, if I want to handle when someone just presses a key (keydown) on a textbox in a webpage?
The functionality that we want to create breaks down like this:
We want to create a "smart" search box at the top of our page. When the user starts typing, a little panel or some element should become visible and it will have some check boxes on it. They can search for one or many different types of searches: First Name, Last Name, Business Name, ZIP, Customer Number, and Contact Info. As they begin typing their search, we need it to execute some code that attempts to figure out exactly what they are searching. So if it can tell they are typing in alphabetic characters and not numbers, then we know to NOT check the Customer Number box, but we will want to check the First Name, Last Name, and Business Name boxes. If they start typing a number, we know that we can check the Customer Number box and leave the First Name and Last Name, etc boxes unchecked. If they type a number that is 5 digits, then we know to check the ZIP and Customer Numbers both. Any other length number characters and the ZIP will be unchecked. And any other rules like these that we might want to implement in the future. The idea here is we will almost always be able to tell what someone is searching, but the user can always check any box that they want to search for if they so choose. For example, if a business is named "123 Plumbing Company" and they just want to search the Business Name field for a number, they can over ride it and do that. Otherwise, they just can blindly type their search and hit enter and the program will usually know what kind of search they are trying to do.
I come from a strong windows app development background and have just recently tried to do some web development professionally. A quick few sentences on what philosophy I am missing out on as far as a more robust and "Windows App-like" webpage would be appreciated if anyone wants to coach me on that area and point me in the right direction!
Also, in my example we are using master pages. So if you can imagine a typical master page that has a logo top left and a search box and button top right, then you can picture what we have. Its simple looking. But with the content page being a separate aspx page, we are having trouble referencing it after a search is performed anyway. So what I mean by all this is The masterpage.master has a search textbox. They type something, hit enter. We then want a gridview that is on our default.aspx page to update with the results of the event that was fired from the masterpage.master.
My windows app background tells me to just point to it like I would from two different forms. Like if I had a form1 with a search box on it and I wanted it to show up the results on form2, I would just say Form2.Show: Form2.GridView = whatever.
Of course, with my confusion of what the scope of these asp.net pages is, I am having a difficult time just visualizing everything and how they are inter-related.
So I guess to recap here:
1) How do I tap into more events with textboxes or any other asp.net control. Is the answer AJAX? If so, can you elaborate just a little bit?
2) How would I use the keypress or keydown type of event to make a panel or some kind of content holder to become visible when the textbox gets focus from the cursor and go back to being invisible if it loses focus.
3) What about the scope in which asp.net pages behave?
I'm creating a group of surveys that query Salesforce ([URL] CRM) to generate survey questions dynamically.
The survey layouts are determined by a record type that gets passed in the QueryString. The page queries Salesforce and aggregates the questions/fields it should be using. Then it creates questions and adds them to a panel.
When I open one survey, things look great, and they work as designed. But on opening a separate survey, of a different type, the questions from the first survey are still in the questions panel, as if they are cached somewhere.
To see what I mean, open "Survey 1". Then open "Survey 2" in a new tab. Now re-open "Survey 1", but this time do it in a new tab. Compare the first "Survey 1" to the second "Survey 1", and you'll see that the second "Survey 1" has the questions from "Survey 2" added into it.
Is there something - or a way that - I should be clearing variables, public variables, sessions, or page/panel caches on every page load?
I define the array where the fields/questions are aggregated like this:
ASP Code:
public partial class _Default : System.Web.UI.Page { private static ArrayList field_names_use = new ArrayList { };
Just setup the collapsible panels, there are different fields within the panels that are required. When i submit the page, i get my validation summary, but if the panels are closed, then i cant tell which fields are failing.. so i wou,ld have to open each panel up again to see where i missed something. Is there anyway to have the panels open up if there are any controls that failed validation?
I have 2 collapsible panel. The first panel is expanded by default and second panel is collapsed. When I insert a user control in the first panel (about 650px height) it displays it but the content overflows into second panel header. I have autosize to none and height to 0px in the cssclass.
The content section in panel is not expanding to fit. However if any place any amount of static text it works perfectly. Also when I collapse the first panel the rest of the panel is disappearing when an user control is used. Am I missing something. The same problem when I tried to used ajax accordion
I am using strong typed views in my MVC and have now manage to show all the editors for my register form as I like.
The problem is that I have a radiogroup containing 4 radiobotton, When selecting a radiobutton I neet to hide some of the editors that are bound to the strong typed propertie fields.
I could create a javascript function like this
[Code]....
The problem with this is that it will be a BIG function and Im not sure how the MVC Validation will handle it if a editor that is not valid are hidden? Will it still be possible to submit?
