|
An issue occur while performing multiFile selection in framework 3.5. I am using 'jquery.MultiFile.js' and 'jquery-1.8.2.js' scripts to achieve it. My attachment control is inside a update panel within Tab control. Everything is fine but when i am use async or full post back then file uploader control can not read script and can not select multiple files. My Code part is as follows :
<script src="../Scripts/jquery.MultiFile.js" type="text/javascript"></script>
<script src="../Scripts/jquery-1.8.2.js" type="text/javascript"></script>
<div class="PageMainTable">
<ajaxToolkit:TabContainer ID="TabContainer1" runat="server" AutoPostBack="true" ActiveTabIndex="1"
OnActiveTabChanged="TabContainer1_ActiveTabChanged">
<ajaxToolkit:TabPanel ID="tb_home" runat="server" HeaderText="Home">
</ajaxToolkit:TabPanel>
<ajaxToolkit:TabPanel ID="TabPanel1" runat="server" HeaderText="CSR Registration Process">
<ContentTemplate>
<asp:UpdatePanel ID="up_addupdt" runat="server" UpdateMode="Conditional" >
<Triggers>
<asp:PostBackTrigger ControlID="btn_save" />
</Triggers>
<ContentTemplate>
.....
<tr>
<td class="lbl_text">Attachment:
</td>
<td colspan="4">
<asp:FileUpload ID="FileUpload1"
maxlength="5" runat="server" class="multi" />
</td>
<td align="left" colspan="4">
<asp:Label ID="lbl_attach" runat="server" Text="" Visible="false"></asp:Label>
</td>
</tr>
...
</ContentTemplate>
<Triggers>
<asp:AsyncPostBackTrigger ControlID="drop_system" EventName="SelectedIndexChanged" />
</Triggers>
</asp:UpdatePanel>
</ContentTemplate>
</ajaxToolkit:TabPanel>
On async post back of drop down (drop_system) file uploader behave normal and could not allow me to select multiple files.
Pls reply to my query as early as possible.
Thanx in advance.
|
|
|
|
|
That is ASP.NET code. Please use the correct forum.
|
|
|
|
|
How do I Filter a value selected from the dropdown list? note. the dropdown list is populated with values from another table.
|
|
|
|
|
The best method is to filter the table so you only populate the dropdown with the necessary information.
|
|
|
|
|
Why is it that Metro style apps do not include "Imports System.Data.SqlClient"?
I found this out about a year ago and I have not asked why Visual Studios for metro apps does not allow for SqlClient. I feel that by doing this Microsoft is pushing away developers from using MSSQL Server. So you have options of using SQL Lite, Azure Web Services, WCF and there might be other ways to get data. However that takes away from precious time us developers have to make apps.
Also are there any work arounds for using MSSQL Server and using Imports System.Data.sqlClient?
Sincerely a Developer.
|
|
|
|
|
I think you should direct your question to Microsoft.
|
|
|
|
|
Microsoft is already alert, but isn't implementing. This namespace of .NET isn't available, instead he needs to work with Storage APIs.
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
|
hi,
i have google autocomplete suggestion in textbox and added jquery autocmplete suggestion to google pac-container div.
If i select the jquery suggestions from div, i am able to fire in
$(document).on("click", function (e) {
]
but i need to get selected element value. below is my div.
LondonUnited Kingdom London BridgeBengaluru, Karnataka, India LonavalaMaharashtra, India Longitude GroupLavelle Road, D Souza Layout, Bengaluru, Karnataka, India LondenpetKrishnagiri, Tamil Nadu, India 830 LONG DRIVE, ABERDEEN, MARYLAND, UNITED STATES, 21001 2370.628906-4569.779785 830 LONG DRIVE, ABERDEEN, MARYLAND, UNITED STATES, 21001 2371.930664-4571.367188 1 AVENUE DELAFOSSE PROLONGEE 01 BP 2185, ABIDJAN, COTE D'IVOIRE, 2185 320.179077-241.665054 9910 AVALON ROAD NW, ALBUQUERQUE, NEW MEXICO, UNITED STATES, 87121 2105.522949-6394.536133 9910 AVALON ROAD NORTHWEST, ALBUQUERQUE, NEW MEXICO, UNITED STATES, 87121 2103.865723-6389.127441
based on Div selection option (id =areasearch or class="pac-item-areasearch") i need to get the addrees and lat & lon.
How to achieve selected div element values .
if anybody knows reply me.
Thanks in advance.
modified 24-Jul-15 8:31am.
|
|
|
|
|
You might want to ask this question in the web development forum. It has nothing to do with the .NET Framework, and you will find that it's better to get help from the experts in the appropriate forum.
|
|
|
|
|
With this type of code which is the best option to check a column prior to inserting data? Stored procedure or additional code here.
thanks
con.Open();
SqlCommand cmd = new SqlCommand("insert into MOD_002 values('" + DropDownList4.SelectedValue + "','" + DropDownList5.SelectedValue + "','" + TextBox9.Text + "','" + Datebox.Text + "','" + Operator0.Text + "','" + TextBox8.Text + "')", con);
cmd.ExecuteNonQuery();
con.Close();
Label4.Text = "MOD_002 is updated"; con.Open();
SqlCommand cmd = new SqlCommand("insert into MOD_002 values('" + DropDownList4.SelectedValue + "','" + DropDownList5.SelectedValue + "','" + TextBox9.Text + "','" + Datebox.Text + "','" + Operator0.Text + "','" + TextBox8.Text + "')", con);
cmd.ExecuteNonQuery();
con.Close();
Label4.Text = "MOD_002 is updated";
|
|
|
|
|
Best to use command parameters instead of a constructed string, but if you must then you must verify all parameters yourself in your code.
|
|
|
|
|
I would say that you should separate the program into layers:
1. The User Layer handles user interactions.
2. The Business Layer validates the data and does any necessary processing.
3. The Data Layer stores the data in the database.
In this model, all validation should be done in the Business Layer.
Your code fragment mixes the layers; you have the Data Layer, you want to add validation (part of the Business Layer), and you also have the User Layer (in the last line).
IMO, the only validation that should be performed inside the database is inherent:
1. Unique indexes must be unique.
2. non-Null fields must be non-Null.
etc.
If you have an important point to make, don't try to be subtle or clever. Use a pile driver. Hit the point once. Then come back and hit it again. Then hit it a third time - a tremendous whack.
--Winston Churchill
|
|
|
|
|
I have a problem in trying to make an Inventory Report using crystal report in my Sales and Inventory System using vb.net.
I have two tables (Purchase and Sales). Whenever I used this line of code, It will give the correct total item purchased with Item name in a given date:
str = "SELECT Purchase.Item, SUM(Purchase.Quantity_received) as Purchases FROM Purchase WHERE " _
& " Purchase.PO_Date between #" & dtfrom.Value.ToShortDateString & "# AND #" & dtto.Value.ToShortDateString _
& "# GROUP BY Purchase.Item"
When using the line of code below, the total item purchased in a given date will be no longer the same and correct. I'am confused with how will I correctly join and group multiple tables.
str = "SELECT Purchase.Item, SUM(Purchase.Quantity_received) as Purchases, SUM(Sales.Quantity) as Sold FROM Purchase INNER JOIN Sales ON Purchase.Item=Sales.Item_Description WHERE " _
& " Purchase.PO_Date between #" & dtfrom.Value.ToShortDateString & "# AND #" & dtto.Value.ToShortDateString _
& "# AND Sales.Sales_Date between #" & dtfrom.Value.ToShortDateString & "# AND #" & dtto.Value.ToShortDateString _
& "# GROUP BY Purchase.Item"
I want the following result in my crystal report:
1. To have a complete Item Name list of my Purchases with the corresponding Quantity of the total purchase ordered in the given date
2. To get the total Quantity of Items Sold in the given date
3. To get the remaining stocks in the given date
Any help would be much appreciated. Thank you.
|
|
|
|
|
Your code is vulnerable to SQL Injection[^].
NEVER use string concatenation to build a SQL query. ALWAYS use a parameterized query:
using (var connection = new SqlConnection("..."))
using (var command = new SqlCommand("... PO_Date Between @FromDate And @ToDate ...", connection))
{
command.Parameters.AddWithValue("@FromDate", dtfrom.Value);
command.Parameters.AddWithValue("@ToDate", dtto.Value);
...
}
I'm guessing that the problem is that you could have multiple sales and multiple purchases for the same item within the same date range. When you join the tables on the item, every purchase within the date range gets matched up to every sale for the same item in that date range. As a result, the purchase quantities will be multiplied by the number of sales, and the sales quantities will be multiplied by the number of purchases.
Also, since you're using an INNER JOIN, your query won't pick up any items with a purchase but no sale within the date range, or with a sale but no purchase within the date range.
You didn't mention which DBMS you're using. Assuming Microsoft SQL Server 2005 or higher, something like this should work:
WITH ctePurchases As
(
SELECT
Item,
Sum(Quantity_Received) As Quantity_Received
FROM
Purchase
WHERE
PO_Date Between @FromDate And @ToDate
GROUP BY
Item
),
cteSales As
(
SELECT
Item_Description,
Sum(Quantity) As Quantity
FROM
Sales
WHERE
Sales_Date Between @FromDate And @ToDate
GROUP BY
Item_Description
)
SELECT
IsNull(P.Item, S.Item_Description) As Item,
IsNull(P.Quantity_Received, 0) As Purchases,
IsNull(S.Quantity, 0) As Sold
FROM
ctePurchases As P
FULL OUTER JOIN cteSales As S
ON S.Item_Description = P.Item
;
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Thanks for you help. I am now trying to figure it out based on your idea. By the way, i'm using vb.net 2008 with MS Access as my database back-end.
A little clarification, may I ask if what do you mean with your
your
WITH ctePurchases As... peace of code? Thanks again. I'm new, apologize.
modified 23-Jul-15 18:37pm.
|
|
|
|
|
It's a Common Table Expression, which Access doesn't support.
|
|
|
|
|
ratchoy010 wrote: By the way, i'm using vb.net 2008 with MS Access as my database back-end.
OK, that's the sort of useful information you should include in your question. 
Access doesn't support common table expressions. You might be able to use a nested query, although I haven't tried it:
SELECT
IsNull(P.Item, S.Item_Description) As Item,
IsNull(P.Quantity_Received, 0) As Purchases,
IsNull(S.Quantity, 0) As Sold
FROM
(
SELECT
Item,
Sum(Quantity_Received) As Quantity_Received
FROM
Purchase
WHERE
PO_Date Between ? And ?
GROUP BY
Item
) As P
FULL OUTER JOIN
(
SELECT
Item_Description,
Sum(Quantity) As Quantity
FROM
Sales
WHERE
Sales_Date Between ? And ?
GROUP BY
Item_Description
) As S
ON S.Item_Description = P.Item
You'll also find the the OleDbCommand doesn't support named parameters; you have to use ? as the parameter placeholder, and add the parameters to the command in the same order as they appear in the query:
using (var connection = new OleDbConnection("..."))
using (var command = new OleDbCommand("...", connection))
{
command.Parameters.AddWithValue("p0", dtfrom.Value);
command.Parameters.AddWithValue("p1", dtto.Value);
command.Parameters.AddWithValue("p2", dtfrom.Value);
command.Parameters.AddWithValue("p3", dtto.Value);
...
}
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Hi,
Is it possible to add Custom Suggestions to the google.maps.places.Autocomplete suggestion.
Below code i used to get the google suggestion list based on text entry on textbox but i need to add additional suggestion from database based on same text entry and add those suggestions to this google suggestion list DIV.
google.maps.event.addDomListener(window, 'load', function () {
var places = new google.maps.places.Autocomplete(document.getElementById('txtPlaces'));
google.maps.event.addListener(places, 'place_changed', function () {
var place = places.getPlace();
var address = place.formatted_address;
var latitude = place.geometry.location.lat();
var longitude = place.geometry.location.lng();
});
});
how to achieve this.
If anybody knows, please reply me.
Thanks in advance.
modified 16-Jul-15 7:54am.
|
|
|
|
|
So what did Google say when you asked them about using their API?
|
|
|
|
|
Hello everybody,
I m learning C# for some months now through Coursera ,microsoft virtual academy and learnvisualstudio.net and I m a little confused about ASP.NET.I have developed some sites in weebly but there were some limitations.So my question is can I built a site totally in C# front end and back end .I thought C# can only do the back end tasks and I m confused about ASP.Net what can do ,is and what languages has in it.Should I learn html also with C#?The thing is that sometimes customers want to add new contents on their sites easily so I want them to give them that option.Thank you a lot .
|
|
|
|
|
The content that is supplied to the browser is HTML and JavaScript. You really should learn that. The C# side runs at the server end and, while you can generate HTML content from that, it is definitely helpful if you know how to code up in JavaScript as well.
|
|
|
|
|
Server end is different from back end ?Isn't C# the main language of ASP.NET?
|
|
|
|
|
ASP.NET code runs entirely on the web server. It generates the HTML that is sent to the browser.
"Front end" refers to code on the server that generates the HTML. It can also refer to either browser-side code, mainly javascript and HTML. "Back end" usually refers to some data store, like a SQL database, and the code that interacts with it. This code is sometimes called "middleware".
ASP.NET code can be written in any language that targets the .NET Framework, not just C# though it's the most popular.
|
|
|
|
|
So as I understand and thank you all for that I will learn html and C#.I will be ready then to make a site.Probably html is for the design like buttons tabs etc (like xaml is for WPF)and C# is what runs back like storing passwords moving to pages etc.Thank you all again.Glad we have tools like that cause when I was in college before 14 years you should write a lot of code for simple stuff.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
