benwizzle
Last Activity: Sep 29 '10, 05:55 PM
Joined: May 6 '10
Location:
-
benwizzle replied to I want to create a table on Oracle on a click event of a button on ASP.NET. How can Iin ASP .NETI would think that you would just declare a SqlConnection and an SqlCommand which contains the sql to create the table. Open, Execute, and then Close. -
General this is how i do query's in asp.net.
First you must make sure you load the assembly to your page.
Then declare a connection, command, datatable, and a dataadapter.Code:using System.Data.SqlClient;
...Code:SqlConnection con = new SqlConnection("connectionstring"); SqlCommand cmd = new SqlCommand("put command here", con); DataTable dt = new DataTable(); SqlDataAdapterLeave a comment:
-
If your referring to what Mr.Mancunian just said...i can help you out there.Leave a comment:
-
If your using the Session variable to get the DefaultValue, why don't you try using a session parameter? I'm not quite sure that you can use the Session variable like that as the default value(could be wrong)Leave a comment:
-
The final function i came up with that works is
...Code:function selectRowCustom(id) { var gridview = document.getElementById('<%=gvSideList.ClientID%>'); if(gridview) { for(var count=0; count<gridview.rows.length; count++) { var cell = gridview.rows[count].cells; if (cell[1].innerHTML == id)Leave a comment:
-
Does this method account for the gridview being sorted? As far as i knew the HTML of a sorted gridview does not change from its original non-sorted. Its all done on the client side. I actually just broke down and used a session variable to save the sort expression and direction of the gridview but havent got around to trying your method out. You have never steered me wrong before so I declared it the best answer.Leave a comment:
-
still trying to tackle this problem. Havent found an easy way to do this yet.Leave a comment:
-
Gridview SelectedDataKey and SelectedValue are read only. Ive tried to use them to set the selected row but was not successful.Leave a comment:
-
Retrieving a gridview's sort expression and direction via Javascript
I was given help in a previous topic located here: http://bytes.com/topic/asp-net/answe...w-another-form
In this topic I had gridview rows that are selectable and a search window that returned search results. We found a way for me to select a row in the parent window of the search one. My issue now is that when the parent windows gridview is sorted, the function no longer selects the correct row. I was wondering... -
Probably yet another bug with the Tabs controlLeave a comment:
-
If I'm correct, you are not converting the value retrieved from the dropdownlist into an int. @Name is an Int32 and the value retrieved from DropDownList1 is a string try this
Code:cmd.Parameters["@Name"].Value = Convert.ToInt32(DropDownList1.SelectedItem.Value);
Leave a comment:
-
benwizzle replied to ProcessStart won't start an application within my Programs folder on my web serverin ASP .NETput all that stuff inside the try catch...the way you have it setup right now, its not going to catch anythingLeave a comment:
-
Actually I take that back...Union would require that all the tables have the same amount of columns and DataTypes. After thinking about this I think just doing some LEFT and RIGHT JOINS would work. As they return all columns even if there are no matches.Leave a comment:
-
Ive never had to do this before but I think a UNION ALL would serve the purpose your looking for.Leave a comment:
-
benwizzle replied to How to modify an inner join search query to return all fields even if a table is nullin SQL ServerI think I had a similar need before with what your asking. I needed the results of an inner join on two tables but wanted to get matches with a third table and still get results even if there was no matches from that third table.
If I am understanding you correctly then you would inner join the first two tables and then LEFT JOIN the third table. For example. Let say Table1 is General, Table 2 is Services, and Table3 is ServiceGoals.(T his...Leave a comment:
-
How about using the System.Data.Sql Client assembly to write the values to your database? I usually do parametrized query's like this:
Where "sqlcommand " is at is where you type your sql command...Code:SqlConnection con = new SqlConnection("connectionstring"); SqlCommand cmd = new SqlCommand("sqlcommand", con) cmd.Connection.Open(); cmd.ExecuteNonQuery(); cmd.Connection.Close();Leave a comment:
-
Exporting Crystal Report to PDF
I have a crystal report viewer bound as such:
...Code:ReportDocument rd = getReportDocument(); DESClass des = new DESClass(key, iv); string encrypted; ParameterDiscreteValue crParameterDiscreteValue; ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition -
To explain what I am doing more. I have a crystal reports viewer linked to a report that takes in the parameter.
The only way for the stored procedure to return a match is if that parameter is passed into the select statement with the Key and IV I used in the app at saving time. That field is constantly encrypted and decrypted many times in my app, so encrypting it permanently does not help me.
Basically im just trying to find...Leave a comment:
-
Triple DES Encryption Custom Key and IV
Is there a way to encrypt/decrypt in SQL using your own defined Key and Initialization Vector. I have a stored procedure that uses an encrypted field and of course it doesnt return anything because I encrypted the value inside my web app before saving it to my database.
Any ideas/thoughts appreciated.
No activity results to display
Leave a comment: