|
Yep - I use two databases for the ASP.Net ap I am working on, just need to define two connection strings, I use:
Dim conn As New SqlConnection("Server=SERVER;" & _
"Database=DATABASE1;User ID=nottelling;Password=nottelling")
Dim conn2 As New SqlConnection("Server=SERVER;" & _
"Database=DATABASE2;User ID=nottelling;Password=nottelling")
(this may not be the best way to do it, but it works)
also, remember you can query two databases in a single SQL query if they are on the same server
Dim SignedOutCommand As New SqlCommand("Select S.StaffID, S.InTime, S.HaveMob, I.FirstName, I.LastName FROM WhereAreYou.dbo.StaffOut S, Infobase.dbo.Staff I WHERE S.StaffID = I.StaffID ORDER BY I.FirstName", conn)
is one of my commands.
Hope this helps!
|
|
|
|
|
I have a web application developed for a single customer in VS2003. The application consistes of about a dozen pages. I am now deploying it to several other customers. For each different customer, most of the pages remain the same, with one or two pages being "custom" for each customer. I would like to maintain the source code for the "common" pages in a single location and just create or modify the different pages for each customer. I tried this using the "sharing" feature of Visual SOurce Safe 6, with no luck.
Can anyone reccommend a method of doing this such that i can create a new web app that shares a "base" set of pages so that as i make upgrades to the app, they will be made in one common set of files?
|
|
|
|
|
I was generating a word document with a password set to it from an ASP.NET application...
It was working fine except that a table which is assigned as the header is not correctly getting executed and that the 2 gif images are also not loaded.
The code is.....
wordApp.ActiveWindow.ActivePane.View.[U]SeekView[/U] =
Word.WdSeekView.wdSeekCurrentPageHeader;
if(Convert.ToString(POarray[17]) != "0")
{
object dBehaviour = Word.WdDefaultTableBehavior.wdWord9TableBehavior;
object aBehaviour = Word.WdAutoFitBehavior.wdAutoFitWindow;
Word.Range tableRange = wordApp.Selection.Range;
Word.Table TblPO = wordDoc.Tables.Add(tableRange, 1, 3, ref dBehaviour,
ref aBehaviour);
TblPO.AllowAutoFit = true;
TblPO.TableDirection = Word.WdTableDirection.wdTableDirectionLtr;
TblPO.Columns.PreferredWidth = 10.0f;
TblPO.Cell(0,1).Range.Select();
string picHeaderLeft =
"C:\\InetPub\\WWWroot\\FolderName\\images\\Logo1.gif";
TblPO.Cell(0,1).Range.InlineShapes.AddPicture(picHeaderLeft, ref missing,
ref missing, ref missing);
//The above code in If Block is not getting executed correctly
//Only the following code is executed correctly (the middle cell)
TblPO.Columns.PreferredWidth = 80.0f;
//used setwidth()method...Got an exception
//which i could not resolve...
//And i am Automating Word 2000 (Word 9.0.2720)
TblPO.Cell(0,2).Range.Select();
wordApp.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
//TblPO.Cell(0,2).Range.Font.Size = 11;
//TblPO.Cell(0,2).Range.Font.Name = "Times New Roman";
string file = Convert.ToString(POarray[17]); // FilePath
TblPO.Cell(0,2).Range.InsertFile( file, ref missing, ref missing, ref missing, ref missing );
// The file got inserted correctly to the document as header
// Meaning TblPO is active in memory
// Again the following code is not getting executed properly
TblPO.Columns.PreferredWidth = 10.0f;
TblPO.Cell(0,3).Range.Select();
string picHeaderRight
= "C:\\InetPub\\WWWroot\\FolderName\\images\\Logo2.gif";
TblPO.Cell(0,3).Range.InlineShapes.AddPicture(picHeaderRight, ref missing,
ref missing,ref missing);
}
The code snippet continues as...
wordApp.Selection.TypeParagraph();
wordApp.ActiveWindow.ActivePane.View.SeekView =
Word.WdSeekView.wdSeekMainDocument;
wordApp.Selection.TypeParagraph();
wordApp.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
wordApp.Selection.Font.Bold = 1;
wordApp.Selection.Font.Underline = Word.WdUnderline.wdUnderlineSingle;
wordApp.Selection.Font.Name = "Times New Roman";
wordApp.Selection.Font.Size = 12;
wordApp.Selection.TypeText("Heading");
I heve checked up the code with breakpoints...But surprisingly it is not entering that "if " statement itself...It was jumping to a statement way
after wordApp.Selection.TypeText("Heading"), after it has executed SeekView statement.
Before also i had problems with breakpoints....Some times it will not enter to this class itself...
As this code is executed in Word(Unmanaged code) and not in CLR...I think inconsistancies can happen.....
I also had problems with solution....Changes not getting reflected in the solution even after building...In .NET is there versioning for solution ?
Please help....
I have no idea why it is behaving like this....
|
|
|
|
|
I’am using the System.Configuration.NameValueSectionHandler to read a key value pair from the web.config file
The code works perfect fine on our offshore environment, but it has failed on our onsite environment.
The web.config has the following entries
<configSections>
<section name="Twin" type="System.Configuration.NameValueSectionHandler, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
</configSections>
<Twin>
<add key="Pair1" value="Value1"/>
<add key="Pair2" value=" Value2"/>
</Twin>
The Error message generated is
An error occurred creating the configuration section handler for TwinCOBAM: Could not load type 'System.Configuration.NameValueSectionHandler' from assembly 'System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'.
I’ve tried the following combinations of the Section entry, I picked up the version number; the public token number from the GAC
<section name="Twin" type="System.Configuration.NameValueSectionHandler, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<section name="Twin" type="System.Configuration.NameValueSectionHandler, System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
After some googling, there are some varied findings; some say that it’s a bug in the .net framework. For some it works without even specifying the version numbers and public token keys. I haven’t been able to pin down the source of this problem.
Please help.
-Ben Salins
|
|
|
|
|
How to apply style to the content in autocompleteextender?
Sandeep Kumbhar
|
|
|
|
|
I am currently working on a competition site that will automatically draw winners at certain times. I have three seperate draws all to be drawn. One every month, another every week and another anually. I have a seperate table in a database with all entrants, obviously all with a unique id.
What I want is an automatic method for the draws. So that they happen seamslessly in the back ground. Draw the winners, email me to tell me about the winner, and update the database.
I'm guessing that it would make more sense to do this in a standalone app as I cant think of a way of getting a web site to automatically check this. Is this a good approach.
Also what would be a good, random method for selecting a winner from the list??
|
|
|
|
|
Sam Heller wrote: I'm guessing that it would make more sense to do this in a standalone app as I cant think of a way of getting a web site to automatically check this. Is this a good approach.
Yeah, you will have to use a standalone application to do this.
Sam Heller wrote: Also what would be a good, random method for selecting a winner from the list??
I would suggest Gaussian method to get the draw, you would get a perfect U curve while plotting the results.
|
|
|
|
|
Ok thanks for that. I had a brief look at Gaussian but looks like it could be slightly overkill for my requirements. I also couldnt see how u would tie that into my problem of having what is basically an array from the database of unique numbers and how to select one of these?
Any other ideas? or examples?
Thanks
|
|
|
|
|
Sam Heller wrote: Ok thanks for that. I had a brief look at Gaussian but looks like it could be slightly overkill for my requirements. I also couldnt see how u would tie that into my problem of having what is basically an array from the database of unique numbers and how to select one of these?
The Gaussian numbers can be used to get a set of random numbers which could be used as the index of the array. If you have 1000 records in your database, you can have your Gaussian function return 10 values(according to how many you need) between 0 and 999. Use the numbers generated as the index and pull out those from the array.
The reason I suggested this is because it follows a uniform distribution and your draws would not follow a pattern.
|
|
|
|
|
Don't suppose you know of any good examples regarding this before I go looking?
|
|
|
|
|
You can have a look at this thread[^]. I wrote the function using the formula I found online, you probably have to search online to find if some code is available.
Formula I used[^]
|
|
|
|
|
Hi all,
I have an aspx page which contains a hiddenfield ..i have javascript in the samepage which contains the following piece of code..
function PostPage()
{
var popup;
document.form1.action = "Default6.aspx";
document.form1.method = "POST";
document.form1.submit();
}
and the aspx page contains the following
<asp:ImageButton ID="ImageButton1" runat="server" OnClientClick="Javascript:PostPage()" />
with the hidden field populated from codebehind...
Now i want the Default6.aspx to be opened as a pop-up after submitting the current page.I need to submit the page instead-of using 'window.open' coz i'can retrieve the hiddenfield value in the popup page...
Overall my question is that when i click on the imagebutton the javascript submit() should occur annd then the new page should be opened as popup ..how to do that? please let me know
Koushik
|
|
|
|
|
Use This link:
http://www.pageresource.com/jscript/j_a_02.htm
Hope this helps u...
|
|
|
|
|
Use this:
http://www.pageresource.com/jscript/j_a_02.htm
OR
Use this
window.showModalDialog("http://www.altavista.com","","dialogWidth:500px;dialogHeight:500px")
|
|
|
|
|
I have a grid and i want to do pagging, i have a form in which i am taking 3 inputs , ID , and 2 dates and showing records in that grid on the base of that ID and dates. for example my Qry returns 25 records and it shows in 3 pages when i click page number 2 all values remain same ,when i click on 3rd page it makes it page size to 5 but values remains same.
any help in this respect will be higly appreciated.
K Dastgir
|
|
|
|
|
|
i guess problem is due to parameters i am passing in Qry strin that every time parameters are passed again and results comes same instead of next page
on Page load i have this code
If Not Page.IsPostBack Then
bind SQL
end if
BindSQL()
'DSgrid is a data.dataset
'DB is a object of a class where i make connection
dsgrid = db.getRecords("SELECT attendence.EmpNo, Strength.Name,convert(varchar,Strength.DOJ,101)as DOJ,Strength.EmpStatusid,convert(varchar,attendence.Date,101)as DDate,convert(varchar,attendence.InTime,108) As InTime,convert(varchar,attendence.OutTime,108)As OutTime,attendence.Present AS Status,convert(varchar,(OutTime-InTime),108)As WorkedHrs FROM attendence INNER JOIN Strength ON attendence.EmpNo = Strength.EmpNo Where attendence.EmpNo ='" & cempid & "'AND attendence.Date >= '" & mfromdate & "' And attendence.Date <= '" & mtodate & "' Order by Date")
Dim mtcheck As Integer = dsgrid.Tables(0).Rows.Count()
If mtcheck = 0 Then
lblerror.Visible = True
Label3.Visible = False
Label5.Visible = False
lblerror.Text = "No Record Found"
Else
DG_CheckBox.DataSource = dsgrid
DG_CheckBox.DataBind()
End If
End Sub
Sub myDataGrid_PageChanger(ByVal Source As Object, ByVal E As DataGridPageChangedEventArgs)
DG_CheckBox.CurrentPageIndex = E.NewPageIndex
BindSQL()
End Sub
K Dastgir
|
|
|
|
|
Didnt understood this function
Sub myDataGrid_PageChanger(ByVal Source As Object, ByVal E As DataGridPageChangedEventArgs)
DG_CheckBox.CurrentPageIndex = E.NewPageIndex
BindSQL()
End Sub
I Think it should be like this
Sub DG_CheckBox_PageChanger(ByVal Source As Object, ByVal E As DataGridPageChangedEventArgs)
DG_CheckBox.CurrentPageIndex = E.NewPageIndex
BindSQL()
End Sub
Hope this helps u...
|
|
|
|
|
sorry it was my mistake it is DG)checkbox_pagechanger(...)
result is same
can it be the parameters passing in the qry making this problem
K Dastgir
|
|
|
|
|
I have Change your code please,
'Bind GridView Method
Public Sub BindGridView()
Dim oDS As New DataSet
strSql = "Your Query"
oDS = db.ExecuteDataSet(strSql)
DG_CheckBox.DataSource = oDS
DG_CheckBox.DataBind()
End Sub
'Return Dataset
Public Function ExecuteDataSet(ByVal strsql As String) As DataSet
Dim dtad As SqlDataAdapter
Dim dtst As DataSet
dtst = New DataSet
dtad = New SqlDataAdapter(strsql, GetConnection)
' GetConnection Get the sql connection
dtad.Fill(dtst)
CloseConnection()
Return dtst
End Function
Protected Sub DG_CheckBox_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles DG_CheckBox.PageIndexChanging
Try
DG_CheckBox.PageIndex = e.NewPageIndex()
BindGridView()
Catch ex As Exception
End Try
End Sub
U Can use EmptyDataText if your query doesnt returns any records.
eg: EmptyDataText = "No Record Found"
Else u can use your code also for showing error "No Record Found"
Hope this helps u...
|
|
|
|
|
Hi,
I am looking for a rental system like for videos or property, it must be open source. Does any one know of something like this?? It must preferably have a back office and must be integrated into a payment gateway, like Pay Pal for example. But the payment gateway is not required, I'm also looking for a rental calendar, where a user can look at what dates a property has been booked for.
Please can someone help me out.
Regards
ma se
|
|
|
|
|
<asp:dropdownlist id="ddlNames" runat="server">
<asp:listitem>item 1
<asp:listitem>item 2
<asp:listitem>Heer i want to allow user to add item 3
in the 3rd lstitem i want to allow user to edit his own item.
Savindra
-- modified at 8:18 Wednesday 9th May, 2007
|
|
|
|
|
savindra.bandi wrote: eer i want to allow user to add item 3
you can add item at run time
<br />
DropDownList1.Items.Add(new ListItem("text","Value"));<br />
savindra.bandi wrote: n the 3rd lstitem i want to allow user to edit his own item.
I think you can't do it using drop down list .
You can go with different approach by Adding one more TextBox
When user selects item from drop down list it will get into text where you can Edit it and After editing Add back to drop down list ...
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
Tnx mr sandeep,
I will look wat I have...
|
|
|
|
|
Hi to all
i used Radiobuttonlist for displaying the two radio buttons Gross & Net
& also i am having a checkbox on form when i click this checkbox then
this radio buttons should be enabled. I make this radiogross disabled on page load event. but it is not getting enabled.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
