16,004,836 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Mayur Gujrathiii (Top 23 by date)
Mayur Gujrathiii
31-May-11 6:35am
View
your R&D over?
Mayur Gujrathiii
26-May-11 5:59am
View
no not like that i want to fire radiobutton checked change event asynchronously as we can do it with the use of update panel but i want to do same with the help of javascript (xmlhttprequest)
Hope you got it now
Mayur Gujrathiii
25-May-11 9:16am
View
your back up created successfully
Mayur Gujrathiii
25-May-11 8:37am
View
backup databse DatabaseName to disk='c:\temp\DatabaseName.bak'
Mayur Gujrathiii
13-May-11 2:02am
View
i am not getting
i have done as follows on checked change event
and i have also calling one javascript on checked changed
<asp:TemplateField HeaderText="SELECT">
<itemtemplate>
<asp:CheckBox ID="check" runat="server" OnCheckedChanged="check_CheckedChanged" ToolTip ="javascript:ViewSIGN();" AutoPostBack="true" Visible="true">
Protected Sub check_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs)
myds = DirectCast(ViewState("dsdata"), DataSet)
Dim chkbox As CheckBox = CType(sender, CheckBox)
Dim Grow As GridViewRow = CType(chkbox.NamingContainer, GridViewRow)
btnauthorise.Enabled = True
btnreject.Enabled = True
If (chkbox.Checked = True) Then
btnauthorise.Enabled = True
btnreject.Enabled = True
strCureentRowIndex = Grow.RowIndex
hdrowno.Value = strCureentRowIndex
reqslipno = myds.Tables(0).Rows(strCureentRowIndex)(1).ToString()
Boid = myds.Tables(0).Rows(strCureentRowIndex)(3).ToString()
imag.Visible = True
Image2.Visible = True
imag.ImageUrl = myds.Tables(0).Rows(strCureentRowIndex).Item("imagepath")
Image2.ImageUrl = hdimage2.Value
End If
End Sub
and
Mayur Gujrathiii
11-May-11 3:59am
View
i mean to say how can i get that cell value simply
Mayur Gujrathiii
9-May-11 4:03am
View
on one button click i am filing gridview like this
cmd.Parameters.AddWithValue("@pa_id", 0)
cmd.Parameters.AddWithValue("@pa_boname", "")
cmd.Parameters.AddWithValue("@pa_sholder", "")
cmd.Parameters.AddWithValue("@pa_chk_yn", 1)
cmd.Parameters.AddWithValue("@pa_rmks", "")
cmd.Parameters.AddWithValue("@pa_imagepath", "")
cmd.Parameters.Add("@pa_error", SqlDbType.VarChar, 8000)
cmd.Parameters("@pa_error").DbType = DbType.AnsiString
cmd.Parameters("@pa_error").Direction = ParameterDirection.Output
da.Fill(ds, "pr_ins_upd_reqdtls")
'If (Not (ds Is Nothing)) Then
If ds.Tables(0).Rows.Count > 0 Then
GridView1.DataSource = ds.Tables(0)
GridView1.DataBind()
rowcount = ds.Tables(0).Rows.Count
lblsubheader.Text = "Records Found, " & rowcount & " "
'Dim name As String = ds.Tables(0).Rows(0)(11).ToString()
'Response.Write(name)
'lblsubheader.Text = name
'hdimage.Value = ds.Tables(0).Rows(0).Item("imagepath")
'Image2.ImageUrl = path
imag.ImageUrl = ds.Tables(0).Rows(0).Item("imagepath")
'Image2.Src = path
Image2.ImageUrl = hdimage2.Value
'lblsubheader.Text = hdimage.Value
Else
GridView1.DataSource = ds.Tables(0)
GridView1.DataBind()
lblsubheader.Text = "No Record Found"
Image2.Visible = False
imag.Visible = False
End If
End Sub
and another button click trying to take values like this
Dim id As String = GridView1.Rows(0).Cells(1).Text
Mayur Gujrathiii
9-May-11 4:01am
View
it is vb.net
Mayur Gujrathiii
7-May-11 7:44am
View
compile time error
Mayur Gujrathiii
7-May-11 7:41am
View
yes it is windows application
Mayur Gujrathiii
7-May-11 7:18am
View
Ankur i have already stated there first read and then comment any thing
Mayur Gujrathiii
7-May-11 7:06am
View
it is giving error on Application.StartupPath word key word not found
Mayur Gujrathiii
5-May-11 4:46am
View
it is giving error on value keyword and after removing it application runs but "System.Web.UI.WebControls.DataControlFieldCell" is getting in lblheader.Text
Mayur Gujrathiii
5-May-11 4:41am
View
not working means values are not coming and i correct it to count-1. but still not solved
Mayur Gujrathiii
28-Apr-11 9:02am
View
error:Cannot find table 0
Mayur Gujrathiii
28-Apr-11 8:51am
View
My stored procedure
USE [DMAT_SVV]
GO
/****** Object: StoredProcedure [citrus_usr].[pr_ins_upd_reqdtls] Script Date: 04/28/2011 10:17:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--select top 1 * from slip_issue_mstr
/*
create table Dis_req_Dtls_mak
(id numeric identity(1,1)
,req_slip_no varchar(100)
,req_date datetime
,Boid varchar(16)
,Boname varchar(150)
,sholder varchar(150)
,tholder varchar(150)
,created_dt datetime
,created_by varchar(100)
,lst_upd_dt datetime
,lst_upd_by varchar(100)
,deleted_ind smallint)
create table Dis_req_Dtls
(id numeric identity(1,1)
,req_slip_no varchar(100)
,req_date datetime
,Boid varchar(16)
,Boname varchar(150)
,sholder varchar(150)
,tholder varchar(150)
,created_dt datetime
,created_by varchar(100)
,lst_upd_dt datetime
,lst_upd_by varchar(100)
,deleted_ind smallint)
*/
ALTER proc [citrus_usr].[pr_ins_upd_reqdtls](@pa_id numeric
, @pa_action varchar(50)
, @pa_req_slip_no varchar(100)
, @pa_req_date datetime
, @pa_boid varchar(16)
, @pa_boname varchar(150)
, @pa_sholder varchar(150)
, @pa_tholder varchar(150)
, @pa_login_name varchar(100)
, @pa_chk_yn smallint
, @pa_rmks varchar(200)
, @pa_error varchar(8000) output
)
as
begin
if @pa_chk_yn = 0
begin
if @pa_action ='INS'
begin
insert into Dis_req_Dtls
select @pa_req_slip_no
,@pa_req_date
, @pa_boid
, @pa_boname
, @pa_sholder
, @pa_tholder
, getdate()
, @pa_login_name
, getdate()
, @pa_login_name
,1
,NULL
,@pa_rmks
end
if @pa_action ='EDT'
begin
update Dis_req_Dtls
set req_slip_no=@pa_req_slip_no
,req_date=@pa_req_date
,Boid=@pa_boid
,Boname=@pa_boname
,sholder=@pa_sholder
,tholder = @pa_tholder
,remarks = @pa_rmks
,lst_upd_dt = getdate()
,lst_upd_by =@pa_login_name
where id = @pa_id
and deleted_ind = 1
end
if @pa_action ='DEL'
begin
update Dis_req_Dtls
set deleted_ind = 0
,lst_upd_dt = getdate()
,lst_upd_by =@pa_login_name
where id = @pa_id
and deleted_ind = 1
end
if @pa_action ='VALIDATESELECT'
begin
select SLIIM_DPAM_ACCT_NO
, dpam_sba_no , isnull(DPHD_SH_FNAME,'') + ' ' + isnull(DPHD_SH_MNAME,'') +' ' + isnull(DPHD_SH_LNAME,'') sh_holder
, isnull(DPHD_TH_FNAME,'') + ' ' + isnull(DPHD_TH_MNAME,'') +' ' + isnull(DPHD_TH_LNAME,'') th_holder
from slip_issue_mstr , dp_acct_mstr left outer join dp_holder_dtls on dphd_dpam_id = dpam_id
where SLIIM_SLIP_NO_TO = replace(@pa_req_slip_no ,SLIIM_SERIES_TYPE,'')
and sliim_deleted_ind =1
end
if @pa_action ='SEARCH'
begin
select * from Dis_req_Dtls
where req_slip_no = @pa_req_slip_no
and deleted_ind =1
end
end
else if @pa_chk_yn = 1
begin
if @pa_action ='INS'
begin
if not exists(select req_slip_no from Dis_req_Dtls where id = @pa_id)
insert into Dis_req_Dtls_mak
select @pa_req_slip_no
,@pa_req_date
, @pa_boid
, @pa_boname
, @pa_sholder
, @pa_tholder
, getdate()
, @pa_login_name
, getdate()
, @pa_login_name
,0
, @pa_rmks
end
if @pa_action ='EDT'
begin
if not exists(select req_slip_no from Dis_req_Dtls where id = @pa_id and deleted_ind = 1)
begin
update Dis_req_Dtls_mak
set req_slip_no=@pa_req_slip_no
,req_date=@pa_req_date
,Boid=@pa_boid
,Boname=@pa_boname
,sholder=@pa_sholder
,tholder = @pa_tholder
,remarks = @pa_rmks
,lst_upd_dt = getdate()
,lst_upd_by =@pa_login_name
where id = @pa_id
and deleted_ind = 0
END
ELSE
BEGIN
insert into Dis_req_Dtls_mak
select @pa_req_slip_no
,@pa_req_date
Mayur Gujrathiii
27-Apr-11 10:09am
View
yes dear
Mayur Gujrathiii
27-Apr-11 10:04am
View
Thanks , i will take care of such silly mistakes
Mayur Gujrathiii
27-Apr-11 9:54am
View
posted my code
Mayur Gujrathiii
27-Apr-11 9:53am
View
Dim Var_StrLoginame As String = Session("LoginName")
Dim cmd As SqlCommand = New SqlCommand
Dim constr As String = ConfigurationManager.AppSettings("PooledConnectionString")
Dim sqlcon As SqlConnection = New SqlConnection(constr)
Dim da As SqlDataAdapter = New SqlDataAdapter("select * from Dis_req_Dtls_MAK", sqlcon)
da.SelectCommand = cmd
cmd.Connection = sqlcon
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "pr_ins_upd_reqdtls"
cmd.Parameters.Clear()
cmd.Parameters.AddWithValue("@pa_action", "SEARCHCHK")
cmd.Parameters.AddWithValue("@pa_tholder", ddlselect.Value)
If (filter.Value = "I") Then
cmd.Parameters.AddWithValue("@pa_boid", hdfilter.Value)
cmd.Parameters.AddWithValue("@pa_req_slip_no", "")
cmd.Parameters.AddWithValue("@pa_req_date", "")
ElseIf (filter.Value = "S") Then
cmd.Parameters.AddWithValue("@pa_boid", "")
cmd.Parameters.AddWithValue("@pa_req_slip_no", hdfilter.Value)
cmd.Parameters.AddWithValue("@pa_req_date", "")
ElseIf (filter.Value = "D") Then
cmd.Parameters.AddWithValue("@pa_boid", "")
cmd.Parameters.AddWithValue("@pa_req_slip_no", "")
cmd.Parameters.AddWithValue("@pa_req_date", hdfilter.Value)
End If
cmd.Parameters.AddWithValue("@pa_login_name", Var_StrLoginame)
'parameters not in use
cmd.Parameters.AddWithValue("@pa_id", 0)
cmd.Parameters.AddWithValue("@pa_boname", "")
cmd.Parameters.AddWithValue("@pa_boname", "")
cmd.Parameters.AddWithValue("@pa_sholder", "")
cmd.Parameters.AddWithValue("@pa_chk_yn", 0)
cmd.Parameters.AddWithValue("@pa_rmks", "")
cmd.Parameters.Add("@pa_error", SqlDbType.VarChar, 8000)
cmd.Parameters("@pa_error").DbType = DbType.AnsiString
cmd.Parameters("@pa_error").Direction = ParameterDirection.Output
'cmd.Parameters.Add("@pa_error", SqlDbType.VarChar, 800, "@pa_error")
'cmd.Parameters("@pa_error").Direction = ParameterDirection.Output
da.Fill(ds, "pr_ins_upd_reqdtls")
If (Not (ds.Tables(0).Rows.Count > 0)) Then
'GridView1.Visible = False
GridView1.DataSource = ds.Tables(0)
GridView1.DataBind()
lblsubheader.Text = "No Records Found"
ElseIf ds.Tables(0).Rows.Count > 0 Then
Dim rowcount As Integer
rowcount = ds.Tables(0).Rows.Count
GridView1.DataSource = ds.Tables(0)
GridView1.DataBind()
' ViewState("dsdata") = ds
lblsubheader.Text = "Records Found, " & rowcount & " "
End If
'Else
'lblsubheader.Text = "Enter Proper Date"
'End If
Catch ex As Exception
Response.Write(ex.Message.ToString())
End Try
Mayur Gujrathiii
27-Apr-11 9:52am
View
i am calling all but where i am getting error i put it here
Mayur Gujrathiii
7-Apr-11 6:09am
View
I am doing like this
<form id="frmstatehlp" runat="server" target="stateclient">
<table align="left" class="clsborder" border="0" cellpadding="0" cellspacing="0" >
<tr class="grhd">
<th class="grhd" align="left" style="height: 17px; width:10%">STATE</th>
</tr>
<tr ondblclick="getvalues(this);" onmouseover="this.bgColor='#FFFFFF'" önmouseout="this.bgColor='gold';" >
<td class="clstd" style="height: 17px; width:10%">ANDHRA PRADESH</td>
</tr>
<tr ondblclick="getvalues(this);" onmouseout="this.bgColor='#FFFFFF'" önmouseover="this.bgColor='gold';" >
<td class="clstd" style="height: 17px; width:10%">ARUNACHAL PRADESH</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">ASSAM</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">BIHAR</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">CHATTISGARH</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">GOA</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">GUJARAT</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">HARYANA</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">HIMACHAL PRADESH</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">JAMMU AND KASHMIR</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">JHARKHAND</td>
</tr>
<tr öndblclick="getvalues(this);" >
<td class="clstd" style="height: 17px; width:10%">KARNATAKA</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">KERALA</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">MADHYA PRADESH</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px; width:10%">MAHARASHTRA</td>
</tr>
<tr ondblclick="getvalues(this);" önmouseout="this.bgColor='#FFFFFF'" >
<td class="clstd" style="height: 17px;
Mayur Gujrathiii
29-Mar-11 5:04am
View
same connection string i am using in my both applications and problem is that it is giving error on + +Application.StartupPath + keyword
Show More