How to Query this:
My query code:
Code:
SELECT TOP 1000 [WireID] ,[PadNo] ,[Pattern] ,[Tester] FROM [WLSystem].[dbo].[TblR8Pure] ORDER BY LEN(Tester), Tester ASC GO
ayakamacy
Last Activity: Sep 14 '16, 02:24 AM
Joined: May 20 '15
Location: Philippines
-
Sql Order By
Hello there, can anyone help me out with this problem?
How to Query this:
My query code:
... -
Sql order by
Hello there, can anyone help me out with this problem? How to Query this:
My query code:
...Code:SELECT TOP 1000 [WireID] ,[PadNo] ,[Pattern] ,[Tester] FROM [WLSystem].[dbo].[TblR8Pure] ORDER BY LEN(Tester), Tester ASC GO
-
Export Gridview Table to PDF with REPEAT TABLE HEADER
Language: ASP.net / VB.net
Platform: Visual Studio 2010 with ASP.net
Technology: Used in ASP.net
-------------
Right now, I'm working with my report of of how to export Gridview Table with repeat table header on the next page.
can someone teach me how to do that.
here's my ASP.NET code:
...Code:<asp:GridView ID="gv" runat="server" BackColor="White"
-
When textbox is null it will not insert data
Hello there, I have 2 tables in my database, all i want to do is when the time txtJobstart is null then it will not insert the data to the tbl2 but all the data from other fields will save to tbl1.
...Code:If txtJobStart.Text = "" Then 'Don't save, do nothing Else Dim constr As String = ConStrX Using test As New SqlConnection(constr) -
RowCount in VB.NET
Can someone help me out.
im facing a problem regarding in rowcount @ vb.net
-- Updating
All i want to do is If JobStart.Text Change date then
rowcount + 1
elseif JobStart.text didn't change date then
rowcount (but no +1)
...Code:COn.Open() SQL = "Select [JobStart] from tblJOL where [JobStart] = '" & txtJobStart.Text & "'" DA
-
Try this also.
Code:Dim d As Date If Date.TryParse(txtDate.Text, d) Then Response.Write(d.Month & " - " & d.Year) End If
-
Output : May, 2015Code:Dim now As DateTime = DateTime.Now Response.Write("<BR/>" & now.ToString("y"))Leave a comment:
-
Best answer
I knew the answer for this problem.
for those people who will encounter this problem
Try this sample code, and its working =)
...Code:Dim cmd As New SqlCommand("SELECT * FROM tblJOL", SQLcon) cmd.Parameters.Add(New SqlParameter("@DRsda", SqlDbType.VarChar)) If (txtShipoutDateActual.Text = "") Then cmd.Parameters("@DRsda").ValueLeave a comment:
-
@computerfox, i already used your new code.
and the result now is accurate.
yeah right, i will now use parenthesis so that it can be look like a formal coding. hehe, thanks anyway =)Leave a comment:
-
ok, i knew it. i just change the add value into negative.
So, I got the correct answer.
...Code:Dim dt1 As DateTime = Convert.ToDateTime(Date.Now) Dim dt2 As DateTime = Convert.ToDateTime(txtDate2.Text) Dim ts As TimeSpan = dt1 - dt2 If Convert.ToInt32(ts.Days) < 0 Then txtTtlDelay.Text = Convert.ToInt32(ts.Days) + -1 ElseIf Convert.ToInt32(ts.Days) > 0 Then txtTtlDelay.TextLeave a comment:
-
still incorrect
Hello @ computerfox, the answer is still incorrect.
please see the attach picture....Leave a comment:
-
if textbox value is negative then increment 1
how to construct conditional statement if the textbox value is negative then it will increament 1
for example:
the textbox is: -2
then in database it will save by increamenting as 1.
it will become as: -3
can someone help me out for this problem. thanks
----
i have here a sample code for computing delays of date.
but then the computation if d2 is greater than... -
i only used varchar(MAX)
as I've said above, when the time i left txtShipoutDateA ctual.Text empty, i got an error. "Conversion from string "" to type 'Date' is not valid."
because all the input value of txtShipoutDateA ctual.Text i convert it into Dayvalue.
here is my code:
...Code:Dim dateValueSDA As Date dateValueSDA = txtShipoutDateActual.Text lblDaysda.Text = WeekdayName(Weekday(dateValueSDA))
Leave a comment:
-
Insert null values into database vb.net
Hello all, i was wondering how should i insert null values into a database. I have textbox1 and the textbox2 will convert the value out of textbox1, when i the time i click save and the textbox1 is empty i got an error, "Conversion from string "" to type 'Date' is not valid." i just want to insert null value if the textbox is empty.
No activity results to display
Leave a comment: