Click here to Skip to main content
15,902,112 members
Home / Discussions / C#
   

C#

 
GeneralRe: SendMessage return value Pin
mav.northwind6-Oct-05 20:42
mav.northwind6-Oct-05 20:42 
QuestionListening to keypresses?? Pin
.M6-Oct-05 0:29
.M6-Oct-05 0:29 
QuestionHow can we add values in ArratList in different way?? Pin
parvinder sehrawat6-Oct-05 0:04
parvinder sehrawat6-Oct-05 0:04 
AnswerRe: How can we add values in ArratList in different way?? Pin
Stefan Troschuetz6-Oct-05 0:14
Stefan Troschuetz6-Oct-05 0:14 
Questionconverting aspx pages to HMTL pages Pin
A.Grover5-Oct-05 23:52
A.Grover5-Oct-05 23:52 
AnswerRe: converting aspx pages to HMTL pages Pin
Guffa6-Oct-05 0:06
Guffa6-Oct-05 0:06 
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 

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.