16,019,764 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 Visual Basic questions
View Javascript 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 Member 10556393 (Top 45 by date)
Member 10556393
11-Nov-21 22:32pm
View
Hi,
I agree your point, but you can help us to list of the steps like here you check or in this step you may check like that guidance you can give us.
Member 10556393
10-Aug-21 5:30am
View
Hi,
We cannot use ARN for ODBC connection and for Visual basic application. We need to connect with hostname, username and Password only. This is my understanding. Is it Correct?
Member 10556393
9-Aug-21 23:14pm
View
Hi,
Thank you for your solution. It is somewhat ok I can understand but not fully.
My expectation is how to implement AWS ARN key in source coding level or in DB Connection string level?
Member 10556393
9-Aug-21 5:48am
View
Deleted
Hi,
Thank you and apology for my unclear question.
Currently I am working in Migration project. It is Visual basic application. Database is Sql server. Database connection strings are declared in INI (text) file and configured with Visual basic coding.
Client expectation is to migrate the on premise database to AWS RDS. Our DevOps team clearly said that they are not provide password to access the database even for INI file also and using AWS ARN (Amazon Resource Name) key only we can connect database manually to sql server or through application also.
I am stuck here only that How can I connect sql server database using AWS ARN key through visual basic application. I am not able to get help from my organization because this is the first migration project using AWS ARN key and I am the only person working in visual basic and sql server. This is the help I need from Codeproject team. Please ask if you need more clarification.
Thank You.
Member 10556393
8-Aug-21 2:40am
View
Hi,
Thank you and apology for my unclear question.
Currently I am working in Migration project. It is Visual basic application. Database is Sql server. Database connection strings are declared in INI (text) file and configured with Visual basic coding.
Client expectation is to migrate the on premise database to AWS RDS. Our DevOps team clearly said that they are not provide password to access the database even for INI file also and using AWS ARN (Amazon Resource Name) key only we can connect database manually to sql server or through application also.
I am stuck here only that How can I connect sql server database using AWS ARN key through visual basic application. I am not able to get help from my organization because this is the first migration project using AWS ARN key and I am the only person working in visual basic and sql server. This is the help I need from Codeproject team. Please ask if you need more clarification.
Thank You.
Member 10556393
6-Aug-21 8:55am
View
Thank you for your response. Please give some possible ways or links?
Member 10556393
29-Jul-21 9:23am
View
I will check and give the status.
Member 10556393
29-Jul-21 6:05am
View
args2[0] = aws args2[1] = s3 args2[2] = cp args2[3] = C:\TEMP\Test1.TXT
args2[4] = <s3 bucket="" name="">
Process objProcess = new Process();
objProcess.StartInfo.FileName = "cmd.exe";
objProcess.StartInfo.Arguments = args2[0] + " " + args2[1] + " " + args2[2] + " " + args2[3] + " " + args2[4];
objProcess.StartInfo.CreateNoWindow = false;
objProcess.Start();
objProcess.Close();
It is opening the command prompt only. Not executing and not closing.
This is my code.
Member 10556393
29-Jul-21 5:21am
View
Hi,
Thanks for your response.
But it is not working. The command prompt will open and the parameters i passed but it is not showing and command prompt not closing.
Member 10556393
29-Jul-21 4:58am
View
Hi,
I am not able to understand your answer. Can you explain please?
Member 10556393
29-Jul-21 1:53am
View
For security purpose our organization aws team could not share the AWSAccesskey, AWSSecretkey. Instead of that they suggest use presigned URL. Anyone can help how to create presigned URL and how to implement it into our visual studio applciations? Thanks in advance.
Member 10556393
29-Jul-21 1:53am
View
For security purpose our organization aws team could not share the AWSAccesskey, AWSSecretkey. Instead of that they suggest use presigned URL. Anyone can help how to create presigned URL and how to implement it into our visual studio applciations? Thanks in advance.
Member 10556393
22-Feb-21 3:49am
View
Hi Maciej Los,
I read your solutions. But my requirements is I will create a batch file and Application exe folder and give to SCCM team to deploy the application in client system. In that batch program I will do everything that means Bin folder created, INI folder created and all the exe files are copied into the Bin folder. Everything runs successfully. But the main exe file shortcut will not create on desktop. The user just double click the exe and needs to run the application. For that how to create exe shortcut from the batch program. I searched in net, some one says use mklink, xcopy or create vbs file. I tried all those. But not work.
Member 10556393
22-Feb-21 3:13am
View
Is there anyother method? I am not clear about the solutions.
Member 10556393
22-Feb-21 3:13am
View
Is there anyother method? I am not clear about the solutions.
Member 10556393
22-Feb-21 3:12am
View
Is there anyother method? I am not clear above the solutions.
Member 10556393
30-Sep-20 8:08am
View
The error is Invalid procedure call or argument in DateAdd("m",-1,"2020/09/29") function.
Member 10556393
29-Sep-20 6:48am
View
Your answer is not understanding. Can you please explain clearly?
Member 10556393
26-Sep-20 23:02pm
View
Hi, this application runned successfully more than 4 years without this error. I got this error recently and if I want to change coding which you showed means I need to change minimum 300 modules. So i think it is not possible. Anyway I tried your coding it is working for testing.
Member 10556393
18-Mar-19 2:22am
View
Thank You.
Member 10556393
2-Jan-18 1:47am
View
Hi,
Thanks for your reply. Now i got the following error message, The 'br' start tag on line 1 does not match the end tag of 'RESPONSE'. Line 1, position 543.....
But i am not using Response tag and I am clearly checked the open and end tags. It is correct and I copied the datas opened in notepad++, saved as filename.xml. Then i import in Tally, it is imported successfully and I have the data what i have in xml format.
Member 10556393
2-Jan-18 0:42am
View
Ok.
I am fetching xml format into dataset,
dsTally = objBLCRMMatser.TALLYSALESINVOICE3(objDAOCRMMatser);
Then, i split and store into one string vairable, like below
strXMLData = dsTally.Tables[0].Rows[0]["Invoice"].ToString();
strXMLData = strXMLData + dsTally.Tables[1].Rows[0]["Invoice1"].ToString();
strXMLData = strXMLData + dsTally.Tables[2].Rows[0]["Invoice2"].ToString();
I am using the xmlhttp class,
MSXML2.ServerXMLHTTP objHTTP = new ServerXMLHTTP();
I passed the tally path from Textbox
ServerIP = txtTallyPath.Text.ToString();
try
{
objHTTP.open("POST", ServerIP, false, null, null);
//MessageBox.Show("Post Method Complete", "ERP", MessageBoxButtons.OK);
objHTTP.send(strXMLData);
//MessageBox.Show("send XML Data", "ERP", MessageBoxButtons.OK);
}
catch (System.Runtime.InteropServices.COMException ex)
{
ErrorLogClass.SendError(ex, formName, "");
}
In this line i am getting the error message.
Exception from HRESULT: 0x80072EE6....
Member 10556393
1-Apr-17 9:07am
View
I am expect help, apart from nothing. Thanks for your reply.
Member 10556393
17-Oct-16 3:22am
View
This is my controller function,
[HttpPost]
public HttpResponseMessage Validate(Login login)
{
try
{
Login = new LoginCRUD();
return new HttpResponseMessage()
{
Content = new StringContent(string.Concat(Login.Validate(login)), Encoding.UTF8, "application/json")
};
}
catch (Exception ex)
{
throw ex;
}
}
This is my Class function,
public object Validate(Login login)
{
try
{
DataSet ds = new DataSet();
object[] objParamValue = { login.Password, login.User_Name };
ds = sqlhelper.GetDataset(ConnectionString, "usp_getlogindetails", ProcedureParameters.GetLoginDetailsParameters, objParamValue);
//ds = sqlhelper.GetDataset(ConnectionString, "usp_getlogindetails1", null, null);
return JsonUtility.serializetoJSON(ds.Tables[0]);
}
catch(Exception ex)
{
throw ex;
}
}
Member 10556393
29-Sep-16 3:46am
View
Hi, thanks for your reply. I just fetch data from database using sp. The sp looks like create procedure usp_GetQuestionWithOptionList
as
begin
select
sq.survey_question_id,
sq.survey_question_text,
sqo.survey_question_option_value,
sqo.survey_question_option_text,
sqo.survey_question_option_order,
sq.survey_question_type,
sq.survey_question_comment_req,
sq.survey_question_active,
sqo.survey_question_option_active
from
survey_questions sq inner join survey_question_options sqo on sq.survey_question_id = sqo.survey_question_id
order by sq.survey_question_id,sqo.survey_question_option_order
End
Member 10556393
8-Sep-16 8:42am
View
Thanks for your guidance.
Member 10556393
8-Sep-16 8:26am
View
Thanks for your reply. I want to know how the project folders are stored in Github and the structure? My TL asks like this only.
Member 10556393
16-Jun-16 2:34am
View
I accept your solution. But what is the best way to create encryption and decryption. Each and every time i want different encrypt text for the same input also.
Member 10556393
17-Feb-16 1:56am
View
How to create custom control and how to use it in Asp.net?
Member 10556393
29-Jan-16 7:22am
View
Ok. Thanks
Member 10556393
29-Jan-16 7:19am
View
I am asking is it possible we can change or not?
Member 10556393
9-Dec-15 5:24am
View
I need to store the values which is inside itemtemplate textbox and checkbox value to database based on contract no. I am not able to take values. Because the first three rows are header and it is disigned at runtime. So it will not take the values.
Member 10556393
9-Dec-15 5:13am
View
This is the gridview coding for runtime,
<table cellspacing="0" cellpadding="4" rules="all" id="ContentPlaceHolder1_GridViewForLite" style="background-color:White;border-color:#CC9966;border-width:1px;border-style:None;border-collapse:collapse;">
<tbody><tr style="color:#FFFFCC;background-color:#990000;font-weight:bold;">
<td align="center" rowspan="3">Contract No</td><td align="center" rowspan="3">BP Name</td><td align="center" colspan="3">Q3/14-15</td><td align="center" colspan="3">Q4/14-15</td><td align="center" colspan="3">Q1/15-16</td><td align="center" colspan="3">Q2/15-16</td><td align="center" colspan="5">Q3/15-16</td><td align="center" rowspan="3">Approve</td>
</tr><tr style="color:#FFFFCC;background-color:#990000;font-weight:bold;">
<td align="center" colspan="1">Targets</td><td align="center" colspan="2">Achievements</td><td align="center" colspan="1">Targets</td><td align="center" colspan="2">Achievements</td><td align="center" colspan="1">Targets</td><td align="center" colspan="2">Achievements</td><td align="center" colspan="1">Targets</td><td align="center" colspan="2">Achievements</td><td align="center" colspan="5">Targets</td>
</tr><tr style="color:#FFFFCC;background-color:#990000;font-weight:bold;">
<td align="center" colspan="1">PC</td><td align="center" colspan="1">PC</td><td align="center" colspan="1">Audit Score</td><td align="center" colspan="1">PC</td><td align="center" colspan="1">PC</td><td align="center" colspan="1">Audit Score</td><td align="center" colspan="1">PC</td><td align="center" colspan="1">PC</td><td align="center" colspan="1">Audit Score</td><td align="center" colspan="1">PC</td><td align="center" colspan="1">PC</td><td align="center" colspan="1">Audit Score</td><td align="center" colspan="1">PC</td><td align="center" colspan="1">Premiunm NB</td><td align="center" colspan="1">AIO</td><td align="center" colspan="1">RCM Remarks</td><td align="center" colspan="1">Remarks</td>
</tr><tr style="color:#FFFFCC;background-color:#990000;font-weight:bold;">
</tr><tr style="color:#330099;background-color:White;">
<td style="white-space:nowrap;">2002130</td><td style="white-space:nowrap;">Infotech Computers & Communications</td><td style="white-space:nowrap;">40</td><td style="white-space:nowrap;">48</td><td style="white-space:nowrap;">100</td><td style="white-space:nowrap;">40</td><td style="white-space:nowrap;">20</td><td style="white-space:nowrap;">78.5</td><td style="white-space:nowrap;">40</td><td style="white-space:nowrap;">11</td><td style="white-space:nowrap;">80</td><td style="white-space:nowrap;">40</td><td style="white-space:nowrap;">6</td><td style="white-space:nowrap;">70</td><td>0</td><td>0</td><td>0</td><td> </td><td>
<textarea name="ctl00$ContentPlaceHolder1$GridViewForLite$ctl05$txtLITEApprovalRemarks" rows="2" cols="20" ></textarea>
</td><td>
<input id="ContentPlaceHolder1_GridViewForLite_CheckBox1_0" type="checkbox" name="ctl00$ContentPlaceHolder1$GridViewForLite$ctl05$CheckBox1" >
</td>
</tr><tr style="color:#330099;background-color:White;">
<td style="white-space:nowrap;">2004030</td><td style="white-space:nowrap;">The White House Infotech</td><td style="white-space:nowrap;">160</td><td style="white-space:nowrap;">163</td><td style="white-space:nowrap;">90</td><td style="white-space:nowrap;">170</td><td style="white-space:nowrap;">180</td><td style="white-space:nowrap;">77.5</td><td style="white-s
Member 10556393
9-Dec-15 5:08am
View
<asp:GridView ID="GridViewForLite" runat="server" OnRowDataBound="GridViewForLite_RowDataBound" AutoGenerateColumns="False" BackColor="White" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px" CellPadding="4">
<columns>
<asp:BoundField DataField="Contract No" HeaderText="Contract No">
<HeaderStyle Wrap="False" />
<itemstyle wrap="False">
<asp:BoundField DataField="BP Name" HeaderText="BP Name">
<HeaderStyle Wrap="False" />
<itemstyle wrap="False">
<asp:BoundField HeaderText="Targets" DataField="PC">
<HeaderStyle Wrap="False" />
<itemstyle wrap="False">
<asp:BoundField DataField="APC" HeaderText="Achievements">
<HeaderStyle Wrap="False" />
<itemstyle wrap="False">
<asp:BoundField HeaderText="Achievements" DataField="Audit Score">
<HeaderStyle Wrap="False" />
<itemstyle wrap="False">
<asp:BoundField HeaderText="Targets" DataField="PC1">
<HeaderStyle Wrap="False" />
<itemstyle wrap="False">
<asp:BoundField DataField="APC1" HeaderText="Achievements">
<HeaderStyle Wrap="False" />
<itemstyle wrap="False">
<asp:BoundField HeaderText="Achievements" DataField="Audit Score1">
<HeaderStyle Wrap="False" />
<itemstyle wrap="False">
<asp:BoundField HeaderText="Targets" DataField="PC2">
<HeaderStyle Wrap="False" />
<itemstyle wrap="False">
<asp:BoundField DataField="APC2" HeaderText="Achievements">
<HeaderStyle Wrap="False" />
<itemstyle wrap="False">
<asp:BoundField HeaderText="Achievements" DataField="Audit Score2">
<HeaderStyle Wrap="False" />
<itemstyle wrap="False">
<asp:BoundField HeaderText="Targets" DataField="PC3">
<HeaderStyle Wrap="False" />
<itemstyle wrap="False">
<asp:BoundField DataField="APC3" HeaderText="Achievements">
<HeaderStyle Wrap="False" />
<itemstyle wrap="False">
<asp:BoundField HeaderText="Achievements" DataField="Audit Score3">
<HeaderStyle Wrap="False" />
<itemstyle wrap="False">
<asp:BoundField DataField="PC4" HeaderText="Targets" />
Member 10556393
25-Nov-15 8:37am
View
No. Headers need to be fixed not side part.
Member 10556393
25-Nov-15 8:31am
View
Yes, i got for only single row header not for more than one header.
Member 10556393
16-Nov-15 9:14am
View
Yes, and how to store each and every agent voice separately in mysql database?
Member 10556393
18-Aug-15 7:20am
View
Yes Thanks, but generally what is the job nature of Business Analyst-Software?
Member 10556393
5-Aug-15 3:54am
View
Thanks.....
Member 10556393
5-Aug-15 3:48am
View
Hi Maciej,
Thanks for the reply and for the link. But my output is just different, One main header, under that one sub main header, under that sub header like this i need.
Member 10556393
5-Aug-15 2:57am
View
Hi Sergey,
Asp.net gridview,C# coding.
Member 10556393
4-Aug-15 10:17am
View
Hi Kornfeld Eliyahu Peter,
Thanks for your reply. I already visit this link, but it is sum of tables only there.
Member 10556393
3-Aug-15 11:30am
View
Thanks for your help.
Member 10556393
3-Jul-15 5:23am
View
Problem not solved. I used all the steps which is in the link.
Member 10556393
3-Jul-15 4:47am
View
What i want to do this to solve?
Show More