|
Imports System
Imports System.Data
Imports System.Data.OleDb
Imports System.Data.SqlClient
Imports System.Data.Common
Imports System.IO
Protected Sub Button3_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button3.Click
Dim cn As New OleDbConnection
Dim cm As New OleDbCommand
cn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Data\Excel_File.xlsx;Extended Properties=""Excel 12.0 Xml;HDR=YES""")
cn.Open()
With cm
.Connection = cn
.CommandText = "INSERT INTO [feuil1$] ([Operateur], [Type_Heures], [Date], [Heure_Entree], [Heure_Sortie], [Taches])VALUES (op, th, dt, he, hs, tc)"
cm = New OleDbCommand(.CommandText, cn)
cm.Parameters.AddWithValue("op", Label4.Text)
cm.Parameters.AddWithValue("th", RadioButtonList1.Text)
cm.Parameters.AddWithValue("dt", TextBox3.Text)
cm.Parameters.AddWithValue("he", TextBox1.Text)
cm.Parameters.AddWithValue("hs", TextBox2.Text)
cm.Parameters.AddWithValue("tc", TextBox4.Text)
cm.ExecuteNonQuery()
MsgBox("UPDATE SUCCESSFUL")
cn.Close()
End With
End Sub
|
|
|
|
|
I know that I can retrieve the values in resx files programmaticaly. But, Is there a way to modify the values of existing resx key's? For eg: there is an entry already in the resx file as below:
Key: UsernameReqdValidation
Value: User Name is required.
I want to change this value to 'UserName is mandatory'. Can this can be changed by the user on run time?
I googled for a while, but couldn't find any useful stuff. Please help.
|
|
|
|
|
|
i was reading a signalr private & public chat code and it looks great but few area i just do not understand. i was reading from this url
http://www.tugberkugurlu.com/archive/mapping-asp-net-signalr-connections-to-real-application-users
https://github.com/tugberkugurlu/SignalRSamples/blob/master/ConnectionMappingSample/ConnectionMappingSample/Hubs/ChatHub.cs
public class User {
public string Name { get; set; }
public HashSet<string> ConnectionIds { get; set; }
}
public class ChatHub : Hub {
private static readonly ConcurrentDictionary<string, user=""> Users
= new ConcurrentDictionary<string, user="">(StringComparer.InvariantCultureIgnoreCase);
public override Task OnConnected() {
string userName = Context.User.Identity.Name;
string connectionId = Context.ConnectionId;
var user = Users.GetOrAdd(userName, _ => new User {
Name = userName,
ConnectionIds = new HashSet<string>()
});
lock (user.ConnectionIds) {
user.ConnectionIds.Add(connectionId);
// // broadcast this to all clients other than the caller
// Clients.AllExcept(user.ConnectionIds.ToArray()).userConnected(userName);
// Or you might want to only broadcast this info if this
// is the first connection of the user
if (user.ConnectionIds.Count == 1) {
Clients.Others.userConnected(userName);
}
}
return base.OnConnected();
}
}
i do not understand OnConnected() function very well. so please help me to understand it. why they use
HashSet class ?
if some one see the full code from my given url then please tell me how they could handle users with same name but different connection id?
thanks
tbhattacharjee
|
|
|
|
|
|
where is the answer....? i am looking for answer.
tbhattacharjee
|
|
|
|
|
I think that if a user has multiple tabs or windows open in their web browser then each one will be considered a different web socket connection.
A HashSet isn't something I've used, but I believe it is a high performance List that will never store duplicate values. I would recommend reading the MSDN remarks on the class to make sure you understand what it is:
The reason for this HashSet would be to ensure that all connections to a given user are associated with each other, so that a message intended for that user would be sent to all of his active connections.
I think the idea is that your user name would be a unique value - for example a user logging into your site using their email address. If you wanted to make users share the same visible user name, you would still need to give them a unique identifier to track them with.
I understand that English is probably not your primary language, but is there some specific point in that tutorial link that you sent that you're having difficulty understanding? I'm afraid that without you being more specific I would only be able to repeat whatever is written in that article, and probably only confuse you more.
|
|
|
|
|
My GIF image doesn't stop rotating. It continues just like that. Also If there is some txtbox empty and is required still it shows up Progress and keeps on rotating.
Here is my Code. Can anyone in here help me with this
<script language="javascript" type="text/javascript">
function StartProgressBar() {
var myExtender = $find('ProgressBarModalPopupExtender');
myExtender.show();
return true;
}
function StopProgressBar() {
var myExtender = $find('ProgressBarModalPopupExtender');
myExtender.hide();
return true;
}
function Valid() {
if (Page_ClientValidate("Required") == true) {
StartProgressBar()
}
else {
alert("Please fill the Required fields");
}
}
</script>
<asp:Button ID="btnSubmit" runat="server" Text="Submit" CssClass="Button" OnClientClick="Valid()" />
<div>
<cc1:ModalPopupExtender ID="ProgressBarModalPopupExtender" runat="server" BackgroundCssClass="ModalBackground" behaviorID="ProgressBarModalPopupExtender" TargetControlID="hiddenField" PopupControlID="Panel1" />
<asp:Panel ID="Panel1" runat="server" Style="display: none; background-color: #C0C0C0;">
<asp:Image ID="Image3" ImageUrl="~/Images/712Blue.GIF" runat="server" AlternateText="" />
</asp:Panel>
<asp:HiddenField ID="hiddenField" runat="server" />
</div>
Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
If Page.IsValid Then
Thread.Sleep(300)
ProgressBarModalPopupExtender.Hide()
ClearAll()
End If
End Sub
Your help is much appreciated.
Thanks
Happy Coding!
|
|
|
|
|
So you put a progress bar in a modal extender?
Must people just use the updateProgress control. I do it in code, but it's been years since I built one on the webform, so I won't be much help on that.
I don't know about the textbox issue.
Create Modal Popup in Ajax UpdateProgress[^]
|
|
|
|
|
Of course Modal extender is in Update panel. It is an Ajax control. So it wont work if it is not in update panel. But issue here is I added a Validation group and checking in JavaScript. Even after checking Validation why is it still showing progress bar when validation failed. That is making progress bar to rotate continuously. But couldn't figure how to solve it.
Your help is much appreciated.
Thanks
Happy Coding!
|
|
|
|
|
I said update progress, not update panel
The update progress shows the progress content only during postback, and then it disappears.
You attach it to the update panel.
Animated gifs go round and round, that's what there suppose to do. Perhaps you mean that the image won't go away or hide, or the div element that contains the image won't hide or go
display: none
|
|
|
|
|
|
Hello Experts,
I am wondering if anyone in here can help me understand this simple concept.
if ddl="abc" and fileuplaod1.HasFile Then
UploadFile
Bool=true
Else if ddl="abc" and FileUpload1.HasFile=false Then
Alert asking for fileupload
Bool=false
Else
Bool=True
If Bool=True then
DataBind to Gridview
So in here my second condition executes though one of them is false. How can I stop that?
Your help is much appreciated.
Thanks
Happy Coding!
|
|
|
|
|
|
Excellent ... Thank you. I thought it will be same as C#. In C# you just say && VB.Net is 
Thanks again PiebaldConsult
Your help is much appreciated.
Thanks
Happy Coding!
|
|
|
|
|
I have a linkbutton in Gridview which downloads uploaded file. When I click on download linkbutton, it only downloads the file when all the textboxes above grid are not empty.
Ex:
txt1
txt2
fileupload
Grid
after giving values to txt1, txt2 and file uploaded I click on button and Gridview is populated with the values entered which has a Download link button that downloads the attached file. Now when I click on Download if txt1 and txt2 are empty it shows Required field validator asking me to fill those fields. Only after filling it Downloads the file.
Do you know why is this weird thing happening?
Your help is much appreciated.
Thanks
Happy Coding!
|
|
|
|
|
|
Hahaha No I didn't  .what happened is on Linkbutton I must set Causevalidation=false. This is my guess. But I am not sure.
Your help is much appreciated.
Thanks
Happy Coding!
|
|
|
|
|
i dont use the Vs validation controls, they can be annoying especially in this case where it want to force you to enter something even if you want to do something entirely separate to the problem controls. The way i solve this, is that i ajaxify(Update panels and add Triggers) the control, if you have two controls that are causing a Problem why dont you handle validation manually ?
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa[at]dotnetfunda.com
http://www.Dotnetfunda.com
|
|
|
|
|
I really didn't understand "Quote: why dont you handle validation manually ?
Can you explain me how to do it manually?
Your help is much appreciated.
Thanks
Happy Coding!
|
|
|
|
|
Remove the Validation controls on these controls
txt1
txt2
fileupload
and trap for things that might go wrong e.g when you trying to add etc... after you remove those validation controls , it will solve your Grid issue.
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa[at]dotnetfunda.com
http://www.Dotnetfunda.com
|
|
|
|
|
Thanks but I still did not understand it. I am new to DotNet so this is taking time to understand.
Your help is much appreciated.
Thanks
Happy Coding!
|
|
|
|
|
please post your html here and i will fix it here for you
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa[at]dotnetfunda.com
http://www.Dotnetfunda.com
|
|
|
|
|
If you debug it, it should be pretty easy to see what is happening.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
How to solve this error
Error:
Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed.
My ASPX:
<asp:UpdatePanel ID="Upnl1" runat="server">
<Triggers>
<asp:PostBackTrigger ControlID="btnAddLineItems" />
</Triggers>
<ContentTemplate>
<div>
</div>
<asp:panel>
<table>
txt1
txt2
ddl1
ddl2
File upload
Button Add new Items
</table>
</asp:panel>
<asp:updatepanel>
<ContentTemplate>
<Gridview>
<Boundfield 1=txt1>
<Boundfield 2=txt2>
<Boundfield 3=ddl1>
<Boundfield 4=ddl3>
<Templatefield Link button="Download">
</Gridview>
</ContentTemplate>
<asp:updatepanel>
</ContentTemplate>
</asp:UpdatePanel>
LinkbuttonClick Event:
Dim filePath As String = CType(sender, LinkButton).CommandArgument
Response.ContentType = ContentType
Response.AppendHeader("Content-Disposition", ("attachment; filename=" + Path.GetFileName(filePath)))
Response.WriteFile(filePath)
Response.End()
Your help is much appreciated.
Thanks
Happy Coding!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
