|
I have huge excel files with columns havng redundant data. I want to transfer all the excel data into a sql database which is properly fragmented that is 2 tables are used to get the one to many relationship working...
Is there any easy way of doin it... Can anybody provide help regarding SSIS and Dts. i am unable to find Business Intelligence studio .. I don't think i have it...
Please provide help and links to help sites
Thanx
haseeb
|
|
|
|
|
Do you have programming experience ? You could write a VB.NET application that would open the Excel document, loop through the rows and create INSERT statements to your SQL server.
|
|
|
|
|
|
Is there any way to map to multiple tables...do i have to create the database for it manually and then use dts or all tables will be created automatically. also my excel file well there are 2 of them lead to about 10 sql tables of data... how would i be able to fill up these tables with data from excel file which is more than 15mb.
how do i get ssis on my system
thanx
haseeb
|
|
|
|
|
there is only one way to find out. Make a copy of your excel file and try it out. you want learn unless you try it.
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
Hi,
I have a link my aspx page and onclick of that i need to download
and run the msi(ie i need to run a command in client like "msiexec /i http://(servername)/(virtual directory name)/test.msi ALLUSERS=1" )
which is present in the webserver(IIS 5 or IIS 6)...(it"s an intranet application)
as of now im giving the path of the msi to the link ....but the requirement is to
run msi using msiexec so that we can even perform passive installation...
Please help me out .....and correct me if im wrong
|
|
|
|
|
It can not be done. IE will not allow you to execute the msi file. You have two choices
1. write an activex code and with permission from the client you can execute what ever you want. But this only works on IE and you need the client to give you permission
2. Let the client download the msi file and give them instructions in your page how to execute it.
Imagine if someone can write malicious code and use IE to execute it, that would be huge security hole.
|
|
|
|
|
Thanks for ur reply...
please let me know how can i write an ActiveX control and use in my webpage...
|
|
|
|
|
Hi,
I have an application that has been developed mysomebody else and i want to continue developing it...
It has the following connectionstring
< name="abc1" connectionString="Data Source=SERVER\SQLEXPRESS;Initial Catalog=abc;Integrated Security=True"
providerName="System.Data.SqlClient" /> in web.config file;
As i understand it, the database is stored on server and database name is abc, now when i try accessing the server from sql server 2005, it would not access. what should i enter in server txtbox, authentication textbox and the above statement doesn't show any username, so is there any username or password...
please provide help,
Thanx,
haseeb
haseeb
|
|
|
|
|
Hi,
First, note that it uses a named instance (SQLEXPREESS) , so when you try to connect the server you need to specify all (SERVER\SQLEXPRESS)
Second, it is using Integrated Security, so, seems you dont need any specific user/password information.
And yes, the database name is : abc
|
|
|
|
|
Use server explorer of visual studio/database explorer of visual web developer
Right Click Data Connections -> Add Connection
Server Name= IP Address of the remote server [must be static IP]
SQl Authentication:
User Name = type in user name who has authentication
Password = type your password
Click on Test Connection, it will work.
If test not succeed then try to ping the IP Address from command prompt. If not pings, its networking fault. and if it works then check permissions of the server.
|
|
|
|
|
If the database is on the pc you are coding on ,
change >> Data Source=SERVER\SQLEXPRESS to Data Source=(local)\SQLEXPRESS
|
|
|
|
|
Hi all,
One Page of my ASP.NET application uses an active directory search to fetch the list of users.
The Problem is :
This page works fine all day long but sometimes throws an error "The server is not operational".
This error disappears when the IIS is reset, but appears again after 2 or 3 hrs.I am unable to find out the reason behind this.I am sending you the details I found in the event Viewer:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 4/15/2009 6:23:17 AM
Event time (UTC): 4/15/2009 1:23:17 PM
Event ID: dbd99a355e4f451da4fd7e4f50e0f8e1
Event sequence: 21
Event occurrence: 6
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/399023246/Root/Mail-14-128842748654050392
Trust level: Full
Application Virtual Path: /Mail
Application Path: C:\Inetpub\wwwroot\EnhancementSite\Mail on myip\
Machine name: mymachinename
Process information:
Process ID: 2380
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: COMException
Exception message: The server is not operational.
Request information:
Request URL: http://mydomain.com/Mail/newmail.aspx
Request path: /Mail/newmail.aspx
User host address: mydomain.com
User: username
Is authenticated: True
Authentication Type: NTLM
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 5
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
at System.DirectoryServices.DirectoryEntry.Bind()
at System.DirectoryServices.DirectoryEntry.get_AdsObject()
at System.DirectoryServices.DirectorySearcher.FindAll(Boolean findMoreThanOne)
at System.DirectoryServices.DirectorySearcher.FindAll()
at GetAllUsers.getUsers.getUsername(DropDownList dduserlist)
at Mail.newmail.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
kindly help me find a permanent solution to this problem as iisreset is not a very good option.
Thanks
Vasillis_zayetsav
|
|
|
|
|
Try this...
Replace the values for user and active directory group.
DirectoryEntry ent = new DirectoryEntry(appSettings.domain, appSettings.user, appSettings.password, AuthenticationTypes.ReadonlyServer);
DirectorySearcher srch = new DirectorySearcher(ent, "(CN=" + activeDirectoryGroup + ")");
SearchResult obj = srch.FindOne();
DirectoryEntry dr = new DirectoryEntry(obj.Path, appSettings.user, appSettings.password);
foreach (object ob in (IEnumerable)dr.Invoke("members"))
{
DirectoryEntry obGpEntry = new DirectoryEntry(ob);
//Put your code here.
}
I didn't get any requirements for the signature
|
|
|
|
|
Any thoughts how to prevent displaying querystring value information...e.g. abc.aspx?userid=103?
If someone wants they can type in userid=101 or 102 to display information for the other records by typing in the URL. I've heard folks use GUIDs when passing ID's in URLS. When you see a large value of 889EA536-0B32-3345-B124-F44141C50CB7 would make it complicated to guess the next record. My guess they'd use an INT as the PK, but meanwhile have a GUID column for each user record? Thoughts on that practice?
Thanks
|
|
|
|
|
|
Ya encryption is a good way but its been restricted to 2mb in IE and again it depends on the browser you are using.
|
|
|
|
|
If you don't want people to see your querystring, then save it to database and use some ID, preferably GUID. Then based on the id you read the querystring value.
another technique is to host your application in iframe, that way only the top level url which houses the iframe will be visible and the user can not see the full url + querystring.
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
Since you are dealing with only an integer, you could store it in the Session on the source page and then do a response.redirect to the new page and read the session value.
SourcePage:
Protected Sub TransferButton_Click(ByVal sender As Object, ByVal e As EventArgs) Handles TransferButton.Click
Session("MyId") = MyID
Response.Redirect("TargetPage.aspx")
End Sub
TargetPage.aspx:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim MyID as Int = 0
If Me.IsPostBack = False then
MyID = CInt(Session("MyId"))
Session("MyId") = Nothing 'Clear value from session after retrieving
End If
End Sub
- Robert Beaubien
- Kool Software LLC
- Try the New Warp10 Code Generator and Framework at https://www.warp-10.com
-
|
|
|
|
|
you have many options:
1. Not use query string, use post method and retrieve value on next form using previouspage object
2. Use encrypted values in querystring, there are hundreds of different algorithms
3. Use Session object
4. Use Profile
5. Use Application Object too.
6. Use Encrypted Cookies
7. If you want to slow down a little bit use database
8. Also you can use file handling to write value to text or xml file
From
Gaurav Mahajan
Website Developer Amritsar
Website: sushilindia.com
|
|
|
|
|
I'll sugest using session objects, it's the easiest way.
oh and if you didn't know , you can place any type of object into a session variable you'll just have to convert it back to the type of object you want when you use it, and another plus , its value can be used on any page.
|
|
|
|
|
"oh and if you didn't know , you can place any type of object into a session variable you'll just have to convert it back to the type of object you want when you use it, and another plus , its value can be used on any page."
True, but large objects will require more memory in the webserver and will limit scalability of the website.
- Robert Beaubien
- Kool Software LLC
- Try the New Warp10 Code Generator and Framework at https://www.warp-10.com
-
|
|
|
|
|
Here is my scenario... a user control (UCCulture) with a dropdown box for culture. Autopostback on change of dropdown box sets the thread culture to new value early in page lifecyle.
In most cases, a post back does not require rebinding data, however, in the case of a culture change, this often does require a rebinding of data using the newly selected culture.
I'm looking for the best way to allow UCCulture to fire a CultureChanged event and have the page, masterpage and all other user controls subscribe to this event, so they can rebind their data, if necessary, when the event is fired.
I have base classes for Page and UserControl, and would prefer to wire up the events in these base classes instead of manually writing the event hookup code individually.
Anyone developed a pattern for this type of thing already?
|
|
|
|
|
Hi,
I'm hoping you guys can help me with a question.
I've been reviewing someone else's code, and I found that in some places where they are using a repeater to display data from a database, in places where the Database query will only ever return 1 row of data. They are returning a reader, loading a datatable with the reader data, and binding that datatable to a repeater.
now am I nutz, or is that extremely inefficient?
it's always been my practice to take the reader, check for rows, and then set individual controls (like literals) to the fields directly.
the only reason I can think of to do this, is that if for some reason there isn't any data, the repeater won't display anything. however I've always handled this by wrapping the results in a div, and setting the div's visibility property to false if there is no data returned.
please let me know your opinion.
thank you
|
|
|
|
|
There are better ways of the doing that, but it probably doesn't matter.
As you say you can always count the rows in the data table. If no rows exists display another div.
If this application is going to have 10K+ users then you might want to look at doing this in a more efficient way. But really it is probably fine. However, you really should not use a repeater if you are only going to have one record. That's just common sense, it is called a repeater for a reason.
Also, why use a datareader to get a datatable. This is foolish. Use the dataAdapter to get a dataTable. Use DataReader to iterate through read only data or bind a control directly to a datareader object.
I didn't get any requirements for the signature
|
|
|
|