ASP.NET

FirstPrevNext

Object Pooling aaraaayen6-Dec-06 18:41 aaraaayen 6-Dec-06 18:41  Hi friends, Please explain about object pooling with example. Thanks in Advance, Regards, Prya Re: Object Pooling Saqib Raja6-Dec-06 23:38 Saqib Raja 6-Dec-06 23:38  See the following link. This might help you. http://www.codeproject.com/csharp/ObjectPooling.asp[^] Regards, Saqib Umar Sr. Software Engineer implementation of storedprocedures chinnivinay6-Dec-06 17:51 chinnivinay 6-Dec-06 17:51  how to implement stored procedures with outputparameters in asp.net Re: implementation of storedprocedures Christian Graus6-Dec-06 19:12 Christian Graus 6-Dec-06 19:12  The same way you do it outside ASP.NET. ASP.NET is irrelevant. You specify parameters as output parameters when you add them, and check their value on return. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog Re: implementation of storedprocedures Ritika S6-Dec-06 23:58 Ritika S 6-Dec-06 23:58  Hi, u can use this as an example which returns integer as output value Public Function GetMailSent(ByVal CaseId As String) As Integer Dim objConn As New SqlConnection Dim objDB As New clsCommon Dim objDS As New DataSet Dim objCommand As New SqlCommand Dim objDA As New SqlDataAdapter Dim param As New SqlParameter Dim intMailSent As Integer Try objConn = objDB.GetDatabaseConnection objCommand.CommandType = CommandType.StoredProcedure objCommand.CommandText = "spGetMailSent" objCommand.Connection = objConn objDA.SelectCommand = objCommand objCommand.Parameters.Add("@CaseID", SqlDbType.VarChar).Value = IIf(IsDBNull(CaseId), DBNull.Value, CaseId) param = objCommand.Parameters.Add("@retval", SqlDbType.Int) param.Value = Decimal.Zero param.Direction = ParameterDirection.Output intMailSent = objCommand.ExecuteNonQuery() GetMailSent = objCommand.Parameters("@retval").Value Finally 'objDB.CloseDatabaseConnection() End Try End Function Regards, Ritika Datagrid binding miniThomas6-Dec-06 17:44 miniThomas 6-Dec-06 17:44  I have 1 query in which i want to select max(column) value and second query select * from tablename i want to bind both these queries to dataset and display in 1 datagrid. How to do this? Thanx Mini Thomas Re: Datagrid binding Saqib Raja7-Dec-06 0:40 Saqib Raja 7-Dec-06 0:40  Try using group by in query. SELECT stateid, MAX(stateid) as "MAX id" FROM states GROUP BY stateid Regards, Saqib Umar Sr. Software Engineer populating datas from sql db and displaying it inTEXTformat - VERY VERY URGENT saravanan056-Dec-06 13:12 saravanan05 6-Dec-06 13:12  hi toall I have to populate some datas from sql server database and display it directly in a TEXT Format or TEXT file. When i run the project it should provide me an option to whether open or save or cancel the file. when i click open it should be opened and be viewed in a excel sheet in TEXT format and when i click save it should ask the destination folder and should be saved there in TEXT format and when i click cancel it should be cancelled and the application should be closed. pls note that all these actions should happen in the same browser and should not be redirected to anyother page. Can anybody give me the detailed description and code in Asp.Net using C# .It's very Urgent. regards saravanan Re: populating datas from sql db and displaying it inTEXTformat - VERY VERY URGENT Christian Graus6-Dec-06 14:10 Christian Graus 6-Dec-06 14:10  The first step is probably to write a method that returns your data as a CSV, given that this is a good way of getting Excel to read something. So, read your file from the database, iterate over the rows and create your text file. Clicking Save can just feed the file down again to a file. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog Rg:Style sheet in Child master page nzsatish6-Dec-06 12:01 nzsatish 6-Dec-06 12:01  Hi Every one, i am trying to use style sheet in content page which is using my master page... it is not applying syles to Grid.. i declared <link> tag for style sheet... in Master page could u please answer my question Thanks Satish Re: Rg:Style sheet in Child master page Saqib Raja7-Dec-06 0:09 Saqib Raja 7-Dec-06 0:09  If master page contains the style definition for the grid in app_theme folder then your style defined in page can't take precedence over skin/style in theme folder. You can apply a theme as a style sheet theme by setting the page's StyleSheetTheme property. In this case, local page settings take precedence over those defined in the theme when the setting is defined in both places. This is the model used by cascading style sheets. You might apply a theme as a style sheet theme if you want to be able to set the properties of individual controls on the page while still applying a theme for an overall look. You can add one or more .css files into a theme directory. ASP.NET will automatically apply all of a theme’s style sheets into a page by injecting a element for each .css into the header of a page. Your page must have runat=”server” in the <head%gt; tag="" for="" the="" automatic="" style="" sheet="" inclusion.="" <div="" class="ForumSig">Regards, Saqib Umar Sr. Software Engineer Re: Rg:Style sheet in Child master page nzsatish7-Dec-06 9:20 nzsatish 7-Dec-06 9:20  Hi Saqib, thanxs for your reply... can you please help me how to use ancher <a> Tab and Script tags <script> in content page regards Satish problem exporting to excel swissmiss866-Dec-06 10:54 swissmiss86 6-Dec-06 10:54  is there a way to directly export SQL data to excel using a aspx page without displaying this data on a datagrid. so this is not like exporting from datagrid to excel but it is like...when user clicks a button then an Sproc is executed and data should be directly saved into excel. any help would be appreciated,thanks Re: problem exporting to excel Saqib Raja6-Dec-06 23:55 Saqib Raja 6-Dec-06 23:55  Yes you can export data directly from SQL to xls file without displaying it in grid. Excel can be treated as SQL using connection string like following : "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;DBQ=/book1.xls;UID=admin;" rows and colums are treated as html and or . I've done this work 3 years back on classic ASP. Don't get confused by the syntax. Cheers! Regards, Saqib Umar Sr. Software Engineer Anyone using IIS7 successfully ? Christian Graus6-Dec-06 9:05 Christian Graus 6-Dec-06 9:05  I'm trying, but while the server in VS2005 works fine, IIS7 gives me this error: HTTP Error 500.19 - Internal Server Error Description: The requested page cannot be accessed because the related configuration data for the page is invalid. Error Code: 0x80070005 Notification: BeginRequest Module: IIS Web Core Requested URL: http://localhost:80/ Physical Path: D:\inetpub\ Logon User: Not yet determined Logon Method: Not yet determined Handler: Not yet determined Config Error: Cannot read configuration file Config File: \\?\D:\inetpub\web.config Config Source: -1: 0: More Information... This error occurs when there is a problem reading the configuration file for the Web server or Web application. In some cases, the event logs may contain more information about what caused this error. -------------------------------------------------------------------------------- Now, the control panel applet initially told me that some fields were invalid, but even getting it to a state where that would work, doesn't fix this. Also went and made sure teh ASPNET user had access to the file. Anyone have any experience here ? Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog Re: Anyone using IIS7 successfully ? User 17164926-Dec-06 13:52 User 1716492 6-Dec-06 13:52  Christian, Could it be that with "Error Code: 0x80070005" that you are not logged in as Administrator? or perhaps permissions are incorrect? modified 1-Aug-19 21:02pm. Re: Anyone using IIS7 successfully ? Christian Graus6-Dec-06 14:04 Christian Graus 6-Dec-06 14:04  No, I'm logged in as admin. I've also gone and given everyone in the entire world access to that file, to see if it's a permissions issue. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog Re: Anyone using IIS7 successfully ? Rama Krishna Vavilala6-Dec-06 14:06 Rama Krishna Vavilala 6-Dec-06 14:06  Have you already modified the web.config file required by IIS7. Does the web.config file show any errors when it is opened with VS. I suspect it can be as simple as tag not being closed. Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it. -Brian Kernighan Re: Anyone using IIS7 successfully ? Christian Graus6-Dec-06 14:12 Christian Graus 6-Dec-06 14:12  The file is valid XML, it works with the VS2005 web server, and IIS in XP. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog Re: Anyone using IIS7 successfully ? Rama Krishna Vavilala6-Dec-06 14:23 Rama Krishna Vavilala 6-Dec-06 14:23  Does it have system.webserver section? Which you are prompted to add when running the app under IIS7 for the first time. Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it. -Brian Kernighan Re: Anyone using IIS7 successfully ? Christian Graus6-Dec-06 19:18 Christian Graus 6-Dec-06 19:18  No - I'll google that. Thanks. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog Export to Excel. deepaks36-Dec-06 8:21 deepaks3 6-Dec-06 8:21  Hi, I have written the code to export the gridview values to Excel, the main problem i am facing is that i have a column in which there is picture which is not shown in Excel. It showz the general icon of picture not found. Please Help. Thanks and Regards, Deepak Surana problem updating datagrid values jonjoe906-Dec-06 6:25 jonjoe90 6-Dec-06 6:25  im having a problem writing values back to the database. im using sql 2000. the values are pulled in from a datagrid the user can make multiple edits and get click a button that preforms a batch update. below is the code for the button Protected Sub btnSave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSave.Click Dim txtPrelimDecisionCode, txtPrelimLetterIssued, txtFinalDecisionCode, txtFinalLetterIssued As TextBox Dim studentId, classId As Label Dim gvRow As GridViewRow Dim sqlConn As New SqlConnection Dim sqlComm As New SqlCommand Dim sqlDr As SqlDataReader sqlConn.ConnectionString = ( "data source=.; integrated security= true; initial catalog=dbStudentRecords;") Try sqlConn.Open() sqlComm.Connection = sqlConn sqlComm.CommandText = "SELECT * FROM tblStudentDecision" sqlDr = sqlComm.ExecuteReader For Each gvRow In Me.dgResults.Rows ' obtain the values from the dataGrid studentId = CType(gvRow.Cells(0).FindControl("studentId"), Label) classId = CType(gvRow.Cells(1).FindControl("classId"), Label) txtPrelimDecisionCode = CType(gvRow.Cells(21).FindControl("txtprelimDecisionCode"), TextBox) txtPrelimLetterIssued = CType(gvRow.Cells(21).FindControl("txtPrelimLetterIssued"), TextBox) txtFinalDecisionCode = CType(gvRow.Cells(21).FindControl("txtFinalDecisionCode"), TextBox) txtFinalLetterIssued = CType(gvRow.Cells(21).FindControl("txtFinalLetterIssued"), TextBox) 'convert the dataGrid Values into the correct data types(not sure if i need this) 'Dim classIdValue As Integer = Convert.ToInt32(classId) 'Dim prelimDecisionCodeValue As Integer = Convert.ToInt32(txtPrelimDecisionCode) 'Dim prelimLetterIssuedValue As Boolean = Convert.ToBoolean(txtPrelimLetterIssued) 'Dim finalDecisionCodeValue As Integer = Convert.ToInt32(txtFinalDecisionCode) 'Dim finalLetterIssuedValue As Boolean = Convert.ToBoolean(txtFinalLetterIssued) 'values from dataGrid 'these values below are printing to the debug just fine Debug.Print(studentId.Text) Debug.Print(classId.Text) Debug.Print(txtPrelimDecisionCode.Text) Debug.Print(txtPrelimLetterIssued.Text) Debug.Print(txtFinalDecisionCode.Text) Debug.Print(txtFinalLetterIssued.Text) sqlDr.Read() If IsDBNull("StudentId") Then 'studentId = CType(gvRow.Cells(0).FindControl("studentId"), Label) ' if record does not exsist insert all fields- not sure of the syntax 'sqlComm.CommandText = "INSERT NEW RECORD" 'sqlComm.ExecuteNonQuery() Else ' i want to update txtPrelimDecisionCode txtPrelimLetterIssued txtFinalDecisionCode txtFinalLetterIssued if the record already exsists ' i tried to get it working with the first value txtPrelimDecisionCode and then i was going to proceed with the rest but damm it dosent work!! sqlComm.CommandText = "UPDATE tblStudentDecision SET prelimDecisionCode='" & txtPrelimDecisionCode.Text & "' WHERE studentId='" & studentId.Text & "'" sqlComm.ExecuteNonQuery() End If Next Catch ex As SqlException Trace.Warn( "dbError: " & ex.Message) Catch ex As Exception Trace.Warn( "Other error: " & ex.Message) Finally sqlConn.Close() End Try End Sub i thought this would be straight forward but i seem to be having problems any help would be great! steve Re: problem updating datagrid values Vasudevan Deepak Kumar6-Dec-06 6:51 Vasudevan Deepak Kumar 6-Dec-06 6:51  Are you using PostBack check? Otherwise the data would rebind and your event handler would be voided of its intended action. Vasudevan Deepak Kumar Personal Homepage Tech Gossips Re: problem updating datagrid values ToddHileHoffer6-Dec-06 7:25 ToddHileHoffer 6-Dec-06 7:25  I don't understand your code. You are not doing this right. Mistake #1 Attempting to READ from the database when the user clicks submit??? Just store the primary key field(s) in the datagrid to use as a reference. Mistake #2 You should be using SqlParameters to protect against sql injection Mistake #3 Your connection string should be in only one place like a session or application object. Mistake #4 Not using stored procedure to do updates. If you are using integrated security and grant datawriter access to your application, your user could use MS Access or queary analyzer and update the data without your knowledge. Check out MSDN or a basic programming book for more information. MSDN GameFly free trial

Last Visit: 31-Dec-99 18:00     Last Update: 6-May-24 18:34 Refresh ᐊ Prev1...5576557755785579558055815582558355845585 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.