|
I have created an MS ACCESS database file, and configured a DSN using ODBC.
To access my database through the ODBC driver, I use the connection string as follows: "Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\MyDb.mdb"
So, what shall be the connection string if I'd like to use the DSN I created.
Mohamed Gouda
Egypt
|
|
|
|
|
|
if i am copying a website using vwd to a web server do i need to create a dll manually as 1 is created for me automatcially
also should I have a namespace defined in my code?
thanks
|
|
|
|
|
|
Hi
shall i explain
I have a website made in VWD, there are no dlls for it
it used to run on citrix fine
now ive moved it to web server it doesnt
I have a cs file called common methods which is in app_code folder
i have a file called login.aspx.cs which references this file
e.g.
Common_methods.SetFocus(Login1.FindControl("UserName"), this);
this worked fine in citrix
not in web server
any clues/
fanx
|
|
|
|
|
Is there a way to play and mp3 file on a page without relying on whether or not a media player, such as windows mediad player, is first installed on the computer?
|
|
|
|
|
The best maximum thing that you can do is to embed the MP3 using EMBED tag and it is upto the web browser to choose the available Media Player to play it.
Vasudevan Deepak Kumar
Personal Homepage Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
hello i have folowing function
Public Shared Function Save(ByVal myContactInfo As ContactInfo) As Integer
Dim result As Integer = 0
Dim myConnection As SqlConnection = New SqlConnection(AppConfiguration.ConnectionString)
Try
Dim myCommand As SqlCommand = New SqlCommand("JobsDb_ContactInfo_InsertUpdateSingleItem", myConnection)
myCommand.CommandType = CommandType.StoredProcedure
If myContactInfo.UserID = -1 Then
myCommand.Parameters.AddWithValue("@Userid", DBNull.Value)
Else
myCommand.Parameters.AddWithValue("@Userid", myContactInfo.UserID)
End If
myCommand.Parameters.AddWithValue("@UserName", myContactInfo.UserName)
myCommand.Parameters.AddWithValue("@Title", myContactInfo.Title)
myCommand.Parameters.AddWithValue("@FirstName", myContactInfo.FirstName)
myCommand.Parameters.AddWithValue("@LastName", myContactInfo.LastName)
myCommand.Parameters.AddWithValue("@Email", myContactInfo.Email)
If String.IsNullOrEmpty(myContactInfo.StreetAddress1) Then
myCommand.Parameters.AddWithValue("@StreetAddress1", DBNull.Value)
Else
myCommand.Parameters.AddWithValue("@StreetAddress1", myContactInfo.StreetAddress1)
End If
If String.IsNullOrEmpty(myContactInfo.StreetAddress2) Then
myCommand.Parameters.AddWithValue("@StreetAddress2", DBNull.Value)
Else
myCommand.Parameters.AddWithValue("@StreetAddress2", myContactInfo.StreetAddress2)
End If
If String.IsNullOrEmpty(myContactInfo.ZiporPost) Then
myCommand.Parameters.AddWithValue("@ZipOrPost", DBNull.Value)
Else
myCommand.Parameters.AddWithValue("@ZipOrPost", myContactInfo.ZiporPost)
End If
myCommand.Parameters.AddWithValue("@CountryId", myContactInfo.CountryID)
myCommand.Parameters.AddWithValue("@StateId", myContactInfo.StateID)
myCommand.Parameters.AddWithValue("@city", myContactInfo.City)
If String.IsNullOrEmpty(myContactInfo.PrimaryPhone) Then
myCommand.Parameters.AddWithValue("@PrimaryPhone", DBNull.Value)
Else
myCommand.Parameters.AddWithValue("@PrimaryPhone", myContactInfo.PrimaryPhone)
End If
If String.IsNullOrEmpty(myContactInfo.SecondaryPhone) Then
myCommand.Parameters.AddWithValue("@SecondaryPhone", DBNull.Value)
Else
myCommand.Parameters.AddWithValue("@SecondaryPhone", myContactInfo.SecondaryPhone)
End If
myCommand.Parameters.AddWithValue("@WorkStatus", myContactInfo.WorkStatus)
myCommand.Parameters.AddWithValue("@SHMyName", myContactInfo.SHMyName)
myCommand.Parameters.AddWithValue("@SHMyEmail", myContactInfo.SHMyEmail)
myCommand.Parameters.AddWithValue("@SHMyPhones", myContactInfo.SHMyPhone)
myCommand.Parameters.AddWithValue("@ActivityDate", myContactInfo.ActivityDate)
Dim returnValue As DbParameter
returnValue = myCommand.CreateParameter
returnValue.Direction = ParameterDirection.ReturnValue
myCommand.Parameters.Add(returnValue)
myConnection.Open()
myCommand.ExecuteNonQuery()
result = Convert.ToInt32(returnValue.Value)
myConnection.Close()
Finally
CType(myConnection, IDisposable).Dispose()
End Try
Return result
End Function
and i want to get return value of user id which is main column and primary key with identity specification =yes
i want to get something like this
If Not (Profile.UserId = -1) Then
myContactInfo.UserID = Profile.UserId
[ContactInfoManager].Save(myContactInfo)
[BandEManager].Save(myBandE)
[DPManager].Save(mydp)
Else
Dim returnvalue As Integer = ContactInfoManager.Save(myContactInfo)
Profile.UserId = returnvalue
[BandEManager].Save(myBandE)
[DPManager].Save(mydp)
End If
but when i run the save function i get UserId=0 wich is supposed to be UserId of that contact info table in database...please can anyone help
thank you in advance
appu
modified 20-Apr-17 11:32am.
|
|
|
|
|
What is your stored proc returning?
only two letters away from being an asset
|
|
|
|
|
its
ALTER PROCEDURE [dbo].[JobsDb_ContactInfo_InsertUpdateSingleItem]
@Userid int ,
@UserName varchar(50),
@Title varchar(50),
@FirstName varchar(50) ,
@LastName varchar(50),
@Email varchar(50),
@StreetAddress1 Varchar(50),
@StreetAddress2 Varchar(50),
@ZiporPost varchar(40),
@CountryId int,
@StateId int,
@City varchar(50),
@PrimaryPhone varchar(50),
@SecondaryPhone varchar(50),
@WorkStatus smallint,
@SHMyName char(1),
@SHMyEmail char(1),
@SHMyPhones char(1),
@ActivityDate datetime
AS
DECLARE @ReturnValue int
IF (@Userid IS NULL)
BEGIN
INSERT INTO JobsDb_ContactInformation
([UserName] ,
[Title],
[FirstName] ,
[LastName] ,
[Email],
[StreetAddress1],
[StreetAddress2] ,
[ZiporPost] ,
[CountryID],
[StateId],
[City],
[PrimaryPhone] ,
[SecondaryPhone],
[WorkStatus],
[SHMyName] ,
[SHMyEmail],
[SHMyPhones],
[ActivityDate]
)
VALUES
(
@UserName,
@Title,
@FirstName,
@LastName,
@Email,
@StreetAddress1,
@StreetAddress2,
@ZiporPost,
@CountryId,
@StateId,
@City,
@PrimaryPhone,
@SecondaryPhone,
@WorkStatus,
@SHMyName,
@SHMyEmail,
@SHMyPhones,
@ActivityDate
)
SELECT @ReturnValue = SCOPE_IDENTITY()
END
ELSE
BEGIN
UPDATE JobsDb_ContactInformation SET
[UserName] = @UserName,
[Title] = @Title,
[FirstName] = @FirstName,
[LastName] = @LastName,
[Email] = @Email,
[StreetAddress1] = @StreetAddress1,
[StreetAddress2] = @StreetAddress2,
[ZiporPost] = @ZiporPost,
[CountryId]= @CountryId,
[StateId] = @StateId,
[City] = @City,
[PrimaryPhone] = @PrimaryPhone,
[SecondaryPhone] = @SecondaryPhone,
[WorkStatus]=@WorkStatus,
[SHMyName] = @SHMyName,
[SHMyEmail]=@SHMyEmail,
[SHMyPhones]=@SHMyPhones,
[ActivityDate]= @ActivityDate
WHERE
UserId = @Userid
SELECT @ReturnValue = @Userid
END
IF (@@ERROR != 0)
BEGIN
RETURN -1
END
ELSE
BEGIN
RETURN @ReturnValue
END
appu
modified 20-Apr-17 11:32am.
|
|
|
|
|
Hi, I'm looking into WebParts and its authorization. You can set the AuthorizationFilter and use the OnAuthorizeWebPart event of the WebPartManager to check if the user has permissions to see the WebPart.
I understand that this event is called every time the Manager adds a WebPart to the page. Unfortunatly I cannot make it work. I always see all WebParts and when placing a break point, the event is not even triggered. And I am not able to find good articles that handle this subject in detail (preferable with some example code).
Can anybody here help me out understanding the WebPart Authorization? Maybe some links to good articles that explain the subject in detail? I am currently playing around with it to see if everything we need is provided or possible. And this is a very important requirement
"Dream as if you'll live forever, live as if you'll die today" (James Dean)
|
|
|
|
|
Hi,
i am using seekafile application to search the documents,rtf files.
here it is not searched with stop words in the seekafile.
How we enable the stop words to search and how SEEKAFILE.SERVER get body from the document.how it parses the data into multiple words/keywords.
i am facing difficulty with this problem from long time.please help me to solve this problem.
Regards
venkat.M
venkat
|
|
|
|
|
hi
I'm not very familiar with asp.net but want to know how I can add an events calendar to a website.
I would require a backend area to programme cinema screenings and general events, as you can imagine there would be re-occuring dates for certain screenings and also exclusions on certain dates.
On the frontend I would like to have several display options available to the user i.e whats on today, whats on this week and a archive section.
I don't want a calendar display, I know there is a calendar control available, would this work somehow or is there better ways to do this?
thanks
|
|
|
|
|
|
Hi all Is there a way to open a popup window with no title bar. I want to disable or delete maximize minimize and close(x) buttons from the upper right corner of a browser.
I have used javascript window.open and specified titlebar=0 and didnt work.There ia another approach where u specify fullscreen=1 and it works but than the popup window opens fullscreen and i can not open another popup window from the previous page.
Any ideas
|
|
|
|
|
|
Hi all
i need to check all check boxes for a certain column upon checking a checkbox in the header of a gridview. Iam receving the following error
Error Message: C:\CID\Admin\UserAccounts\AccountsEdit.aspx(211): error BC30456: 'chkall' is not a member of 'ASP.admin_useraccounts_accountsedit_aspx'.,
here is the code iam using:
<script>
function chkall(ival)
{
var f= document.getElementById("DataGrid1");
for(var i=0; i<f.getElementsByTagName("input").length ;i++ )
{
if(f.getElementsByTagName("input").item(i).type == "checkbox" )
{
f.getElementsByTagName("input").item(i).checked=ival;
}
}
</script>
</code>
then in the grid view i define
<code><asp:datagrid id="DataGrid1" runat="server">
<Columns>
<asp:TemplateColumn HeaderText="Select All">
<HeaderTemplate>
<asp:CheckBox ID="chkboxViewSelectAll" runat="server" OnCheckedChanged="chkall(this.checked)"></asp:CheckBox>
</HeaderTemplate>
<ItemTemplate>
<asp:CheckBox id="CheckBox1" runat="server"></asp:CheckBox>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:datagrid>
modified 20-Apr-17 11:33am.
|
|
|
|
|
function SelectAllCheckboxes(spanChk)
{
document.getElementById("ctl00_ContentPlaceHolder1_TextBox1").value="prashant"
var oItem = spanChk.children;
var theBox= (spanChk.type=="checkbox") ?
spanChk : spanChk.children.item[0];
xState=theBox.checked;
elm=theBox.form.elements;
for(i=0;i<elm.length;i++)
if(elm[i].type=="checkbox" &&
elm[i].id!=theBox.id)
{
if(elm[i].checked!=xState)
elm[i].click();
}
}
Thanks & Regards,
Prashant B. Lavate
Software Engineer
Mobile-9890413352
Pune(India)
modified 20-Apr-17 11:34am.
|
|
|
|
|
hi, Can anybody Pls. help me regarding FLvplayer, compatible with c#.net. I'm working on a website that need to play user uloaded video files. I want to do this task using flvplayer. so can anybody provide me the link for the open source of flvplayer. Or anything regarding the same. It will be a great help for me.
Thanks,
Thanks & Regards,
Prashant B. Lavate
Software Engineer
Mobile-9890413352
Pune(India)
|
|
|
|
|
|
i want to save html file to server
by asp.net 1.1,
|
|
|
|
|
ashok kr yadav wrote: i want to save html file to server
by asp.net 1.1,
Uploading file ? Or creating a new HTML file ?
|
|
|
|
|
__doPostBack('PageClick',''); --Java Script Code
it's working with page(without master page)
it's not working with page(with master page)
PageClick is a input control Name
You get the best out of others when you give the best of yourself.
|
|
|
|
|
you override oninit method and initialize all the datagrid events for the page in that method.
hope this helps!!!
Sathy
|
|
|
|
|
Hi,
I have an image control which renders the image perfectly on IE, a mehod SetParams is called to set the properties for control to start function. This works well in IE but throws error firefox stating 'SetParams is not a funtion'.
Can any body help me out, i need to fix this as soon as possible.
Here is the sample code
function ViewDocumentImage()
{
var strURL = "http://localhost//customer_data//images//Assessor_2081210_1.tif";
var nPageCount = 1;
var strDescription = "";
alert( "Inside View Document IMage");
if(window.ActiveXObject){
window.document.objImageViewer.SetParams(strURL, nPageCount, strDescription);
}else{
alert(" Inside FireFox");
alert( strURL);
window.document.objImageViewer.SetParams(strURL, nPageCount, strDescription)
document.getElementById('objImageViewer').SetParams(strURL, nPageCount, strDescription);
}
}
<object id="objImageViewer" classid="CLSID:EAC4DA12-B6EA-4A51-B455-1B506043C718" style="width:80%;height:80%">
<embed />
src="params.ini"
border="0"
width="500"
height="250"
name="objImageViewer"
TYPE = "application/x-fobs-activex-plugin"
/>
Click Here
Please respond its very urgent for me
Regards
Trinadh
|
|
|
|
|