|
Without being an Access expert I do see something that looks a little odd in the code you posted.
<br />
update tbladvance <br />
set check = false<br />
and <br />
where <br />
ecode = '1011' <br />
and <br />
type = 'festival' <br />
and <br />
check = true<br />
Should probably be:
<br />
update tbladvance <br />
set check = false <br />
where <br />
ecode = '1011' <br />
and <br />
type = 'festival' <br />
and <br />
check = true<br />
So remove the 1st AND
Regards,
Mike
|
|
|
|
|
hi mike
sorry!.. And is not there... query written by u is the same query i execute.. but it doesnt exectute at all
|
|
|
|
|
update tbladvance set check=false where ecode='1011' and type='festival' and check=true
|
|
|
|
|
hi all,
i need a optimized solution for my problem.my situation arises such that i need to loop which internally calls lots of classes i.e including creating
object for that class. say
class c
{
for i=1 to 10000
{
create object for class a;
a.function1;
a.function2;
create object for class b;
b.function1;
b.function2;
}
}
class a
{
function 1
function 2
function 3
}
class b
{
function 1
function 2
}
so where should i create the object inside the loop or outside the loop. will creating object inside the loop kills the time or not?
|
|
|
|
|
raj_developer wrote: so where should i create the object
It Depends on wat are the function and how you want to use that object.
I think for performance improvement you should create a object outside.
Inside loop will create a object 10000.
|
|
|
|
|
Impossible to say because it depends on what you are doing with the objects.
Please give some more information about your intentions.
-^-^-^-^-^-
no risk no funk
|
|
|
|
|
hi guys,
thanks for your reply,
the approached i have shown is something similar to visual basic 6, i need to know whether is the right way to call a class inside a loop or is there any DOTNET way.
|
|
|
|
|
hi every body.
i want to use dropdownlist in datagrid.i know that throw templete coloumns it will be use.but iam not know very well plz send me the idea or any link.
|
|
|
|
|
You can get so many examples on datagrid Here[^] .
Apurva Kaushal
|
|
|
|
|
Hi,
I have this sql statement:
Dim strSQL2 As String = "Select Dep_code from vwDepList where Member_ID =" & EmailAddID
Can I put it in a Select Case statement?
Select case strSQL2
Case "1"
label1.text = "hello"
so on....
End select
How will I do this? Need a tutorial.
Thanks in advance.
|
|
|
|
|
Erhm, I totally don't understand your question and the code seems really weird! You can compare the case construction with an 'if' kind of construction
Dim s as string = "a"<br />
<br />
Select case s<br />
Case "a"<br />
Do something<br />
Case "b"<br />
Do Something else<br />
End Select
The case block's result here would exactly match the following if construction
Dim s as string = "a"<br />
If (s = "a") Then<br />
Do something<br />
Else if (s = "b") Then<br />
Do something else<br />
End If
|
|
|
|
|
Just as a side note:
Do not concatenate query strings! Use Parameters!!
Better performance, easier to program (i.e. DateTime format problems), stringer against SQL injection.
-^-^-^-^-^-
no risk no funk
|
|
|
|
|
[
DLLImport("ODBCCP32.dll")
]
private static extern bool SQLConfigDataSource(
IntPtr parent, int request, string driver, string attributes)
this was the code in C#
what is the equivalant in vb.net 2005
|
|
|
|
|
<DLLImport("ODBCCP32.dll")>
private shared function SQLConfigDataSource(
IntPtr parent, int request, string driver, string attributes) as boolean
|
|
|
|
|
(via Instant VB):
<dllimport("odbccp32.dll")> _
Private Shared Function SQLConfigDataSource(ByVal parent As IntPtr, ByVal request As Integer, ByVal driver As String, ByVal attributes As String) As Boolean
End Function
David Anton
www.tangiblesoftwaresolutions.com
Instant C#: VB to C# converter
Instant VB: C# to VB converter
C++ to C# Converter: converts C++ to C#
C++ to VB Converter: converts C++ to VB
Instant C++: converts C# to C++/CLI and VB to C++/CLI
Instant Python: converts C# to IronPython and VB to IronPython
|
|
|
|
|
How can I read a file from my asp.net application using streamreader..
where should I put my file..I have to read a html page...??
Please give the answer
hiiiiii
|
|
|
|
|
hello frnd hkchauhan,
try the following example of reading using Stream Reader
Imports System
Imports System.IO
Imports System.Text
Public Class Test
Public Shared Sub Main()
Dim path As String = "c:\temp\MyTest.txt"
Try
If File.Exists(path) Then
File.Delete(path)
End If
Dim sr As StreamReader = New StreamReader(path)
Do While sr.Peek() >= 0
'This is an arbitrary size for this example.
Dim c(5) As Char
sr.Read(c, 0, c.Length)
'The output will look odd, because
'only five characters are read at a time.
Console.WriteLine(c)
Loop
sr.Close()
Catch e As Exception
Console.WriteLine("The process failed: {0}", e.ToString())
End Try
End Sub
End Class
regards,
koolprasad2003
If the message is useful for U then please Rate This message...
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
Pleas give me c# soln..
hiiiiii
|
|
|
|
|
Hi dude.
Hope this helps, it can't be easier than this:
<br />
public string LoadFromFile(string FileName)<br />
{<br />
try<br />
{<br />
string fileContents;<br />
<br />
using (StreamReader sr = new StreamReader(FileName))<br />
{<br />
fileContents = sr.ReadToEnd();<br />
}<br />
return fileContents;<br />
}<br />
catch (Exception exc)<br />
{<br />
return exc.Message;<br />
}<br />
}
Good luck
M
|
|
|
|
|
Hi,
We are creating a Code generation Tool for internal use. This tool uses a dll, which helps generate the BL and DL of the generated solution. Sometimes this dll gives an error while the Tool is run, if I give user "ASPNET" full permission on this dll, the error vanishes.
The Error is provided below:
Parser Error Message: Access is denied: 'AAA.BBB.CCC.BL'.
Line 196:add assembly="System.EnterpriseServices, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/
Line 197:add assembly="System.Web.Mobile, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/
Line 198:add assembly="*"/
Line 199:/assemblies
Line 200:/compilation
Error is in Line 198.
Does anybody know why this happens?
Blumen
|
|
|
|
|
|
Thank you, I'll try that.
Regards,
Blumen
|
|
|
|
|
I have a dataview object and I want to apply rowfilter to it. How to use the 'IN' operator in rowfilter, to access multiple rows.
aasstt
|
|
|
|
|
Hi,
YOu can do this by following way.
dv.RowFilter = "coluname in (value1, vaue2, value3)"
I hope this will help you.
Thanks and Regards,
Chetan Ranpariya
|
|
|
|
|
hi!
my page is not working on IE 7.0 but it is working fine on 6.0. wat cud be the prob.
im sending u the link too.
i have used grid control inside a datalist control to show this page.
http://www.realtime-dxb.com/navintex/FamilyInfo.aspx?nodeID=20
thanks.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
