Click here to Skip to main content
15,888,610 members
Home / Discussions / C#
   

C#

 
QuestionExecuting programs Pin
Stefan_ Spenz5-Oct-05 23:38
Stefan_ Spenz5-Oct-05 23:38 
AnswerRe: Executing programs Pin
Stefan Troschuetz5-Oct-05 23:48
Stefan Troschuetz5-Oct-05 23:48 
GeneralRe: Executing programs Pin
Stefan_ Spenz6-Oct-05 1:51
Stefan_ Spenz6-Oct-05 1:51 
AnswerRe: Executing programs Pin
User 66586-Oct-05 1:41
User 66586-Oct-05 1:41 
GeneralRe: Executing programs Pin
Stefan_ Spenz6-Oct-05 1:52
Stefan_ Spenz6-Oct-05 1:52 
Questionhow to get the target of shortcut Pin
Anonymous5-Oct-05 22:27
Anonymous5-Oct-05 22:27 
AnswerRe: how to get the target of shortcut Pin
Heath Stewart6-Oct-05 7:28
protectorHeath Stewart6-Oct-05 7:28 
QuestionDatabase query Pin
ybasha5-Oct-05 21:39
ybasha5-Oct-05 21:39 
Hi all,

Here is the scenario i have 3 database table 1.lcsh 2.sub 3. terms

i need to write a select query which will fill datatable let say we get multiple record in that multi record i will take 1 value say lcshid from lcsh with this lcshid and again run another select query for database table 2.sub, we get multi rec and again taking 1 value from say nid from sub with this nid field again running another select query for datbase table 3.terms and finally select the fields which should be display in XSLT... this execrise is for mapping two fields this is my code snippet...

objTempNodes = objXml.SelectNodes("//dc:Subject",objNameSpaceMgr);
sData[5] = "";
foreach (Xml objNode in objTempNodes)
{
foreach(XmlAttribute ElementAttr in objNode.Attributes)
{
if (ElementAttr.Value=="dcterms:LCSH")
{
SubjectLCSH=objNode.InnerText;
if(SubjectLCSH.Trim()!="")
SubjectLCSH = RemoveDups(SubjectLCSH);
objNode.InnerText = SubjectLCSH;
}
if (ElementAttr.Value=="dcterms:DLTaxonomy")
{
try
{
//Select the record in db in LCSH Terms
SqlConnection conn = new SqlConnection();
conn.ConnectionString = new SqlConnection(Global.sConnectionString);
conn.Open();

sqlAdapter = new SqlDataAdapter();
sqlAdapter.SelectCommand = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();


//Building the query for Selecting record From the SubjectTermsMapping
da = "Select " + ConfigurationSettings.AppSettings["connstrsubjmapping"] + " where DDC ='" + strDDC + "'";

sqldataset ds = new DataSet();
da.Fill(ds);


DataTable dt = ds.Tables[0];

}
catch
{


//SubjectDL = "Final Value";
//End Here
objNode.InnerText = SubjectDL;
}
finally
{

sData[5] = "NLBTerms:~LCSH:" + SubjectLCSH + "~DLTaxonomy:" + SubjectDL + "~SASH:";
}
}
}

suggest me how to do the above mention query i need to check the condition of each field ex:lcshid is avaiable r not if no then it should not move to next query...

Regards
ybashaSmile | :)
AnswerRe: Database query Pin
Heath Stewart6-Oct-05 6:43
protectorHeath Stewart6-Oct-05 6:43 
QuestionSearching for a string value Pin
Brendan Vogt5-Oct-05 20:37
Brendan Vogt5-Oct-05 20:37 
AnswerRe: Searching for a string value Pin
S. Senthil Kumar5-Oct-05 20:45
S. Senthil Kumar5-Oct-05 20:45 
GeneralRe: Searching for a string value Pin
Brendan Vogt5-Oct-05 21:01
Brendan Vogt5-Oct-05 21:01 
GeneralRe: Searching for a string value Pin
S. Senthil Kumar5-Oct-05 21:12
S. Senthil Kumar5-Oct-05 21:12 
GeneralRe: Searching for a string value Pin
Brendan Vogt5-Oct-05 21:55
Brendan Vogt5-Oct-05 21:55 
AnswerRe: Searching for a string value Pin
Guffa5-Oct-05 23:01
Guffa5-Oct-05 23:01 
GeneralRe: Searching for a string value Pin
Brendan Vogt5-Oct-05 23:10
Brendan Vogt5-Oct-05 23:10 
AnswerRe: Searching for a string value Pin
Guffa6-Oct-05 0:22
Guffa6-Oct-05 0:22 
GeneralRe: Searching for a string value Pin
Brendan Vogt6-Oct-05 0:41
Brendan Vogt6-Oct-05 0:41 
GeneralRe: Searching for a string value Pin
Guffa6-Oct-05 1:20
Guffa6-Oct-05 1:20 
QuestionSetup starts after installation again Pin
Ariadne5-Oct-05 20:31
Ariadne5-Oct-05 20:31 
AnswerRe: Setup starts after installation again (minor bug) Pin
Ariadne6-Oct-05 20:14
Ariadne6-Oct-05 20:14 
QuestionSockets in C# Pin
Thoughthopper5-Oct-05 20:04
Thoughthopper5-Oct-05 20:04 
Questionsetup problem Pin
shashank veerkar5-Oct-05 19:40
shashank veerkar5-Oct-05 19:40 
AnswerRe: setup problem Pin
Ariadne5-Oct-05 20:49
Ariadne5-Oct-05 20:49 
QuestionHow to find all fax machines on asystem Pin
shashank veerkar5-Oct-05 18:48
shashank veerkar5-Oct-05 18:48 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.