|
It shouldn't actually matter. And Oracle uses SQL. I think you mean SQL SERver, which is T-SQL.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
I have a requirement: If i click on a datagrid(cell),the data's corresponding to that particular data grid has to be displayed in a text box('s). I mean, if i click a roll number, corresponding data's like marks, class etc has to be displayed in a text box. Please suggest me a solution ASAP.
|
|
|
|
|
You need to insert javascript so that the data is in a div, and it's click event calls code that transfers it's value into the textbox.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
datagrid have the propery e.item(0).text=textbox1.text write it hope it works
|
|
|
|
|
Dear Friends,
I have facing a problem in which i want data in delimited format
For Example,
Database: Northwind
Table: Products
Data Input:
ProductID CategoryID
1 1
1 2
1 3
Output:
ProductID CategoryID
1 1,2,3
i want this data in my View, can it possible please guide me.
Thanks in Advanced.
Sasmi
|
|
|
|
|
|
Hi,
U can use this Store procedure to get your goal..
SET ANSI_WARNINGS OFF<br />
Declare @ono varchar(50)<br />
DECLARE My_Cursor CURSOR FOR<br />
SELECT distinct ProductID<br />
FROM Products<br />
<br />
drop table tmp<br />
create table tmp(ono varchar(50),allname varchar(50))<br />
<br />
OPEN My_Cursor<br />
<br />
FETCH NEXT FROM My_Cursor into @ono<br />
WHILE @@FETCH_STATUS = 0<br />
BEGIN<br />
DECLARE @MyList varchar(100)<br />
set @MyList = null<br />
SELECT @MyList = COALESCE(@MyList + ', ', '') + <br />
CAST(CategoryID AS varchar(5))<br />
FROM Products where ProductID = @ono<br />
insert into tmp(ono,allname) values(@ono,@MyList)<br />
FETCH NEXT FROM My_Cursor into @ono<br />
END<br />
<br />
CLOSE My_Cursor<br />
DEALLOCATE My_Cursor<br />
<br />
select * from tmp<br />
<br />
Thanks,
Sun Rays
|
|
|
|
|
hi friends
i upload the image
by default i wrote the stored procedure,the image does not store the original name in database..it store LGO1,LGO2 like this.
my problem is i upload the file .i got image name like this ballLGO1.gif,imageLGO2.gif...
how i remove ball in ballLGO1.gif
regards
saravanan
Known Is Drop.Unknown Is Ocean
|
|
|
|
|
Well, it sounds like your code to remove the old filename is broken. You can remove it with string mashing, but you'd do better to fix the initial code.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
hi !
I have one datalist control and there is itemtemplete of textbox. there is one check box on the form , when i click that checkbox that time all the textbox should be disable by javascript
|
|
|
|
|
use document.getElementById to find the textbox, then set it's disabled property to true.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
thanx for sugestion but textbox is in datalist itemtemplet so how can i that texbox id ?
|
|
|
|
|
You'll have to handle the row data bound event, and get the Id and store it somewhere.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
for this (format([StartDateTime],"hh mm ss") As StartTime) we get time in Ms Access but it not return AM/PM. what i do for AM/PM please help
Piyush Vardhan Singh
|
|
|
|
|
Piyush Vardhan Singh wrote: or this (format([StartDateTime],"hh mm ss") As StartTime) we get time in Ms Access but it not return AM/PM.
you willl get it by using "h:mm:ss tt"
bEst rEgard
pAthan
please don't forget to vote on the post that helped you.
|
|
|
|
|
thanks for reply it working in vb.net but its not working in MS access SqL query
Piyush Vardhan Singh
|
|
|
|
|
Piyush Vardhan Singh wrote: (format([StartDateTime],"hh mm ss") As StartTime
if you use HH mm ss it will return the time in 24hr format when u write it as h mm ss tt it will return in 12 hr format with AM/PM option
regards
sunilwise;);)
|
|
|
|
|
i want to retrieve the data from the database to treeview.if table contains the colums name ,id, sal .then the treeview should contain tha child nodes as name ,id,sal.
|
|
|
|
|
Hi,
u can try this
foreach(DataRow dr in ds.Tables[0].Rows)<br />
{<br />
TreeNode tn = new TreeNode();<br />
tn.Text = dr["name"].ToString();<br />
dataTRV.Nodes.Add(tn);<br />
TreeNode ctn = new TreeNode();<br />
ctn.Text = dr["id"].ToString();<br />
tn.ChildNodes.Add(ctn);<br />
TreeNode ctn1 = new TreeNode();<br />
ctn1.Text = dr["sal"].ToString();<br />
ctn.ChildNodes.Add(ctn1);<br />
}
Thanks,
Sun Rays
|
|
|
|
|
i want to dispaly the contents of xml in iframes without the tags <titie></title> etc....
|
|
|
|
|
Why are you still asking this, what's wrong with the advice you were given before ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi "Sherin" please delete your post or modify.
I thing you used table structure in your post thats why the code project is changed. or just check the check box for "Ignore HTML tags in this message (good for code snippets)"
|
|
|
|
|
Pl delete that mess..
Thanks,
Sun Rays
|
|
|
|
|
Imran Khan Pathan wrote: Hi "Sherin" please delete your post or modify.
His signature is making problem. It crashed entire forum,
|
|
|
|
|
hi friends i want to generate bar code using asp.net please tell how to generate
thanks and reg
nanthakumar
|
|
|
|