I was put in charge of a database that has no source control, and all work was done in the database. I want to pull all the objects (stored procs, views, tables) from the database, and add to my new source control.
Is there a way to get all the objects into individual files out of a database?
Our database is SQL 2005. I have Visual Studio 2005/2008/2010 (beta 2) at my disposal.
On a test page, I successfully created a google map that pulls both marker and infoWindow information from an XML file. I did this just to get a feel for working with the API. It works fine. However, I do have a SQL database that has this information in it already. This database is updated behind the scenes regulary via a webservice.
I would like to try pulling the map information from my SQL database instead so I don't have to hand maintain the .xml file. The dabase alread has the lat/long information needed for markers. What is the easiest way for me to get that data from the SQL database? Is there a way to run a query and use the data, or will I need to run the query and somehow have it write/update my .xml file for me?
I want to pull a random record from the db.
Here what I have so far.
Dim RandomNumber As New Random()
Dim num As Integer
num = RandomNumber.Next(1, 75).ToString
Try
Dim Cnn As New OleDb.OleDbConnection("File Name=E:WebRHIUDLShelf_Life.UDL;")
Dim da As New OleDb.OleDbDataAdapter("SELECT tbMaster_List.dbMFG, tbMaster_List.dbDescription, tbInStock.ID, tbInStock.dbMFG_Lot_Code, tbInStock.dbDateReceived, tbInStock.dbDateOpened, tbInStock.dbExpireDate, tbInStock.dbLocation FROM (tbInStock
INNER JOIN tbMaster_List ON tbInStock.LnkToMaster = tbMaster_List.ID) ", Cnn)
Cnn.Open()
Dim dtt As New DataTable()
da.Fill(dtt)
This is were I am stuck.
I need to filter all rows out except where row(index) = num
Me.GridView4.DataSource = dtt
Me.GridView4.DataBind()
Catch
Label1.Text = "Error: Unable to Pull Data"
End Try
How would you pull only the current month data from SQL?
View 9 RepliesI have location #s, date, time, the sales amount, and tax in a excel file. The system pulls sales numbers throughout the day from each store location and places the total sales and tax numbers along with the polling date into a file.
So the most current date/time has the most upto date sales numbers at the time for that location number, but it also lists the older entries so mgmt can see how sales went during the day, and this is where my issue is, I don't need to see the old numbers from this generated file (atleast at this part of the program).
What I would like to do is write a query that only selects the most recent sales numbers for each location. I will output this to a table in ASP.NET. The query I tried using the TOP 1 clause only gave me the very first row listed below.
[code]....
I need to pull a SubString from a Linq Datasource, but can't use INTs per .SubString(int, int) I have strings such as xxxx.xxxx.xxxxx.AAAA.xxxx.xxxx.xxxx.xxx and I need to pull AAAA out. the preceeding x's will be varying lengths, so I can't use a static int. What I do know is that there will be a static number of periods (.) leading up to the AAAA. I can't figure out how to use the SubSting with characters rather than indexs. This is what I have so far:
[Code]....
For context: First of all, I am new to LINQ, as I have been using SubSonic for quite some time now.
I have two tables, Users, and Affiliates. They both have a very typical schema. The FK that joins them is the UserId field, which is in the Affiliates table. I want to create a LINQ query that pulls the Username from the Users table using the AffiliateId value. The AffiliateId is a primary key of the Affiliates table.
I have tried to accomplish this using many variations of the following code:
[Code]....
In the above query, I expect to get a single row result set. However, I instead receive the entire table of results.
How can I make this work? I have yet to see an example or article out there to do what I am trying to do.
I want the user to click the link then the window pops up, but I want the data inside the window to be pulled from a database, and I need to repeat this process for 5 links that are also pulled out of a database. Say the most popular items for the month. My question is how would this be best accomplished? Jquery, or AJAX. I am just trying to see which would be the easier way to go about coding this with .net and C#.
View 1 RepliesWhat i want to do is read from a database where the catalog = 12 and then have a button on the page to add a new catalog named 13 so it takes the 12 and adds 1 to it so everytime they click the button they will get a message saying "are you sure you want to create anoter catalog?" and if yes then it executes.
View 5 RepliesWhich is the best platform to create a gadget that pulls data from a database.
View 8 RepliesI have 2 Linq to Entity queries, here they are:
[Code]....
In "query" there are several columns, 2 of them are NIIN and Qty. In "objViewDDRT" there are only 2 columns, they are NIIN and AvailBalance.
What I need to do is for each row in "query" check to see if the NIIN is in "objViewDDRT", and if it is get the AvailBalance for that NIIN from objViewDDRT.
Entity framework easily allows for this but how can I detach objects in linq to sql?
View 1 RepliesI have content that I want to load dynamically, the problem is it has some html formatting in it. What control should i pull the text into, is there a way to pull the text into a div or a label, along with the formatting?
View 1 RepliesI have a gridview control that displays expenses claims received from clients. I have a template field that contains a checkbox - if this is ticked, a value from the gridview is added to a variable and this is outputted to a label control.
What I then want to do is to update the database according to which row has been ticked. I have so far the following code that adds each value to an array, which I was then hoping to access in the sql query i.e. Update table set value = value where id = (id's added to array)..
Code as follows - so far I'm just displaying the count of values in the array to make sure they are actually being added:
[Code]....
For some reason, some of the fields in our database use a different collation than the default. There doesn't seem to be a pattern as to which fields use the different collations, so I'd like to run a query to find which fields use this collation and change them to the default. Does anyone know how to do this?
View 2 RepliesI have been banging my head against this problem for a bit and I think I am stuck. I would like to pull data from a Database to populate a list of possible "clients" to select from on one side. Then using what has been clicked load the client specific data into a tab container on the opposite side. I plan on doing lazy tab loading so I am not sure if that matters. I am really stuck and any help or guidance anyone could give would be greatly appreciated! I understand the basics of data loading and of tab containers, but i am unsure of what to do. I am coding this in C#. Example Mock Interface This is where the data list would be and I want to be able to select something here And update the Tab Panel control here based on the selection from the left side via querying the database.
View 3 RepliesWhen a user logins, I want to be able to store all his profile information so I can display, for example, his email on different pages of my website, but I don't want to have to keep querying the database for every time I want to display his email. How would I go about doing this?
View 2 RepliesI need to pull the data from DB and fill the view model, is there any better way to do this? Currently I'm doing something like this.
ViewModel vm = new ViewModel();
var recentBill = context.Money.Take(10);
foreach (var r in recnetBill)
{
vm.lst.Add(r);
}
I have two business objects mapped via LINQ to tables. One of the objects contains an instance of the other object and share a key as an identifier.I want to retrieve Class A and within class A all of Class B's values as well. What I am doing is this:
[Code]....
[Code]....
This seems a little clunky, as in slow. Is there a better way to get the Class B (User) information without making a query every time?
im developing a silverlight project using silverlight 3, vs2008 and linq2sql. when projects starts, im storing all the data from database into some static list variables. so when ever i need data, im reading it from those static list variables. all i want to know is, is it good to store data in static list variables and use it when ever necessary or is it good to get data directly from DataClassesDataContext object like db.mytable. which is the rite and fastest way or retrieving data. i mean which will use less connections to database?
View 2 RepliesMyGridView.DataSource = <<<what kind of objects here?>>>
DataTable works. What else?
I have a really weird problem. It actually made me restart the computer.
View 1 RepliesWhich is better from the performance point of view Wizard Bound Controls or Binding Controls by manual ADO.NET Coding?
View 2 RepliesI would like to write Set difference minus operation with Linq on list objects using Except method. [Code]....
Tha above code always returns lstrbb objects.
I created a class library: PRTreatmentReviews. I created a reference for the class library on the website. I checked the property pages and the reference to the class is there. I put objectdatasource on a page and tried to pick up the PRTreatmentReviews class but it's not there? The Class
[Code]....