Click here to Skip to main content
15,912,329 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: how can i get the value of ENTER key Pin
Jay_se12-Oct-06 0:02
Jay_se12-Oct-06 0:02 
QuestionmultiSelect in datagrid [modified] Pin
ptvce6-Oct-06 21:37
ptvce6-Oct-06 21:37 
Question{"This row already belongs to another table." } Pin
MHASSANF6-Oct-06 20:38
MHASSANF6-Oct-06 20:38 
AnswerRe: {"This row already belongs to another table." } Pin
Abhishek Joshi6-Oct-06 21:20
Abhishek Joshi6-Oct-06 21:20 
AnswerRe: {"This row already belongs to another table." } Pin
Guffa7-Oct-06 1:27
Guffa7-Oct-06 1:27 
QuestionCommenting Standard Pin
Abhishek Joshi6-Oct-06 20:20
Abhishek Joshi6-Oct-06 20:20 
AnswerRe: Commenting Standard Pin
Mike Ellison7-Oct-06 3:53
Mike Ellison7-Oct-06 3:53 
Questionhelp me not insert in database Pin
isis_preaw6-Oct-06 19:31
isis_preaw6-Oct-06 19:31 
i write asp not asp.net
don't error but data not insert into database
i don't sure i write wrong
//code//

//when input new data--> series,model,sfx check in database if have field series ,model, sfx already insert z ,y, x…..last field-->sfx//

If (Request("savetypenew") ="บันทึก" ) then
If (Request("nmtypenew1") <> "") and (Request("nmtypenew2") <> "") and (Request("nmtypenew3") <> "") then
If (len(Request("nmtypenew1")) >= 12) and (len(Request("nmtypenew2")) >= 2) and (len(Request("nmtypenew3")) >= 1) then

// create array //

Cha = array
("Z","Y","X","W","V","U","T","S","R","Q","P","O","N","M","L","K","J","I","H","G","F","E","D","C","B","A")

//check if have--> series ,model, sfx//

sql = ""
sql = sql &"select count(MMT_MOD_SFX) as AMOUNT_SFX,count(MMT_SRS_CD) as AMOUNT_SRS,count(MMT_MOD_CD) as AMOUNT_MOD"
sql = sql &" from DSP_MOD_MST"
sql = sql &" where MMT_MOD_SFX = '"&Request("nmtypenew2")&"'"
sql = sql &" and MMT_SRS_CD= '"&Request("codetypenew1")&"'"
sql = sql &" and MMT_MOD_CD = '"&Request("nmtypenew1")&"'"

set rs = conn.execute(sql)
if not rs.eof then
Totalrecord = rs("AMOUNT_SFX")
for i = 0 to Cint(Totalrecord)-1

sql = ""
sql = "Select * From DSP_MOD_MST"
sql = sql & " Where MMT_SRS_CD = '" &Request("codetypenew1")& "' and"
sql = sql & " MMT_MOD_CD = '" &Request("nmtypenew1")& "' and"
sql = sql & " MMT_MOD_SFX = '" &Request("nmtypenew2")& "' and"
sql = sql & " MMT_FR_DT <= '"&DateNow&"' "
set rs = conn.execute(sql)
do while not rs.eof
rs.movenext
loop

//if data have already then insert and add z in field MMT_MOD_SFX value Request("nmtypenew2")&Cha(i)//

sql = ""
sql = "Insert Into DSP_MOD_MST"
…….
…….
sql = sql & " MMT_MOD_SFX,"

sql = sql & " Values ('"&Request("codetypenew1")&"' , "
…….
…….
sql = sql & " '"&Request("nmtypenew2")&Cha(i)&"' , "

end if
next
else

if data haven't already then normal insert not add z


Preaw

Questiondatagrid problem Pin
varuni656-Oct-06 17:53
varuni656-Oct-06 17:53 
AnswerRe: datagrid problem Pin
Jay_se6-Oct-06 21:14
Jay_se6-Oct-06 21:14 
GeneralRe: datagrid problem Pin
varuni656-Oct-06 21:54
varuni656-Oct-06 21:54 
AnswerRe: datagrid problem Pin
Jay_se7-Oct-06 2:54
Jay_se7-Oct-06 2:54 
GeneralRe: datagrid problem Pin
varuni6511-Oct-06 2:48
varuni6511-Oct-06 2:48 
Question(URGENT) Auto Generating Report Interface Pin
Yong Yau6-Oct-06 16:59
Yong Yau6-Oct-06 16:59 
QuestionGridView Button Field. Type = Link Pin
shapper6-Oct-06 16:55
shapper6-Oct-06 16:55 
QuestionGridView and Image Link Pin
shapper6-Oct-06 16:34
shapper6-Oct-06 16:34 
Questionasp:Panel with CheckBox added dynamically: persistence Pin
RicConte6-Oct-06 16:28
RicConte6-Oct-06 16:28 
AnswerRe: asp:Panel with CheckBox added dynamically: persistence Pin
Mike Ellison7-Oct-06 3:50
Mike Ellison7-Oct-06 3:50 
GeneralRe: asp:Panel with CheckBox added dynamically: persistence Pin
RicConte7-Oct-06 17:56
RicConte7-Oct-06 17:56 
GeneralRe: asp:Panel with CheckBox added dynamically: persistence Pin
Mike Ellison8-Oct-06 4:51
Mike Ellison8-Oct-06 4:51 
GeneralRe: asp:Panel with CheckBox added dynamically: persistence Pin
RicConte8-Oct-06 10:08
RicConte8-Oct-06 10:08 
QuestionAlternative to onLoad Pin
eggie56-Oct-06 12:08
eggie56-Oct-06 12:08 
AnswerRe: Alternative to onLoad Pin
Guffa6-Oct-06 12:48
Guffa6-Oct-06 12:48 
Questionhandle event and validate Pin
TheEagle6-Oct-06 11:44
TheEagle6-Oct-06 11:44 
AnswerRe: handle event and validate Pin
thomas_joyee6-Oct-06 18:11
thomas_joyee6-Oct-06 18:11 

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.