I need to read a dbase V table with more than 500 fields.
The example:
View Complete Post
If I use Microsoft.Jet.OLEDB.4.0 to retreive for example named range or sheet from Excel and use it as data source for some server control on the ASP page, everything works fine. But when I try to get table from Excel like this: "select * from [Table1]", debugger complains that database engine could not find object Table1. So how should I reference Table1 in Excel file so that the database engine could find it?
Hello,
I have 2 tables, master, detail. 1.master table have fields (id, username, plan)-->id is primary key (PK) 2. detail table have fields (srNo,id, worksummary, ... )--> srNo is PK.
I have created foreign key relationship from detail to .master table for "id" field.
the code is:
IList<detail> objDetail=new List<detail> (); IList<master> objMaster = new List<master> ();string[] sarray = queryFields.Split('|');// for (int i = 0; i < sarray.Length; i++){ string[] sfields = sarray[i].Split(','); if (sfields[0] != "") { objDetail.Add(new _detail { Id = count , modify = sfields[1].ToString(), verified = sfields[2], I}); } }
I have problem to add fields in "objDetail" using Add method. But I am unable to access the reference field "Id" , rest of the field of detail table can be accessed using objDetail.
How can I access the "Id" field from objDetail object to add in IList.
I want to solve this problem
I have two tables (a,b) each with a primary key (which are clustered indexes). When I issue the t-sql statement
delete XX from t1 XX inner join t2 on (xx.A2 = t2 how can i drag and drop fields of table in teh desing surface I am followint the insructions of this walkthrough of VS2003http://msdn.microsoft.com/es-es/library/1as0t7ff(en-us,VS.71).aspxadn in a part say this 8 Find the authors node and expand it to show the fields in the authors table. 9 Using CTRL+Click, select the au_id, au_lname, au_fname, and city fields. 10 Drag these fields from Server Explorer onto the design surfaceNow i am using VS2008 When i try to drag and drop i can not made it is maybe because of the differences between 2003 and 2008 versionshow can do it in VS2008?Luis
I am followint the insructions of this walkthrough of VS2003
http://msdn.microsoft.com/es-es/library/1as0t7ff(en-us,VS.71).aspx
adn in a part say this
Now i am using VS2008
When i try to drag and drop i can not made it is maybe because of the differences between 2003 and 2008 versions
how can do it in VS2008?
Luis
--Loading the single row returned by a table valued function into a temp table works fine like this: DECLARE @techNumLoop VARCHAR(25) DECLARE @myTemp TABLE ( Names Varchar(25) ,Item_Count Integer ,Expense_AP MONEY --,[...20 more fields] ) --Loop a while INSERT @myTemp SELECT * FROM ufn_FindSomeRow(@techNumLoop) --And finally display a table with one row for each function call SELECT * FROM @myTemp ============ --My Question: what if I would like to also display the value of @techNumLoop passed in to ufn_FindSomeRow? --Then I add a field to @myTemp to hold it: DECLARE @myTemp TABLE ( TechNum VARCHAR(25)--added
Morning all,
I'm currently defining a fact table in my first datacube and have a question (basic one albeit). Can a datetime column be left in a fact table as a measure or should this be stored only within a dimension table? The other columns I have left in thus far are foreign keys for the dimension tables.
Any pointers appreciated.
Thanks
I am trying to verify if the SSIS package created by someone else has all the fields from source mapped to a destination table columns.
How to do that?
Also are there any best practices for testing for correctness of SSIS package.
hello
i want to read specific record form a table for example (tb1)
that consist of 3 field and each field contain of 100 record
i want to read record from 80 to 90 but with out using ID field
Hello:
I have update statement.
UPDATE SPECT SET SRE = CLSS.NEWSIDFROM SPECTINNER JOINstudent (NOLOCK) ON student.ID = SPECT.IDINNER JOIN CLSS ON CLSS.GID = SPECT.GIDON CLSS.GID = student.GIDWHERE student.PID = '20201'AND CLSS.PID = '20201'AND SRE IS NOT NULL
However, student.PID and ClSS.PID need dynamically reach through from table CLSS to get each row of PID.
Here my table CLSS
Rowid Username PID gid nit sid NEWSID7 cc 20201 00 1 AA XX8 cc 20201 02 1 SS AA9 dd 11000 0N &n
Is it possible to make specific fields in the EditForm Read Only so that once data has been entered it cannot be changed?
I have name and address information that once input I do not want to be changed however other fields in the form will need to be modified several times so if I can make some fields Read Only this will ensure the user modifying will only be able to change certain fields.
Some forums are suggesting Java Script however I am uncertain of whether this is the best or only option.
Thank you
I've got a couple dbf files (from Visual FoxPro) that I routinely import into a local SQL server (via OPENROWSET) for further manipulation. I've been doing this for a while now, but today I realized that not all of the data is getting imported correctly.
There are several columns that act as indicators, using a single character. There are 15 of the columns, and generally anywhere from 5 to 15 of them may be populated:
Record1 s w X f d + y
Record2 s w X f d +
Record3 s w X f _ y
Record y s _ F b d
...and so on. What I've noticed is that fields using a single underscore are getting imported as NULL. To further complicate things, the fields following the underscore are then NULL as well, but for some reason, the OPENROWSET recovers, and the NULLs stop once the 15 indicator columns are finished. So basically a record that has "y s _ F b d" becomes "y s NULL NULL NULL NULL".
Obviously I can scrub this file before importing it, but it kind of defeats the purpose of automating the import via the OPENROWSET. I don't know if anyone else has run into this, as I searched the web and couldn't find anything, but any help would be appreciated. Just for background, here is the OPENROWSET command I use:
EXEC('SELECT * INTO TABLENAME FROM OPENROWSET(''MICRO
public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { SPSite mySite = new SPSite("http://spserv"); //SPWeb myWeb = mySite.OpenWeb("/vst"); using (SPWeb oWebsite = mySite.AllWebs["website_name"]) { oWebsite.AllowUnsafeUpdates = true; SPList oList = oWebsite.Lists["list_name"]; SPViewCollection collViews = oList.Views; string strViewName = "CustomView"; System.Collections.Specialized.StringCo
Hi ,
I am trying to create infopath 2007 form with the repeating / non repeating fields with in the same table. Basically i have to get the few column values from the sharepoint List and remaining will be free text.
A B C D E F
x x x e a y
x x x s s g
x x x h t w
x x x j h t
X - Values getting from the sharepoint list by using repeating table
remaing values should be not repeating fields and should be text fields.
anyideas on this. please let me know.
Hall of Fame Twitter Terms of Service Privacy Policy Contact Us Archives Tell A Friend