Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
100% Quality Score
Upvotes Received
4
Posts with Upvotes
4
Upvoting Members
4
Downvotes Received
0
Posts with Downvotes
0
Downvoting Members
0
1 Commented Post
~37.5K People Reached
About Me

Me....ehmmm.....

Interests
Football (Liverpool & Barca), Computer, Games (PES, Champions Manager), Punk Rock (Social Distortion,…
PC Specs
at office : Pentium 4 CPU 3.40GHz, Memory 1GB, Windows 2000 Professional. -----------------------------------------------------------…
Favorite Tags

148 Posted Topics

Member Avatar for ashishparihar
Member Avatar for AKshay_13
0
3K
Member Avatar for kodingkarthik

Hi, you still forgot for DropDownList [code] myCommand = New SqlCommand("Insert into Employee Data values('" & ddlid.selectedItem & "','" & txtname.Text & "','" & ddldesig.selectedItem & "','" & txtcontno.Text & "')", "myConnection") [/code]

Member Avatar for ILA RANI
0
3K
Member Avatar for Kusno

Dear all, I can use this code to write a value in parent window control. [CODE]StrJScript = "<SCRIPT>parent.document.forms[0].TxtCustomerId.value = '" & ClearSpace(Row.Cells(1).Text.Trim) & "';</SCRIPT>" If Not ClientScript.IsClientScriptBlockRegistered("S1") Then ClientScript.RegisterClientScriptBlock(Me.GetType(), "S1", StrJScript) End If[/CODE] but, I cannot set iFrame visible to false. I use this code : [CODE]StrJScript = "<SCRIPT>parent.document.form1.iFrmCustomer.visible = …

Member Avatar for sachin.e
0
542
Member Avatar for sreein1986

[QUOTE=sierrainfo;648837]You can use MsgBox -- just like in VB6.[/QUOTE] CMIIW : It's only work in Microsoft Visual Studio Designer, not in IIS. I searched in Google how to create Msgbox and I found it. [CODE] Public Sub UserMsgBox(ByVal F As Object, ByVal sMsg As String) Dim sb As New StringBuilder() …

Member Avatar for PKOLB
0
942
Member Avatar for divyasrinivasan

Hi divyasrinivasan, This is for validating textbox for numeric only : [CODE] <%@ Page Language="VB" AutoEventWireup="false" CodeFile="OperationSheetMultipleArticle.aspx.vb" Inherits="OperationSheetMultipleArticle" EnableSessionState="true" %> <%@ OutputCache Location="Client" duration="5" varybyparam="none" %> <html xmlns="http://www.w3.org/1999/xhtml" > <script type="text/javascript" language=javascript> function keyDownNumber() { var key; if(navigator.appName == 'Microsoft Internet Explorer') key = event.keyCode; else key = event.which if …

Member Avatar for cloudlight
0
851
Member Avatar for Kusno

Dear all, I have a table that contains image data type and has more than 20,000 records. I want to change its file group to the new file group. I tried to change it using table designer, but everytime I wanted to save it, it occured an error with this …

Member Avatar for pclfw
0
135
Member Avatar for Kusno

Dear all, I'm stucked with my XML problem. I have these stored procedures to save XML data into server hard disk. [CODE]CREATE PROCEDURE dbo.sp_XML_Employee(@Database varchar(10), @FileName Varchar(2000)) AS DECLARE @bcpCommand varchar(4000) SET @bcpCommand = 'bcp "SELECT EmployeeID, EmployeeName FROM ' + @Database + '.dbo.MasterEmployee ORDER BY EmployeeID FOR XML RAW(''Employee''), …

Member Avatar for Kusno
0
221
Member Avatar for Kusno

Dear all, I have this query to generate sql row to XML Mode. [CODE]SELECT CurrencyID, CurrencyName FROM MasterCurrency ORDER BY CurrencyID FOR XML RAW ('Currency') , ELEMENTS;[/CODE] the result is : [CODE]<Currency> <CurrencyID>AUD</CurrencyID> <CurrencyName>AUSTRALIAN DOLLAR</CurrencyName> </Currency> <Currency> <CurrencyID>CHF</CurrencyID> <CurrencyName>SWISS FRANC</CurrencyName> </Currency> <Currency> <CurrencyID>EUR</CurrencyID> <CurrencyName>EUROPEAN EURO</CurrencyName> </Currency> [/CODE] I want the …

Member Avatar for Kusno
0
100
Member Avatar for Kusno

Dear all, I created a very simple web mobile form. It worked When I runned it from Microsoft Visual Studio 2005 editor and IIS web server. But when I put the link in my device emulator manager from Tools->device emulator manager it didn`t work. I used SmartPhone 2003 SE Emulator, …

Member Avatar for miraclebos
0
57
Member Avatar for vinaya

Hi, You forget to set this function : "HtmlEncode= false" <asp:BoundField dataField="TransactionDate" HeaderText="Trans. Date" SortExpression="TransactionDate" DataFormatString="{0:yyyy-MM-dd}" HtmlEncode="false"/> Thanks, Kusno.

Member Avatar for kvprajapati
0
497
Member Avatar for ebosysindia

Hi ebosysindia, Please use CheckBoxList control. and to check which item is selected : [CODE] Dim V As String = "" Dim I As SByte For i = 0 To CheckBoxList1.Items.Count - 1 If CheckBoxList1.Items(I).Selected = True Then If V = "" Then V = CheckBoxList1.Items(I).Value Else V = V …

Member Avatar for boycuoi
0
93
Member Avatar for kanuri1

Hi.. I try to help u [CODE] Dim FileName As String = "" Dim ErrorMessage As String Dim ExportToExcel As String = "0" Dim Folder As String = "" Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not Request.QueryString("ExportToExcel") Is Nothing Then ExportToExcel = Request.QueryString("ExportToExcel") …

Member Avatar for pauldani
0
166
Member Avatar for farooq82

Check your locigal file [CODE]Imports System Imports System.data Imports System.data.SqlClient Imports System.Collections.Generic Partial Class company End Class [/CODE] compare it with [CODE] <%@ Page Language="C#" MasterPageFile ="~/trunkey.Master" AutoEventWireup="false" CodeBehind="company.aspx.cs" Inherits="test.company" %> [/CODE] [B]Inherits="test.company"[/B] must be same with [B]Partial Class[/B]

Member Avatar for farooq82
0
91
Member Avatar for ultras1
Member Avatar for Kusno
0
92
Member Avatar for kanuri1
Member Avatar for SheSaidImaPregy

Dear SheSaid, What mode of SessionState do you use ? In my application, I use SQLServer mode and the session is never expired. When using InProc, it works. To trigger Session_End you need call Session.Abandon() Im my project, to trigger Session_End, I use 2 events. 1. When users Click Log …

Member Avatar for jaredclinton
0
1K
Member Avatar for anup.maverick

[QUOTE=anup.maverick;1072384]Hi, In an Javascript code, I am taking a value from User and this value I want in my server side code , vb.net, What is the code for this.??? Thanx & Regards Anup[/QUOTE] [CODE] <input id="TxtBDReffNo" type="text" [B]runat="server"[/B] style="width: 140px; text-align: center" readonly="readOnly" value="5" />[/CODE]

Member Avatar for iamchamith
0
108
Member Avatar for deven_a76

I'm using this code : [CODE] Dim SQLConn As String = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString [/CODE]

Member Avatar for deven_a76
0
144
Member Avatar for bharanidharanit

ASP.NET table or HTML table? this is for HTML table [CODE] <asp:HyperLink ID="HyperLink1" runat="server" onmouseover="document.getElementById('tbl').visible=true" >HyperLink</asp:HyperLink> [/CODE] You need to give ID for your table

Member Avatar for bharanidharanit
0
224
Member Avatar for Kusno

dear all, I created a web user control for date picker with VB.Net language. To use that control, I dragged that file into my forms. Now, I want to put it in ToolBox control... Does anyone know how to do that? What is this code function ? [CODE]<DefaultProperty("PagingText"), ToolboxData("<{0}:PagingTextBox runat=server></{0}:PagingTextBox>")> …

Member Avatar for chandru7
0
109
Member Avatar for bharanidharanit

[QUOTE=bharanidharanit;864402]Hello, I am having 3 pages default.aspx, default1.aspx and default2.aspx Default.aspx is the home page. When i click default2.aspx, it must check whether i have logged in, if not it must redirect to a login page(default1.aspx)[/QUOTE] You may use session to check your user id [CODE] Public Function CheckValidation(ByVal UserId …

Member Avatar for bharanidharanit
0
107
Member Avatar for 15389049

something is like this : [CODE] Sub ActionSave() Dim D As GridViewRow Dim SQL As String = "" Dim TrxID As String = "" For Each D In GV.Rows TrxID = D.Cells(0).Text If ChkSelect.Checked = True Then SQL = "INSERT INTO Trx VALUES('" & TrxID & "')" End If Next …

Member Avatar for 15389049
1
176
Member Avatar for willopt_ric
Member Avatar for Kusno
-1
123
Member Avatar for RAMAN2233

Like this : [CODE] Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim Index As Byte = 0 Dim Item As New ListItem If ListBox1.SelectedIndex <> -1 Then Index = ListBox1.SelectedIndex Item.Text = ListBox1.SelectedItem.ToString Item.Text = ListBox1.SelectedValue.ToString ListBox2.Items.Add(Item) ListBox1.Items.RemoveAt(Index) End If End Sub Sub ActionSave() Dim …

Member Avatar for willopt_ric
0
82
Member Avatar for Kusno

Dear all, before using AJAX.Net, when I wanted to find control in form, I used this code [CODE] Dim SQL As String = "SELECT CurrencyID, CurrencyID FROM MasterCurrency ORDER BY CurrencyID" Dim ctl As Object For Each ctl In Me.FindControl("form1").Controls If LCase(Left(ctl.id, 6)) = "cmbccy" Then FillControl(ctl, SQL) Next [/CODE] …

Member Avatar for Kusno
1
519
Member Avatar for mshravs

[CODE]Protected Sub CmdPrint_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles CmdPrint.Click Dim S As String = "<SCRIPT>window.print();window.close();</SCRIPT>" If Not ClientScript.IsClientScriptBlockRegistered("print") Then ClientScript.RegisterClientScriptBlock(Me.GetType, "print", S) End If[/CODE]

Member Avatar for Kusno
0
112
Member Avatar for sakhi kul

[QUOTE=sakhi kul;1040395]Hi to all, I have table student in which I inserting first name,middle name, last name in 3 different columns. but when i want to show it in gridview I want to join three columns into only one heading "Name". Is it possible...? or any other way to show …

Member Avatar for Kusno
0
109
Member Avatar for love_dude1984

[QUOTE=love_dude1984;1030367]hello frndz.. i really need some urgent help on a simple problem. im storing a string in a database, say its "1 2 3",these are actually the id's of something. in order to get the name from the ID, i need to seperate the id's from the string, that is …

Member Avatar for carobee
0
166
Member Avatar for Dhruv Shah

[QUOTE=peter_budo;316412]First thing, please [B]do not[/B] use JSP to connect to database. Pass data to servlet for validation, or use JavaScript to valildate them in JSP, and setup connection inside servlet and then by the needs go back to previous page to pick up correct/new data or move to nex page …

Member Avatar for masijade
0
2K
Member Avatar for Pankaj18

Using Stored Procedure or use my way, replace ' to ` :$ [CODE] TextBox1.Text = Replace(TextBox1.Text,"'","`") [/CODE]

Member Avatar for Kusno
0
85
Member Avatar for marangajared

[QUOTE=marangajared;1009197]Hi. on my form, the field are entered depending on availability. some fields are mandatory while others are optional. The mandatory fields are inserted into one table called [B]Receipt [/B]while the optional ones are saved in the other table called [B]receiptLine[/B]. When all the fields are filled in, then the …

Member Avatar for shenulal
0
97
Member Avatar for omotoyosi

[QUOTE=omotoyosi;1009368]hello all, am using asp.net vb . i have a label named label1 but i am passing data into it at runtime which depends on what the user clicks. My problem now is that 1. How do i do autosize for the label because its not in the label properties …

Member Avatar for shenulal
0
122
Member Avatar for marangajared
Member Avatar for SID.SIL

[QUOTE=SID.SIL;996665]Hello Friends I still muddled with some things (that is with a lot of them). I have a Gridview, where the first column ia a TemplateField with a LinkButton to delete the record, the selected row. I did the same routine using the primary key with DataKeyNames, however in this …

Member Avatar for Kusno
0
104
Member Avatar for ritu verma

[CODE] Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click Panel1.Width = 400 Panel1.Height = 400 End Sub [/CODE]

Member Avatar for Kusno
0
105
Member Avatar for SID.SIL

If you have save the ID in session, you can directly use it [CODE] Dim SQL As String = "SELECT * FROM Trx WHERE ID = '" & Session("ID") & "' [/CODE] but, just my suggestion, try to avoid using sessions. For this case, try to use query string like …

Member Avatar for Kusno
0
310
Member Avatar for f_atencia

[QUOTE=f_atencia;994787]Hi all, I have an SQL Datasource: <asp:SqlDataSource ID="shownMovie" runat="server" ConnectionString="<%$ ConnectionStrings:MovieTix %>" SelectCommand="SELECT movie.title, movie.category FROM [movie],[session],[theatre],[cinema] WHERE cinema.cinemaLocation=theatre.cinemaLocation AND theatre.theatreNumber=session.theatreNumber AND session.movieID=movie.movieID AND ([COLOR="Red"][B][movieID][/B][/COLOR] = @movieID)"> <SelectParameters> <asp:ControlParameter ControlID="GridView1" Name="movieID" PropertyName="SelectedValue" Type="String" /> </SelectParameters> </asp:SqlDataSource> However, i get the following error message: Ambiguous column name 'movieID'. Basically I …

Member Avatar for jbisono
0
139
Member Avatar for Studio
Member Avatar for mjc225
Member Avatar for Kusno
0
221
Member Avatar for marangajared

[QUOTE=marangajared;993340]I want to create or export data from the database (SQL Server 2005) to a text file. the data I need is for THAT DAY ONLY. The text file is required by another system and therefore at the end of the day, I need a report on txt for the …

Member Avatar for Kusno
0
140
Member Avatar for k.vijayakumar

[QUOTE=k.vijayakumar;958799]hi, when session expires i want to give message and send them to my login page.for this where i have to write the code. thank you[/QUOTE] how if like this : [CODE] Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If session("UserID").ToString.Trim = "" Then Response.Redirect("Login.aspx") …

Member Avatar for carobee
0
133
Member Avatar for mindfrost82

Have you written your code in IsPostBack method ? [CODE] Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not IsPostBack Then Me.txtCompany.Text = dr.GetString(1) End If Protected Sub CmdSave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles CmdSave.Click Dim strSQLCompany as String strSQLCompany = "UPDATE …

Member Avatar for mindfrost82
0
82
Member Avatar for Kusno

Dear all, I have a problem for my session state. Previously, I used session state InProc, but because CPU usage was very high cause IIS sometimes restarts, so I changed it to SQLServer. but now, session doesnt want to expire even I set timeout to 1 minute !!!. this is …

Member Avatar for kameswari
0
127
Member Avatar for Kusno

Dear all, Sorry, if this Thread is wrong room :$ . I want to return a field value from a table, so I created a function like this : [CODE]CREATE FUNCTION dbo.CheckStatusTrx(@TransNo Varchar(20)) RETURNS varchar(20) AS BEGIN DECLARE @Flag Numeric(1) SELECT @Flag = Flag, CreatedBy, ApprovedBy FROM TrxTD WHERE TransNo …

0
99
Member Avatar for VinayRok

You may use JavaScript function. [CODE]<html xmlns="http://www.w3.org/1999/xhtml" > <head> <title>Untitled Page</title> <script language="JavaScript"> function openWindow() { var w = 0, h = 0; if (document.all || document.layers) { w = screen.availWidth; h = screen.availHeight; } var popW = 550, popH = 350; var leftc = (w - popW) / 2, …

Member Avatar for almostbob
0
275
Member Avatar for noorashegh

Hi, please adjust with your purpose. I hope I can help you. :) [CODE] Protected Sub CmdTD_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles CmdTD.Click IFrameTDInfo.Attributes("Src") = "IFrameMasterCustomer\MasterCustomerTDInfo.aspx?CustomerID=" & TxtCustomerID.Text.Trim End Sub <iframe runat="server" id="IFrameTDInfo" height="100%" width="100%" style="width: 100%"></iframe>[/CODE] Thanks

Member Avatar for Kusno
0
151
Member Avatar for Kusno

Dear all friends, I have Crystal Report file, just call RptCustomerMaster.rpt that displays Customer ID, Customer Name, Telp No, Email Address, Account Officer, In my report, I want users to be able to sort record use all columns in RptCustomerMaster.rpt Do you know how to send sort record parameters from …

Member Avatar for Ramesh S
0
96
Member Avatar for gingank

[QUOTE=gingank;909201]Hi guys if i use the asp.net to write the code but i didnt involve to connect to the sql database what should i write in the web.config under the connection string??[/QUOTE] :) just use the default setting from ASP.NET web.config. Because there is no "connection string" if you use …

Member Avatar for kvprajapati
0
93
Member Avatar for Yellowdog428

Hi YellowDog, I want to try to help you...hope this helpful from parent page : [CODE] Protected Sub CmdLocateCustomer_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles CmdLocateCustomer.Click If TxtCustomerId.Value.Trim = "" Then ClearTextBox() Dim S As String = "<SCRIPT>var w = 0, h = 0;if (document.all || document.layers) { …

Member Avatar for serkan sendur
0
126
Member Avatar for Kusno

Dear all, I have a problem with AJAX.Net. Now, all my program forms use Anthem.Net. But, Anthem.Net gets problem in IE7 (dropdownlist shrunks and Anthem.Net doesn't provide date picker). So, I have plan to convert my forms AJAX to AJAX.Net. I have converted one modules, and when I compared AJAX.Net …

0
58

The End.